contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA395690" and tax_phylum = "Rotifera"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6789324 | 6789324 | PRJNA395690_P_NODE_18286_length_190_cov_2.141844_g18134_i0 | PRJNA395690 | 18286 | 190 | 2.141844 | 4.0695036 | Adineta vaga complex sp. B JFF-2016 | 1813165 | Rotifera | other_Eukaryota | 346 | 6.690000000000001e-91 | NTclustered | gi|1005055631|gb|KU860774.1| | 1813165 | g18134 | i0 | 99.474 | 31.1157894736842 | 190 | 1 | 100 | 0 | 1 | 190 | 1119 | 1308 | Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence | blastn | 5912 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. B JFF-2016 | |
| 14440309 | 14440309 | PRJNA395690_P_NODE_1212_length_709_cov_72.706061_g1083_i0 | PRJNA395690 | 1212 | 709 | 72.706061 | 515.48597249 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 228 | 1.1e-54 | NTclustered | gi|2106370087|gb|MZ706951.1| | 104777 | g1083 | i0 | 77.218 | 7.87588152327221 | 417 | 77 | 58 | 14 | 292 | 701 | 7108 | 7513 | Brachionus calyciflorus chromosome I mitochondrion, complete sequence | blastn | 5584 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 15714353 | 15714353 | PRJNA395690_P_NODE_273_length_1492_cov_12.485793_g218_i0 | PRJNA395690 | 273 | 1492 | 12.485793 | 186.28803156 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 673 | 0 | NTclustered | gi|632795131|gb|KJ489418.1| | 392764 | g218 | i0 | 75.408 | 13.7855227882038 | 1472 | 319 | 97 | 37 | 4 | 1451 | 5618 | 7070 | Brachionus rubens chromosome II mitochondrion, complete sequence | blastn | 20568 | 673 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 15714578 | 15714578 | PRJNA395690_P_NODE_9633_length_262_cov_1.323944_g9481_i0 | PRJNA395690 | 9633 | 262 | 1.323944 | 3.46873328 | Lepadella triba | 497826 | Rotifera | other_Eukaryota | 385 | 2.08e-102 | NTclustered | gi|166014122|gb|EU252111.1| | 497826 | g9481 | i0 | 98.63 | 47.2671755725191 | 219 | 0 | 84 | 3 | 1 | 219 | 447 | 662 | Lepadella triba internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 12384 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella triba | |
| 19537313 | 19537313 | PRJNA395690_P_NODE_116_length_2072_cov_6.084034_g90_i0 | PRJNA395690 | 116 | 2072 | 6.084034 | 126.06118448 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 652 | 0 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g90 | i0 | 80.322 | 20.4160231660232 | 869 | 165 | 42 | 5 | 921 | 1786 | 1 | 866 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 42302 | 652 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 20813281 | 20813281 | PRJNA395690_P_NODE_237_length_1598_cov_11.043899_g187_i0 | PRJNA395690 | 237 | 1598 | 11.043899 | 176.48150602 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 1216 | 0 | NTclustered | gi|2778092484|gb|PP988072.1| | 3231738 | g187 | i0 | 81.039 | 49.9311639549437 | 1540 | 280 | 96 | 10 | 52 | 1582 | 1561 | 25 | Asplanchna sp. chromosome II mitochondrion, complete sequence | blastn | 79790 | 1216 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;