Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Tutorials
Tools
Jobs
Forum
Planet
All »
Home
Log In
Question: How to convert SNP genotyping excel file to .MEGA file format
1
gravatar for blacktomato27
4.6 years ago by
blacktomato27 • 60
United States
blacktomato27 • 60 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 COMMENT • link •
modified 3.5 years ago by caroline.pont • 10 • written 4.6 years ago by blacktomato27 • 60

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 • link modified 4.6 years ago • written 4.6 years ago by _r_am ♦ 32k
1
gravatar for caroline.pont
3.5 years ago by
caroline.pont • 10
caroline.pont • 10 wrote:

Hi, I have exactely the same question... did you find the way to do that? (I have a .vcf format)
ADD COMMENT • link written 3.5 years ago by caroline.pont • 10

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

ADD REPLY • link written 3.5 years ago by _r_am ♦ 32k
Please log in to add an answer.

Similar posts • Search »

Content
Help
Access
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
_