contig_metadata
8 rows where bioproject = "PRJNA577226" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5665521 | 5665521 | PRJNA577226_S_NODE_36745_length_205_cov_1.958333_g35806_i0 | PRJNA577226 | 36745 | 205 | 1.958333 | 4.01458265 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 346 | 7.33e-91 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g35806 | i0 | 97.073 | 119.468292682927 | 205 | 6 | 100 | 0 | 1 | 205 | 667673 | 667469 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 24491 | 346 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 8789919 | 8789919 | PRJNA577226_S_NODE_12587_length_366_cov_1.747720_g11648_i0 | PRJNA577226 | 12587 | 366 | 1.74772 | 6.3966552 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 660 | 0 | NTclustered | gi|1842053267|gb|CP039998.1| | 713059 | g11648 | i0 | 99.18 | 74.5846994535519 | 366 | 3 | 100 | 0 | 1 | 366 | 147114 | 146749 | Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome | blastn | 27298 | 660 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 20263776 | 20263776 | PRJNA577226_S_NODE_32576_length_218_cov_2.994475_g31637_i0 | PRJNA577226 | 32576 | 218 | 2.994475 | 6.5279555 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 77.8 | 1.2e-14 | NR | MBR3143877.1 | 2026720 | g31637 | i0 | 48.6 | 1.95412844036697 | 72 | 37 | 99.1 | 0 | 218 | 3 | 678 | 749 | MBR3143877.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium] | diamond | 426 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27932462 | 27932462 | PRJNA577226_S_NODE_45925_length_184_cov_1.312925_g44986_i0 | PRJNA577226 | 45925 | 184 | 1.312925 | 2.415782 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 56.2 | 8.97e-8 | NR | MCA9301483.1 | 2026720 | g44986 | i0 | 54.8 | 2.05434782608696 | 42 | 18 | 68.5 | 1 | 4 | 129 | 129 | 169 | MCA9301483.1 CHAP domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 378 | 56.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29069286 | 29069286 | PRJNA577226_S_NODE_40908_length_194_cov_2.235669_g39969_i0 | PRJNA577226 | 40908 | 194 | 2.235669 | 4.33719786 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 64.7 | 3.45e-10 | NR | HET6925064.1 | 2973664 | g39969 | i0 | 42.9 | 2.18041237113402 | 70 | 34 | 99 | 1 | 194 | 3 | 147 | 216 | HET6925064.1 phage portal protein [Candidatus Saccharimonadales bacterium] | diamond | 423 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30237624 | 30237624 | PRJNA577226_S_NODE_8852_length_448_cov_2.384428_g7917_i0 | PRJNA577226 | 8852 | 448 | 2.384428 | 10.68223744 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 78.2 | 6.85e-15 | NR | MCA9325962.1 | 2026720 | g7917 | i0 | 43.6 | 0.676339285714286 | 101 | 54 | 67 | 2 | 321 | 22 | 59 | 157 | MCA9325962.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 303 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30332839 | 30332839 | PRJNA577226_S_NODE_28772_length_233_cov_2.000000_g27833_i0 | PRJNA577226 | 28772 | 233 | 2 | 4.66 | Candidatus Nanosynbacter sp. BB | 2725945 | Bacteria | Bacteria | 109 | 7.88e-27 | NR | WP_338520426.1 | 3393757 | g27833 | i0 | 70.1 | 1.98283261802575 | 77 | 21 | 97.9 | 2 | 232 | 5 | 52 | 127 | WP_338520426.1 GH25 family lysozyme [Candidatus Nanosynbacter sp. BB002] | diamond | 462 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 32084650 | 32084650 | PRJNA577226_S_NODE_16018_length_321_cov_1.785211_g15079_i0 | PRJNA577226 | 16018 | 321 | 1.785211 | 5.73052731 | Bacillati | 1783272 | Bacteria | Bacteria | 83.2 | 5.61e-16 | NR | HET6925064.1 | 2973664 | g15079 | i0 | 43.8 | 1.74766355140187 | 105 | 57 | 96.3 | 2 | 2 | 310 | 415 | 519 | HET6925064.1 phage portal protein [Candidatus Saccharimonadales bacterium] | diamond | 561 | 83.6 | 0.995215311004785 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales 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);;