RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJDB9741 · 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
29211678 29211678 PRJDB9741_P_NODE_11749_length_196_cov_2.816327_g11432_i0 PRJDB9741 11749 196 2.816327 5.52000092 Deinococcus xinjiangensis 457454 Bacteria Bacteria 62.8 1.75e-9   NR WP_353543409.1 457454 g11432 i0 100 0.459183673469388 30 0 45.9 0 91 2 798 827 WP_353543409.1 hypothetical protein [Deinococcus xinjiangensis] diamond 90 62.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus xinjiangensis
30285708 30285708 PRJDB9741_P_NODE_9632_length_210_cov_2.527950_g9315_i0 PRJDB9741 9632 210 2.52795 5.308695 Deinococcus taklimakanensis 536443 Bacteria Bacteria 71.6 6.41e-14   NR WP_386842910.1 536443 g9315 i0 92.7 0.585714285714286 41 1 58.6 1 208 86 95 133 WP_386842910.1 hypothetical protein [Deinococcus taklimakanensis] diamond 123 71.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taklimakanensis
32309082 32309082 PRJDB9741_P_NODE_37319_length_162_cov_1.433628_g37002_i0 PRJDB9741 37319 162 1.433628 2.32247736 Deinococcus misasensis 392413 Bacteria Bacteria 95.9 2.28e-21   NR WP_051963965.1 392413 g37002 i0 83 7.81481481481481 53 9 98.1 0 3 161 76 128 WP_051963965.1 MDR family MFS transporter [Deinococcus misasensis] diamond 1266 95.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis

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