contig_metadata
7 rows where bioproject = "PRJNA312107", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7441574 | 7441574 | PRJNA312107_P_NODE_2426_length_447_cov_10.072864_g2260_i0 | PRJNA312107 | 2426 | 447 | 10.072864 | 45.02570208 | Encentrum | 360660 | Rotifera | other_Eukaryota | 665 | 0 | NTclustered | gi|124388846|gb|EF151006.1| | 360661 | g2260 | i0 | 93.527 | 75.5973154362416 | 448 | 28 | 100 | 1 | 1 | 447 | 741 | 294 | Encentrum astridae 28S ribosomal RNA gene, partial sequence | blastn | 33792 | 665 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum astridae | |
| 14406538 | 14406538 | PRJNA312107_P_NODE_21832_length_166_cov_0.888889_g21666_i0 | PRJNA312107 | 21832 | 166 | 0.888889 | 1.47555574 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 198 | 1.69e-46 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g21666 | i0 | 88.554 | 7.00602409638554 | 166 | 16 | 100 | 3 | 1 | 166 | 257 | 419 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 1163 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 16954878 | 16954878 | PRJNA312107_P_NODE_10334_length_224_cov_6.194286_g10168_i0 | PRJNA312107 | 10334 | 224 | 6.194286 | 13.87520064 | Encentrum tectipes | 360662 | Rotifera | other_Eukaryota | 353 | 4.87e-93 | NTclustered | gi|83285187|gb|DQ297734.1| | 360662 | g10168 | i0 | 95.089 | 100.647321428571 | 224 | 11 | 100 | 0 | 1 | 224 | 968 | 745 | Encentrum tectipes 28S ribosomal RNA gene, partial sequence | blastn | 22545 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum tectipes | |
| 16955008 | 16955008 | PRJNA312107_P_NODE_4074_length_347_cov_5.335570_g3908_i0 | PRJNA312107 | 4074 | 347 | 5.33557 | 18.5144279 | Encentrum astridae | 360661 | Rotifera | other_Eukaryota | 623 | 5.549999999999999e-174 | NTclustered | gi|83285083|gb|DQ297695.1| | 360661 | g3908 | i0 | 99.133 | 99.6311239193084 | 346 | 3 | 99 | 0 | 2 | 347 | 937 | 592 | Encentrum astridae 18S ribosomal RNA gene, partial sequence | blastn | 34572 | 623 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum astridae | |
| 20189698 | 20189698 | PRJNA312107_P_NODE_15536_length_185_cov_3.095588_g15370_i0 | PRJNA312107 | 15536 | 185 | 3.095588 | 5.7268378 | Ploima | 84394 | Rotifera | other_Eukaryota | 337 | 3.89e-88 | NTclustered | gi|2317705897|gb|OP653727.1| | 96446 | g15370 | i0 | 99.459 | 100 | 185 | 1 | 100 | 0 | 1 | 185 | 1372 | 1556 | Lecane bulla voucher P11 small subunit ribosomal RNA gene, partial sequence | blastn | 18500 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 29947965 | 29947965 | PRJNA312107_P_NODE_26231_length_162_cov_0.920354_g26065_i0 | PRJNA312107 | 26231 | 162 | 0.920354 | 1.49097348 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 100 | 2.9e-25 | NR | CAF1099792.1 | 104777 | g26065 | i0 | 94.3 | 0.981481481481482 | 53 | 3 | 98.1 | 0 | 2 | 160 | 66 | 118 | CAF1099792.1 unnamed protein product [Brachionus calyciflorus] | diamond | 159 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31401665 | 31401665 | PRJNA312107_P_NODE_20196_length_168_cov_0.873950_g20030_i0 | PRJNA312107 | 20196 | 168 | 0.87395 | 1.468236 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 77.4 | 1.69e-15 | NR | RNA13468.1 | 10195 | g20030 | i0 | 76.7 | 4.76785714285714 | 43 | 10 | 76.8 | 0 | 39 | 167 | 190 | 232 | RNA13468.1 hypothetical protein BpHYR1_012004 [Brachionus plicatilis] | diamond | 801 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;