User:Lindenb/Notebook/UMR915/20110207

From OpenWetWare

Jump to: navigation, search

20110206        Top        20110208       


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 
| uniq | tr "	" " " | awk -F ' ' '{printf("INSERT INTO EXON(name,chrom,start,end) VALUES(\"%s\",\"%s\",%s,%s);\n",$1,$2,$3,$4);}'
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);}'
Personal tools