contig_metadata
16 rows where bioproject = "PRJNA934472" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2186288 | 2186288 | PRJNA934472_P_NODE_23202_length_304_cov_1.900433_g22824_i0 | PRJNA934472 | 23202 | 304 | 1.900433 | 5.77731632 | Candidatus Saccharibacteria bacterium oral taxon 955 | 2572087 | Bacteria | Bacteria | 518 | 2.32e-142 | NTclustered | gi|1663049602|gb|CP040008.1| | 2572087 | g22824 | i0 | 97.674 | 216.072368421053 | 301 | 7 | 99 | 0 | 1 | 301 | 139896 | 140196 | Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome | blastn | 65686 | 518 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 955 | ||||||
| 3461919 | 3461919 | PRJNA934472_P_NODE_28123_length_279_cov_1.475728_g27745_i0 | PRJNA934472 | 28123 | 279 | 1.475728 | 4.11728112 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 110 | 1.5e-19 | NTclustered | gi|1958074337|gb|CP064994.1| | 2045217 | g27745 | i0 | 91.25 | 64.6236559139785 | 80 | 7 | 29 | 0 | 200 | 279 | 427901 | 427822 | MAG: Candidatus Moraniibacteriota bacterium isolate Hirt_18-Q3-R61-65_MAXAC.378_cln chromosome, complete genome | blastn | 18030 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 6359616 | 6359616 | PRJNA934472_P_NODE_36385_length_248_cov_0.880000_g36007_i0 | PRJNA934472 | 36385 | 248 | 0.88 | 2.1824 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 420 | 5.34e-113 | NTclustered | gi|1842054184|gb|CP039999.1| | 713059 | g36007 | i0 | 97.177 | 38.1491935483871 | 248 | 7 | 100 | 0 | 1 | 248 | 431959 | 431712 | Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome | blastn | 9461 | 420 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 12390391 | 12390391 | PRJNA934472_P_NODE_38210_length_243_cov_0.905882_g37832_i0 | PRJNA934472 | 38210 | 243 | 0.905882 | 2.20129326 | Candidatus Nanogingivalaceae bacterium | 2725942 | Bacteria | Bacteria | 416 | 6.739999999999998e-112 | NTclustered | gi|2070571752|gb|CP072208.2| | 2725942 | g37832 | i0 | 97.531 | 108.543209876543 | 243 | 6 | 100 | 0 | 1 | 243 | 112220 | 112462 | MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome | blastn | 26376 | 416 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanogingivales | Candidatus Nanogingivalaceae | Candidatus Nanogingivalaceae bacterium | |||
| 12735032 | 12735032 | PRJNA934472_P_NODE_7830_length_503_cov_1.637209_g7511_i0 | PRJNA934472 | 7830 | 503 | 1.637209 | 8.23516127 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 682 | 0 | NTclustered | gi|499052612|gb|CP005957.1| | 1332188 | g7511 | i0 | 91.287 | 76.8369781312127 | 505 | 36 | 100 | 8 | 1 | 503 | 695983 | 696481 | Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome | blastn | 38649 | 686 | 0.994169096209913 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis | ||
| 13664757 | 13664757 | PRJNA934472_P_NODE_35131_length_251_cov_1.460674_g34753_i0 | PRJNA934472 | 35131 | 251 | 1.460674 | 3.66629174 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 381 | 2.549999999999999e-101 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g34753 | i0 | 95.041 | 117.908366533865 | 242 | 12 | 96 | 0 | 10 | 251 | 850728 | 850487 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 29595 | 381 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 13664767 | 13664767 | PRJNA934472_P_NODE_35531_length_250_cov_1.305085_g35153_i0 | PRJNA934472 | 35531 | 250 | 1.305085 | 3.2627125 | uncultured Candidatus Binatia bacterium | 3036252 | Bacteria | Bacteria | 289 | 1.59e-73 | NTclustered | gi|2546137839|emb|OY282432.1| | 3036252 | g35153 | i0 | 87.698 | 51.124 | 252 | 25 | 99 | 3 | 1 | 248 | 2262761 | 2262512 | MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1 | blastn | 12781 | 289 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | uncultured Candidatus Binatia bacterium | |||||
| 13664811 | 13664811 | PRJNA934472_P_NODE_37511_length_245_cov_0.784884_g37133_i0 | PRJNA934472 | 37511 | 245 | 0.784884 | 1.9229658 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 396 | 8.869999999999996e-106 | NTclustered | gi|1474570736|gb|CP023991.1| | 2026720 | g37133 | i0 | 95.918 | 124.881632653061 | 245 | 9 | 100 | 1 | 1 | 245 | 884190 | 883947 | Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome | blastn | 30596 | 396 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 17489577 | 17489577 | PRJNA934472_P_NODE_4194_length_664_cov_4.201354_g3894_i0 | PRJNA934472 | 4194 | 664 | 4.201354 | 27.89699056 | uncultured Methylomirabilota bacterium | 991135 | Bacteria | Bacteria | 455 | 4.31e-123 | NTclustered | gi|2874253892|emb|OY970067.1| | 991135 | g3894 | i0 | 79.259 | 105.579819277108 | 675 | 123 | 100 | 13 | 1 | 664 | 4746100 | 4745432 | MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1 | blastn | 70105 | 455 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | uncultured Methylomirabilota bacterium | ||||||
| 22588011 | 22588011 | PRJNA934472_P_NODE_28998_length_275_cov_1.371287_g28620_i0 | PRJNA934472 | 28998 | 275 | 1.371287 | 3.77103925 | Candidatus Saccharibacteria genomosp. TM7-H1 | 2080739 | Bacteria | Bacteria | 364 | 2.859999999999999e-96 | NTclustered | gi|1566427536|gb|CP026537.1| | 2080739 | g28620 | i0 | 90.545 | 104.301818181818 | 275 | 26 | 100 | 0 | 1 | 275 | 542665 | 542939 | Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome | blastn | 28683 | 364 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria genomosp. TM7-H1 | ||||||
| 29645573 | 29645573 | PRJNA934472_P_NODE_36310_length_248_cov_0.880000_g35932_i0 | PRJNA934472 | 36310 | 248 | 0.88 | 2.1824 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 42.7 | 0.0384 | NR | HLH76150.1 | 2785449 | g35932 | i0 | 35.1 | 0.895161290322581 | 74 | 34 | 89.5 | 4 | 3 | 224 | 245 | 304 | HLH76150.1 MFS transporter [Candidatus Binataceae bacterium] | diamond | 222 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30278104 | 30278104 | PRJNA934472_P_NODE_38932_length_241_cov_0.916667_g38554_i0 | PRJNA934472 | 38932 | 241 | 0.916667 | 2.20916747 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 95.5 | 2.58e-22 | NR | MDD4804609.1 | 2053589 | g38554 | i0 | 50 | 0.995850622406639 | 80 | 40 | 99.6 | 0 | 1 | 240 | 97 | 176 | MDD4804609.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 240 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31162133 | 31162133 | PRJNA934472_P_NODE_36375_length_248_cov_0.880000_g35997_i0 | PRJNA934472 | 36375 | 248 | 0.88 | 2.1824 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 93.6 | 5.14e-20 | NR | MFQ5853582.1 | 2838779 | g35997 | i0 | 58.1 | 0.895161290322581 | 74 | 31 | 89.5 | 0 | 246 | 25 | 482 | 555 | MFQ5853582.1 amino acid adenylation domain-containing protein [Candidatus Binatia bacterium] | diamond | 222 | 93.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31327495 | 31327495 | PRJNA934472_P_NODE_27735_length_281_cov_1.274038_g27357_i0 | PRJNA934472 | 27735 | 281 | 1.274038 | 3.58004678 | Bacteria | 2 | Bacteria | Bacteria | 55.5 | 1.88e-6 | NR | PIP25852.1 | 1974677 | g27357 | i0 | 34 | 3.08540925266904 | 97 | 58 | 99.3 | 2 | 281 | 3 | 315 | 409 | PIP25852.1 MAG: hypothetical protein COX32_01165 [Candidatus Moranbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_41_28] | diamond | 867 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moranbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_41_28 | ||||||
| 31478860 | 31478860 | PRJNA934472_P_NODE_35676_length_250_cov_0.870056_g35298_i0 | PRJNA934472 | 35676 | 250 | 0.870056 | 2.17514 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 62.8 | 2.89e-9 | NR | PYN43175.1 | 2053607 | g35298 | i0 | 89.7 | 0.696 | 29 | 3 | 34.8 | 0 | 248 | 162 | 301 | 329 | PYN43175.1 MAG: hypothetical protein DME00_27470, partial [Candidatus Rokuibacteriota bacterium] | diamond | 174 | 62.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31636750 | 31636750 | PRJNA934472_P_NODE_7296_length_519_cov_1.773543_g6979_i0 | PRJNA934472 | 7296 | 519 | 1.773543 | 9.20468817 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 118 | 1.16e-29 | NR | RMD61733.1 | 2762014 | g6979 | i0 | 57.8 | 0.739884393063584 | 128 | 46 | 69.4 | 4 | 360 | 1 | 1 | 128 | RMD61733.1 MAG: hypothetical protein D6833_07845, partial [Candidatus Parcubacteria bacterium] | diamond | 384 | 118 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria 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);;