contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax_phylum = "Mollusca"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22558876 | 22558876 | PRJNA902848_P_NODE_17838_length_246_cov_0.901734_g17788_i0 | PRJNA902848 | 17838 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.1 | 6.97e-19 | NR | XP_052765036.1 | 6604 | g17788 | i0 | 57 | 3.59756097560976 | 79 | 29 | 96.3 | 1 | 240 | 4 | 97 | 170 | XP_052765036.1 uncharacterized protein LOC128206531 isoform X1 [Mya arenaria] | diamond | 885 | 90.9 | 0.991199119911991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 29045488 | 29045488 | PRJNA902848_P_NODE_10548_length_278_cov_1.995122_g10498_i0 | PRJNA902848 | 10548 | 278 | 1.995122 | 5.54643916 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 43.5 | 0.00961 | NR | KAL4219916.1 | 2302425 | g10498 | i0 | 31.9 | 1.96402877697842 | 91 | 57 | 93.9 | 2 | 272 | 12 | 10 | 99 | KAL4219916.1 hypothetical protein ACF0H5_020328 [Mactra antiquata] | diamond | 546 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 29771408 | 29771408 | PRJNA902848_P_NODE_13251_length_253_cov_0.866667_g13201_i0 | PRJNA902848 | 13251 | 253 | 0.866667 | 2.19266751 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 115 | 7.54e-28 | NR | XP_041354624.1 | 1735272 | g13201 | i0 | 63.1 | 0.99604743083004 | 84 | 31 | 99.6 | 0 | 253 | 2 | 161 | 244 | XP_041354624.1 nuclear fragile X mental retardation-interacting protein 1-like [Gigantopelta aegis] | diamond | 252 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 30442737 | 30442737 | PRJNA902848_P_NODE_10013_length_285_cov_1.103774_g9963_i0 | PRJNA902848 | 10013 | 285 | 1.103774 | 3.1457559 | Metazoa | 33208 | Mollusca | Mollusca | 175 | 9.33e-53 | NR | XP_065923949.1 | 29159 | g9963 | i0 | 89.5 | 194.157894736842 | 95 | 10 | 100 | 0 | 285 | 1 | 43 | 137 | XP_065923949.1 ras-related protein Rab-8A isoform X1 [Magallana gigas] | diamond | 55335 | 176 | 0.994318181818182 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31699392 | 31699392 | PRJNA902848_P_NODE_14657_length_251_cov_0.876404_g14607_i0 | PRJNA902848 | 14657 | 251 | 0.876404 | 2.19977404 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 75.9 | 8.69e-14 | NR | RUS78787.1 | 188477 | g14607 | i0 | 42.2 | 0.99203187250996006 | 83 | 44 | 99.2 | 1 | 1 | 249 | 181 | 259 | RUS78787.1 hypothetical protein EGW08_013437 [Elysia chlorotica] | diamond | 249 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 32427083 | 32427083 | PRJNA902848_P_NODE_9319_length_293_cov_1.063636_g9269_i0 | PRJNA902848 | 9319 | 293 | 1.063636 | 3.11645348 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 111 | 5.71e-26 | NR | XP_041351713.1 | 1735272 | g9269 | i0 | 54.2 | 0.982935153583618 | 96 | 43 | 98.3 | 1 | 4 | 291 | 227 | 321 | XP_041351713.1 uncharacterized protein LOC121370501 [Gigantopelta aegis] | diamond | 288 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis |
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);;