contig_metadata
10 rows where bioproject = "PRJNA688655" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3728687 | 3728687 | PRJNA688655_P_NODE_14183_length_244_cov_0.888889_g14118_i0 | PRJNA688655 | 14183 | 244 | 0.888889 | 2.16888916 | Candidatus Nanosynbacterales | 2093819 | Bacteria | Bacteria | 91.6 | 4.66e-14 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g14118 | i0 | 94.828 | 10.2377049180328 | 58 | 3 | 24 | 0 | 139 | 196 | 454904 | 454847 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 2498 | 91.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 26733665 | 26733665 | PRJNA688655_P_NODE_11281_length_247_cov_0.885057_g11216_i0 | PRJNA688655 | 11281 | 247 | 0.885057 | 2.18609079 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 72.8 | 9.82e-13 | NR | NCC20536.1 | 2026720 | g11216 | i0 | 44.3 | 0.959514170040486 | 79 | 42 | 96 | 1 | 240 | 4 | 196 | 272 | NCC20536.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 237 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28092916 | 28092916 | PRJNA688655_P_NODE_10665_length_248_cov_0.880000_g10600_i0 | PRJNA688655 | 10665 | 248 | 0.88 | 2.1824 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 137 | 1.89e-35 | NR | NCU38217.1 | 2026720 | g10600 | i0 | 94.4 | 0.870967741935484 | 72 | 4 | 87.1 | 0 | 248 | 33 | 587 | 658 | NCU38217.1 YhgE/Pip domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 216 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28945702 | 28945702 | PRJNA688655_P_NODE_15328_length_242_cov_0.911243_g15263_i0 | PRJNA688655 | 15328 | 242 | 0.911243 | 2.20520806 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 142 | 4.5799999999999995e-37 | NR | MBR0467791.1 | 2026720 | g15263 | i0 | 95 | 2.97520661157025 | 80 | 4 | 99.2 | 0 | 240 | 1 | 973 | 1052 | MBR0467791.1 ABC transporter ATP-binding protein/permease [Candidatus Saccharibacteria bacterium] | diamond | 720 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29103473 | 29103473 | PRJNA688655_P_NODE_16748_length_241_cov_0.916667_g16683_i0 | PRJNA688655 | 16748 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 161 | 4.119999999999999e-47 | NR | MBO7699355.1 | 2026720 | g16683 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 241 | 2 | 28 | 107 | MBO7699355.1 metallophosphoesterase [Candidatus Saccharibacteria bacterium] | diamond | 240 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29114970 | 29114970 | PRJNA688655_P_NODE_9708_length_249_cov_0.875000_g9643_i0 | PRJNA688655 | 9708 | 249 | 0.875 | 2.17875 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 147 | 1.14e-39 | NR | WP_015641867.1 | 1332188 | g9643 | i0 | 81.9 | 2 | 83 | 15 | 100 | 0 | 249 | 1 | 157 | 239 | WP_015641867.1 single-stranded-DNA-specific exonuclease RecJ [Candidatus Saccharimonas aalborgensis] | diamond | 498 | 148 | 0.993243243243243 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis | ||
| 29166676 | 29166676 | PRJNA688655_P_NODE_16169_length_241_cov_0.916667_g16104_i0 | PRJNA688655 | 16169 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 45.8 | 0.00298 | NR | MDO4781365.1 | 2026720 | g16104 | i0 | 47.5 | 1.15767634854772 | 59 | 27 | 68.5 | 2 | 231 | 67 | 425 | 483 | MDO4781365.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 279 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29229834 | 29229834 | PRJNA688655_P_NODE_13289_length_245_cov_0.895349_g13224_i0 | PRJNA688655 | 13289 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 158 | 3.7e-48 | NR | NCC19539.1 | 2026720 | g13224 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 244 | 2 | 43 | 123 | NCC19539.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 243 | 158 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31599423 | 31599423 | PRJNA688655_P_NODE_16376_length_241_cov_0.916667_g16311_i0 | PRJNA688655 | 16376 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 137 | 8.990000000000001e-36 | NR | MBP5512283.1 | 2026720 | g16311 | i0 | 83.5 | 0.983402489626556 | 79 | 13 | 98.3 | 0 | 3 | 239 | 328 | 406 | MBP5512283.1 endolytic transglycosylase MltG [Candidatus Saccharibacteria bacterium] | diamond | 237 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32768776 | 32768776 | PRJNA688655_P_NODE_13080_length_245_cov_0.895349_g13015_i0 | PRJNA688655 | 13080 | 245 | 0.895349 | 2.19360505 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 165 | 2.12e-49 | NR | NIV97761.1 | 2026720 | g13015 | i0 | 95.1 | 0.991836734693878 | 81 | 4 | 99.2 | 0 | 243 | 1 | 56 | 136 | NIV97761.1 zinc ribbon domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 243 | 165 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;