contig_metadata
9 rows where bioproject = "PRJNA527965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 496959 | 496959 | PRJNA527965_S_NODE_681_length_426_cov_3.547315_g599_i0 | PRJNA527965 | 681 | 426 | 3.547315 | 15.1115619 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 580 | 4.239999999999999e-161 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g599 | i0 | 91.315 | 578.781690140845 | 426 | 36 | 100 | 1 | 1 | 426 | 814408 | 813984 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 246561 | 580 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 5600694 | 5600694 | PRJNA527965_S_NODE_245_length_629_cov_42.658249_g178_i0 | PRJNA527965 | 245 | 629 | 42.658249 | 268.32038621 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 830 | 0 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g178 | i0 | 90.59 | 323.81240063593 | 627 | 58 | 99 | 1 | 1 | 627 | 892407 | 891782 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 203678 | 830 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 8149913 | 8149913 | PRJNA527965_S_NODE_5567_length_159_cov_0.943548_g5484_i0 | PRJNA527965 | 5567 | 159 | 0.943548 | 1.50024132 | Candidatus Chromulinivorax destructor | 2066483 | Bacteria | Bacteria | 267 | 4.3199999999999996e-67 | NTclustered | gi|1443103054|gb|CP025544.1| | 2066483 | g5484 | i0 | 96.855 | 10.062893081761 | 159 | 5 | 100 | 0 | 1 | 159 | 663241 | 663083 | Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome | blastn | 1600 | 267 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Chromulinivoraceae | Candidatus Chromulinivorax | Candidatus Chromulinivorax destructor | |||
| 10700821 | 10700821 | PRJNA527965_S_NODE_1389_length_323_cov_2.604167_g1306_i0 | PRJNA527965 | 1389 | 323 | 2.604167 | 8.41145941 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 239 | 2.17e-58 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g1306 | i0 | 85.778 | 5.70588235294118 | 225 | 32 | 70 | 0 | 3 | 227 | 813885 | 813661 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 1843 | 239 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 12593266 | 12593266 | PRJNA527965_S_NODE_1470_length_316_cov_6.395018_g1387_i0 | PRJNA527965 | 1470 | 316 | 6.395018 | 20.20825688 | Bacteria | 2 | Bacteria | Bacteria | 156 | 2.19e-33 | NTclustered | gi|2874253997|emb|OY970322.1| | 179883 | g1387 | i0 | 83.529 | 89.797468354430407 | 170 | 24 | 53 | 4 | 1 | 168 | 417626 | 417459 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1 | blastn | 28376 | 156 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 13250691 | 13250691 | PRJNA527965_S_NODE_111_length_849_cov_15.637592_g70_i0 | PRJNA527965 | 111 | 849 | 15.637592 | 132.76315608 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 749 | 0 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g70 | i0 | 82.986 | 51.8138987043581 | 864 | 111 | 100 | 32 | 1 | 849 | 1250203 | 1251045 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 43990 | 749 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 14525768 | 14525768 | PRJNA527965_S_NODE_3352_length_208_cov_2.514451_g3269_i0 | PRJNA527965 | 3352 | 208 | 2.514451 | 5.23005808 | uncultured candidate division SR1 bacterium | 221237 | Bacteria | Bacteria | 62.1 | 3.03e-5 | NTclustered | gi|218854872|gb|FJ479880.1| | 221237 | g3269 | i0 | 74.324 | 13.5240384615385 | 148 | 37 | 71 | 1 | 30 | 177 | 371 | 225 | Uncultured candidate division SR1 bacterium clone ZSR1-47 16S ribosomal RNA gene, partial sequence | blastn | 2813 | 62.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | uncultured candidate division SR1 bacterium | ||||||
| 15799514 | 15799514 | PRJNA527965_S_NODE_2973_length_221_cov_4.543011_g2890_i0 | PRJNA527965 | 2973 | 221 | 4.543011 | 10.04005431 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 76.3 | 4.38e-14 | NR | MDD2745034.1 | 2044595 | g2890 | i0 | 63 | 0.990950226244344 | 73 | 21 | 99.1 | 2 | 1 | 219 | 307 | 373 | MDD2745034.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 219 | 76.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27804075 | 27804075 | PRJNA527965_S_NODE_5624_length_158_cov_1.243902_g5541_i0 | PRJNA527965 | 5624 | 158 | 1.243902 | 1.96536516 | Candidatus Dependentiae bacterium HGW-Dependentiae-1 | 2013760 | Bacteria | Bacteria | 43.9 | 0.00181 | NR | PKN03121.1 | 2013760 | g5541 | i0 | 54.5 | 0.835443037974684 | 44 | 20 | 83.5 | 0 | 133 | 2 | 31 | 74 | PKN03121.1 MAG: hypothetical protein CVU75_03890 [Candidatus Dependentiae bacterium HGW-Dependentiae-1] | diamond | 132 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dependentiae bacterium HGW-Dependentiae-1 |
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);;