RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA588137" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA588137 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
28564061 28564061 PRJNA588137_S_NODE_5287_length_268_cov_1.446154_g5254_i0 PRJNA588137 5287 268 1.446154 3.87569272 Listeria monocytogenes 1639 Bacteria Bacteria 127 2.31e-32   NR HCA4015454.1 1639 g5254 i0 97 0.738805970149254 66 2 73.9 0 59 256 1 66 HCA4015454.1 hypothetical protein [Listeria monocytogenes] diamond 198 127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
28829930 28829930 PRJNA588137_S_NODE_7348_length_249_cov_0.875000_g7315_i0 PRJNA588137 7348 249 0.875 2.17875 root 1 Root_unresolved Root_unresolved 86.7 5.2e-19   NR WP_069142025.1 1313 g7315 i0 47.6 11.8313253012048 82 43 98.8 0 247 2 30 111 WP_069142025.1 LexA family protein, partial [Streptococcus pneumoniae] diamond 2946 86.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28847981 28847981 PRJNA588137_S_NODE_7948_length_248_cov_0.880000_g7915_i0 PRJNA588137 7948 248 0.88 2.1824 Bacilli bacterium 1903720 Bacteria Bacteria 120 2.18e-32   NR MEG0407245.1 1903720 g7915 i0 74.4 1.98387096774194 82 21 99.2 0 248 3 10 91 MEG0407245.1 phage protein [Bacilli bacterium] diamond 492 120 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
29132477 29132477 PRJNA588137_S_NODE_6349_length_251_cov_1.157303_g6316_i0 PRJNA588137 6349 251 1.157303 2.90483053 Carnobacteriaceae bacterium 52-44 3142729 Bacteria Bacteria 48.9 6.53e-5   NR MEY8292856.1 3142729 g6316 i0 75.9 0.346613545816733 29 7 34.7 0 91 5 1 29 MEY8292856.1 Rid family detoxifying hydrolase [Carnobacteriaceae bacterium 52-44] diamond 87 48.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae   Carnobacteriaceae bacterium 52-44
29542694 29542694 PRJNA588137_S_NODE_3930_length_296_cov_1.035874_g3897_i0 PRJNA588137 3930 296 1.035874 3.06618704 Listeria monocytogenes 1639 Bacteria Bacteria 109 1.12e-25   NR HCA4015454.1 1639 g3897 i0 98.1 0.537162162162162 53 1 53.7 0 2 160 432 484 HCA4015454.1 hypothetical protein [Listeria monocytogenes] diamond 159 109 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
30237672 30237672 PRJNA588137_S_NODE_9972_length_243_cov_0.905882_g9939_i0 PRJNA588137 9972 243 0.905882 2.20129326 Thermicanus aegyptius 94009 Bacteria Bacteria 114 1.55e-29   NR WP_028987004.1 94009 g9939 i0 98.4 1.53086419753086 62 1 76.5 0 243 58 143 204 WP_028987004.1 SpoIIIAH-like family protein [Thermicanus aegyptius] diamond 372 114 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
30283125 30283125 PRJNA588137_S_NODE_5692_length_261_cov_1.228723_g5659_i0 PRJNA588137 5692 261 1.228723 3.20696703 Bacillaceae 186817 Bacteria Bacteria 102 4.66e-26   NR WP_229725710.1 373054 g5659 i0 57.6 3.91954022988506 85 36 97.7 0 259 5 30 114 WP_229725710.1 group I truncated hemoglobin [Calditerricola satsumensis] diamond 1023 103 0.990291262135922 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Calditerricola Calditerricola satsumensis

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