contig_metadata
8 rows where bioproject = "PRJNA1047749", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16752096 | 16752096 | PRJNA1047749_P_NODE_35954_length_263_cov_3.210526_g35687_i0 | PRJNA1047749 | 35954 | 263 | 3.210526 | 8.44368338 | Candidatus Saccharibacteria bacterium oral taxon 955 | 2572087 | Bacteria | Bacteria | 135 | 2.32e-27 | NTclustered | gi|1842052453|gb|CP040010.1| | 2572087 | g35687 | i0 | 94.382 | 41.2965779467681 | 89 | 4 | 33 | 1 | 11 | 98 | 754935 | 755023 | Candidatus Saccharibacteria bacterium oral taxon 955 strain CM003 chromosome, complete genome | blastn | 10861 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 955 | ||||||
| 19300945 | 19300945 | PRJNA1047749_P_NODE_36736_length_260_cov_4.165775_g36469_i0 | PRJNA1047749 | 36736 | 260 | 4.165775 | 10.831015 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 448 | 2.5899999999999996e-121 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g36469 | i0 | 100 | 0.930769230769231 | 242 | 0 | 93 | 0 | 1 | 242 | 360197 | 360438 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 242 | 448 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 27193193 | 27193193 | PRJNA1047749_P_NODE_18522_length_312_cov_3.757322_g18255_i0 | PRJNA1047749 | 18522 | 312 | 3.757322 | 11.72284464 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 100 | 1.7199999999999995e-23 | NR | NCU30100.1 | 2026720 | g18255 | i0 | 100 | 0.480769230769231 | 50 | 0 | 48.1 | 0 | 312 | 163 | 144 | 193 | NCU30100.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 150 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27256519 | 27256519 | PRJNA1047749_P_NODE_34903_length_267_cov_4.206186_g34636_i0 | PRJNA1047749 | 34903 | 267 | 4.206186 | 11.23051662 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 76.3 | 7.93e-14 | NR | HSX06161.1 | 2890869 | g34636 | i0 | 59.1 | 2.2247191011236 | 66 | 23 | 74.2 | 1 | 68 | 265 | 1 | 62 | HSX06161.1 DNA translocase FtsK 4TM domain-containing protein [Candidatus Saccharimonadia bacterium] | diamond | 594 | 76.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 28519778 | 28519778 | PRJNA1047749_P_NODE_48067_length_220_cov_10.605442_g47800_i0 | PRJNA1047749 | 48067 | 220 | 10.605442 | 23.3319724 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 122 | 3.8499999999999996e-31 | NR | HMR72506.1 | 2026720 | g47800 | i0 | 74 | 0.995454545454545 | 73 | 19 | 99.5 | 0 | 1 | 219 | 29 | 101 | HMR72506.1 glycoside hydrolase family 57 protein [Candidatus Saccharibacteria bacterium] | diamond | 219 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29237879 | 29237879 | PRJNA1047749_P_NODE_27149_length_297_cov_4.946429_g26882_i0 | PRJNA1047749 | 27149 | 297 | 4.946429 | 14.69089413 | Bacteria | 2 | Bacteria | Bacteria | 69.3 | 3.13e-11 | NR | MBC7565073.1 | 2026720 | g26882 | i0 | 87.8 | 2.48484848484848 | 41 | 5 | 41.4 | 0 | 296 | 174 | 563 | 603 | MBC7565073.1 threonine--tRNA ligase [Candidatus Saccharibacteria bacterium] | diamond | 738 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29340688 | 29340688 | PRJNA1047749_P_NODE_24609_length_301_cov_3.109649_g24342_i0 | PRJNA1047749 | 24609 | 301 | 3.109649 | 9.36004349 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 168 | 1.27e-47 | NR | MEO5499008.1 | 2973664 | g24342 | i0 | 74.6 | 1.13621262458472 | 114 | 13 | 97.7 | 1 | 296 | 3 | 355 | 468 | MEO5499008.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 342 | 168 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30446223 | 30446223 | PRJNA1047749_P_NODE_47433_length_225_cov_5.625000_g47166_i0 | PRJNA1047749 | 47433 | 225 | 5.625 | 12.65625 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 121 | 1.3799999999999998e-31 | NR | NCC19598.1 | 2026720 | g47166 | i0 | 91.7 | 0.96 | 72 | 6 | 96 | 0 | 8 | 223 | 33 | 104 | NCC19598.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 216 | 121 | 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);;