RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA857143 · 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
5947769 5947769 PRJNA857143_S_NODE_89225_length_326_cov_2.047431_g88132_i0 PRJNA857143 89225 326 2.047431 6.67462506 PVC group 1783257 Bacteria Bacteria 152 3.12e-40   NR WP_038066611.1 2337 g88132 i0 69.4 25.840490797546 108 33 99.4 0 325 2 8 115 WP_038066611.1 pyruvate, phosphate dikinase [Thermotoga neapolitana] diamond 8424 153 0.993464052287582 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga neapolitana
26770225 26770225 PRJNA857143_S_NODE_169341_length_253_cov_0.866667_g168248_i0 PRJNA857143 169341 253 0.866667 2.19266751 Synergistaceae bacterium 2053624 Bacteria Bacteria 56.6 5.25e-7   NR MBR0202831.1 2053624 g168248 i0 67.6 0.438735177865613 37 12 43.9 0 10 120 232 268 MBR0202831.1 toll/interleukin-1 receptor domain-containing protein [Synergistaceae bacterium] diamond 111 56.6 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
29013315 29013315 PRJNA857143_S_NODE_55228_length_383_cov_5.719355_g54135_i0 PRJNA857143 55228 383 5.719355 21.90512965 Deinococcus roseus 392414 Bacteria Bacteria 93.2 3.1400000000000002e-19   NR WP_189006493.1 392414 g54135 i0 75.4 0.892950391644909 57 14 44.6 0 382 212 427 483 WP_189006493.1 glycoside hydrolase family 30 protein [Deinococcus roseus] diamond 342 93.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus roseus

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