contig_metadata
26 rows where analysis = "diamond" and tax_phylum = "Candidatus Coatesiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21338116 | 21338116 | PRJNA951810_P_NODE_141437_length_264_cov_7.910995_g141092_i0 | PRJNA951810 | 141437 | 264 | 7.910995 | 20.8850268 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 144 | 7.39e-39 | NR | RLC48553.1 | 2250272 | g141092 | i0 | 69.3 | 8 | 88 | 27 | 100 | 0 | 264 | 1 | 226 | 313 | RLC48553.1 MAG: L-lysine 6-transaminase [Candidatus Coatesbacteria bacterium] | diamond | 2112 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 24015465 | 24015465 | PRJNA312107_P_NODE_17539_length_174_cov_1.632000_g17373_i0 | PRJNA312107 | 17539 | 174 | 1.632 | 2.83968 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 105 | 8.5e-25 | NR | MEK7474158.1 | 2250272 | g17373 | i0 | 81 | 2 | 58 | 11 | 100 | 0 | 1 | 174 | 94 | 151 | MEK7474158.1 xylulokinase [Candidatus Coatesbacteria bacterium] | diamond | 348 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 26691626 | 26691626 | PRJNA1148190_P_NODE_615941_length_249_cov_2.534091_g604768_i0 | PRJNA1148190 | 615941 | 249 | 2.534091 | 6.30988659 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 44.7 | 0.00798 | NR | RLC41288.1 | 2250272 | g604768 | i0 | 44.1 | 0.819277108433735 | 68 | 35 | 80.7 | 2 | 2 | 202 | 21 | 86 | RLC41288.1 MAG: hypothetical protein DRH51_03485 [Candidatus Coatesbacteria bacterium] | diamond | 204 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 26711471 | 26711471 | PRJNA1237347_P_NODE_388261_length_285_cov_0.886792_g381688_i0 | PRJNA1237347 | 388261 | 285 | 0.886792 | 2.5273572 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47.8 | 7.34e-4 | NR | MEK7474050.1 | 2250272 | g381688 | i0 | 57.7 | 1.63157894736842 | 52 | 22 | 54.7 | 0 | 18 | 173 | 164 | 215 | MEK7474050.1 ankyrin repeat domain-containing protein [Candidatus Coatesbacteria bacterium] | diamond | 465 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 26946316 | 26946316 | PRJNA1237347_P_NODE_245542_length_379_cov_1.186275_g238969_i0 | PRJNA1237347 | 245542 | 379 | 1.186275 | 4.49598225 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 51.2 | 1.74e-4 | NR | MBN2208130.1 | 2250272 | g238969 | i0 | 33.6 | 1.06068601583113 | 134 | 61 | 93.4 | 7 | 22 | 375 | 204 | 325 | MBN2208130.1 FG-GAP repeat protein [Candidatus Coatesbacteria bacterium] | diamond | 402 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 27460862 | 27460862 | PRJNA666695_S_NODE_132663_length_190_cov_2.469799_g131569_i0 | PRJNA666695 | 132663 | 190 | 2.469799 | 4.6926181 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 50.8 | 2.59e-5 | NR | UCE26776.1 | 2250272 | g131569 | i0 | 36.4 | 1.04210526315789 | 66 | 38 | 97.9 | 1 | 190 | 5 | 512 | 577 | UCE26776.1 MAG: hypothetical protein JSW52_10590 [Candidatus Coatesbacteria bacterium] | diamond | 198 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 27878802 | 27878802 | PRJNA966993_P_NODE_77005_length_259_cov_1.655914_g76553_i0 | PRJNA966993 | 77005 | 259 | 1.655914 | 4.28881726 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 43.5 | 0.025 | NR | MEK7474859.1 | 2250272 | g76553 | i0 | 32.3 | 0.718146718146718 | 62 | 41 | 71.8 | 1 | 255 | 70 | 80 | 140 | MEK7474859.1 glycoside hydrolase family 38 C-terminal domain-containing protein [Candidatus Coatesbacteria bacterium] | diamond | 186 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 28089706 | 28089706 | PRJNA561212_P_NODE_11785_length_323_cov_1.188000_g11574_i0 | PRJNA561212 | 11785 | 323 | 1.188 | 3.83724 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 60.5 | 3.13e-8 | NR | MBN1233556.1 | 2250272 | g11574 | i0 | 60.5 | 1.18885448916409 | 43 | 17 | 39.9 | 0 | 313 | 185 | 3 | 45 | MBN1233556.1 T9SS type A sorting domain-containing protein [Candidatus Coatesbacteria bacterium] | diamond | 384 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 28378947 | 28378947 | PRJNA741997_P_NODE_39386_length_346_cov_1.128205_g38266_i0 | PRJNA741997 | 39386 | 346 | 1.128205 | 3.9035893 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 45.8 | 0.0102 | NR | MEK7475803.1 | 2250272 | g38266 | i0 | 39.5 | 0.658959537572254 | 76 | 42 | 65.9 | 1 | 116 | 343 | 167 | 238 | MEK7475803.1 PPC domain-containing protein [Candidatus Coatesbacteria bacterium] | diamond | 228 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 28884125 | 28884125 | PRJNA741997_P_NODE_78288_length_247_cov_2.649425_g77168_i0 | PRJNA741997 | 78288 | 247 | 2.649425 | 6.54407975 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 88.2 | 4.06e-18 | NR | MBN2209197.1 | 2250272 | g77168 | i0 | 53.7 | 0.995951417004049 | 82 | 38 | 99.6 | 0 | 246 | 1 | 463 | 544 | MBN2209197.1 S8 family serine peptidase [Candidatus Coatesbacteria bacterium] | diamond | 246 | 88.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 28884890 | 28884890 | PRJNA773247_P_NODE_27848_length_263_cov_3.005263_g27764_i0 | PRJNA773247 | 27848 | 263 | 3.005263 | 7.90384169 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 62.8 | 8e-11 | NR | RLC40435.1 | 2250272 | g27764 | i0 | 46.5 | 0.809885931558935 | 71 | 34 | 81 | 2 | 225 | 13 | 3 | 69 | RLC40435.1 MAG: hypothetical protein DRH51_05555, partial [Candidatus Coatesbacteria bacterium] | diamond | 213 | 62.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 29014348 | 29014348 | PRJNA911178_P_NODE_238448_length_252_cov_0.966480_g235974_i0 | PRJNA911178 | 238448 | 252 | 0.96648 | 2.4355296 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 71.2 | 3.65e-12 | NR | MEK7476231.1 | 2250272 | g235974 | i0 | 44.6 | 0.988095238095238 | 83 | 44 | 97.6 | 2 | 247 | 2 | 138 | 219 | MEK7476231.1 hypothetical protein [Candidatus Coatesbacteria bacterium] | diamond | 249 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 29346314 | 29346314 | PRJNA1199330_P_NODE_77509_length_275_cov_1.544554_g76810_i0 | PRJNA1199330 | 77509 | 275 | 1.544554 | 4.2475235 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 43.9 | 0.0199 | NR | MBD3399019.1 | 2250272 | g76810 | i0 | 33.3 | 0.752727272727273 | 69 | 44 | 75.3 | 1 | 21 | 227 | 21 | 87 | MBD3399019.1 hypothetical protein [Candidatus Coatesbacteria bacterium] | diamond | 207 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 30096118 | 30096118 | PRJEB12982_P_NODE_17892_length_166_cov_0.871795_g17729_i0 | PRJEB12982 | 17892 | 166 | 0.871795 | 1.4471797 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 58.9 | 2.5e-8 | NR | MBN2208665.1 | 2250272 | g17729 | i0 | 48.1 | 1.91566265060241 | 54 | 25 | 92.2 | 1 | 8 | 160 | 182 | 235 | MBN2208665.1 molecular chaperone DnaJ [Candidatus Coatesbacteria bacterium] | diamond | 318 | 58.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 30103199 | 30103199 | PRJNA1148190_P_NODE_764552_length_242_cov_0.911243_g753379_i0 | PRJNA1148190 | 764552 | 242 | 0.911243 | 2.20520806 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 127 | 4.499999999999999e-32 | NR | MEK7475103.1 | 2250272 | g753379 | i0 | 83.5 | 0.979338842975207 | 79 | 13 | 97.9 | 0 | 6 | 242 | 381 | 459 | MEK7475103.1 type I restriction endonuclease subunit R [Candidatus Coatesbacteria bacterium] | diamond | 237 | 127 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 30325753 | 30325753 | PRJNA1195374_P_NODE_82092_length_243_cov_0.905882_g81748_i0 | PRJNA1195374 | 82092 | 243 | 0.905882 | 2.20129326 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 42.4 | 0.0477 | NR | MEK7476484.1 | 2250272 | g81748 | i0 | 72.4 | 0.358024691358025 | 29 | 3 | 29.6 | 1 | 48 | 119 | 272 | 300 | MEK7476484.1 hypothetical protein [Candidatus Coatesbacteria bacterium] | diamond | 87 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 30387233 | 30387233 | PRJNA1148190_P_NODE_247953_length_344_cov_2.151292_g236783_i0 | PRJNA1148190 | 247953 | 344 | 2.151292 | 7.40044448 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 45.1 | 0.0159 | NR | MBD3372011.1 | 2250272 | g236783 | i0 | 43.9 | 0.575581395348837 | 66 | 34 | 56.7 | 2 | 344 | 150 | 185 | 248 | MBD3372011.1 DNRLRE domain-containing protein [Candidatus Coatesbacteria bacterium] | diamond | 198 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 30396087 | 30396087 | PRJNA591638_P_NODE_13373_length_205_cov_0.902778_g13196_i0 | PRJNA591638 | 13373 | 205 | 0.902778 | 1.8506949 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 42 | 0.0368 | NR | RLC40976.1 | 2250272 | g13196 | i0 | 45.1 | 0.746341463414634 | 51 | 27 | 73.2 | 1 | 37 | 186 | 137 | 187 | RLC40976.1 MAG: MBL fold metallo-hydrolase [Candidatus Coatesbacteria bacterium] | diamond | 153 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 30557238 | 30557238 | PRJNA715462_P_NODE_50193_length_251_cov_1.730337_g49397_i0 | PRJNA715462 | 50193 | 251 | 1.730337 | 4.34314587 | Candidatus Coatesbacteria bacterium RBG_13_66_14 | 1817816 | Bacteria | Bacteria | 86.3 | 1.85e-17 | NR | OGD72496.1 | 1817816 | g49397 | i0 | 48.2 | 2.92828685258964 | 83 | 43 | 99.2 | 0 | 3 | 251 | 137 | 219 | OGD72496.1 MAG: hypothetical protein A2Y64_03085 [Candidatus Coatesbacteria bacterium RBG_13_66_14] | diamond | 735 | 86.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium RBG_13_66_14 | ||||||
| 30674454 | 30674454 | PRJNA312107_P_NODE_20713_length_167_cov_0.881356_g20547_i0 | PRJNA312107 | 20713 | 167 | 0.881356 | 1.47186452 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 57.8 | 3.41e-8 | NR | RLC40267.1 | 2250272 | g20547 | i0 | 49.1 | 0.952095808383233 | 53 | 21 | 95.2 | 1 | 166 | 8 | 171 | 217 | RLC40267.1 MAG: hypothetical protein DRH51_05885 [Candidatus Coatesbacteria bacterium] | diamond | 159 | 57.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 30875546 | 30875546 | PRJNA800053_P_NODE_18274_length_250_cov_0.870056_g18110_i0 | PRJNA800053 | 18274 | 250 | 0.870056 | 2.17514 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 74.3 | 2.93e-13 | NR | RLC40269.1 | 2250272 | g18110 | i0 | 43.2 | 0.888 | 74 | 40 | 86.4 | 1 | 239 | 24 | 244 | 317 | RLC40269.1 MAG: hypothetical protein DRH51_05895 [Candidatus Coatesbacteria bacterium] | diamond | 222 | 74.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 31045904 | 31045904 | PRJNA1010662_P_NODE_14875_length_165_cov_0.887931_g14816_i0 | PRJNA1010662 | 14875 | 165 | 0.887931 | 1.46508615 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 40.8 | 0.0387 | NR | MEK7474779.1 | 2250272 | g14816 | i0 | 41.5 | 0.745454545454545 | 41 | 21 | 74.5 | 1 | 165 | 43 | 28 | 65 | MEK7474779.1 cyclic nucleotide-binding domain-containing protein [Candidatus Coatesbacteria bacterium] | diamond | 123 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 31445504 | 31445504 | PRJNA853203_P_NODE_7256_length_305_cov_0.887931_g7107_i0 | PRJNA853203 | 7256 | 305 | 0.887931 | 2.70818955 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 52.8 | 2.14e-5 | NR | MBD3400439.1 | 2250272 | g7107 | i0 | 34 | 0.924590163934426 | 94 | 50 | 85.6 | 4 | 41 | 301 | 251 | 339 | MBD3400439.1 hypothetical protein [Candidatus Coatesbacteria bacterium] | diamond | 282 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 31505669 | 31505669 | PRJNA704949_P_NODE_569416_length_360_cov_2.138264_g554103_i0 | PRJNA704949 | 569416 | 360 | 2.138264 | 7.6977504 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 72.8 | 4.23e-12 | NR | RLC40328.1 | 2250272 | g554103 | i0 | 50.7 | 1.11666666666667 | 71 | 35 | 59.2 | 0 | 214 | 2 | 150 | 220 | RLC40328.1 MAG: hypothetical protein DRH49_07280, partial [Candidatus Coatesbacteria bacterium] | diamond | 402 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 31722476 | 31722476 | PRJNA560932_P_NODE_55837_length_249_cov_0.875000_g55481_i0 | PRJNA560932 | 55837 | 249 | 0.875 | 2.17875 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 55.1 | 1.61e-6 | NR | UCH78262.1 | 2250272 | g55481 | i0 | 51.1 | 1.7710843373494 | 47 | 22 | 56.6 | 1 | 17 | 157 | 29 | 74 | UCH78262.1 MAG: 6-bladed beta-propeller [Candidatus Coatesbacteria bacterium] | diamond | 441 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria bacterium | ||||||
| 32220981 | 32220981 | PRJNA1148190_P_NODE_444818_length_277_cov_1.754902_g433645_i0 | PRJNA1148190 | 444818 | 277 | 1.754902 | 4.86107854 | Candidatus Coatesbacteria bacterium | 2250272 | Bacteria | Bacteria | 62.8 | 2.56e-10 | NR | RLC38303.1 | 2250272 | g433645 | i0 | 42.4 | 0.92057761732852 | 85 | 42 | 89.9 | 4 | 256 | 8 | 3 | 82 | RLC38303.1 MAG: hypothetical protein DRH51_08460 [Candidatus Coatesbacteria bacterium] | diamond | 255 | 62.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Coatesiibacteriota | Candidatus Coatesbacteria 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);;