contig_metadata
9 rows where bioproject = "PRJNA950981", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4762249 | 4762249 | PRJNA950981_P_NODE_19724_length_246_cov_0.901734_g19548_i0 | PRJNA950981 | 19724 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 1.12e-29 | NR | RNA26004.1 | 10195 | g19548 | i0 | 73.8 | 1.96341463414634 | 80 | 19 | 97.6 | 2 | 1 | 240 | 182 | 259 | RNA26004.1 ADP-ATP carrier mitochondrial-like [Brachionus plicatilis] | diamond | 483 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 23886204 | 23886204 | PRJNA950981_P_NODE_14819_length_268_cov_1.200000_g14643_i0 | PRJNA950981 | 14819 | 268 | 1.2 | 3.216 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 118 | 3.98e-32 | NR | CAF4332048.1 | 392033 | g14643 | i0 | 73 | 6.98507462686567 | 89 | 24 | 99.6 | 0 | 267 | 1 | 16 | 104 | CAF4332048.1 unnamed protein product, partial [Rotaria sordida] | diamond | 1872 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 27506311 | 27506311 | PRJNA950981_P_NODE_4303_length_465_cov_4.698980_g4128_i0 | PRJNA950981 | 4303 | 465 | 4.69898 | 21.850257 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 198 | 6.32e-60 | NR | CAF1646217.1 | 249248 | g4128 | i0 | 62.1 | 19.5354838709677 | 145 | 55 | 93.5 | 0 | 24 | 458 | 5 | 149 | CAF1646217.1 unnamed protein product, partial [Adineta ricciae] | diamond | 9084 | 199 | 0.994974874371859 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28390145 | 28390145 | PRJNA950981_P_NODE_11786_length_299_cov_1.035398_g11610_i0 | PRJNA950981 | 11786 | 299 | 1.035398 | 3.09584002 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 93.6 | 1.04e-19 | NR | UJR17604.1 | 104782 | g11610 | i0 | 44.4 | 4.96655518394649 | 99 | 52 | 99.3 | 1 | 2 | 298 | 1043 | 1138 | UJR17604.1 hypothetical protein I4U23_004500 [Adineta vaga] | diamond | 1485 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28888712 | 28888712 | PRJNA950981_P_NODE_18308_length_249_cov_0.886364_g18132_i0 | PRJNA950981 | 18308 | 249 | 0.886364 | 2.20704636 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 62.8 | 1.28e-9 | NR | CAF2461420.1 | 2762512 | g18132 | i0 | 42.7 | 2.93975903614458 | 82 | 43 | 96.4 | 3 | 243 | 4 | 103 | 182 | CAF2461420.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 732 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28920198 | 28920198 | PRJNA950981_P_NODE_11148_length_306_cov_1.339056_g10972_i0 | PRJNA950981 | 11148 | 306 | 1.339056 | 4.09751136 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 48.9 | 1.87e-4 | NR | CAF2065473.1 | 392030 | g10972 | i0 | 43.9 | 2.20588235294118 | 57 | 31 | 55.9 | 1 | 287 | 117 | 5 | 60 | CAF2065473.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 675 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30625696 | 30625696 | PRJNA950981_P_NODE_17653_length_250_cov_2.305085_g17477_i0 | PRJNA950981 | 17653 | 250 | 2.305085 | 5.7627125 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 62.8 | 3.13e-9 | NR | CAF1486229.1 | 392033 | g17477 | i0 | 38.2 | 0.912 | 76 | 44 | 90 | 2 | 247 | 23 | 223 | 296 | CAF1486229.1 unnamed protein product [Rotaria sordida] | diamond | 228 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31257815 | 31257815 | PRJNA950981_P_NODE_17155_length_252_cov_0.871508_g16979_i0 | PRJNA950981 | 17155 | 252 | 0.871508 | 2.19620016 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 54.3 | 3.42e-6 | NR | CAF0748197.1 | 249248 | g16979 | i0 | 49.1 | 0.630952380952381 | 53 | 27 | 63.1 | 0 | 9 | 167 | 142 | 194 | CAF0748197.1 unnamed protein product [Adineta ricciae] | diamond | 159 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32308682 | 32308682 | PRJNA950981_P_NODE_3939_length_486_cov_1.087167_g3764_i0 | PRJNA950981 | 3939 | 486 | 1.087167 | 5.28363162 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 57.8 | 2.35e-6 | NR | UJR25340.1 | 104782 | g3764 | i0 | 34 | 4.12962962962963 | 97 | 60 | 58 | 2 | 189 | 470 | 296 | 391 | UJR25340.1 hypothetical protein I4U23_006690 [Adineta vaga] | diamond | 2007 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;