contig_metadata
11 rows where bioproject = "PRJNA688352" and tax_phylum = "Candidatus Shapironibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27208463 | 27208463 | PRJNA688352_P_NODE_5842_length_273_cov_1.510000_g5739_i0 | PRJNA688352 | 5842 | 273 | 1.51 | 4.1223 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 182 | 2.1599999999999995e-54 | NR | MBP6891876.1 | 2053613 | g5739 | i0 | 98.9 | 0.989010989010989 | 90 | 1 | 98.9 | 0 | 3 | 272 | 267 | 356 | MBP6891876.1 glycosyltransferase family 4 protein [Candidatus Shapirobacteria bacterium] | diamond | 270 | 182 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 28945684 | 28945684 | PRJNA688352_P_NODE_7608_length_250_cov_0.870056_g7505_i0 | PRJNA688352 | 7608 | 250 | 0.870056 | 2.17514 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 172 | 5.01e-53 | NR | MEL7666339.1 | 2053613 | g7505 | i0 | 100 | 1.968 | 82 | 0 | 98.4 | 0 | 3 | 248 | 69 | 150 | MEL7666339.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 492 | 172 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 29166658 | 29166658 | PRJNA688352_P_NODE_7309_length_251_cov_0.865169_g7206_i0 | PRJNA688352 | 7309 | 251 | 0.865169 | 2.17157419 | Candidatus Shapirobacteria bacterium CG | 2053613 | Bacteria | Bacteria | 114 | 1.31e-30 | NR | PIV02188.1 | 1974880 | g7206 | i0 | 71.1 | 0.99203187250996006 | 83 | 24 | 99.2 | 0 | 1 | 249 | 13 | 95 | PIV02188.1 MAG: hypothetical protein COS55_00130 [Candidatus Shapirobacteria bacterium CG03_land_8_20_14_0_80_40_19] | diamond | 249 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium CG03_land_8_20_14_0_80_40_19 | ||||||
| 29292698 | 29292698 | PRJNA688352_P_NODE_10289_length_245_cov_0.895349_g10186_i0 | PRJNA688352 | 10289 | 245 | 0.895349 | 2.19360505 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 160 | 1.8199999999999993e-46 | NR | MBP6891522.1 | 2053613 | g10186 | i0 | 98.8 | 0.991836734693878 | 81 | 1 | 99.2 | 0 | 244 | 2 | 115 | 195 | MBP6891522.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 243 | 160 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 29292703 | 29292703 | PRJNA688352_P_NODE_2649_length_373_cov_1.026667_g2546_i0 | PRJNA688352 | 2649 | 373 | 1.026667 | 3.82946791 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 232 | 7.35e-75 | NR | MBP6891395.1 | 2053613 | g2546 | i0 | 99.2 | 0.997319034852547 | 124 | 1 | 99.7 | 0 | 372 | 1 | 116 | 239 | MBP6891395.1 prohibitin family protein [Candidatus Shapirobacteria bacterium] | diamond | 372 | 232 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 29545209 | 29545209 | PRJNA688352_P_NODE_4790_length_296_cov_1.035874_g4687_i0 | PRJNA688352 | 4790 | 296 | 1.035874 | 3.06618704 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 202 | 5.499999999999999e-63 | NR | MBP6891535.1 | 2053613 | g4687 | i0 | 99 | 0.993243243243243 | 98 | 1 | 99.3 | 0 | 295 | 2 | 107 | 204 | MBP6891535.1 WecB/TagA/CpsF family glycosyltransferase [Candidatus Shapirobacteria bacterium] | diamond | 294 | 202 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 29924381 | 29924381 | PRJNA688352_P_NODE_7331_length_251_cov_0.865169_g7228_i0 | PRJNA688352 | 7331 | 251 | 0.865169 | 2.17157419 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 159 | 3.93e-46 | NR | MBP6891813.1 | 2053613 | g7228 | i0 | 97.6 | 0.99203187250996006 | 83 | 2 | 99.2 | 0 | 251 | 3 | 154 | 236 | MBP6891813.1 DNA-directed RNA polymerase subunit alpha [Candidatus Shapirobacteria bacterium] | diamond | 249 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 30587615 | 30587615 | PRJNA688352_P_NODE_5493_length_280_cov_1.115942_g5390_i0 | PRJNA688352 | 5493 | 280 | 1.115942 | 3.1246376 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 183 | 1.0599999999999999e-54 | NR | MBP6891698.1 | 2053613 | g5390 | i0 | 98.9 | 0.996428571428571 | 93 | 1 | 99.6 | 0 | 1 | 279 | 275 | 367 | MBP6891698.1 DNA polymerase III subunit beta [Candidatus Shapirobacteria bacterium] | diamond | 279 | 183 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 31599403 | 31599403 | PRJNA688352_P_NODE_4036_length_316_cov_1.267490_g3933_i0 | PRJNA688352 | 4036 | 316 | 1.26749 | 4.0052684 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 214 | 2.7999999999999998e-67 | NR | MBP6891674.1 | 2053613 | g3933 | i0 | 100 | 0.996835443037975 | 105 | 0 | 99.7 | 0 | 315 | 1 | 136 | 240 | MBP6891674.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 315 | 214 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 32516976 | 32516976 | PRJNA688352_P_NODE_12459_length_241_cov_0.916667_g12356_i0 | PRJNA688352 | 12459 | 241 | 0.916667 | 2.20916747 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 154 | 2.9799999999999998e-46 | NR | MBP6891691.1 | 2053613 | g12356 | i0 | 100 | 0.983402489626556 | 79 | 0 | 98.3 | 0 | 3 | 239 | 55 | 133 | MBP6891691.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 237 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 32548629 | 32548629 | PRJNA688352_P_NODE_4359_length_307_cov_1.200855_g4256_i0 | PRJNA688352 | 4359 | 307 | 1.200855 | 3.68662485 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 122 | 1.19e-32 | NR | MBP6891895.1 | 2053613 | g4256 | i0 | 96.8 | 0.60586319218241 | 62 | 2 | 60.6 | 0 | 186 | 1 | 1 | 62 | MBP6891895.1 AAA family ATPase [Candidatus Shapirobacteria bacterium] | diamond | 186 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria 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);;