User:Lindenb/Notebook/UMR915/20110207

=AngelHeart= support BAM visualition =HC Project= PAPER ACCEPTED !!  =Axiome, SNP in exons ?= cat knownGene.txt | cut -d '	' -f 2,1,9,10 | awk '{N=split($3,S,/,/); split($4,E,/,/); for(i=1;i<=N;i++) {if(length(S[i])>0) {printf("%s\t%s\t%s\t%s\n",$1,$2,S[i],E[i]);}}}' | sort cat /tmp/dina_tmp/PIERRE/new_desir.bim | dos2unix | sed 's/^/chr/' | cut -d '	' -f 1,2,4 | tr "	" " "| sort | uniq |awk -F ' ' '{printf("INSERT INTO SNP(name,chrom,pos) VALUES(\ "%s\",\"%s\",%s);\n",$2,$1,$3);}'
 * uniq | tr "	" " " | awk -F ' ' '{printf("INSERT INTO EXON(name,chrom,start,end) VALUES(\"%s\",\"%s\",%s,%s);\n",$1,$2,$3,$4);}'