contig_metadata
12 rows where bioproject = "PRJNA971593", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3494816 | 3494816 | PRJNA971593_P_NODE_1383_length_978_cov_1.780110_g1277_i0 | PRJNA971593 | 1383 | 978 | 1.78011 | 17.4094758 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 69.4 | 9.84e-7 | NTclustered | gi|2794979275|ref|XM_067863086.1| | 2049356 | g1277 | i0 | 95.349 | 1.83333333333333 | 43 | 2 | 4 | 0 | 477 | 519 | 1323 | 1365 | Monocercomonoides exilis uncharacterized protein (MONOS_10622), partial mRNA | blastn | 1793 | 69.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 8597361 | 8597361 | PRJNA971593_P_NODE_6207_length_488_cov_3.718072_g6059_i0 | PRJNA971593 | 6207 | 488 | 3.718072 | 18.14419136 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 198 | 7.62e-62 | NR | KAJ4460954.1 | 342808 | g6059 | i0 | 61.3 | 5.40368852459016 | 150 | 58 | 92.2 | 0 | 454 | 5 | 23 | 172 | KAJ4460954.1 putative 40S ribosomal protein S11 [Paratrimastix pyriformis] | diamond | 2637 | 198 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 13697915 | 13697915 | PRJNA971593_P_NODE_19731_length_267_cov_1.963918_g19582_i0 | PRJNA971593 | 19731 | 267 | 1.963918 | 5.24366106 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 58.4 | 5.25e-4 | NTclustered | gi|2794963613|ref|XM_067873380.1| | 2049356 | g19582 | i0 | 100 | 1.10112359550562 | 31 | 0 | 12 | 0 | 109 | 139 | 7956 | 7986 | Monocercomonoides exilis uncharacterized protein (MONOS_3382), partial mRNA | blastn | 294 | 58.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 14020145 | 14020145 | PRJNA971593_P_NODE_5711_length_508_cov_5.443678_g5563_i0 | PRJNA971593 | 5711 | 508 | 5.443678 | 27.65388424 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 85.9 | 1.69e-17 | NR | KAA6370095.1 | 222440 | g5563 | i0 | 45.6 | 3.05314960629921 | 114 | 60 | 66.7 | 2 | 23 | 361 | 1 | 113 | KAA6370095.1 MAG: hypothetical protein EZS28_034377 [Streblomastix strix] | diamond | 1551 | 85.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 22621524 | 22621524 | PRJNA971593_P_NODE_6218_length_488_cov_1.761446_g6070_i0 | PRJNA971593 | 6218 | 488 | 1.761446 | 8.59585648 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.013 | NTclustered | gi|2794959160|ref|XM_067863523.1| | 2049356 | g6070 | i0 | 96.97 | 0.0676229508196721 | 33 | 0 | 7 | 1 | 255 | 286 | 284 | 252 | Monocercomonoides exilis uncharacterized protein (MONOS_11026), partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 26810721 | 26810721 | PRJNA971593_P_NODE_28441_length_242_cov_0.911243_g28292_i0 | PRJNA971593 | 28441 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 1.77e-32 | NR | KAA6380283.1 | 222440 | g28292 | i0 | 76.3 | 12.8925619834711 | 80 | 19 | 99.2 | 0 | 2 | 241 | 72 | 151 | KAA6380283.1 MAG: putative Casein kinase I [Streblomastix strix] | diamond | 3120 | 130 | 0.992307692307692 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29836359 | 29836359 | PRJNA971593_P_NODE_311_length_1695_cov_9.017263_g254_i0 | PRJNA971593 | 311 | 1695 | 9.017263 | 152.84260785 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 98.6 | 8.89e-18 | NR | KAJ4461670.1 | 342808 | g254 | i0 | 22.8 | 0.692035398230089 | 391 | 273 | 67.6 | 11 | 1379 | 234 | 102 | 472 | KAJ4461670.1 putative LBP/BPI/CETP family protein [Paratrimastix pyriformis] | diamond | 1173 | 98.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29868036 | 29868036 | PRJNA971593_P_NODE_14251_length_319_cov_0.939024_g14102_i0 | PRJNA971593 | 14251 | 319 | 0.939024 | 2.99548656 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 85.1 | 3.83e-17 | NR | KAJ4454700.1 | 342808 | g14102 | i0 | 52.2 | 0.846394984326019 | 90 | 40 | 83.7 | 2 | 269 | 3 | 11 | 98 | KAJ4454700.1 putative Gamma-glutamyl hydrolase A [Paratrimastix pyriformis] | diamond | 270 | 85.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31005419 | 31005419 | PRJNA971593_P_NODE_13594_length_326_cov_3.043478_g13445_i0 | PRJNA971593 | 13594 | 326 | 3.043478 | 9.92173828 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 113 | 2.8699999999999997e-30 | NR | KAA6379614.1 | 222440 | g13445 | i0 | 58.1 | 5.80674846625767 | 93 | 39 | 85.6 | 0 | 325 | 47 | 1 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 1893 | 113 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31384879 | 31384879 | PRJNA971593_P_NODE_15516_length_304_cov_1.333333_g15367_i0 | PRJNA971593 | 15516 | 304 | 1.333333 | 4.05333232 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 110 | 2.45e-29 | NR | KAA6379614.1 | 222440 | g15367 | i0 | 58.2 | 2.67434210526316 | 91 | 38 | 89.8 | 0 | 302 | 30 | 3 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 813 | 110 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31954004 | 31954004 | PRJNA971593_P_NODE_16697_length_291_cov_1.766055_g16548_i0 | PRJNA971593 | 16697 | 291 | 1.766055 | 5.13922005 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 56.2 | 1.71e-7 | NR | KAA6352702.1 | 222440 | g16548 | i0 | 34.4 | 0.989690721649485 | 96 | 59 | 97.9 | 2 | 289 | 5 | 27 | 119 | KAA6352702.1 MAG: putative vesicle-associated membrane protein [Streblomastix strix] | diamond | 288 | 56.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32239166 | 32239166 | PRJNA971593_P_NODE_26638_length_245_cov_0.895349_g26489_i0 | PRJNA971593 | 26638 | 245 | 0.895349 | 2.19360505 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 47.4 | 8.61e-4 | NR | KAA6373569.1 | 222440 | g26489 | i0 | 38.2 | 1.86122448979592 | 76 | 45 | 93.1 | 2 | 15 | 242 | 198 | 271 | KAA6373569.1 MAG: putative Replication protein A 70 kDa DNA-binding subunit, partial [Streblomastix strix] | diamond | 456 | 47.4 | 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);;