contig_metadata
7 rows where bioproject = "PRJNA379145", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4228075 | 4228075 | PRJNA379145_P_NODE_42084_length_286_cov_1.814229_g39932_i0 | PRJNA379145 | 42084 | 286 | 1.814229 | 5.18869494 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 433 | 8.08e-117 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g39932 | i0 | 94.346 | 76.0524475524475 | 283 | 14 | 99 | 2 | 1 | 283 | 851145 | 851425 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 21751 | 433 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 7451990 | 7451990 | PRJNA379145_P_NODE_59326_length_191_cov_2.006329_g57172_i0 | PRJNA379145 | 59326 | 191 | 2.006329 | 3.83208839 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 342 | 8.699999999999999e-90 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g57172 | i0 | 98.953 | 65.7853403141361 | 191 | 2 | 100 | 0 | 1 | 191 | 152409 | 152219 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 12565 | 342 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 26631792 | 26631792 | PRJNA379145_P_NODE_42421_length_283_cov_2.512000_g40269_i0 | PRJNA379145 | 42421 | 283 | 2.512 | 7.10896 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 70.1 | 1.08e-11 | NR | HMS92978.1 | 2026720 | g40269 | i0 | 40.8 | 2.41696113074205 | 76 | 44 | 79.5 | 1 | 59 | 283 | 83 | 158 | HMS92978.1 cellulase family glycosylhydrolase [Candidatus Saccharibacteria bacterium] | diamond | 684 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 26726323 | 26726323 | PRJNA379145_P_NODE_12481_length_833_cov_2.391250_g11079_i0 | PRJNA379145 | 12481 | 833 | 2.39125 | 19.9191125 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 153 | 9.95e-41 | NR | HUA69260.1 | 2973664 | g11079 | i0 | 36.1 | 1.77551020408163 | 255 | 124 | 90.8 | 6 | 8 | 763 | 53 | 271 | HUA69260.1 tartrate-resistant acid phosphatase type 5 family protein [Candidatus Saccharimonadales bacterium] | diamond | 1479 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 26916720 | 26916720 | PRJNA379145_P_NODE_14602_length_749_cov_2.596369_g11079_i1 | PRJNA379145 | 14602 | 749 | 2.596369 | 19.44680381 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 166 | 7.33e-46 | NR | HUA69260.1 | 2973664 | g11079 | i1 | 40.5 | 1.75033377837116 | 227 | 124 | 89.7 | 5 | 742 | 71 | 53 | 271 | HUA69260.1 tartrate-resistant acid phosphatase type 5 family protein [Candidatus Saccharimonadales bacterium] | diamond | 1311 | 166 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28117134 | 28117134 | PRJNA379145_P_NODE_50665_length_230_cov_1.456853_g48511_i0 | PRJNA379145 | 50665 | 230 | 1.456853 | 3.3507619 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 83.6 | 1.31e-16 | NR | MBR2725423.1 | 2026720 | g48511 | i0 | 52 | 7.81304347826087 | 75 | 33 | 97.8 | 1 | 228 | 4 | 335 | 406 | MBR2725423.1 UvrD-helicase domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 1797 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28622521 | 28622521 | PRJNA379145_P_NODE_22647_length_539_cov_2.496047_g20688_i0 | PRJNA379145 | 22647 | 539 | 2.496047 | 13.45369333 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 48.9 | 0.00481 | NR | NCO10391.1 | 2026720 | g20688 | i0 | 40.3 | 0.345083487940631 | 62 | 33 | 34.5 | 2 | 2 | 187 | 707 | 764 | NCO10391.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 186 | 48.9 | 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);;