Question: How to convert SNP genotyping excel file to .MEGA file format
gravatar for blacktomato27
4.6 years ago by
United States
blacktomato2760 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 • 3.0k views
ADD COMMENTlink modified 3.5 years ago by caroline.pont10 • written 4.6 years ago by blacktomato2760

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 4.6 years ago • written 4.6 years ago by _r_am32k
gravatar for caroline.pont
3.5 years ago by
caroline.pont10 wrote:

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

ADD COMMENTlink written 3.5 years ago by caroline.pont10

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

ADD REPLYlink written 3.5 years ago by _r_am32k
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: 1553 users visited in the last hour