I have a excel file with more than 10.000 rows from a meta-barcoding study on airborne fungi.
Each rows correspond to an OTU and I would like to ask if is possible to include a separate column with information on similarity (%), like those from a local alignment in NCBI. I can do this operation manually, taking the DNA sequence of each OTU and doing the local alignment on NCBI, but it will take me a lot of time...
There is any automatic way to perform this operation?
Thanks for the help and sorry if I forgot to provide more information.