contig_metadata
11 rows where bioproject = "PRJNA576995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23513161 | 23513161 | PRJNA576995_P_NODE_35299_length_251_cov_0.865169_g34707_i0 | PRJNA576995 | 35299 | 251 | 0.865169 | 2.17157419 | Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_ | 2750077 | Bacteria | Bacteria | 55.5 | 1.28e-6 | NR | OGZ07902.1 | 1798660 | g34707 | i0 | 53.8 | 0.621513944223108 | 52 | 24 | 62.2 | 0 | 161 | 6 | 2 | 53 | OGZ07902.1 MAG: hypothetical protein A3C13_04500 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_11] | diamond | 156 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Lloydiibacteriota | Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_11 | ||||||
| 27016203 | 27016203 | PRJNA576995_P_NODE_25282_length_304_cov_1.000000_g24690_i0 | PRJNA576995 | 25282 | 304 | 1 | 3.04 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 62.4 | 8.3e-9 | NR | MFA6525056.1 | 2052139 | g24690 | i0 | 44.7 | 1.65789473684211 | 85 | 45 | 81.9 | 1 | 35 | 283 | 226 | 310 | MFA6525056.1 VWA domain-containing protein [Patescibacteria group bacterium] | diamond | 504 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27553302 | 27553302 | PRJNA576995_P_NODE_43124_length_241_cov_0.916667_g42532_i0 | PRJNA576995 | 43124 | 241 | 0.916667 | 2.20916747 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 90.5 | 5.35e-19 | NR | TXG76971.1 | 2099670 | g42532 | i0 | 62 | 0.983402489626556 | 79 | 30 | 98.3 | 0 | 2 | 238 | 35 | 113 | TXG76971.1 MAG: HNH endonuclease [Candidatus Dojkabacteria bacterium] | diamond | 237 | 90.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 30332814 | 30332814 | PRJNA576995_P_NODE_37652_length_248_cov_0.880000_g37060_i0 | PRJNA576995 | 37652 | 248 | 0.88 | 2.1824 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 88.6 | 2.93e-18 | NR | MFB6181917.1 | 2026717 | g37060 | i0 | 61.8 | 1.72983870967742 | 68 | 21 | 82.3 | 1 | 45 | 248 | 644 | 706 | MFB6181917.1 IGHMBP2 family helicase [Candidatus Magasanikiibacteriota bacterium] | diamond | 429 | 88.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 30598492 | 30598492 | PRJNA576995_P_NODE_22333_length_321_cov_1.766129_g21741_i0 | PRJNA576995 | 22333 | 321 | 1.766129 | 5.66927409 | Bacteria | 2 | Bacteria | Bacteria | 50.1 | 2.61e-4 | NR | OGF36494.1 | 1798001 | g21741 | i0 | 50.9 | 1.02803738317757 | 57 | 27 | 53.3 | 1 | 143 | 313 | 1371 | 1426 | OGF36494.1 MAG: hypothetical protein A2466_01325 [Candidatus Falkowbacteria bacterium RIFOXYC2_FULL_34_220] | diamond | 330 | 50.4 | 0.994047619047619 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium RIFOXYC2_FULL_34_220 | ||||||
| 30679692 | 30679692 | PRJNA576995_P_NODE_41733_length_243_cov_0.905882_g41141_i0 | PRJNA576995 | 41733 | 243 | 0.905882 | 2.20129326 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 43.1 | 0.0267 | NR | MFQ5902728.1 | 2838779 | g41141 | i0 | 33.9 | 0.765432098765432 | 62 | 40 | 75.3 | 1 | 237 | 55 | 34 | 95 | MFQ5902728.1 M16 family metallopeptidase [Candidatus Binatia bacterium] | diamond | 186 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31375304 | 31375304 | PRJNA576995_P_NODE_40076_length_245_cov_0.895349_g39484_i0 | PRJNA576995 | 40076 | 245 | 0.895349 | 2.19360505 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 92.8 | 2.9300000000000004e-21 | NR | MFA5935679.1 | 2052139 | g39484 | i0 | 58.2 | 2.90204081632653 | 79 | 33 | 96.7 | 0 | 240 | 4 | 31 | 109 | MFA5935679.1 lactate utilization protein [Patescibacteria group bacterium] | diamond | 711 | 92.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32039515 | 32039515 | PRJNA576995_P_NODE_39998_length_245_cov_0.895349_g39406_i0 | PRJNA576995 | 39998 | 245 | 0.895349 | 2.19360505 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 63.2 | 2.44e-9 | NR | MBI4636318.1 | 2053607 | g39406 | i0 | 45 | 7.49387755102041 | 80 | 43 | 98 | 1 | 2 | 241 | 715 | 793 | MBI4636318.1 cation:proton antiporter [Candidatus Rokuibacteriota bacterium] | diamond | 1836 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 32243187 | 32243187 | PRJNA576995_P_NODE_39658_length_246_cov_0.890173_g39066_i0 | PRJNA576995 | 39658 | 246 | 0.890173 | 2.18982558 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 58.5 | 1.07e-7 | NR | MDD5470072.1 | 2735830 | g39066 | i0 | 58.1 | 2.01219512195122 | 43 | 18 | 52.4 | 0 | 246 | 118 | 13 | 55 | MDD5470072.1 DUF4215 domain-containing protein [Candidatus Peribacteraceae bacterium] | diamond | 495 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 32292976 | 32292976 | PRJNA576995_P_NODE_35839_length_250_cov_0.870056_g35247_i0 | PRJNA576995 | 35839 | 250 | 0.870056 | 2.17514 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 48.5 | 2.72e-4 | NR | MEI8068040.1 | 2053613 | g35247 | i0 | 42 | 0.6 | 50 | 29 | 60 | 0 | 161 | 12 | 178 | 227 | MEI8068040.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 150 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 32482578 | 32482578 | PRJNA576995_P_NODE_41159_length_244_cov_0.900585_g40567_i0 | PRJNA576995 | 41159 | 244 | 0.900585 | 2.1974274 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 142 | 4.849999999999999e-37 | NR | MBE7526021.1 | 2053526 | g40567 | i0 | 98.8 | 0.995901639344262 | 81 | 1 | 99.6 | 0 | 243 | 1 | 3282 | 3362 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 243 | 142 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 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);;