I'm starting a bioinformatics project and I've been given an excel sheet with two columns: one containing a number assigned to the sequence and one containing the sequence. I have to build a bootstrap tree using all the sequences and there's over 7000 of them. Manually exporting all the sequences and assigning them to a file of the corresponding number would be incredibly tedious and time consuming, is there any other way of doing it that would be faster?
I'm planning on using Mega to build the tree as it's the fastest option that I'm aware of and I'll be working in either Windows or BioLinux depending on what options I can come up with for separating out the sequences.
Thanks in advance