contig_metadata
6 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;