Hi @Pierre Lindenbaum,
I have generated a file through http://www.ensembl.org/biomart (like you suggested)
The file is :
19 49818279 49838816 MED25 610197 605589
19 49818279 49838816 MED25 610197 616449
My file:
chr19 50338843 rs193291405;220933 C G PASS 1 4.401e-03 0.602 MedGen:CN043576|MedGen:CN169374 Charcot-Marie-Tooth_disease,_type_2|not_specified NC_000019.9:g.50338843C>G Benign/Likely_benign single_nucleotide_variant 1 MODERATE MED25 NM_030973.3 protein_coding NON_SYNONYMOUS_CODING MISSENSE gCc/gGc A576G CODING 4.66 B9TX30,B5ME50,Q71SY5 N D,D,D,D,T,D,D,D B,B,B N 5.71 B,B,B . 0/0 0/0 55,0 38,0
I wanted to get this output:
chr19 50338843 rs193291405;220933 C G PASS 1 4.401e-03 0.602 MedGen:CN043576|MedGen:CN169374 Charcot-Marie-Tooth_disease,_type_2|not_specified NC_000019.9:g.50338843C>G Benign/Likely_benign single_nucleotide_variant 1 MODERATE MED25 NM_030973.3 protein_coding NON_SYNONYMOUS_CODING MISSENSE gCc/gGc A576G CODING 4.66 B9TX30,B5ME50,Q71SY5 N D,D,D,D,T,D,D,D B,B,B N 5.71 B,B,B . 0/0 0/0 55,0 38,0 **610197:605589:616449**
I have tried to run the following command:
awk 'NR==FNR{a[$4]=$5":"$6;next}{print $0,"\t",a[$17]}' FS="\t" med25omim med25test
This is the output that I get:
chr19 50338843 rs193291405;220933 C G PASS 1 4.401e-03 0.602 MedGen:CN043576|MedGen:CN169374 Charcot-Marie-Tooth_disease,_type_2|not_specified NC_000019.9:g.50338843C>G Benign/Likely_benign single_nucleotide_variant 1 MODERATE MED25 NM_030973.3 protein_coding NON_SYNONYMOUS_CODING MISSENSE gCc/gGc A576G CODING 4.66 B9TX30,B5ME50,Q71SY5 N D,D,D,D,T,D,D,D B,B,B N 5.71 B,B,B . 0/0 0/0 55,0 38,0 **610197:616449**
I am missing this omimID 605589 Can you please help me to overcome this? Thank you very much, Pola
Hi @Pierre Lindenbaum,
I have generated a file through http://www.ensembl.org/biomart (like you suggested)
The file is :
My file:
I wanted to get this output:
I have tried to run the following command:
This is the output that I get:
I am missing this omimID 605589 Can you please help me to overcome this? Thank you very much, Pola