contig_metadata
7 rows where bioproject = "PRJNA796753", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7159074 | 7159074 | PRJNA796753_P_NODE_31266_length_276_cov_1.068966_g30954_i0 | PRJNA796753 | 31266 | 276 | 1.068966 | 2.95034616 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 499 | 7.54e-137 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g30954 | i0 | 99.275 | 302.811594202899 | 276 | 2 | 100 | 0 | 1 | 276 | 150922 | 151197 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 83576 | 499 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 15245184 | 15245184 | PRJNA796753_P_NODE_51912_length_242_cov_2.059172_g51600_i0 | PRJNA796753 | 51912 | 242 | 2.059172 | 4.98319624 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 448 | 2.3799999999999995e-121 | NTclustered | gi|1842053267|gb|CP039998.1| | 713059 | g51600 | i0 | 100 | 65.5123966942149 | 242 | 0 | 100 | 0 | 1 | 242 | 147114 | 146873 | Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome | blastn | 15854 | 448 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 16519663 | 16519663 | PRJNA796753_P_NODE_7913_length_486_cov_1.382567_g7602_i0 | PRJNA796753 | 7913 | 486 | 1.382567 | 6.71927562 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 876 | 0 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g7602 | i0 | 99.379 | 137.954732510288 | 483 | 3 | 99 | 0 | 4 | 486 | 152302 | 151820 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 67046 | 876 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 26768999 | 26768999 | PRJNA796753_P_NODE_35661_length_261_cov_1.638298_g35349_i0 | PRJNA796753 | 35661 | 261 | 1.638298 | 4.27595778 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 70.5 | 7.82e-12 | NR | MBQ69803.1 | 2026720 | g35349 | i0 | 53.3 | 0.862068965517241 | 75 | 34 | 85.1 | 1 | 223 | 2 | 1 | 75 | MBQ69803.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 225 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 26958733 | 26958733 | PRJNA796753_P_NODE_2482_length_834_cov_2.017083_g2222_i0 | PRJNA796753 | 2482 | 834 | 2.017083 | 16.82247222 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 73.2 | 1.71e-10 | NR | HXI51305.1 | 2973664 | g2222 | i0 | 40 | 0.377697841726619 | 105 | 60 | 36.7 | 1 | 309 | 4 | 49 | 153 | HXI51305.1 VCBS repeat-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 315 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29453517 | 29453517 | PRJNA796753_P_NODE_49970_length_244_cov_0.900585_g49658_i0 | PRJNA796753 | 49970 | 244 | 0.900585 | 2.1974274 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 107 | 4.95e-25 | NR | WP_260764247.1 | 2665156 | g49658 | i0 | 60.8 | 0.971311475409836 | 79 | 31 | 97.1 | 0 | 5 | 241 | 772 | 850 | WP_260764247.1 ATP-dependent helicase [Candidatus Mycosynbacter amalyticus] | diamond | 237 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 32276200 | 32276200 | PRJNA796753_P_NODE_44178_length_248_cov_0.880000_g43866_i0 | PRJNA796753 | 44178 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 159 | 5.7799999999999984e-43 | NR | NCU29181.1 | 2026720 | g43866 | i0 | 93.9 | 1.98387096774194 | 82 | 5 | 99.2 | 0 | 247 | 2 | 523 | 604 | NCU29181.1 ATP-dependent helicase [Candidatus Saccharibacteria bacterium] | diamond | 492 | 160 | 0.99375 | 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);;