contig_metadata
8 rows where bioproject = "PRJNA806354" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26769278 | 26769278 | PRJNA806354_P_NODE_40641_length_242_cov_0.911243_g40532_i0 | PRJNA806354 | 40641 | 242 | 0.911243 | 2.20520806 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 90.5 | 5.56e-19 | NR | MDQ5954390.1 | 2052139 | g40532 | i0 | 48.1 | 0.979338842975207 | 79 | 41 | 97.9 | 0 | 239 | 3 | 265 | 343 | MDQ5954390.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 237 | 90.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28096437 | 28096437 | PRJNA806354_P_NODE_34625_length_253_cov_1.350000_g34516_i0 | PRJNA806354 | 34625 | 253 | 1.35 | 3.4155 | Candidatus Saccharibacteria bacterium 32-49-12 | 1970479 | Bacteria | Bacteria | 104 | 1.13e-25 | NR | OYX43789.1 | 1970479 | g34516 | i0 | 70 | 0.8300395256917 | 70 | 21 | 83 | 0 | 252 | 43 | 151 | 220 | OYX43789.1 MAG: hypothetical protein B7Y94_01055 [Candidatus Saccharibacteria bacterium 32-49-12] | diamond | 210 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-49-12 | ||||||
| 29991036 | 29991036 | PRJNA806354_P_NODE_38231_length_246_cov_0.890173_g38122_i0 | PRJNA806354 | 38231 | 246 | 0.890173 | 2.18982558 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 63.5 | 1.73e-9 | NR | HET7629994.1 | 2973664 | g38122 | i0 | 42.9 | 0.853658536585366 | 70 | 40 | 85.4 | 0 | 35 | 244 | 111 | 180 | HET7629994.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 210 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31128052 | 31128052 | PRJNA806354_P_NODE_39915_length_243_cov_0.905882_g39806_i0 | PRJNA806354 | 39915 | 243 | 0.905882 | 2.20129326 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 96.3 | 5.170000000000001e-21 | NR | MEK7514630.1 | 2052139 | g39806 | i0 | 59.5 | 2.90123456790123 | 79 | 32 | 97.5 | 0 | 2 | 238 | 358 | 436 | MEK7514630.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Patescibacteria group bacterium] | diamond | 705 | 96.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31159611 | 31159611 | PRJNA806354_P_NODE_38235_length_246_cov_0.890173_g38126_i0 | PRJNA806354 | 38235 | 246 | 0.890173 | 2.18982558 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 117 | 1.58e-31 | NR | MBI4036342.1 | 2053542 | g38126 | i0 | 71.6 | 0.98780487804878 | 81 | 23 | 98.8 | 0 | 243 | 1 | 68 | 148 | MBI4036342.1 RpiB/LacA/LacB family sugar-phosphate isomerase [Candidatus Daviesbacteria bacterium] | diamond | 243 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 31191258 | 31191258 | PRJNA806354_P_NODE_40735_length_242_cov_0.911243_g40626_i0 | PRJNA806354 | 40735 | 242 | 0.911243 | 2.20520806 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 142 | 2.42e-37 | NR | HVY35720.1 | 2053589 | g40626 | i0 | 86.1 | 1.97107438016529 | 79 | 10 | 97.9 | 1 | 239 | 3 | 332 | 409 | HVY35720.1 excinuclease ABC subunit UvrA [Candidatus Paceibacterota bacterium] | diamond | 477 | 142 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31697655 | 31697655 | PRJNA806354_P_NODE_35957_length_250_cov_0.870056_g35848_i0 | PRJNA806354 | 35957 | 250 | 0.870056 | 2.17514 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 98.6 | 2.46e-24 | NR | MBI3103487.1 | 2053542 | g35848 | i0 | 69 | 1.704 | 71 | 22 | 85.2 | 0 | 215 | 3 | 33 | 103 | MBI3103487.1 four helix bundle protein [Candidatus Daviesbacteria bacterium] | diamond | 426 | 98.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 32803777 | 32803777 | PRJNA806354_P_NODE_38820_length_245_cov_0.895349_g38711_i0 | PRJNA806354 | 38820 | 245 | 0.895349 | 2.19360505 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 135 | 4.7e-37 | NR | MEK7594917.1 | 2052139 | g38711 | i0 | 82.5 | 0.979591836734694 | 80 | 14 | 98 | 0 | 241 | 2 | 146 | 225 | MEK7594917.1 ATP synthase F1 subunit gamma [Patescibacteria group bacterium] | diamond | 240 | 135 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;