contig_metadata
11 rows where bioproject = "PRJNA407087", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2965715 | 2965715 | PRJNA407087_S_NODE_7743_length_174_cov_3.310345_g7280_i0 | PRJNA407087 | 7743 | 174 | 3.310345 | 5.7600003 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|2794961975|ref|XM_067867602.1| | 2049356 | g7280 | i0 | 100 | 0.160919540229885 | 28 | 0 | 16 | 0 | 31 | 58 | 6243 | 6216 | Monocercomonoides exilis uncharacterized protein (MONOS_14772), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 16992507 | 16992507 | PRJNA407087_S_NODE_7854_length_173_cov_1.645833_g7391_i0 | PRJNA407087 | 7854 | 173 | 1.645833 | 2.84729109 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 84.3 | 4.47e-18 | NR | XP_067734276.1 | 2049356 | g7391 | i0 | 76.9 | 2.79190751445087 | 52 | 12 | 90.2 | 0 | 159 | 4 | 170 | 221 | XP_067734276.1 putative parkin co-regulated protein [Monocercomonoides exilis] | diamond | 483 | 84.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 28117597 | 28117597 | PRJNA407087_S_NODE_4445_length_257_cov_4.719298_g3982_i0 | PRJNA407087 | 4445 | 257 | 4.719298 | 12.12859586 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 67.4 | 4.35e-11 | NR | KAA6375409.1 | 222440 | g3982 | i0 | 51.7 | 3.11673151750973 | 60 | 28 | 70 | 1 | 7 | 186 | 14 | 72 | KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix] | diamond | 801 | 67.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29380678 | 29380678 | PRJNA407087_S_NODE_8869_length_160_cov_5.770992_g8406_i0 | PRJNA407087 | 8869 | 160 | 5.770992 | 9.2335872 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 69.3 | 5.09e-12 | NR | KAJ4460411.1 | 342808 | g8406 | i0 | 57.7 | 1.96875 | 52 | 22 | 97.5 | 0 | 1 | 156 | 177 | 228 | KAJ4460411.1 putative carboxylic ester hydrolase [Paratrimastix pyriformis] | diamond | 315 | 69.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30106937 | 30106937 | PRJNA407087_S_NODE_9432_length_155_cov_2.587302_g8969_i0 | PRJNA407087 | 9432 | 155 | 2.587302 | 4.0103181 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 63.2 | 6.94e-10 | NR | KAJ4462343.1 | 342808 | g8969 | i0 | 55.8 | 1.00645161290323 | 52 | 21 | 98.7 | 2 | 2 | 154 | 111 | 161 | KAJ4462343.1 putative Transcriptional repressor NF-X1 [Paratrimastix pyriformis] | diamond | 156 | 63.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30850375 | 30850375 | PRJNA407087_S_NODE_2994_length_353_cov_22.401235_g2532_i0 | PRJNA407087 | 2994 | 353 | 22.401235 | 79.07635955 | root | 1 | Root_unresolved | Root_unresolved | 108 | 5.44e-28 | NR | KAA6379614.1 | 222440 | g2532 | i0 | 57.3 | 2.25212464589235 | 89 | 38 | 75.6 | 0 | 2 | 268 | 5 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 795 | 108 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31040278 | 31040278 | PRJNA407087_S_NODE_2635_length_387_cov_69.670391_g2174_i0 | PRJNA407087 | 2635 | 387 | 69.670391 | 269.62441317 | root | 1 | Root_unresolved | Root_unresolved | 114 | 3.0299999999999997e-30 | NR | KAA6379614.1 | 222440 | g2174 | i0 | 58.1 | 2.83720930232558 | 93 | 39 | 72.1 | 0 | 364 | 86 | 1 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 1098 | 114 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31356242 | 31356242 | PRJNA407087_S_NODE_3616_length_302_cov_3.351648_g3153_i0 | PRJNA407087 | 3616 | 302 | 3.351648 | 10.12197696 | Viridiplantae | 33090 | Preaxostyla | other_Eukaryota | 140 | 6.83e-38 | NR | KAJ4454657.1 | 342808 | g3153 | i0 | 60 | 7.82781456953642 | 100 | 40 | 99.3 | 0 | 300 | 1 | 181 | 280 | KAJ4454657.1 putative Developmentally-regulated G-protein 3 [Paratrimastix pyriformis] | diamond | 2364 | 140 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32003739 | 32003739 | PRJNA407087_S_NODE_5378_length_221_cov_4.328125_g4915_i0 | PRJNA407087 | 5378 | 221 | 4.328125 | 9.56515625 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 67.4 | 4.57e-11 | NR | KAJ4459378.1 | 342808 | g4915 | i0 | 39.3 | 1.14027149321267 | 84 | 39 | 97.7 | 1 | 221 | 6 | 187 | 270 | KAJ4459378.1 putative Cathepsin B [Paratrimastix pyriformis] | diamond | 252 | 67.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32604659 | 32604659 | PRJNA407087_S_NODE_5340_length_222_cov_4.290155_g4877_i0 | PRJNA407087 | 5340 | 222 | 4.290155 | 9.5241441 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 64.7 | 3.57e-10 | NR | XP_067719831.1 | 2049356 | g4877 | i0 | 46.4 | 1.55405405405405 | 56 | 29 | 74.3 | 1 | 1 | 165 | 81 | 136 | XP_067719831.1 putative protein YIPF1/2 [Monocercomonoides exilis] | diamond | 345 | 64.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32635930 | 32635930 | PRJNA407087_S_NODE_8820_length_161_cov_2.446970_g8357_i0 | PRJNA407087 | 8820 | 161 | 2.44697 | 3.9396217 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 70.1 | 2.65e-12 | NR | XP_067725722.1 | 2049356 | g8357 | i0 | 68.8 | 3.5776397515528 | 48 | 15 | 89.4 | 0 | 18 | 161 | 96 | 143 | XP_067725722.1 Vacuolar protein sorting 4C (Vps4C) [Monocercomonoides exilis] | diamond | 576 | 70.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis |
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);;