contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA446034" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17015608 | 17015608 | PRJNA446034_S_NODE_57134_length_178_cov_1.900709_g57097_i0 | PRJNA446034 | 57134 | 178 | 1.900709 | 3.38326202 | Candidatus Mycosynbacter | 2831665 | Bacteria | Bacteria | 107 | 2.65e-25 | NR | MBH1980377.1 | 2026720 | g57097 | i0 | 91.5 | 24.8426966292135 | 59 | 5 | 99.4 | 0 | 2 | 178 | 601 | 659 | MBH1980377.1 ATP-dependent Clp protease ATP-binding subunit [Candidatus Saccharibacteria bacterium] | diamond | 4422 | 108 | 0.990740740740741 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 26680695 | 26680695 | PRJNA446034_S_NODE_70261_length_169_cov_3.719697_g70224_i0 | PRJNA446034 | 70261 | 169 | 3.719697 | 6.28628793 | Bacteria | 2 | Bacteria | Bacteria | 68.2 | 1.21e-11 | NR | TWO99495.1 | 713053 | g70224 | i0 | 100 | 1.17159763313609 | 33 | 0 | 58.6 | 0 | 169 | 71 | 308 | 340 | TWO99495.1 DNA-protecting protein DprA [TM7 phylum sp. oral taxon 351] | diamond | 198 | 68.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 351 | ||||||
| 26727411 | 26727411 | PRJNA446034_S_NODE_108901_length_152_cov_2.756522_g108864_i0 | PRJNA446034 | 108901 | 152 | 2.756522 | 4.18991344 | TM7 phylum sp. oral taxon 351 | 713053 | Bacteria | Bacteria | 92 | 2.22e-21 | NR | TWO99455.1 | 713053 | g108864 | i0 | 92 | 0.986842105263158 | 50 | 4 | 98.7 | 0 | 152 | 3 | 164 | 213 | TWO99455.1 hypothetical protein EUA79_00150 [TM7 phylum sp. oral taxon 351] | diamond | 150 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 351 | ||||||
| 26871188 | 26871188 | PRJNA446034_S_NODE_37781_length_196_cov_1.704403_g37744_i0 | PRJNA446034 | 37781 | 196 | 1.704403 | 3.34062988 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 128 | 5.82e-34 | NR | MBB1535906.1 | 2026720 | g37744 | i0 | 100 | 1.98979591836735 | 65 | 0 | 99.5 | 0 | 195 | 1 | 201 | 265 | MBB1535906.1 pilus assembly protein PilM [Candidatus Saccharibacteria bacterium] | diamond | 390 | 128 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27455441 | 27455441 | PRJNA446034_S_NODE_16223_length_236_cov_2.055276_g16186_i0 | PRJNA446034 | 16223 | 236 | 2.055276 | 4.85045136 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 146 | 1.94e-41 | NR | MBF1037776.1 | 2725945 | g16186 | i0 | 98.7 | 0.991525423728814 | 78 | 1 | 99.2 | 0 | 236 | 3 | 156 | 233 | MBF1037776.1 hypothetical protein [Candidatus Nanosynbacter sp.] | diamond | 234 | 146 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. | ||
| 28623651 | 28623651 | PRJNA446034_S_NODE_101507_length_155_cov_1.254237_g101470_i0 | PRJNA446034 | 101507 | 155 | 1.254237 | 1.94406735 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 76.3 | 2.31e-16 | NR | MBB1549352.1 | 2026720 | g101470 | i0 | 97.2 | 0.696774193548387 | 36 | 1 | 69.7 | 0 | 46 | 153 | 1 | 36 | MBB1549352.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 108 | 76.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28797424 | 28797424 | PRJNA446034_S_NODE_108227_length_152_cov_4.139130_g108190_i0 | PRJNA446034 | 108227 | 152 | 4.13913 | 6.2914776 | Bacteria | 2 | Bacteria | Bacteria | 102 | 3.1799999999999998e-24 | NR | PIY95344.1 | 1974471 | g108190 | i0 | 96 | 2.96052631578947 | 50 | 2 | 98.7 | 0 | 150 | 1 | 22 | 71 | PIY95344.1 MAG: modification methylase [Candidatus Komeilibacteria bacterium CG_4_10_14_0_8_um_filter_37_78] | diamond | 450 | 103 | 0.990291262135922 | Bacteria | Bacteria candidate phyla | Candidatus Komeiliibacteriota | Candidatus Komeilibacteria bacterium CG_4_10_14_0_8_um_filter_37_78 | ||||||
| 28844330 | 28844330 | PRJNA446034_S_NODE_44448_length_188_cov_7.490066_g44411_i0 | PRJNA446034 | 44448 | 188 | 7.490066 | 14.08132408 | Candidatus Elulimicrobium humile | 2802965 | Bacteria | Bacteria | 82 | 1.19e-17 | NR | NBP59458.1 | 2802965 | g44411 | i0 | 59 | 5.79255319148936 | 61 | 25 | 97.3 | 0 | 186 | 4 | 61 | 121 | NBP59458.1 hypothetical protein [Candidatus Elulimicrobium humile] | diamond | 1089 | 82 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Elulimicrobiota | Candidatus Elulimicrobia | Candidatus Elulimicrobiales | Candidatus Elulimicrobiaceae | Candidatus Elulimicrobium | Candidatus Elulimicrobium humile | ||
| 28844333 | 28844333 | PRJNA446034_S_NODE_53608_length_180_cov_7.888112_g53571_i0 | PRJNA446034 | 53608 | 180 | 7.888112 | 14.1986016 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 66.2 | 8.03e-11 | NR | RTL04440.1 | 2030827 | g53571 | i0 | 51.7 | 0.966666666666667 | 58 | 28 | 96.7 | 0 | 179 | 6 | 481 | 538 | RTL04440.1 MAG: toprim domain-containing protein [Candidatus Dependentiae bacterium] | diamond | 174 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 29286419 | 29286419 | PRJNA446034_S_NODE_41249_length_192_cov_1.974194_g41212_i0 | PRJNA446034 | 41249 | 192 | 1.974194 | 3.79045248 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 104 | 2.71e-24 | NR | MEO5690863.1 | 2973664 | g41212 | i0 | 82.5 | 1.96875 | 63 | 11 | 98.4 | 0 | 3 | 191 | 530 | 592 | MEO5690863.1 excinuclease ABC subunit UvrB [Candidatus Saccharimonadales bacterium] | diamond | 378 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29318065 | 29318065 | PRJNA446034_S_NODE_98849_length_156_cov_1.260504_g98812_i0 | PRJNA446034 | 98849 | 156 | 1.260504 | 1.96638624 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 72.4 | 2.62e-13 | NR | MBR0460713.1 | 2026720 | g98812 | i0 | 64.7 | 0.980769230769231 | 51 | 18 | 98.1 | 0 | 3 | 155 | 234 | 284 | MBR0460713.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 153 | 72.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29507490 | 29507490 | PRJNA446034_S_NODE_19070_length_228_cov_1.979058_g19033_i0 | PRJNA446034 | 19070 | 228 | 1.979058 | 4.51225224 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 65.5 | 2.95e-10 | NR | MBP7767140.1 | 2026720 | g19033 | i0 | 45.8 | 2.85526315789474 | 72 | 36 | 93.4 | 2 | 215 | 3 | 643 | 712 | MBP7767140.1 M1 family metallopeptidase [Candidatus Saccharibacteria bacterium] | diamond | 651 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29507511 | 29507511 | PRJNA446034_S_NODE_92370_length_158_cov_4.115702_g92333_i0 | PRJNA446034 | 92370 | 158 | 4.115702 | 6.50280916 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 100 | 6.02e-26 | NR | HBO64853.1 | 2026720 | g92333 | i0 | 98 | 0.968354430379747 | 51 | 1 | 96.8 | 0 | 6 | 158 | 28 | 78 | HBO64853.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 153 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29696616 | 29696616 | PRJNA446034_S_NODE_5110_length_306_cov_2.680297_g5073_i0 | PRJNA446034 | 5110 | 306 | 2.680297 | 8.20170882 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 197 | 5.23e-62 | NR | RKW00680.1 | 1917697 | g5073 | i0 | 96 | 0.990196078431373 | 101 | 4 | 99 | 0 | 304 | 2 | 109 | 209 | RKW00680.1 MAG: MBL fold metallo-hydrolase [Candidatus Saccharimonas sp.] | diamond | 303 | 197 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 29981303 | 29981303 | PRJNA446034_S_NODE_85931_length_161_cov_2.919355_g85894_i0 | PRJNA446034 | 85931 | 161 | 2.919355 | 4.70016155 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 51.6 | 9.02e-6 | NR | MDP7367631.1 | 2053589 | g85894 | i0 | 51 | 2.66459627329193 | 49 | 24 | 91.3 | 0 | 13 | 159 | 124 | 172 | MDP7367631.1 DEAD/DEAH box helicase family protein [Candidatus Paceibacterota bacterium] | diamond | 429 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30345610 | 30345610 | PRJNA446034_S_NODE_112892_length_151_cov_1.543860_g112855_i0 | PRJNA446034 | 112892 | 151 | 1.54386 | 2.3312286 | Bacteria | 2 | Bacteria | Bacteria | 54.3 | 1.98e-7 | NR | KKQ08696.1 | 1618471 | g112855 | i0 | 56.8 | 1.74834437086093 | 44 | 19 | 87.4 | 0 | 132 | 1 | 19 | 62 | KKQ08696.1 MAG: hypothetical protein US20_C0013G0046 [Candidatus Pacebacteria bacterium GW2011_GWF1_36_5] | diamond | 264 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Candidatus Pacebacteria bacterium GW2011_GWF1_36_5 | ||||||
| 30661006 | 30661006 | PRJNA446034_S_NODE_38953_length_194_cov_5.675159_g38916_i0 | PRJNA446034 | 38953 | 194 | 5.675159 | 11.00980846 | root | 1 | Root_unresolved | Root_unresolved | 57.4 | 6.37e-8 | NR | MCA9313347.1 | 2026720 | g38916 | i0 | 55.1 | 2.90721649484536 | 49 | 17 | 68 | 1 | 2 | 133 | 8 | 56 | MCA9313347.1 DNA adenine methylase [Candidatus Saccharibacteria bacterium] | diamond | 564 | 57.8 | 0.993079584775087 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31624594 | 31624594 | PRJNA446034_S_NODE_17596_length_232_cov_2.271795_g17559_i0 | PRJNA446034 | 17596 | 232 | 2.271795 | 5.2705644 | Parcubacteria group bacterium ADurb.Bin216 | 1852939 | Bacteria | Bacteria | 60.5 | 4.74e-10 | NR | OQB09933.1 | 1852939 | g17559 | i0 | 54 | 0.646551724137931 | 50 | 21 | 62.1 | 1 | 2 | 145 | 22 | 71 | OQB09933.1 MAG: hypothetical protein BWY21_00580 [Parcubacteria group bacterium ADurb.Bin216] | diamond | 150 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium ADurb.Bin216 | |||||||
| 31909372 | 31909372 | PRJNA446034_S_NODE_76577_length_166_cov_1.209302_g76540_i0 | PRJNA446034 | 76577 | 166 | 1.209302 | 2.00744132 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 78.6 | 3.35e-16 | NR | HSX14586.1 | 2973664 | g76540 | i0 | 66.1 | 1.01204819277108 | 56 | 18 | 99.4 | 1 | 2 | 166 | 84 | 139 | HSX14586.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 168 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 32289423 | 32289423 | PRJNA446034_S_NODE_38579_length_195_cov_1.962025_g38542_i0 | PRJNA446034 | 38579 | 195 | 1.962025 | 3.82594875 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 117 | 5.89e-29 | NR | MEO5949866.1 | 2973664 | g38542 | i0 | 90.5 | 1.93846153846154 | 63 | 6 | 96.9 | 0 | 191 | 3 | 273 | 335 | MEO5949866.1 DUF2075 domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 378 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 32447485 | 32447485 | PRJNA446034_S_NODE_63139_length_173_cov_17.536765_g63102_i0 | PRJNA446034 | 63139 | 173 | 17.536765 | 30.33860345 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 111 | 1.08e-26 | NR | OJU87563.1 | 1895829 | g63102 | i0 | 89.5 | 2.96531791907514 | 57 | 6 | 98.8 | 0 | 172 | 2 | 591 | 647 | OJU87563.1 MAG: leucine--tRNA ligase [Candidatus Saccharibacteria bacterium 49-20] | diamond | 513 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 |
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);;