contig_metadata
9 rows where bioproject = "PRJNA876641", tax_clade = "Metamonada" and tax_phylum = "Preaxostyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13992374 | 13992374 | PRJNA876641_P_NODE_2911_length_426_cov_1.645892_g2837_i0 | PRJNA876641 | 2911 | 426 | 1.645892 | 7.01149992 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 179 | 2.83e-49 | NR | KAJ4460566.1 | 342808 | g2837 | i0 | 65.9 | 2.92253521126761 | 135 | 46 | 95.1 | 0 | 1 | 405 | 721 | 855 | KAJ4460566.1 putative 60S ribosomal protein L4-B [Paratrimastix pyriformis] | diamond | 1245 | 179 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 18704781 | 18704781 | PRJNA876641_P_NODE_9595_length_284_cov_2.000000_g9521_i0 | PRJNA876641 | 9595 | 284 | 2 | 5.68 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 58.5 | 1.69e-7 | NR | XP_067730750.1 | 2049356 | g9521 | i0 | 73.5 | 0.940140845070423 | 34 | 9 | 35.9 | 0 | 284 | 183 | 723 | 756 | XP_067730750.1 putative E3 ubiquitin-protein ligase Itchy [Monocercomonoides exilis] | diamond | 267 | 58.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 25079119 | 25079119 | PRJNA876641_P_NODE_10760_length_278_cov_1.126829_g10686_i0 | PRJNA876641 | 10760 | 278 | 1.126829 | 3.13258462 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 58.4 | 5.5e-4 | NTclustered | gi|2794962939|ref|XM_067866283.1| | 2049356 | g10686 | i0 | 100 | 0.111510791366906 | 31 | 0 | 11 | 0 | 247 | 277 | 1579 | 1609 | Monocercomonoides exilis uncharacterized protein (MONOS_1357), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27023589 | 27023589 | PRJNA876641_P_NODE_20462_length_245_cov_0.895349_g20388_i0 | PRJNA876641 | 20462 | 245 | 0.895349 | 2.19360505 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 42.4 | 0.0417 | NR | KAK2964313.1 | 2049346 | g20388 | i0 | 43.1 | 0.624489795918367 | 51 | 22 | 62.4 | 1 | 5 | 157 | 42 | 85 | KAK2964313.1 putative Elongation factor 1-beta [Blattamonas nauphoetae] | diamond | 153 | 42.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28003015 | 28003015 | PRJNA876641_P_NODE_14325_length_258_cov_1.270270_g14251_i0 | PRJNA876641 | 14325 | 258 | 1.27027 | 3.2772966 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 103 | 2.45e-23 | NR | KAJ4460551.1 | 342808 | g14251 | i0 | 57.6 | 0.988372093023256 | 85 | 36 | 98.8 | 0 | 256 | 2 | 962 | 1046 | KAJ4460551.1 hypothetical protein PAPYR_3178 [Paratrimastix pyriformis] | diamond | 255 | 103 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30750433 | 30750433 | PRJNA876641_P_NODE_13514_length_262_cov_1.629630_g13440_i0 | PRJNA876641 | 13514 | 262 | 1.62963 | 4.2696306 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 77.8 | 1.23e-16 | NR | KAJ4461601.1 | 342808 | g13440 | i0 | 52 | 0.858778625954199 | 75 | 36 | 85.9 | 0 | 7 | 231 | 1 | 75 | KAJ4461601.1 hypothetical protein PAPYR_1706 [Paratrimastix pyriformis] | diamond | 225 | 77.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31097753 | 31097753 | PRJNA876641_P_NODE_15915_length_251_cov_0.865169_g15841_i0 | PRJNA876641 | 15915 | 251 | 0.865169 | 2.17157419 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 47.8 | 6.99e-4 | NR | KAJ4461021.1 | 342808 | g15841 | i0 | 52.1 | 0.99203187250996006 | 48 | 16 | 49 | 1 | 243 | 121 | 336 | 383 | KAJ4461021.1 putative MmpL efflux pump [Paratrimastix pyriformis] | diamond | 249 | 47.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31611963 | 31611963 | PRJNA876641_P_NODE_18616_length_247_cov_1.425287_g18542_i0 | PRJNA876641 | 18616 | 247 | 1.425287 | 3.52045889 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.1 | 0.0273 | NR | KAA6392845.1 | 222440 | g18542 | i0 | 32.5 | 1.8582995951417 | 80 | 47 | 88.7 | 3 | 27 | 245 | 99 | 178 | KAA6392845.1 MAG: hypothetical protein EZS28_011628 [Streblomastix strix] | diamond | 459 | 43.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32426492 | 32426492 | PRJNA876641_P_NODE_6279_length_325_cov_1.309524_g6205_i0 | PRJNA876641 | 6279 | 325 | 1.309524 | 4.255953 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 110 | 6.7200000000000006e-29 | NR | KAA6379614.1 | 222440 | g6205 | i0 | 57.8 | 2.47384615384615 | 90 | 38 | 83.1 | 0 | 1 | 270 | 4 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 804 | 110 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix |
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);;