RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA800090", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA800090 · 6 ✖

analysis 1

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
23750628 23750628 PRJNA800090_P_NODE_172679_length_236_cov_0.874251_g170494_i0 PRJNA800090 172679 236 0.874251 2.06323236 Pseudomonadati 3379134 Bacteria Bacteria 137 1.24e-35   NR WP_108976027.1 1917863 g170494 i0 88.5 6.94067796610169 78 9 99.2 0 2 235 502 579 WP_108976027.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Leptospira ryugenii] diamond 1638 138 0.992753623188406 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ryugenii
27726879 27726879 PRJNA800090_P_NODE_93344_length_340_cov_1.273063_g91159_i0 PRJNA800090 93344 340 1.273063 4.3284142 Bacteria 2 Bacteria Bacteria 45.4 0.0119   NR MBP7281011.1 2026757 g91159 i0 50 3.91764705882353 48 23 41.5 1 339 199 98 145 MBP7281011.1 fused response regulator/phosphatase [Leptospiraceae bacterium] diamond 1332 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28980690 28980690 PRJNA800090_P_NODE_77808_length_381_cov_1.310897_g75623_i0 PRJNA800090 77808 381 1.310897 4.99451757 Treponema zioleckii 331680 Bacteria Bacteria 51.2 1.86e-4   NR WP_191014558.1 331680 g75623 i0 44.6 1.92913385826772 74 37 58.3 3 3 224 420 489 WP_191014558.1 ankyrin repeat domain-containing protein [Treponema zioleckii] diamond 735 51.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema zioleckii
29170050 29170050 PRJNA800090_P_NODE_154009_length_252_cov_1.590164_g151824_i0 PRJNA800090 154009 252 1.590164 4.00721328 Leptospira kirschneri 29507 Bacteria Bacteria 42 0.00909   NR UML82154.1 29507 g151824 i0 63.3 0.357142857142857 30 11 35.7 0 239 150 9 38 UML82154.1 ankyrin repeat domain-containing protein [Leptospira kirschneri] diamond 90 42 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira kirschneri
30685887 30685887 PRJNA800090_P_NODE_197333_length_218_cov_2.744966_g195148_i0 PRJNA800090 197333 218 2.744966 5.98402588 Treponema sp. 166 Bacteria Bacteria 42.7 0.0264   NR MBQ1710799.1 166 g195148 i0 41.7 0.825688073394495 60 31 77.1 1 15 182 221 280 MBQ1710799.1 ATP-grasp domain-containing protein [Treponema sp.] diamond 180 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31539558 31539558 PRJNA800090_P_NODE_130056_length_278_cov_0.923445_g127871_i0 PRJNA800090 130056 278 0.923445 2.5671771 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 133 9.48e-34   NR MFP4429666.1 1898206 g127871 i0 71.7 0.992805755395683 92 26 99.3 0 1 276 106 197 MFP4429666.1 pyruvate, phosphate dikinase [Spirochaetaceae bacterium] diamond 276 133 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium

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