Question: How to convert SNP genotyping excel file to .MEGA file format
gravatar for blacktomato27
2.8 years ago by
United States
blacktomato2740 wrote:

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 • 1.9k views
ADD COMMENTlink modified 21 months ago by caroline.pont0 • written 2.8 years ago by blacktomato2740

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 REPLYlink modified 2.8 years ago • written 2.8 years ago by RamRS21k
gravatar for caroline.pont
21 months ago by
caroline.pont0 wrote:

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

ADD COMMENTlink written 21 months ago by caroline.pont0

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

ADD REPLYlink written 21 months ago by RamRS21k
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1033 users visited in the last hour