generate ANNOVAR input file from EXCEL
1
0
Entering edit mode
7.6 years ago

Hello,

I need some help. I have to annotate a list of variants in a excel table; how can I transform in a input file for ANNOVAR? I've transformed it into txt document with tab separators but then can I use -convert2annovar.pl?

Gio

annovar • 2.8k views
0
Entering edit mode

0
Entering edit mode

I've create an excel file where the first 5 columns are the chromosome, the start position, the end position, the ref allele and the alt. allele... the other columns are empty... ex: 6 1052293 1052293 A G 7 59666859 59666859 T C ecc Can You help me?... Tanks! Gio

0
Entering edit mode
7.6 years ago
NB ▴ 960

convert2annovar.pl is used only when you you have your files in one of the following formats.

So in order to run the annovar program, your input file needs to have the following mandatory columns. If your excel sheet has the below info, then you can just re arrange the columns and transform it to a text file to run annovar.

chr    position    position    allele1    allele1
1      948921      948921      T          C
1      1404001     1404001     G          T


Hope this helps!

0
Entering edit mode

I will try... hope it will work! THANK YOU!!