contig_metadata
8 rows where bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4110626 | 4110626 | PRJNA1132896_P_NODE_1184_length_478_cov_2.187654_g1093_i0 | PRJNA1132896 | 1184 | 478 | 2.187654 | 10.45698612 | Rotaria | 231623 | Rotifera | other_Eukaryota | 186 | 2.44e-57 | NR | CAF3796360.1 | 392030 | g1093 | i0 | 81.7 | 211.029288702929 | 104 | 19 | 65.3 | 0 | 8 | 319 | 27 | 130 | CAF3796360.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 100872 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 19409508 | 19409508 | PRJNA1132896_P_NODE_3156_length_316_cov_1.069959_g3065_i0 | PRJNA1132896 | 3156 | 316 | 1.069959 | 3.38107044 | Rotaria | 231623 | Rotifera | other_Eukaryota | 141 | 4.749999999999999e-38 | NR | CAF4522565.1 | 392032 | g3065 | i0 | 76.7 | 9.87341772151899 | 86 | 20 | 81.6 | 0 | 43 | 300 | 1 | 86 | CAF4522565.1 unnamed protein product [Rotaria socialis] | diamond | 3120 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 24509595 | 24509595 | PRJNA1132896_P_NODE_7020_length_250_cov_1.728814_g6929_i0 | PRJNA1132896 | 7020 | 250 | 1.728814 | 4.322035 | Brachionus | 10194 | Rotifera | other_Eukaryota | 83.2 | 2.33e-16 | NR | RNA23316.1 | 10195 | g6929 | i0 | 87.2 | 0.936 | 39 | 5 | 46.8 | 0 | 118 | 2 | 252 | 290 | RNA23316.1 TBC1 domain family member 31 isoform X4, partial [Brachionus plicatilis] | diamond | 234 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28080940 | 28080940 | PRJNA1132896_P_NODE_6365_length_255_cov_3.192308_g6274_i0 | PRJNA1132896 | 6365 | 255 | 3.192308 | 8.1403854 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 61.2 | 7.2e-9 | NR | RNA13366.1 | 10195 | g6274 | i0 | 42.3 | 0.917647058823529 | 78 | 45 | 91.8 | 0 | 2 | 235 | 25 | 102 | RNA13366.1 hypothetical protein BpHYR1_044339 [Brachionus plicatilis] | diamond | 234 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28396770 | 28396770 | PRJNA1132896_P_NODE_1526_length_429_cov_0.865169_g1435_i0 | PRJNA1132896 | 1526 | 429 | 0.865169 | 3.71157501 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 65.5 | 2.39e-9 | NR | CAF4013944.1 | 392030 | g1435 | i0 | 47.3 | 1.15384615384615 | 55 | 29 | 38.5 | 0 | 155 | 319 | 76 | 130 | CAF4013944.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 495 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29469988 | 29469988 | PRJNA1132896_P_NODE_1630_length_416_cov_1.437318_g1539_i0 | PRJNA1132896 | 1630 | 416 | 1.437318 | 5.97924288 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 85.5 | 2.85e-16 | NR | CAF4158666.1 | 392033 | g1539 | i0 | 33.8 | 4.26923076923077 | 148 | 64 | 89.4 | 6 | 44 | 415 | 404 | 541 | CAF4158666.1 unnamed protein product, partial [Rotaria sordida] | diamond | 1776 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31966787 | 31966787 | PRJNA1132896_P_NODE_7578_length_249_cov_0.875000_g7487_i0 | PRJNA1132896 | 7578 | 249 | 0.875 | 2.17875 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 43.1 | 0.03 | NR | CAF1493717.1 | 1234261 | g7487 | i0 | 33.8 | 1.56626506024096 | 65 | 38 | 77.1 | 2 | 4 | 195 | 12 | 72 | CAF1493717.1 unnamed protein product [Didymodactylos carnosus] | diamond | 390 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32114318 | 32114318 | PRJNA1132896_P_NODE_7138_length_250_cov_0.870056_g7047_i0 | PRJNA1132896 | 7138 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Rotifera | other_Eukaryota | 121 | 7.439999999999999e-30 | NR | CAF1931538.1 | 392030 | g7047 | i0 | 67.5 | 10.956 | 83 | 27 | 99.6 | 0 | 2 | 250 | 1166 | 1248 | CAF1931538.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 2739 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata |
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);;