How to convert SNP genotyping excel file to .MEGA file format
1
1
Entering edit mode
8.5 years ago

Hi to All, I got 370 SNP genotyping data of 100 individuals in excel file like this

Genotype SNP1 SNP2 ........SNP370 red C/C A/A T/T White G/G T/T A/T . . . Yellow T/T C/C G/G

Now I want to build phylogenetic tree using MEGA 6.0 software and do not know how to convert this file into .MEGA file format. Can any one help me in this regard? or share any example file like this. you help will be highly acknowledged

Regards, genetist

SNP • 4.6k views
ADD COMMENT
0
Entering edit mode

enter image description here

Also, when you say Excel file, what do you mean exactly? Most machines are set to open CSV and TSV files on Excel by default - check out the actual file extension.

Also, if someone gave you the data in a spreadsheet, ask them for the plain text data. Let them know that Excel and VCF is a bad mix.

ADD REPLY
1
Entering edit mode
7.4 years ago

Hi, I have exactely the same question... did you find the way to do that? (I have a .vcf format)

ADD COMMENT
0
Entering edit mode

If you're using Excel, see my comment above.

ADD REPLY

Login before adding your answer.

Traffic: 1964 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6