RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB12982 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_clade 0

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
27570109 27570109 PRJEB12982_P_NODE_19584_length_163_cov_0.894737_g19421_i0 PRJEB12982 19584 163 0.894737 1.45842131 Sporosarcina sp. FSL K6-3457 2978204 Bacteria Bacteria 53.5 1.84e-6   NR WP_340738690.1 2978204 g19421 i0 50 1.71165644171779 50 24 92 1 14 163 124 172 WP_340738690.1 serine/threonine-protein kinase [Sporosarcina sp. FSL K6-3457] diamond 279 53.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Sporosarcina Sporosarcina sp. FSL K6-3457
28485843 28485843 PRJEB12982_P_NODE_3287_length_425_cov_1.627660_g3126_i0 PRJEB12982 3287 425 1.62766 6.917555 Anaeromicropila populeti 37658 Bacteria Bacteria 61.6 4.64e-9   NR WP_092562468.1 37658 g3126 i0 57.1 1.76470588235294 56 23 38.8 1 202 38 3 58 WP_092562468.1 DnaJ domain-containing protein [Anaeromicropila populeti] diamond 750 61.6 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Anaeromicropila Anaeromicropila populeti
28927838 28927838 PRJEB12982_P_NODE_11268_length_210_cov_1.099379_g11105_i0 PRJEB12982 11268 210 1.099379 2.3086959 Clostridia bacterium 2044939 Bacteria Bacteria 44.3 0.00675   NR MBR1686885.1 2044939 g11105 i0 44.9 0.7 49 26 68.6 1 60 203 88 136 MBR1686885.1 MATE family efflux transporter [Clostridia bacterium] diamond 147 44.3 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29022946 29022946 PRJEB12982_P_NODE_18728_length_164_cov_1.695652_g18565_i0 PRJEB12982 18728 164 1.695652 2.78086928 uncultured Anaerococcus sp. 293428 Bacteria Bacteria 93.2 4.91e-23   NR WP_297790668.1 293428 g18565 i0 98 0.914634146341463 50 1 91.5 0 152 3 1 50 WP_297790668.1 hypothetical protein [uncultured Anaerococcus sp.] diamond 150 93.2 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
29559210 29559210 PRJEB12982_P_NODE_10610_length_217_cov_0.910714_g10447_i0 PRJEB12982 10610 217 0.910714 1.97624938 Bacillota bacterium 1879010 Bacteria Bacteria 63.5 8.2e-10   NR MBR4149758.1 1879010 g10447 i0 56.1 0.788018433179724 57 25 78.8 0 1 171 207 263 MBR4149758.1 SMP-30/gluconolactonase/LRE family protein [Bacillota bacterium] diamond 171 63.5 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
29837058 29837058 PRJEB12982_P_NODE_10211_length_221_cov_1.186047_g10048_i0 PRJEB12982 10211 221 1.186047 2.62116387 Lactobacillus 1578 Bacteria Bacteria 90.9 3.07e-19   NR WP_003652924.1 1596 g10048 i0 59.7 10.6289592760181 67 27 91 0 221 21 71 137 WP_003652924.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Lactobacillus gasseri] diamond 2349 91.3 0.995618838992333 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus gasseri

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;