contig_metadata
5 rows where bioproject = "PRJNA982106", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2239127 | 2239127 | PRJNA982106_P_NODE_22302_length_250_cov_0.870056_g22062_i0 | PRJNA982106 | 22302 | 250 | 0.870056 | 2.17514 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 156 | 1.49e-42 | NR | HVJ04841.1 | 2973664 | g22062 | i0 | 92.7 | 0.984 | 82 | 6 | 98.4 | 0 | 3 | 248 | 20 | 101 | HVJ04841.1 ferrous iron transport protein B [Candidatus Saccharimonadales bacterium] | diamond | 246 | 156 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30247727 | 30247727 | PRJNA982106_P_NODE_31372_length_242_cov_0.911243_g31132_i0 | PRJNA982106 | 31372 | 242 | 0.911243 | 2.20520806 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 107 | 1.39e-25 | NR | HSX78167.1 | 2890869 | g31132 | i0 | 80 | 0.991735537190083 | 80 | 16 | 99.2 | 0 | 240 | 1 | 29 | 108 | HSX78167.1 SIS domain-containing protein [Candidatus Saccharimonadia bacterium] | diamond | 240 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 30405903 | 30405903 | PRJNA982106_P_NODE_27813_length_245_cov_0.895349_g27573_i0 | PRJNA982106 | 27813 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 94.4 | 4.99e-22 | NR | MEI7918250.1 | 2026720 | g27573 | i0 | 58.8 | 0.979591836734694 | 80 | 33 | 98 | 0 | 1 | 240 | 3 | 82 | MEI7918250.1 HAD family phosphatase [Candidatus Saccharibacteria bacterium] | diamond | 240 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31922815 | 31922815 | PRJNA982106_P_NODE_25037_length_247_cov_0.885057_g24797_i0 | PRJNA982106 | 25037 | 247 | 0.885057 | 2.18609079 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 142 | 2.84e-41 | NR | HSX76985.1 | 2890869 | g24797 | i0 | 97.1 | 0.825910931174089 | 68 | 2 | 82.6 | 0 | 205 | 2 | 1 | 68 | HSX76985.1 3-isopropylmalate dehydratase small subunit [Candidatus Saccharimonadia bacterium] | diamond | 204 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 31985993 | 31985993 | PRJNA982106_P_NODE_20578_length_251_cov_0.865169_g20338_i0 | PRJNA982106 | 20578 | 251 | 0.865169 | 2.17157419 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 68.6 | 3.12e-12 | NR | HPQ82233.1 | 1917697 | g20338 | i0 | 94.4 | 0.430278884462151 | 36 | 2 | 43 | 0 | 109 | 2 | 1 | 36 | HPQ82233.1 DNA recombination/repair protein RecA [Candidatus Saccharimonas sp.] | diamond | 108 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. |
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);;