contig_metadata
20 rows where bioproject = "PRJNA270367", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 369912 | 369912 | PRJNA270367_P_NODE_1721_length_1066_cov_2.633235_g1568_i0 | PRJNA270367 | 1721 | 1066 | 2.633235 | 28.0702851 | uncultured Oxymonadida sp. | 413579 | Preaxostyla | other_Eukaryota | 658 | 0 | NTclustered | gi|119116880|gb|DQ924976.1| | 413579 | g1568 | i0 | 78.172 | 91.015947467167 | 1072 | 207 | 99 | 23 | 3 | 1062 | 1130 | 74 | Unidentified Oxymonadida clone 4 alpha-tubulin (Atub) mRNA, partial cds | blastn | 97023 | 658 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | uncultured Oxymonadida sp. | |||||
| 8023271 | 8023271 | PRJNA270367_P_NODE_1467_length_1163_cov_3.982944_g1316_i0 | PRJNA270367 | 1467 | 1163 | 3.982944 | 46.32163872 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 144 | 3.8e-34 | NR | KAJ4455863.1 | 342808 | g1316 | i0 | 40.8 | 0.644883920894239 | 250 | 135 | 62.4 | 5 | 1046 | 321 | 287 | 531 | KAJ4455863.1 putative glycine-rich RNA binding protein [Paratrimastix pyriformis] | diamond | 750 | 144 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 14399048 | 14399048 | PRJNA270367_P_NODE_29072_length_208_cov_0.981132_g28867_i0 | PRJNA270367 | 29072 | 208 | 0.981132 | 2.04075456 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|2794961975|ref|XM_067867602.1| | 2049356 | g28867 | i0 | 100 | 0.134615384615385 | 28 | 0 | 13 | 0 | 35 | 62 | 6216 | 6243 | Monocercomonoides exilis uncharacterized protein (MONOS_14772), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 15672913 | 15672913 | PRJNA270367_P_NODE_4653_length_634_cov_8.276923_g4464_i0 | PRJNA270367 | 4653 | 634 | 8.276923 | 52.47569182 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 257 | 1.24e-63 | NTclustered | gi|2794954461|ref|XM_067876948.1| | 2049356 | g4464 | i0 | 77.65 | 50.2334384858044 | 434 | 89 | 68 | 7 | 165 | 595 | 462 | 34 | Monocercomonoides exilis histone H3 (MONOS_6699), mRNA | blastn | 31848 | 257 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 19496020 | 19496020 | PRJNA270367_P_NODE_33116_length_191_cov_1.091549_g32911_i0 | PRJNA270367 | 33116 | 191 | 1.091549 | 2.08485859 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 91.7 | 9.62e-20 | NR | KAK2944336.1 | 2049346 | g32911 | i0 | 73 | 0.989528795811518 | 63 | 17 | 99 | 0 | 191 | 3 | 203 | 265 | KAK2944336.1 thioredoxin reductase [Blattamonas nauphoetae] | diamond | 189 | 91.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 22046633 | 22046633 | PRJNA270367_P_NODE_36858_length_177_cov_1.500000_g36653_i0 | PRJNA270367 | 36858 | 177 | 1.5 | 2.655 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 167 | 5.12e-37 | NTclustered | gi|74039647|gb|DQ118092.1| | 342808 | g36653 | i0 | 91.667 | 12.0112994350282 | 120 | 10 | 68 | 0 | 58 | 177 | 409 | 528 | Trimastix pyriformis ribosomal protein L7A mRNA, complete cds | blastn | 2126 | 167 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 26979078 | 26979078 | PRJNA270367_P_NODE_17562_length_296_cov_0.842105_g17357_i0 | PRJNA270367 | 17562 | 296 | 0.842105 | 2.4926308 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 144 | 5.31e-40 | NR | KAJ4459981.1 | 342808 | g17357 | i0 | 69.4 | 3.97297297297297 | 98 | 28 | 99.3 | 1 | 295 | 2 | 38 | 133 | KAJ4459981.1 putative Splicing factor 3B subunit 4 [Paratrimastix pyriformis] | diamond | 1176 | 144 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27295324 | 27295324 | PRJNA270367_P_NODE_6003_length_557_cov_2.009843_g5810_i0 | PRJNA270367 | 6003 | 557 | 2.009843 | 11.19482551 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 115 | 6.51e-26 | NR | KAJ4456955.1 | 342808 | g5810 | i0 | 39.8 | 0.974865350089767 | 181 | 78 | 96.4 | 8 | 19 | 555 | 192 | 343 | KAJ4456955.1 putative pregnancy-associated plasma protein A; pappalysin 1 [Paratrimastix pyriformis] | diamond | 543 | 115 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28084644 | 28084644 | PRJNA270367_P_NODE_26905_length_219_cov_1.311765_g26700_i0 | PRJNA270367 | 26905 | 219 | 1.311765 | 2.87276535 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 56.2 | 4.01e-7 | NR | KAJ4456705.1 | 342808 | g26700 | i0 | 39.7 | 0.794520547945205 | 58 | 34 | 79.5 | 1 | 38 | 211 | 1 | 57 | KAJ4456705.1 putative methionyl-tRNA synthetase [Paratrimastix pyriformis] | diamond | 174 | 56.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28084667 | 28084667 | PRJNA270367_P_NODE_42945_length_166_cov_0.880342_g42740_i0 | PRJNA270367 | 42945 | 166 | 0.880342 | 1.46136772 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 54.7 | 2.97e-7 | NR | KAA6357311.1 | 222440 | g42740 | i0 | 49 | 2.69277108433735 | 49 | 25 | 88.6 | 0 | 15 | 161 | 85 | 133 | KAA6357311.1 MAG: putative calcium-translocating P-type ATPase, PMCA-type, partial [Streblomastix strix] | diamond | 447 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28558509 | 28558509 | PRJNA270367_P_NODE_3247_length_764_cov_2.169231_g3069_i0 | PRJNA270367 | 3247 | 764 | 2.169231 | 16.57292484 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 96.7 | 1.22e-18 | NR | KAJ4456955.1 | 342808 | g3069 | i0 | 37 | 0.742146596858639 | 189 | 90 | 68.3 | 7 | 762 | 241 | 416 | 590 | KAJ4456955.1 putative pregnancy-associated plasma protein A; pappalysin 1 [Paratrimastix pyriformis] | diamond | 567 | 96.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28968906 | 28968906 | PRJNA270367_P_NODE_28308_length_212_cov_0.957055_g28103_i0 | PRJNA270367 | 28308 | 212 | 0.957055 | 2.0289566 | Paratrimastix eleionoma | 1709329 | Preaxostyla | other_Eukaryota | 93.6 | 3.12e-20 | NR | WCZ58296.1 | 1709329 | g28103 | i0 | 61.4 | 3.91981132075472 | 70 | 27 | 99.1 | 0 | 2 | 211 | 375 | 444 | WCZ58296.1 general transcription and DNA repair factor IIH helicase subunit, partial [Paratrimastix eleionoma] | diamond | 831 | 93.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix eleionoma | ||||
| 29284367 | 29284367 | PRJNA270367_P_NODE_42289_length_166_cov_1.316239_g42084_i0 | PRJNA270367 | 42289 | 166 | 1.316239 | 2.18495674 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 45.8 | 0.00111 | NR | KAJ4461051.1 | 342808 | g42084 | i0 | 38.8 | 2.81927710843373 | 49 | 30 | 88.6 | 0 | 165 | 19 | 3122 | 3170 | KAJ4461051.1 putative protein kinase [Paratrimastix pyriformis] | diamond | 468 | 45.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29838975 | 29838975 | PRJNA270367_P_NODE_26231_length_223_cov_0.896552_g26026_i0 | PRJNA270367 | 26231 | 223 | 0.896552 | 1.99931096 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 42.4 | 0.0394 | NR | KAJ4458650.1 | 342808 | g26026 | i0 | 52.8 | 0.968609865470852 | 36 | 17 | 48.4 | 0 | 110 | 3 | 319 | 354 | KAJ4458650.1 putative Pyruvate carboxylase [Paratrimastix pyriformis] | diamond | 216 | 42.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31527893 | 31527893 | PRJNA270367_P_NODE_41576_length_167_cov_0.881356_g41371_i0 | PRJNA270367 | 41576 | 167 | 0.881356 | 1.47186452 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 68.9 | 7.64e-12 | NR | KAK2951950.1 | 2049346 | g41371 | i0 | 61.7 | 4.61676646706587 | 47 | 18 | 84.4 | 0 | 25 | 165 | 253 | 299 | KAK2951950.1 putative Casein kinase I [Blattamonas nauphoetae] | diamond | 771 | 68.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 32002299 | 32002299 | PRJNA270367_P_NODE_43198_length_165_cov_1.344828_g42993_i0 | PRJNA270367 | 43198 | 165 | 1.344828 | 2.2189662 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 47.8 | 1.11e-4 | NR | KAJ4462916.1 | 342808 | g42993 | i0 | 41.7 | 0.872727272727273 | 48 | 27 | 87.3 | 1 | 165 | 22 | 117 | 163 | KAJ4462916.1 putative cytoplasmic protein [Paratrimastix pyriformis] | diamond | 144 | 47.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32192201 | 32192201 | PRJNA270367_P_NODE_23218_length_242_cov_1.585492_g23013_i0 | PRJNA270367 | 23218 | 242 | 1.585492 | 3.83689064 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 127 | 1.14e-35 | NR | KAJ4457791.1 | 342808 | g23013 | i0 | 73.2 | 0.880165289256198 | 71 | 19 | 88 | 0 | 229 | 17 | 63 | 133 | KAJ4457791.1 putative Ctype lysozyme/alpha-lactalbumin superfamily protein [Paratrimastix pyriformis] | diamond | 213 | 127 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32494810 | 32494810 | PRJNA270367_P_NODE_34959_length_184_cov_1.155556_g34754_i0 | PRJNA270367 | 34959 | 184 | 1.155556 | 2.12622304 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.9 | 5.53e-10 | NR | KAJ4460929.1 | 342808 | g34754 | i0 | 75 | 2.08695652173913 | 40 | 10 | 65.2 | 0 | 6 | 125 | 1328 | 1367 | KAJ4460929.1 ion-transporting P-type ATPase [Paratrimastix pyriformis] | diamond | 384 | 63.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32634475 | 32634475 | PRJNA270367_P_NODE_42320_length_166_cov_1.085470_g42115_i0 | PRJNA270367 | 42320 | 166 | 1.08547 | 1.8018802 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 93.2 | 2.13e-20 | NR | KAJ4456700.1 | 342808 | g42115 | i0 | 80 | 0.993975903614458 | 55 | 11 | 99.4 | 0 | 2 | 166 | 216 | 270 | KAJ4456700.1 putative Extracellular signal-regulated kinase 2 [Paratrimastix pyriformis] | diamond | 165 | 93.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32746858 | 32746858 | PRJNA270367_P_NODE_14180_length_342_cov_3.252560_g13975_i0 | PRJNA270367 | 14180 | 342 | 3.25256 | 11.1237552 | root | 1 | Root_unresolved | Root_unresolved | 111 | 2.08e-29 | NR | KAA6379614.1 | 222440 | g13975 | i0 | 58.2 | 2.37719298245614 | 91 | 38 | 79.8 | 0 | 342 | 70 | 3 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 813 | 111 | 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);;