Hi all

I have blast results in tabular format comprising near about 0.5 Million entries having titles qseqid; sseqid; qlen; slen; qstart; qend; sstart; send; evalue; length; pident; qcovs; bitscore; staxid; sscinames; scomnames; sskingdoms; stitle

I want to analyse this data based on family, order, class, genus and species level in excel. How to import all taxonomic tree data for each taxon ids

Is there any perl, python script or tool available to do this analysis or fetch data from ncbi taxdb or other db?

suppose my  data having more than 1 Million read which tool should i use for simple calculations like abundance and all (Excel only supports 1048576 raw in single sheet)

I tried MEGAN for the above mentioned and finding other tool for the same.

Please help