contig_metadata
7 rows where bioproject = "PRJNA792582" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2052946 | 2052946 | PRJNA792582_P_NODE_41302_length_274_cov_1.557214_g40488_i0 | PRJNA792582 | 41302 | 274 | 1.557214 | 4.26676636 | Mytilina ventralis | 360682 | Rotifera | other_Eukaryota | 296 | 1.05e-75 | NTclustered | gi|83285200|gb|DQ297747.1| | 360682 | g40488 | i0 | 87.549 | 6.30656934306569 | 257 | 31 | 93 | 1 | 19 | 274 | 593 | 337 | Mytilina ventralis 28S ribosomal RNA gene, partial sequence | blastn | 1728 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Mytilina | Mytilina ventralis | |
| 27938305 | 27938305 | PRJNA792582_P_NODE_60025_length_237_cov_2.371951_g59211_i0 | PRJNA792582 | 60025 | 237 | 2.371951 | 5.62152387 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 40 | 0.0403 | NR | CAF3306560.1 | 2762512 | g59211 | i0 | 64.5 | 0.392405063291139 | 31 | 11 | 39.2 | 0 | 129 | 221 | 5 | 35 | CAF3306560.1 unnamed protein product, partial [Rotaria sp. Silwood2] | diamond | 93 | 40 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 29115715 | 29115715 | PRJNA792582_P_NODE_44228_length_266_cov_1.595855_g43414_i0 | PRJNA792582 | 44228 | 266 | 1.595855 | 4.2449743 | Adineta | 104781 | Rotifera | other_Eukaryota | 136 | 2.11e-36 | NR | UJR20801.1 | 104782 | g43414 | i0 | 75 | 44.4924812030075 | 88 | 22 | 99.2 | 0 | 2 | 265 | 54 | 141 | UJR20801.1 hypothetical protein I4U23_023914 [Adineta vaga] | diamond | 11835 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29368249 | 29368249 | PRJNA792582_P_NODE_25189_length_344_cov_1.955720_g24375_i0 | PRJNA792582 | 25189 | 344 | 1.95572 | 6.7276768 | Metazoa | 33208 | Rotifera | other_Eukaryota | 84.7 | 1.31e-16 | NR | RNA03008.1 | 10195 | g24375 | i0 | 80 | 1.6046511627907 | 45 | 9 | 39.2 | 0 | 344 | 210 | 328 | 372 | RNA03008.1 Methionine aminopeptidase 1 [Brachionus plicatilis] | diamond | 552 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30536899 | 30536899 | PRJNA792582_P_NODE_7493_length_612_cov_1.721707_g6705_i0 | PRJNA792582 | 7493 | 612 | 1.721707 | 10.53684684 | Metazoa | 33208 | Rotifera | other_Eukaryota | 231 | 1.82e-70 | NR | UJR29393.1 | 104782 | g6705 | i0 | 53.4 | 12.9117647058824 | 204 | 95 | 100 | 0 | 612 | 1 | 58 | 261 | UJR29393.1 hypothetical protein I4U23_010605 [Adineta vaga] | diamond | 7902 | 233 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31665561 | 31665561 | PRJNA792582_P_NODE_8697_length_573_cov_1.874000_g7901_i0 | PRJNA792582 | 8697 | 573 | 1.874 | 10.73802 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 42.4 | 0.0431 | NR | CAF4909986.1 | 392030 | g7901 | i0 | 43.9 | 0.214659685863874 | 41 | 23 | 21.5 | 0 | 363 | 241 | 8 | 48 | CAF4909986.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 123 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32203480 | 32203480 | PRJNA792582_P_NODE_21478_length_372_cov_1.030100_g20664_i0 | PRJNA792582 | 21478 | 372 | 1.0301 | 3.831972 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 84 | 5.24e-16 | NR | CAF1570775.1 | 392030 | g20664 | i0 | 35.2 | 4.03225806451613 | 125 | 77 | 99.2 | 2 | 371 | 3 | 88 | 210 | CAF1570775.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1500 | 84 | 1 | 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);;