contig_metadata
12 rows where bioproject = "PRJNA975724", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3496127 | 3496127 | PRJNA975724_S_NODE_15903_length_407_cov_9.380240_g15722_i0 | PRJNA975724 | 15903 | 407 | 9.38024 | 38.1775768 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 107 | 1.08e-27 | NR | MBN1857846.1 | 2306012 | g15722 | i0 | 74.2 | 0.486486486486487 | 66 | 17 | 48.6 | 0 | 87 | 284 | 4 | 69 | MBN1857846.1 cold-shock protein [Candidatus Bipolaricaulota bacterium] | diamond | 198 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 4773927 | 4773927 | PRJNA975724_S_NODE_20644_length_383_cov_8.154839_g20463_i0 | PRJNA975724 | 20644 | 383 | 8.154839 | 31.23303337 | Parcubacteria group bacterium CG | 2026774 | Bacteria | Bacteria | 149 | 1.01e-40 | NR | PIS34603.1 | 2014323 | g20463 | i0 | 67.7 | 10.2062663185379 | 99 | 32 | 77.5 | 0 | 5 | 301 | 300 | 398 | PIS34603.1 MAG: elongation factor Tu [Parcubacteria group bacterium CG08_land_8_20_14_0_20_43_9] | diamond | 3909 | 149 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium CG08_land_8_20_14_0_20_43_9 | |||||||
| 27057629 | 27057629 | PRJNA975724_S_NODE_6182_length_499_cov_2.009390_g6003_i0 | PRJNA975724 | 6182 | 499 | 2.00939 | 10.0268561 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 75.1 | 2.33e-13 | NR | MEK7187714.1 | 2052139 | g6003 | i0 | 43 | 0.517034068136273 | 86 | 49 | 51.7 | 0 | 484 | 227 | 90 | 175 | MEK7187714.1 NUDIX domain-containing protein [Patescibacteria group bacterium] | diamond | 258 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27594846 | 27594846 | PRJNA975724_S_NODE_84904_length_246_cov_0.890173_g84723_i0 | PRJNA975724 | 84904 | 246 | 0.890173 | 2.18982558 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 55.5 | 6.35e-7 | NR | MCX7017712.1 | 2107588 | g84723 | i0 | 40.7 | 1.81707317073171 | 59 | 35 | 72 | 0 | 29 | 205 | 61 | 119 | MCX7017712.1 YbjN domain-containing protein [Candidatus Sumerlaeota bacterium] | diamond | 447 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 27658073 | 27658073 | PRJNA975724_S_NODE_90664_length_241_cov_2.059524_g90483_i0 | PRJNA975724 | 90664 | 241 | 2.059524 | 4.96345284 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 91.7 | 2.23e-19 | NR | PLX28907.1 | 2762014 | g90483 | i0 | 70.6 | 1.70539419087137 | 68 | 16 | 84.6 | 2 | 5 | 208 | 698 | 761 | PLX28907.1 MAG: hypothetical protein C0581_00580 [Candidatus Parcubacteria bacterium] | diamond | 411 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 30594592 | 30594592 | PRJNA975724_S_NODE_68973_length_264_cov_1.528796_g68792_i0 | PRJNA975724 | 68973 | 264 | 1.528796 | 4.03602144 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 61.2 | 1.43e-8 | NR | MDR3548550.1 | 2053589 | g68792 | i0 | 40 | 1.88636363636364 | 85 | 50 | 96.6 | 1 | 3 | 257 | 277 | 360 | MDR3548550.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 498 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30695708 | 30695708 | PRJNA975724_S_NODE_88733_length_243_cov_0.905882_g88552_i0 | PRJNA975724 | 88733 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 48.1 | 1.87e-4 | NR | OGH21289.1 | 1798598 | g88552 | i0 | 50 | 4.85185185185185 | 52 | 24 | 61.7 | 1 | 30 | 179 | 93 | 144 | OGH21289.1 MAG: 30S ribosomal protein S7 [Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_41_15] | diamond | 1179 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_41_15 | ||||||
| 30720992 | 30720992 | PRJNA975724_S_NODE_12754_length_428_cov_1.729577_g12573_i0 | PRJNA975724 | 12754 | 428 | 1.729577 | 7.40258956 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 136 | 2.8199999999999997e-37 | NR | MBR2726012.1 | 2026720 | g12573 | i0 | 61.2 | 0.72196261682243 | 103 | 39 | 71.5 | 1 | 1 | 306 | 113 | 215 | MBR2726012.1 uracil-DNA glycosylase [Candidatus Saccharibacteria bacterium] | diamond | 309 | 136 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31701113 | 31701113 | PRJNA975724_S_NODE_30457_length_346_cov_7.630037_g30276_i0 | PRJNA975724 | 30457 | 346 | 7.630037 | 26.39992802 | Candidatus Babeliales bacterium | 2803731 | Bacteria | Bacteria | 45.8 | 0.0088 | NR | MEX0939744.1 | 2803731 | g30276 | i0 | 44 | 0.433526011560694 | 50 | 28 | 43.4 | 0 | 4 | 153 | 265 | 314 | MEX0939744.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Babeliales bacterium] | diamond | 150 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliales bacterium | |||||
| 32681081 | 32681081 | PRJNA975724_S_NODE_25280_length_364_cov_5.178694_g25099_i0 | PRJNA975724 | 25280 | 364 | 5.178694 | 18.85044616 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 130 | 3.4e-33 | NR | MCL2451447.1 | 2026720 | g25099 | i0 | 59 | 0.865384615384615 | 105 | 43 | 86.5 | 0 | 364 | 50 | 314 | 418 | MCL2451447.1 asparagine synthase-related protein [Candidatus Saccharibacteria bacterium] | diamond | 315 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32681082 | 32681082 | PRJNA975724_S_NODE_3560_length_567_cov_1.787449_g3383_i0 | PRJNA975724 | 3560 | 567 | 1.787449 | 10.13483583 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 147 | 2.34e-39 | NR | MBP6875432.1 | 2212470 | g3383 | i0 | 66.4 | 2.35978835978836 | 110 | 34 | 58.2 | 1 | 567 | 238 | 61 | 167 | MBP6875432.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 1338 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32807277 | 32807277 | PRJNA975724_S_NODE_93960_length_227_cov_2.097403_g93779_i0 | PRJNA975724 | 93960 | 227 | 2.097403 | 4.76110481 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 42 | 0.0313 | NR | MYE91290.1 | 2026781 | g93779 | i0 | 59.4 | 0.422907488986784 | 32 | 11 | 42.3 | 1 | 3 | 98 | 121 | 150 | MYE91290.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 96 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria 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);;