contig_metadata
7 rows where bioproject = "PRJNA217180", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26694058 | 26694058 | PRJNA217180_P_NODE_15321_length_161_cov_0.910714_g15221_i0 | PRJNA217180 | 15321 | 161 | 0.910714 | 1.46624954 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 74.3 | 3.24e-14 | NR | MBA3678781.1 | 2026720 | g15221 | i0 | 82.5 | 1.49068322981366 | 40 | 7 | 74.5 | 0 | 120 | 1 | 1 | 40 | MBA3678781.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 240 | 74.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28810514 | 28810514 | PRJNA217180_P_NODE_13188_length_166_cov_0.871795_g13088_i0 | PRJNA217180 | 13188 | 166 | 0.871795 | 1.4471797 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 67.4 | 2.5e-11 | NR | MEO7905068.1 | 2973664 | g13088 | i0 | 51.9 | 0.975903614457831 | 54 | 26 | 97.6 | 0 | 5 | 166 | 119 | 172 | MEO7905068.1 metallophosphoesterase [Candidatus Saccharimonadales bacterium] | diamond | 162 | 67.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29568594 | 29568594 | PRJNA217180_P_NODE_9670_length_189_cov_1.242857_g9570_i0 | PRJNA217180 | 9670 | 189 | 1.242857 | 2.34899973 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 76.3 | 2.43e-15 | NR | MEP7205241.1 | 2026720 | g9570 | i0 | 63.5 | 0.825396825396825 | 52 | 17 | 82.5 | 1 | 158 | 3 | 95 | 144 | MEP7205241.1 isoprenylcysteine carboxylmethyltransferase family protein [Candidatus Saccharibacteria bacterium] | diamond | 156 | 76.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31527817 | 31527817 | PRJNA217180_P_NODE_9796_length_188_cov_1.374101_g9696_i0 | PRJNA217180 | 9796 | 188 | 1.374101 | 2.58330988 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 49.3 | 6.83e-5 | NR | HSH31078.1 | 2973664 | g9696 | i0 | 54.2 | 0.765957446808511 | 48 | 22 | 76.6 | 0 | 145 | 2 | 72 | 119 | HSH31078.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 144 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31545642 | 31545642 | PRJNA217180_P_NODE_11276_length_176_cov_1.338583_g11176_i0 | PRJNA217180 | 11276 | 176 | 1.338583 | 2.35590608 | Bacteria | 2 | Bacteria | Bacteria | 109 | 5.15e-26 | NR | MCA9345291.1 | 2026720 | g11176 | i0 | 91.4 | 5.93181818181818 | 58 | 5 | 98.9 | 0 | 1 | 174 | 334 | 391 | MCA9345291.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Candidatus Saccharibacteria bacterium] | diamond | 1044 | 110 | 0.990909090909091 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32287291 | 32287291 | PRJNA217180_P_NODE_13639_length_165_cov_0.879310_g13539_i0 | PRJNA217180 | 13639 | 165 | 0.87931 | 1.4508615 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 64.7 | 1.5e-10 | NR | HSX14396.1 | 2973664 | g13539 | i0 | 64.8 | 0.981818181818182 | 54 | 19 | 98.2 | 0 | 164 | 3 | 173 | 226 | HSX14396.1 DNA-processing protein DprA [Candidatus Saccharimonadales bacterium] | diamond | 162 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 32350445 | 32350445 | PRJNA217180_P_NODE_14759_length_162_cov_0.902655_g14659_i0 | PRJNA217180 | 14759 | 162 | 0.902655 | 1.4623011 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 68.2 | 7.12e-12 | NR | MBA3678777.1 | 2026720 | g14659 | i0 | 71.7 | 0.981481481481482 | 53 | 15 | 98.1 | 0 | 162 | 4 | 7 | 59 | MBA3678777.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 159 | 68.2 | 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);;