RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA342843" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA342843 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
26853469 26853469 PRJNA342843_S_NODE_8581_length_217_cov_1.005682_g8431_i0 PRJNA342843 8581 217 1.005682 2.18232994 Treponema sp. 166 Bacteria Bacteria 69.3 4.41e-12   NR MDD7451654.1 166 g8431 i0 42.5 1.93548387096774 73 40 98.2 1 1 213 166 238 MDD7451654.1 hypothetical protein [Treponema sp.] diamond 420 69.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30485537 30485537 PRJNA342843_S_NODE_13153_length_166_cov_1.736000_g13003_i0 PRJNA342843 13153 166 1.736 2.88176 Leptospira stimsonii 2202203 Bacteria Bacteria 57 1.23e-7   NR WP_135684291.1 2202203 g13003 i0 45.1 2.76506024096386 51 26 92.2 1 153 1 124 172 WP_135684291.1 zinc-ribbon domain-containing protein [Leptospira stimsonii] diamond 459 57 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira stimsonii
31148568 31148568 PRJNA342843_S_NODE_8955_length_211_cov_1.694118_g8805_i0 PRJNA342843 8955 211 1.694118 3.57458898 Leptonema sp. (in: bacteria) 2046886 Bacteria Bacteria 67 3.33e-11   NR MFN3247494.1 2046886 g8805 i0 88.2 0.483412322274882 34 4 48.3 0 210 109 226 259 MFN3247494.1 DNA-methyltransferase [Leptonema sp. (in: bacteria)] diamond 102 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema sp. (in: bacteria)

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