contig_metadata
21 rows where bioproject = "PRJNA407886" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26600379 | 26600379 | PRJNA407886_P_NODE_59061_length_277_cov_1.132353_g57367_i0 | PRJNA407886 | 59061 | 277 | 1.132353 | 3.13661781 | Parcubacteria group bacterium GW2 | 2026774 | Bacteria | Bacteria | 43.9 | 0.0187 | NR | KKR54673.1 | 1618816 | g57367 | i0 | 43.5 | 0.671480144404332 | 62 | 27 | 58.5 | 2 | 59 | 220 | 138 | 199 | KKR54673.1 MAG: hypothetical protein UT91_C0011G0038 [Parcubacteria group bacterium GW2011_GWA2_40_23] | diamond | 186 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium GW2011_GWA2_40_23 | |||||||
| 27075470 | 27075470 | PRJNA407886_P_NODE_24542_length_486_cov_1.857143_g22851_i0 | PRJNA407886 | 24542 | 486 | 1.857143 | 9.02571498 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 106 | 7.57e-25 | NR | MDD4027124.1 | 2053613 | g22851 | i0 | 43.9 | 0.759259259259259 | 123 | 69 | 75.9 | 0 | 373 | 5 | 45 | 167 | MDD4027124.1 SIMPL domain-containing protein [Candidatus Shapirobacteria bacterium] | diamond | 369 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 27075504 | 27075504 | PRJNA407886_P_NODE_60442_length_273_cov_1.540000_g58748_i0 | PRJNA407886 | 60442 | 273 | 1.54 | 4.2042 | Candidatus Babeliaceae bacterium | 2545253 | Bacteria | Bacteria | 66.6 | 2.15e-10 | NR | HVX00123.1 | 2545253 | g58748 | i0 | 34.4 | 3.95604395604396 | 90 | 58 | 98.9 | 1 | 270 | 1 | 525 | 613 | HVX00123.1 RNase H-like domain-containing protein [Candidatus Babeliaceae bacterium] | diamond | 1080 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliaceae | Candidatus Babeliaceae bacterium | ||||
| 27265247 | 27265247 | PRJNA407886_P_NODE_62583_length_267_cov_2.855670_g60889_i0 | PRJNA407886 | 62583 | 267 | 2.85567 | 7.6246389 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 71.6 | 4.12e-14 | NR | RTL06915.1 | 2030827 | g60889 | i0 | 67.4 | 0.51685393258427 | 46 | 15 | 51.7 | 0 | 235 | 98 | 37 | 82 | RTL06915.1 MAG: hypothetical protein EKK58_03725 [Candidatus Dependentiae bacterium] | diamond | 138 | 71.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 27281930 | 27281930 | PRJNA407886_P_NODE_76583_length_245_cov_0.895349_g74889_i0 | PRJNA407886 | 76583 | 245 | 0.895349 | 2.19360505 | Candidatus Nanoperiomorbus | 2171988 | Bacteria | Bacteria | 165 | 2.9299999999999997e-45 | NR | WP_129621723.1 | 2171989 | g74889 | i0 | 100 | 2.97551020408163 | 81 | 0 | 99.2 | 0 | 2 | 244 | 605 | 685 | WP_129621723.1 class I tRNA ligase family protein, partial [Candidatus Nanoperiomorbus periodonticus] | diamond | 729 | 165 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanoperiomorbia | Candidatus Nanoperiomorbales | Candidatus Nanoperiomorbaceae | Candidatus Nanoperiomorbus | Candidatus Nanoperiomorbus periodonticus | ||
| 27296788 | 27296788 | PRJNA407886_P_NODE_68243_length_254_cov_1.458564_g66549_i0 | PRJNA407886 | 68243 | 254 | 1.458564 | 3.70475256 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 44.3 | 0.012 | NR | PYN36212.1 | 2053607 | g66549 | i0 | 34.9 | 0.980314960629921 | 83 | 40 | 92.1 | 2 | 5 | 238 | 162 | 235 | PYN36212.1 MAG: hypothetical protein DME01_09510 [Candidatus Rokuibacteriota bacterium] | diamond | 249 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28117677 | 28117677 | PRJNA407886_P_NODE_69845_length_251_cov_0.865169_g68151_i0 | PRJNA407886 | 69845 | 251 | 0.865169 | 2.17157419 | candidate division BRC1 bacterium HGW-BRC1-1 | 2013722 | Bacteria | Bacteria | 58.5 | 1.08e-7 | NR | PKO20148.1 | 2013722 | g68151 | i0 | 66.7 | 1.00398406374502 | 42 | 13 | 49 | 1 | 127 | 249 | 2 | 43 | PKO20148.1 MAG: amine oxidase [candidate division BRC1 bacterium HGW-BRC1-1] | diamond | 252 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | candidate division BRC1 bacterium HGW-BRC1-1 | ||||||
| 28212237 | 28212237 | PRJNA407886_P_NODE_19486_length_582_cov_2.257367_g17807_i0 | PRJNA407886 | 19486 | 582 | 2.257367 | 13.13787594 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 77.8 | 7.14e-13 | NR | MBI4080147.1 | 2052151 | g17807 | i0 | 36.2 | 0.896907216494845 | 174 | 98 | 88.7 | 7 | 17 | 532 | 310 | 472 | MBI4080147.1 DUF1416 domain-containing protein [Candidatus Levyibacteriota bacterium] | diamond | 522 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 28433606 | 28433606 | PRJNA407886_P_NODE_75566_length_246_cov_0.890173_g73872_i0 | PRJNA407886 | 75566 | 246 | 0.890173 | 2.18982558 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 42 | 0.0314 | NR | MCA9343866.1 | 2026720 | g73872 | i0 | 29.6 | 0.98780487804878 | 81 | 51 | 91.5 | 1 | 227 | 3 | 44 | 124 | MCA9343866.1 YtxH domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 243 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29159915 | 29159915 | PRJNA407886_P_NODE_31789_length_402_cov_1.401216_g30095_i0 | PRJNA407886 | 31789 | 402 | 1.401216 | 5.63288832 | Candidatus Babeliaceae bacterium | 2545253 | Bacteria | Bacteria | 86.3 | 1.29e-16 | NR | HVX00123.1 | 2545253 | g30095 | i0 | 45.4 | 0.723880597014925 | 97 | 48 | 70.1 | 3 | 395 | 114 | 608 | 702 | HVX00123.1 RNase H-like domain-containing protein [Candidatus Babeliaceae bacterium] | diamond | 291 | 86.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliaceae | Candidatus Babeliaceae bacterium | ||||
| 29191392 | 29191392 | PRJNA407886_P_NODE_49729_length_305_cov_1.405172_g48035_i0 | PRJNA407886 | 49729 | 305 | 1.405172 | 4.2857746 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 187 | 3.05e-57 | NR | HRN71286.1 | 2026804 | g48035 | i0 | 97 | 0.99344262295082 | 101 | 3 | 99.3 | 0 | 3 | 305 | 38 | 138 | HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium] | diamond | 303 | 187 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 29191397 | 29191397 | PRJNA407886_P_NODE_54189_length_290_cov_3.640553_g52495_i0 | PRJNA407886 | 54189 | 290 | 3.640553 | 10.5576037 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 197 | 8.25e-63 | NR | HRO65834.1 | 2099670 | g52495 | i0 | 99 | 0.993103448275862 | 96 | 1 | 99.3 | 0 | 289 | 2 | 37 | 132 | HRO65834.1 uL15 family ribosomal protein [Candidatus Dojkabacteria bacterium] | diamond | 288 | 197 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 29443655 | 29443655 | PRJNA407886_P_NODE_65390_length_260_cov_3.540107_g63696_i0 | PRJNA407886 | 65390 | 260 | 3.540107 | 9.2042782 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 171 | 6.199999999999998e-53 | NR | HRO65834.1 | 2099670 | g63696 | i0 | 98.8 | 0.992307692307692 | 86 | 1 | 99.2 | 0 | 258 | 1 | 8 | 93 | HRO65834.1 uL15 family ribosomal protein [Candidatus Dojkabacteria bacterium] | diamond | 258 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 30106965 | 30106965 | PRJNA407886_P_NODE_13652_length_776_cov_1.837838_g12112_i0 | PRJNA407886 | 13652 | 776 | 1.837838 | 14.26162288 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 99 | 1.11e-20 | NR | RTL06913.1 | 2030827 | g12112 | i0 | 34.2 | 0.746134020618557 | 193 | 122 | 73.5 | 2 | 200 | 769 | 27 | 217 | RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium] | diamond | 579 | 99 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 30138333 | 30138333 | PRJNA407886_P_NODE_80452_length_242_cov_0.911243_g78758_i0 | PRJNA407886 | 80452 | 242 | 0.911243 | 2.20520806 | Candidatus Anderseniibacteriota bacterium | 2053502 | Bacteria | Bacteria | 63.2 | 8.31e-11 | NR | MEX1112196.1 | 2053502 | g78758 | i0 | 40 | 1.83471074380165 | 75 | 45 | 93 | 0 | 239 | 15 | 12 | 86 | MEX1112196.1 30S ribosomal protein S17 [Candidatus Andersenbacteria bacterium] | diamond | 444 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Anderseniibacteriota | Candidatus Anderseniibacteriota bacterium | ||||||
| 30660883 | 30660883 | PRJNA407886_P_NODE_83513_length_229_cov_2.269231_g81819_i0 | PRJNA407886 | 83513 | 229 | 2.269231 | 5.19653899 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57.4 | 2.2e-7 | NR | OGJ69531.1 | 1801929 | g81819 | i0 | 73.3 | 1.58515283842795 | 30 | 8 | 39.3 | 0 | 229 | 140 | 1053 | 1082 | OGJ69531.1 MAG: hypothetical protein A3H90_02690 [Candidatus Peribacteria bacterium RIFCSPLOWO2_02_FULL_55_36] | diamond | 363 | 57.8 | 0.993079584775087 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium RIFCSPLOWO2_02_FULL_55_36 | |||||
| 30928669 | 30928669 | PRJNA407886_P_NODE_49394_length_306_cov_2.313305_g47700_i0 | PRJNA407886 | 49394 | 306 | 2.313305 | 7.0787133 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 50.4 | 8.22e-5 | NR | MFS8160316.1 | 2282149 | g47700 | i0 | 37.7 | 0.676470588235294 | 69 | 38 | 67.6 | 2 | 2 | 208 | 134 | 197 | MFS8160316.1 WD40 repeat domain-containing protein [Candidatus Roizmanbacteria bacterium] | diamond | 207 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 31276124 | 31276124 | PRJNA407886_P_NODE_42215_length_335_cov_2.209924_g40521_i0 | PRJNA407886 | 42215 | 335 | 2.209924 | 7.4032454 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 122 | 8.05e-34 | NR | HRN71285.1 | 2026804 | g40521 | i0 | 96.6 | 0.528358208955224 | 59 | 2 | 52.8 | 0 | 334 | 158 | 27 | 85 | HRN71285.1 hypothetical protein [Candidatus Woesebacteria bacterium] | diamond | 177 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 31592689 | 31592689 | PRJNA407886_P_NODE_43476_length_330_cov_1.190661_g41782_i0 | PRJNA407886 | 43476 | 330 | 1.190661 | 3.9291813 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 43.5 | 0.0472 | NR | MBP9667417.1 | 2026720 | g41782 | i0 | 28.8 | 0.6 | 66 | 41 | 54.5 | 1 | 148 | 327 | 87 | 152 | MBP9667417.1 orotidine 5'-phosphate decarboxylase [Candidatus Saccharibacteria bacterium] | diamond | 198 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32162091 | 32162091 | PRJNA407886_P_NODE_42798_length_333_cov_1.107692_g41104_i0 | PRJNA407886 | 42798 | 333 | 1.107692 | 3.68861436 | Candidatus Babeliaceae bacterium | 2545253 | Bacteria | Bacteria | 130 | 5.84e-33 | NR | HVW99438.1 | 2545253 | g41104 | i0 | 56.9 | 1.96396396396396 | 109 | 47 | 98.2 | 0 | 4 | 330 | 187 | 295 | HVW99438.1 DDE-type integrase/transposase/recombinase [Candidatus Babeliaceae bacterium] | diamond | 654 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliaceae | Candidatus Babeliaceae bacterium | ||||
| 32446933 | 32446933 | PRJNA407886_P_NODE_65159_length_261_cov_1.638298_g63465_i0 | PRJNA407886 | 65159 | 261 | 1.638298 | 4.27595778 | Candidatus Acetothermia bacterium | 2053493 | Bacteria | Bacteria | 67.4 | 9.38e-11 | NR | HAZ27488.1 | 2053493 | g63465 | i0 | 78.4 | 2.94252873563218 | 37 | 8 | 42.5 | 0 | 147 | 257 | 1 | 37 | HAZ27488.1 hydroxylamine reductase [Candidatus Acetothermia bacterium] | diamond | 768 | 67.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Acetothermia 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);;