User:Lindenb/Notebook/UMR915/20110207
From OpenWetWare

AngelHeart
support BAM visualition

HC Project
PAPER ACCEPTED !!
<html><iframe title="YouTube video player" width="240" height="275" src="http://www.youtube.com/embed/Bx1iclqbNyM" frameborder="0" allowfullscreen></iframe></html>
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);}'