I have an excel sheet file of both binary (male and female) and continuous characters data, I need to convert it to NEXUS file format, in order to read it with the tree of DNA sequences, for mapping these characters on the tree, How can I make the NEXUS format from these data?
Any solution please reply....
Greetings
Hi Aram,
you might try MEGA (http://www.megasoftware.net/), which I think accepts Excel formatted files. If not, you could convert from Excel to a text file and then load into MEGA. In either case, you should be able to output as Nexus format from there.
To have a distance tree of the discrete binary traits in the table, first you need to run a calculation to obtain a distance matrix and from that, a dendrogram of the distances in nexus format. My suggestion is to use the option at http://www.trex.uqam.ca/index.php?action=trex&menuD=3&project=trex before you need to format your excel data to a phylip format, or alternatively using the service at http://genomes.urv.cat/UPGMA/ where you can paste the copied text from excel tables in tabular format, selecting Jaccard or Dice and i.e. UPGMA. This will produce a tree topology in Newick format that can be easily converted to Nexus format http://phylogeny.lirmm.fr/phylo_cgi/data_converter.cgi showing the similarity of the patterns.
- Badges
- Science method