contig_metadata
16 rows where tax_phylum = "Candidatus Blackburniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8587437 | 8587437 | PRJNA951376_P_NODE_11767_length_283_cov_6.466667_g11634_i0 | PRJNA951376 | 11767 | 283 | 6.466667 | 18.30066761 | Candidatus Blackburnbacteria bacterium RIFCSPLOWO2_ | 2053523 | Bacteria | Bacteria | 95.9 | 1.25e-20 | NR | OGY13506.1 | 1797520 | g11634 | i0 | 65.8 | 1.45229681978799 | 76 | 23 | 80.6 | 1 | 22 | 249 | 552 | 624 | OGY13506.1 MAG: hypothetical protein A3A58_00335 [Candidatus Blackburnbacteria bacterium RIFCSPLOWO2_01_FULL_41_27] | diamond | 411 | 95.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPLOWO2_01_FULL_41_27 | ||||||
| 22828845 | 22828845 | PRJNA630162_P_NODE_39618_length_283_cov_1.290598_g38095_i0 | PRJNA630162 | 39618 | 283 | 1.290598 | 3.65239234 | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_ | 2053523 | Bacteria | Bacteria | 98.6 | 3.34e-24 | NR | OGY09129.1 | 1797513 | g38095 | i0 | 74.3 | 0.742049469964664 | 70 | 18 | 74.2 | 0 | 279 | 70 | 28 | 97 | OGY09129.1 MAG: hypothetical protein A2782_01275 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b] | diamond | 210 | 98.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b | ||||||
| 27039929 | 27039929 | PRJNA1148190_P_NODE_616322_length_249_cov_2.187500_g605149_i0 | PRJNA1148190 | 616322 | 249 | 2.1875 | 5.446875 | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_ | 2053523 | Bacteria | Bacteria | 57 | 3.26e-7 | NR | OGY10072.1 | 1797514 | g605149 | i0 | 47.3 | 0.662650602409639 | 55 | 28 | 66.3 | 1 | 168 | 4 | 229 | 282 | OGY10072.1 MAG: hypothetical protein A2700_02245 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_44_64] | diamond | 165 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_44_64 | ||||||
| 27200329 | 27200329 | PRJNA283169_P_NODE_3762_length_215_cov_0.933735_g3699_i0 | PRJNA283169 | 3762 | 215 | 0.933735 | 2.00753025 | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_ | 2053523 | Bacteria | Bacteria | 112 | 2.64e-27 | NR | OGY09650.1 | 1797514 | g3699 | i0 | 79.7 | 0.893023255813953 | 64 | 13 | 89.3 | 0 | 3 | 194 | 346 | 409 | OGY09650.1 MAG: hypothetical protein A2700_02100 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_44_64] | diamond | 192 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_44_64 | ||||||
| 28137314 | 28137314 | PRJNA867519_P_NODE_18485_length_282_cov_1.746411_g18331_i0 | PRJNA867519 | 18485 | 282 | 1.746411 | 4.92487902 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 44.3 | 0.0167 | NR | OGY10952.1 | 1797518 | g18331 | i0 | 41.8 | 1.71276595744681 | 55 | 32 | 58.5 | 0 | 22 | 186 | 299 | 353 | OGY10952.1 MAG: hypothetical protein A3E16_01110 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_12_FULL_44_25] | diamond | 483 | 44.7 | 0.991051454138702 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_12_FULL_44_25 | ||||||
| 28339292 | 28339292 | PRJNA438111_P_NODE_66306_length_167_cov_1.862319_g65681_i0 | PRJNA438111 | 66306 | 167 | 1.862319 | 3.11007273 | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_ | 2053523 | Bacteria | Bacteria | 97.8 | 1.72e-22 | NR | OGY09430.1 | 1797513 | g65681 | i0 | 87.3 | 1.97604790419162 | 55 | 7 | 98.8 | 0 | 167 | 3 | 275 | 329 | OGY09430.1 MAG: type I glyceraldehyde-3-phosphate dehydrogenase [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b] | diamond | 330 | 97.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b | ||||||
| 28765438 | 28765438 | PRJNA283169_S_NODE_2927_length_170_cov_0.132231_g2913_i0 | PRJNA283169 | 2927 | 170 | 0.132231 | 0.2247927 | Bacteria | 2 | Bacteria | Bacteria | 67.4 | 2.77e-11 | NR | OGY10018.1 | 1797513 | g2913 | i0 | 58.2 | 2.92941176470588 | 55 | 23 | 97.1 | 0 | 2 | 166 | 516 | 570 | OGY10018.1 MAG: hypothetical protein A2782_00620 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b] | diamond | 498 | 67.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b | ||||||
| 28960127 | 28960127 | PRJEB48218_S_NODE_22608_length_189_cov_4.625000_g21646_i0 | PRJEB48218 | 22608 | 189 | 4.625 | 8.74125 | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_12_FULL_44_25 | 1797518 | Bacteria | Bacteria | 99.8 | 5.88e-26 | NR | OGY10247.1 | 1797518 | g21646 | i0 | 79.6 | 0.777777777777778 | 49 | 10 | 77.8 | 0 | 187 | 41 | 13 | 61 | OGY10247.1 MAG: hypothetical protein A3E16_03505 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_12_FULL_44_25] | diamond | 147 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_12_FULL_44_25 | ||||||
| 29807543 | 29807543 | PRJNA340009_P_NODE_78731_length_157_cov_8.379630_g78424_i0 | PRJNA340009 | 78731 | 157 | 8.37963 | 13.1560191 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 7.56e-8 | NR | OGY06952.1 | 1797512 | g78424 | i0 | 57.7 | 1.98726114649682 | 52 | 21 | 97.5 | 1 | 155 | 3 | 29 | 80 | OGY06952.1 MAG: hypothetical protein A2694_04190 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_40_17] | diamond | 312 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_40_17 | ||||||
| 30364636 | 30364636 | PRJNA597223_P_NODE_85972_length_152_cov_0.982906_g84126_i0 | PRJNA597223 | 85972 | 152 | 0.982906 | 1.49401712 | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_ | 2053523 | Bacteria | Bacteria | 43.5 | 0.00577 | NR | OGY10064.1 | 1797513 | g84126 | i0 | 41.9 | 2.42763157894737 | 43 | 25 | 84.9 | 0 | 146 | 18 | 37 | 79 | OGY10064.1 MAG: hypothetical protein A2782_04085 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b] | diamond | 369 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b | ||||||
| 30927961 | 30927961 | PRJNA340009_P_NODE_77594_length_160_cov_15.234234_g77287_i0 | PRJNA340009 | 77594 | 160 | 15.234234 | 24.3747744 | Candidatus Blackburnbacteria bacterium | 2053523 | Bacteria | Bacteria | 54.3 | 4.16e-8 | NR | MBI4029482.1 | 2053523 | g77287 | i0 | 85.7 | 0.525 | 28 | 4 | 52.5 | 0 | 155 | 72 | 33 | 60 | MBI4029482.1 hypothetical protein [Candidatus Blackburnbacteria bacterium] | diamond | 84 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium | ||||||
| 31338580 | 31338580 | PRJNA340009_P_NODE_25496_length_243_cov_22.391753_g25189_i0 | PRJNA340009 | 25496 | 243 | 22.391753 | 54.41195979 | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_ | 2053523 | Bacteria | Bacteria | 76.3 | 5.61e-14 | NR | OGY06826.1 | 1797512 | g25189 | i0 | 58.3 | 1.79012345679012 | 72 | 30 | 88.9 | 0 | 241 | 26 | 133 | 204 | OGY06826.1 MAG: hypothetical protein A2694_00715 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_40_17] | diamond | 435 | 76.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_40_17 | ||||||
| 31925208 | 31925208 | PRJNA340009_P_NODE_77857_length_160_cov_2.549550_g77550_i0 | PRJNA340009 | 77857 | 160 | 2.54955 | 4.07928 | Bacteria | 2 | Bacteria | Bacteria | 58.5 | 3.22e-8 | NR | MBI2268403.1 | 2053523 | g77550 | i0 | 71.9 | 2.45625 | 32 | 9 | 60 | 0 | 154 | 59 | 61 | 92 | MBI2268403.1 hypothetical protein [Candidatus Blackburnbacteria bacterium] | diamond | 393 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium | ||||||
| 32032141 | 32032141 | PRJNA1180292_P_NODE_11598_length_245_cov_0.906977_g11466_i0 | PRJNA1180292 | 11598 | 245 | 0.906977 | 2.22209365 | Candidatus Blackburnbacteria bacterium RIFCSPLOWO2_ | 2053523 | Bacteria | Bacteria | 93.2 | 6.66e-20 | NR | OGY14946.1 | 1797522 | g11466 | i0 | 60 | 0.979591836734694 | 80 | 32 | 98 | 0 | 6 | 245 | 118 | 197 | OGY14946.1 MAG: hypothetical protein A3I52_02750 [Candidatus Blackburnbacteria bacterium RIFCSPLOWO2_02_FULL_40_10] | diamond | 240 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPLOWO2_02_FULL_40_10 | ||||||
| 32348872 | 32348872 | PRJNA1188114_P_NODE_11719_length_168_cov_1.714286_g11667_i0 | PRJNA1188114 | 11719 | 168 | 1.714286 | 2.88000048 | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_ | 2053523 | Bacteria | Bacteria | 71.6 | 1.18e-13 | NR | OGY09246.1 | 1797513 | g11667 | i0 | 66 | 1.89285714285714 | 53 | 18 | 94.6 | 0 | 9 | 167 | 1 | 53 | OGY09246.1 MAG: methyltransferase [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b] | diamond | 318 | 71.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_43_15b | ||||||
| 32942605 | 32942605 | PRJEB14175_P_NODE_11874_length_1028_cov_117.788004_g10382_i0 | PRJEB14175 | 11874 | 1028 | 117.788004 | 1210.86068112 | Candidatus Blackburnbacteria bacterium | 2053523 | Bacteria | Bacteria | 67 | 5.82e-9 | NR | MBI4029425.1 | 2053523 | g10382 | i0 | 35.8 | 0.318093385214008 | 109 | 67 | 30.9 | 1 | 490 | 173 | 19 | 127 | MBI4029425.1 hypothetical protein [Candidatus Blackburnbacteria bacterium] | diamond | 327 | 67 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Blackburniibacteriota | Candidatus Blackburnbacteria 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);;