contig_metadata
12 rows where bioproject = "PRJNA870096" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14877815 | 14877815 | PRJNA870096_S_NODE_15672_length_461_cov_5.023923_g14031_i0 | PRJNA870096 | 15672 | 461 | 5.023923 | 23.16028503 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 170 | 6.3999999999999985e-49 | NR | MYC75063.1 | 2026781 | g14031 | i0 | 52.9 | 12.9370932754881 | 153 | 70 | 98.9 | 2 | 456 | 1 | 173 | 324 | MYC75063.1 NADP-dependent oxidoreductase [Candidatus Poribacteria bacterium] | diamond | 5964 | 170 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 27023532 | 27023532 | PRJNA870096_S_NODE_89922_length_186_cov_0.867133_g88258_i0 | PRJNA870096 | 89922 | 186 | 0.867133 | 1.61286738 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 41.6 | 0.0436 | NR | HSX02891.1 | 2890869 | g88258 | i0 | 39.5 | 0.612903225806452 | 38 | 23 | 61.3 | 0 | 167 | 54 | 252 | 289 | HSX02891.1 hypothetical protein [Candidatus Saccharimonadia bacterium] | diamond | 114 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 28065873 | 28065873 | PRJNA870096_S_NODE_17245_length_439_cov_2.638889_g15598_i0 | PRJNA870096 | 17245 | 439 | 2.638889 | 11.58472271 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 69.7 | 5.27e-11 | NR | MFS8160432.1 | 2282149 | g15598 | i0 | 35.1 | 0.662870159453303 | 97 | 61 | 65.6 | 2 | 405 | 118 | 178 | 273 | MFS8160432.1 hypothetical protein [Candidatus Roizmanbacteria bacterium] | diamond | 291 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 28160813 | 28160813 | PRJNA870096_S_NODE_101665_length_175_cov_1.818182_g100001_i0 | PRJNA870096 | 101665 | 175 | 1.818182 | 3.1818185 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 44.7 | 0.00303 | NR | MFS8160432.1 | 2282149 | g100001 | i0 | 40.4 | 0.891428571428571 | 52 | 31 | 89.1 | 0 | 5 | 160 | 222 | 273 | MFS8160432.1 hypothetical protein [Candidatus Roizmanbacteria bacterium] | diamond | 156 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 28571019 | 28571019 | PRJNA870096_S_NODE_134307_length_154_cov_1.297297_g132643_i0 | PRJNA870096 | 134307 | 154 | 1.297297 | 1.99783738 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 58.9 | 2.16e-8 | NR | MBI2638329.1 | 2030811 | g132643 | i0 | 52.8 | 1.03246753246753 | 53 | 23 | 99.4 | 1 | 2 | 154 | 382 | 434 | MBI2638329.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Peregrinibacteria bacterium] | diamond | 159 | 58.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 29392122 | 29392122 | PRJNA870096_S_NODE_63249_length_220_cov_2.135593_g61585_i0 | PRJNA870096 | 63249 | 220 | 2.135593 | 4.6983046 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 97.1 | 1.66e-21 | NR | MCX5923494.1 | 2030827 | g61585 | i0 | 60.9 | 3.79090909090909 | 69 | 27 | 94.1 | 0 | 208 | 2 | 400 | 468 | MCX5923494.1 DUF4804 domain-containing protein [Candidatus Dependentiae bacterium] | diamond | 834 | 97.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 29518220 | 29518220 | PRJNA870096_S_NODE_25050_length_360_cov_4.056782_g23386_i0 | PRJNA870096 | 25050 | 360 | 4.056782 | 14.6044152 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 80.5 | 1.79e-16 | NR | HKA52333.1 | 2838779 | g23386 | i0 | 48.6 | 0.875 | 105 | 51 | 86.7 | 3 | 353 | 42 | 31 | 133 | HKA52333.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 315 | 80.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30221139 | 30221139 | PRJNA870096_S_NODE_143652_length_151_cov_0.888889_g141988_i0 | PRJNA870096 | 143652 | 151 | 0.888889 | 1.34222239 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42.4 | 0.00809 | NR | HKB24774.1 | 2072417 | g141988 | i0 | 48.6 | 2.26490066225166 | 37 | 18 | 73.5 | 1 | 127 | 17 | 86 | 121 | HKB24774.1 NUDIX hydrolase [Candidatus Methylomirabilota bacterium] | diamond | 342 | 42.7 | 0.992974238875878 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31160671 | 31160671 | PRJNA870096_S_NODE_45715_length_261_cov_3.256881_g44051_i0 | PRJNA870096 | 45715 | 261 | 3.256881 | 8.50045941 | Parcubacteria group bacterium GW2 | 2026774 | Bacteria | Bacteria | 59.3 | 3.17e-9 | NR | KKW23571.1 | 1618856 | g44051 | i0 | 30.7 | 3.22988505747126 | 75 | 51 | 86.2 | 1 | 258 | 34 | 17 | 90 | KKW23571.1 MAG: 50S ribosomal protein L32 [Parcubacteria group bacterium GW2011_GWA2_51_12] | diamond | 843 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium GW2011_GWA2_51_12 | |||||||
| 32244931 | 32244931 | PRJNA870096_S_NODE_47378_length_256_cov_2.436620_g45714_i0 | PRJNA870096 | 47378 | 256 | 2.43662 | 6.2377472 | Bacteria | 2 | Bacteria | Bacteria | 65.5 | 3.62e-11 | NR | MFA5936110.1 | 2052139 | g45714 | i0 | 48 | 1.734375 | 75 | 35 | 86.7 | 2 | 35 | 256 | 66 | 137 | MFA5936110.1 DUF1761 domain-containing protein [Patescibacteria group bacterium] | diamond | 444 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32584684 | 32584684 | PRJNA870096_S_NODE_119279_length_163_cov_1.200000_g117615_i0 | PRJNA870096 | 119279 | 163 | 1.2 | 1.956 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 52.8 | 9.86e-7 | NR | MCL4419573.1 | 2052139 | g117615 | i0 | 49.1 | 0.975460122699387 | 53 | 26 | 97.5 | 1 | 5 | 163 | 82 | 133 | MCL4419573.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 159 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32867800 | 32867800 | PRJNA870096_S_NODE_28820_length_334_cov_1.979381_g27156_i0 | PRJNA870096 | 28820 | 334 | 1.979381 | 6.61113254 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 94.4 | 8.88e-22 | NR | MFA6099077.1 | 2052139 | g27156 | i0 | 51.1 | 0.808383233532934 | 90 | 43 | 80.8 | 1 | 3 | 272 | 78 | 166 | MFA6099077.1 phosphoribosyltransferase family protein [Patescibacteria group bacterium] | diamond | 270 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium |
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);;