RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA1241156", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 9 ✖

tax_phylum 1

  • Spirochaetota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1241156 · 9 ✖

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
350060 350060 PRJNA1241156_S_NODE_56621_length_261_cov_0.981651_g56161_i0 PRJNA1241156 56621 261 0.981651 2.56210911 Treponema sp. 166 Bacteria Bacteria 117 3.35e-28   NR MBQ1175754.1 166 g56161 i0 95 0.689655172413793 60 3 69 0 237 58 612 671 MBQ1175754.1 diguanylate cyclase [Treponema sp.] diamond 180 117 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26724960 26724960 PRJNA1241156_S_NODE_30341_length_329_cov_6.461538_g29881_i0 PRJNA1241156 30341 329 6.461538 21.25846002 Spirochaetia bacterium 2053615 Bacteria Bacteria 162 1.27e-46   NR MCI7036589.1 2053615 g29881 i0 98.9 0.829787234042553 91 1 83 0 1 273 225 315 MCI7036589.1 ABC transporter permease [Spirochaetia bacterium] diamond 273 162 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28241954 28241954 PRJNA1241156_S_NODE_11786_length_409_cov_4.101093_g11326_i0 PRJNA1241156 11786 409 4.101093 16.77347037 Treponema sp. 166 Bacteria Bacteria 249 1.6100000000000002e-79   NR MBQ1174803.1 166 g11326 i0 94.7 0.968215158924205 132 7 96.8 0 397 2 72 203 MBQ1174803.1 acyltransferase family protein [Treponema sp.] diamond 396 249 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28431667 28431667 PRJNA1241156_S_NODE_27926_length_337_cov_2.717687_g27466_i0 PRJNA1241156 27926 337 2.717687 9.15860519 Treponema porcinum 261392 Bacteria Bacteria 83.6 2.46e-16   NR WP_273349999.1 261392 g27466 i0 95.6 1.20178041543027 45 2 40.1 0 159 25 1 45 WP_273349999.1 hypothetical protein, partial [Treponema porcinum] diamond 405 83.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema porcinum
29094774 29094774 PRJNA1241156_S_NODE_42168_length_296_cov_6.015810_g41708_i0 PRJNA1241156 42168 296 6.01581 17.8067976 Treponema bryantii 163 Bacteria Bacteria 198 1.9e-62   NR WP_074929871.1 163 g41708 i0 99 0.993243243243243 98 1 99.3 0 294 1 61 158 WP_074929871.1 hypothetical protein [Treponema bryantii] diamond 294 198 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
29568157 29568157 PRJNA1241156_S_NODE_42750_length_295_cov_2.373016_g42290_i0 PRJNA1241156 42750 295 2.373016 7.0003972 Spirochaetia bacterium 2053615 Bacteria Bacteria 48.1 6.07e-5   NR MCI6317122.1 2053615 g42290 i0 100 0.447457627118644 20 0 20.3 0 295 236 45 64 MCI6317122.1 hypothetical protein [Spirochaetia bacterium] diamond 132 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30484395 30484395 PRJNA1241156_S_NODE_66593_length_240_cov_2.979695_g66133_i0 PRJNA1241156 66593 240 2.979695 7.151268 Treponema sp. 166 Bacteria Bacteria 104 2.49e-24   NR MBQ1181278.1 166 g66133 i0 100 0.625 50 0 62.5 0 1 150 382 431 MBQ1181278.1 bifunctional phosphoribosyl-AMP cyclohydrolase/phosphoribosyl-ATP diphosphatase HisIE [Treponema sp.] diamond 150 104 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30800107 30800107 PRJNA1241156_S_NODE_27814_length_337_cov_4.367347_g27354_i0 PRJNA1241156 27814 337 4.367347 14.71795939 Treponema sp. 166 Bacteria Bacteria 91.3 2.59e-20   NR MDD7451016.1 166 g27354 i0 66.2 0.605341246290801 68 23 60.5 0 337 134 98 165 MDD7451016.1 portal protein [Treponema sp.] diamond 204 91.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32697115 32697115 PRJNA1241156_S_NODE_64240_length_245_cov_1.539604_g63780_i0 PRJNA1241156 64240 245 1.539604 3.7720298 Treponema sp. 166 Bacteria Bacteria 125 3.53e-31   NR MBQ1948799.1 166 g63780 i0 87 0.844897959183673 69 9 84.5 0 245 39 599 667 MBQ1948799.1 UvrD-helicase domain-containing protein [Treponema sp.] diamond 207 125 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.

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