contig_metadata
19 rows where bioproject = "PRJNA908278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11094044 | 11094044 | PRJNA908278_P_NODE_6349_length_466_cov_2.295165_g6246_i0 | PRJNA908278 | 6349 | 466 | 2.295165 | 10.6954689 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 126 | 7.3299999999999985e-34 | NR | KAK2959335.1 | 2049346 | g6246 | i0 | 60.5 | 2.7618025751073 | 86 | 34 | 55.4 | 0 | 443 | 186 | 1 | 86 | KAK2959335.1 putative 60S ribosomal protein L21-A [Blattamonas nauphoetae] | diamond | 1287 | 126 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 16192953 | 16192953 | PRJNA908278_P_NODE_11633_length_360_cov_4.020906_g11530_i0 | PRJNA908278 | 11633 | 360 | 4.020906 | 14.4752616 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 184 | 9.220000000000001e-58 | NR | KAJ4457095.1 | 342808 | g11530 | i0 | 67.8 | 7.91666666666667 | 118 | 38 | 98.3 | 0 | 359 | 6 | 2 | 119 | KAJ4457095.1 putative 40S ribosomal protein S15a [Paratrimastix pyriformis] | diamond | 2850 | 184 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 16193078 | 16193078 | PRJNA908278_P_NODE_24993_length_259_cov_1.231183_g24890_i0 | PRJNA908278 | 24993 | 259 | 1.231183 | 3.18876397 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 121 | 1.17e-33 | NR | KAA6384362.1 | 222440 | g24890 | i0 | 67.1 | 0.94980694980695 | 82 | 26 | 95 | 1 | 12 | 257 | 1 | 81 | KAA6384362.1 MAG: putative FKBP-type peptidyl-prolyl cis-trans isomerase [Streblomastix strix] | diamond | 246 | 121 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 18741667 | 18741667 | PRJNA908278_P_NODE_10675_length_372_cov_16.414716_g10572_i0 | PRJNA908278 | 10675 | 372 | 16.414716 | 61.06274352 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 82.4 | 1.73e-17 | NR | KAJ4453711.1 | 342808 | g10572 | i0 | 55.6 | 4.17741935483871 | 72 | 29 | 58.1 | 1 | 353 | 138 | 2 | 70 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 1554 | 82.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 20016947 | 20016947 | PRJNA908278_P_NODE_35016_length_241_cov_1.273810_g34913_i0 | PRJNA908278 | 35016 | 241 | 1.27381 | 3.0698821 | Trimastix marina | 137419 | Preaxostyla | other_Eukaryota | 147 | 9.67e-31 | NTclustered | gi|84105352|gb|DQ295223.1| | 137419 | g34913 | i0 | 80.749 | 77.0995850622407 | 187 | 36 | 78 | 0 | 26 | 212 | 117 | 303 | Trimastix marina cytosolic heat shock protein 90 (HSP90) gene, partial cds | blastn | 18581 | 147 | 1 | Eukaryota | Metamonada | Preaxostyla | Trimastigidae | Trimastix | Trimastix marina | ||||
| 27253036 | 27253036 | PRJNA908278_P_NODE_4703_length_533_cov_1.004348_g4600_i0 | PRJNA908278 | 4703 | 533 | 1.004348 | 5.35317484 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 151 | 7.69e-39 | NR | KAJ4459864.1 | 342808 | g4600 | i0 | 45.3 | 3.9343339587242 | 172 | 93 | 96.2 | 1 | 2 | 514 | 558 | 729 | KAJ4459864.1 putative Arginine--tRNA ligase [Paratrimastix pyriformis] | diamond | 2097 | 151 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27782693 | 27782693 | PRJNA908278_P_NODE_29624_length_248_cov_0.880000_g29521_i0 | PRJNA908278 | 29624 | 248 | 0.88 | 2.1824 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 48.1 | 4.83e-4 | NR | KAK2948407.1 | 2049346 | g29521 | i0 | 35.4 | 0.580645161290323 | 48 | 31 | 58.1 | 0 | 154 | 11 | 55 | 102 | KAK2948407.1 putative serine/threonine protein kinase [Blattamonas nauphoetae] | diamond | 144 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28761251 | 28761251 | PRJNA908278_P_NODE_29027_length_248_cov_0.880000_g28924_i0 | PRJNA908278 | 29027 | 248 | 0.88 | 2.1824 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 53.1 | 8.5e-6 | NR | KAJ4461644.1 | 342808 | g28924 | i0 | 31 | 1.01612903225806 | 84 | 56 | 99.2 | 2 | 2 | 247 | 212 | 295 | KAJ4461644.1 hypothetical protein PAPYR_1757 [Paratrimastix pyriformis] | diamond | 252 | 53.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28800167 | 28800167 | PRJNA908278_P_NODE_6527_length_461_cov_2.030928_g6424_i0 | PRJNA908278 | 6527 | 461 | 2.030928 | 9.36257808 | Polymastigidae | 302780 | Preaxostyla | other_Eukaryota | 93.6 | 6.35e-19 | NR | KAK2941068.1 | 2049346 | g6424 | i0 | 36.2 | 2.11496746203905 | 163 | 81 | 92.4 | 6 | 439 | 14 | 29 | 189 | KAK2941068.1 putative actin bundling protein [Blattamonas nauphoetae] | diamond | 975 | 94.4 | 0.991525423728813 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 30000419 | 30000419 | PRJNA908278_P_NODE_35951_length_230_cov_3.375796_g35848_i0 | PRJNA908278 | 35951 | 230 | 3.375796 | 7.7643308 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52 | 1.76e-5 | NR | KAJ4454393.1 | 342808 | g35848 | i0 | 41.1 | 1.61739130434783 | 73 | 37 | 95.2 | 2 | 3 | 221 | 1453 | 1519 | KAJ4454393.1 putative Alpha-actinin A [Paratrimastix pyriformis] | diamond | 372 | 52.4 | 0.99236641221374 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30189772 | 30189772 | PRJNA908278_P_NODE_11892_length_357_cov_1.528169_g11789_i0 | PRJNA908278 | 11892 | 357 | 1.5281690000000001 | 5.45556333 | Oxymonadida | 66288 | Preaxostyla | other_Eukaryota | 70.9 | 9.96e-12 | NR | KAJ4456705.1 | 342808 | g11789 | i0 | 37.6 | 1.47058823529412 | 101 | 60 | 83.2 | 2 | 331 | 35 | 1 | 100 | KAJ4456705.1 putative methionyl-tRNA synthetase [Paratrimastix pyriformis] | diamond | 525 | 70.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30845911 | 30845911 | PRJNA908278_P_NODE_16114_length_315_cov_2.144628_g16011_i0 | PRJNA908278 | 16114 | 315 | 2.144628 | 6.7555782 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 82.8 | 6.25e-18 | NR | KAJ4453711.1 | 342808 | g16011 | i0 | 55.4 | 0.704761904761905 | 74 | 30 | 70.5 | 1 | 17 | 238 | 2 | 72 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 222 | 82.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30877441 | 30877441 | PRJNA908278_P_NODE_17174_length_307_cov_1.529915_g17071_i0 | PRJNA908278 | 17174 | 307 | 1.529915 | 4.69683905 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 53.9 | 1.13e-6 | NR | KAJ4453711.1 | 342808 | g17071 | i0 | 61.7 | 0.791530944625407 | 81 | 24 | 74.3 | 3 | 307 | 80 | 35 | 113 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 243 | 53.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31193096 | 31193096 | PRJNA908278_P_NODE_9415_length_392_cov_0.965517_g9312_i0 | PRJNA908278 | 9415 | 392 | 0.965517 | 3.78482664 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 95.5 | 4.92e-20 | NR | KAJ4455423.1 | 342808 | g9312 | i0 | 60 | 0.612244897959184 | 80 | 28 | 58.2 | 2 | 8 | 235 | 387 | 466 | KAJ4455423.1 putative Alpha-amylase A type-3 [Paratrimastix pyriformis] | diamond | 240 | 95.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31193098 | 31193098 | PRJNA908278_P_NODE_995_length_1034_cov_2.422477_g934_i0 | PRJNA908278 | 995 | 1034 | 2.422477 | 25.04841218 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 143 | 1.94e-35 | NR | XP_067734977.1 | 2049356 | g934 | i0 | 36.7 | 1.58704061895551 | 240 | 132 | 63.8 | 5 | 902 | 243 | 8 | 247 | XP_067734977.1 putative La domain-containing protein [Monocercomonoides exilis] | diamond | 1641 | 143 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31351648 | 31351648 | PRJNA908278_P_NODE_17356_length_306_cov_0.991416_g17253_i0 | PRJNA908278 | 17356 | 306 | 0.991416 | 3.03373296 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 51.6 | 5.73e-5 | NR | KAJ4456417.1 | 342808 | g17253 | i0 | 47.3 | 0.53921568627451 | 55 | 28 | 53.9 | 1 | 3 | 167 | 176 | 229 | KAJ4456417.1 putative TNF receptor-associated factor 4 [Paratrimastix pyriformis] | diamond | 165 | 51.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31825835 | 31825835 | PRJNA908278_P_NODE_17677_length_303_cov_1.934783_g17574_i0 | PRJNA908278 | 17677 | 303 | 1.934783 | 5.86239249 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 80.9 | 3.08e-17 | NR | KAJ4453711.1 | 342808 | g17574 | i0 | 55.6 | 2.88118811881188 | 72 | 29 | 71.3 | 1 | 5 | 220 | 2 | 70 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 873 | 80.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31920915 | 31920915 | PRJNA908278_P_NODE_13017_length_344_cov_1.442804_g12914_i0 | PRJNA908278 | 13017 | 344 | 1.442804 | 4.96324576 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.5 | 1.94e-4 | NR | KAJ4460547.1 | 342808 | g12914 | i0 | 35.1 | 0.819767441860465 | 94 | 55 | 76.7 | 2 | 333 | 70 | 12 | 105 | KAJ4460547.1 hypothetical protein PAPYR_3173 [Paratrimastix pyriformis] | diamond | 282 | 48.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32805628 | 32805628 | PRJNA908278_P_NODE_16100_length_315_cov_7.210744_g15997_i0 | PRJNA908278 | 16100 | 315 | 7.210744 | 22.7138436 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 110 | 2.86e-29 | NR | KAA6379614.1 | 222440 | g15997 | i0 | 54.9 | 2.56190476190476 | 91 | 41 | 86.7 | 0 | 313 | 41 | 3 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 807 | 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);;