RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA752572", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 15 ✖

tax_kingdom 1

  • Pseudomonadati · 15 ✖

bioproject 1

  • PRJNA752572 · 15 ✖

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
16031190 16031190 PRJNA752572_P_NODE_209613_length_183_cov_3.047297_g209106_i0 PRJNA752572 209613 183 3.047297 5.57655351 Leptospira sp. GIMC2001 1513297 Bacteria Bacteria 126 9.05e-25   NTclustered gi|2440388381|gb|CP115468.1| 1513297 g209106 i0 80.864 2.72677595628415 162 29 88 2 15 175 3993502 3993342 Leptospira sp. GIMC2001 chromosome 1, complete sequence blastn 499 126 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. GIMC2001
24955109 24955109 PRJNA752572_P_NODE_121040_length_244_cov_2.287081_g120533_i0 PRJNA752572 121040 244 2.287081 5.58047764 Pseudomonadati 3379134 Bacteria Bacteria 96.7 4.0500000000000005e-21   NR NBU98349.1 2053615 g120533 i0 47.5 6.92213114754098 80 42 98.4 0 241 2 612 691 NBU98349.1 deoxyribodipyrimidine photo-lyase [Spirochaetia bacterium] diamond 1689 96.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
25428013 25428013 PRJNA752572_P_NODE_169100_length_205_cov_2.623529_g168593_i0 PRJNA752572 169100 205 2.623529 5.37823445 Leptospiraceae bacterium 2026757 Bacteria Bacteria 107 8.409999999999999e-28   NR HNO24933.1 2026757 g168593 i0 80.6 0.980487804878049 67 13 98 0 203 3 52 118 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 201 107 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27021246 27021246 PRJNA752572_P_NODE_209962_length_183_cov_2.148649_g209455_i0 PRJNA752572 209962 183 2.148649 3.93202767 Spirochaetales bacterium 2026792 Bacteria Bacteria 63.2 1.02e-9   NR MBN1647197.1 2026792 g209455 i0 58.1 2.31147540983607 43 18 70.5 0 54 182 110 152 MBN1647197.1 serine/threonine protein kinase [Spirochaetales bacterium] diamond 423 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28126803 28126803 PRJNA752572_P_NODE_150385_length_218_cov_1.830601_g149878_i0 PRJNA752572 150385 218 1.830601 3.99071018 Leptospira alexanderi 100053 Bacteria Bacteria 42.4 0.0365   NR WP_078129602.1 100053 g149878 i0 35.7 0.770642201834862 56 32 71.6 1 3 158 282 337 WP_078129602.1 protein-disulfide reductase DsbD family protein [Leptospira alexanderi] diamond 168 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira alexanderi
28474114 28474114 PRJNA752572_P_NODE_164426_length_208_cov_2.531792_g163919_i0 PRJNA752572 164426 208 2.531792 5.26612736 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 40.4 0.0473   NR MDR0709193.1 1898206 g163919 i0 40.4 0.822115384615385 57 25 82.2 2 201 31 46 93 MDR0709193.1 DUF6171 family protein [Spirochaetaceae bacterium] diamond 171 40.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29042536 29042536 PRJNA752572_P_NODE_126228_length_239_cov_1.441176_g125721_i0 PRJNA752572 126228 239 1.441176 3.44441064 Treponema succinifaciens 167 Bacteria Bacteria 55.5 9.35e-7   NR UKI56908.1 167 g125721 i0 63.6 0.552301255230126 44 15 54 1 129 1 84 127 UKI56908.1 MAG: pesticin C-terminus-like muramidase [Treponema succinifaciens] diamond 132 55.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema succinifaciens
29863287 29863287 PRJNA752572_P_NODE_7831_length_899_cov_5.613426_g1188_i1 PRJNA752572 7831 899 5.613426 50.46469974 Treponema sp. 166 Bacteria Bacteria 69.3 1.3e-9   NR MEE0352004.1 166 g1188 i1 38 1.0678531701891 158 88 52.7 6 704 231 91 238 MEE0352004.1 CAP domain-containing protein [Treponema sp.] diamond 960 69.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30021443 30021443 PRJNA752572_P_NODE_57731_length_360_cov_1.372308_g57224_i0 PRJNA752572 57731 360 1.372308 4.9403088 Spirochaetota bacterium 2202144 Bacteria Bacteria 86.7 5.27e-17   NR HMB20739.1 2202144 g57224 i0 43 0.775 93 53 77.5 0 52 330 288 380 HMB20739.1 aspartate aminotransferase family protein [Spirochaetota bacterium] diamond 279 86.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30147384 30147384 PRJNA752572_P_NODE_180872_length_198_cov_2.251534_g180365_i0 PRJNA752572 180872 198 2.251534 4.45803732 Spirochaetota bacterium 2202144 Bacteria Bacteria 45.4 0.00223   NR HPI14991.1 2202144 g180365 i0 62.5 0.96969696969697 32 12 48.5 0 98 193 183 214 HPI14991.1 tetratricopeptide repeat protein [Spirochaetota bacterium] diamond 192 45.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30242550 30242550 PRJNA752572_P_NODE_57832_length_359_cov_3.703704_g57325_i0 PRJNA752572 57832 359 3.703704 13.29629736 Leptospiraceae bacterium 2026757 Bacteria Bacteria 64.7 3.32e-11   NR MCB1177358.1 2026757 g57325 i0 43.3 0.501392757660167 60 32 50.1 1 201 22 2 59 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 180 64.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30779571 30779571 PRJNA752572_P_NODE_215034_length_181_cov_1.369863_g214527_i0 PRJNA752572 215034 181 1.369863 2.47945203 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 57.4 9.78e-8   NR MDC7244430.1 2791017 g214527 i0 49 0.812154696132597 49 25 81.2 0 14 160 250 298 MDC7244430.1 DUF1295 domain-containing protein [Sphaerochaetaceae bacterium] diamond 147 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
31611452 31611452 PRJNA752572_P_NODE_2176_length_1389_cov_30.794682_g2028_i0 PRJNA752572 2176 1389 30.794682 427.73813298 Pseudomonadati 3379134 Bacteria Bacteria 75.5 3.42e-11   NR MDR2632347.1 166 g2028 i0 27.5 2.16846652267819 189 121 38.2 5 1344 814 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 3012 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32022625 32022625 PRJNA752572_P_NODE_177278_length_200_cov_2.412121_g176771_i0 PRJNA752572 177278 200 2.412121 4.824242 Pseudomonadati 3379134 Bacteria Bacteria 42 0.0336   NR HOT43381.1 2202144 g176771 i0 63 2.445 27 10 40.5 0 87 7 6 32 HOT43381.1 methionine biosynthesis protein MetW [Spirochaetota bacterium] diamond 489 42 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32022628 32022628 PRJNA752572_P_NODE_276378_length_162_cov_1.070866_g275871_i0 PRJNA752572 276378 162 1.070866 1.73480292 Bacteria 2 Bacteria Bacteria 68.6 7.41e-12   NR MDX9957060.1 2053615 g275871 i0 58.8 1.88888888888889 51 21 94.4 0 156 4 130 180 MDX9957060.1 aldo/keto reductase [Spirochaetia bacterium] diamond 306 68.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia 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);;