RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where bioproject = "PRJNA594101" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA594101 · 31 ✖

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
27332825 27332825 PRJNA594101_S_NODE_5443_length_696_cov_4.197432_g5159_i0 PRJNA594101 5443 696 4.197432 29.21412672 Leptospira sp. 178 Bacteria Bacteria 74.7 6.12e-12   NR MCZ8343166.1 178 g5159 i0 36 0.478448275862069 111 70 47.8 1 559 227 59 168 MCZ8343166.1 SDR family NAD(P)-dependent oxidoreductase [Leptospira sp.] diamond 333 74.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
27522048 27522048 PRJNA594101_S_NODE_42183_length_268_cov_1.912821_g41881_i0 PRJNA594101 42183 268 1.912821 5.12636028 Leptospira ryugenii 1917863 Bacteria Bacteria 45.8 0.00424   NR WP_108977735.1 1917863 g41881 i0 27 0.996268656716418 89 62 98.5 2 5 268 88 174 WP_108977735.1 aminopeptidase N [Leptospira ryugenii] diamond 267 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ryugenii
27616998 27616998 PRJNA594101_S_NODE_8524_length_560_cov_3.160164_g8224_i0 PRJNA594101 8524 560 3.160164 17.6969184 Treponema primitia 88058 Bacteria Bacteria 151 2.69e-39   NR WP_010253189.1 88058 g8224 i0 46.4 0.9 168 82 87.3 2 558 70 389 553 WP_010253189.1 glycoside hydrolase family 13 protein [Treponema primitia] diamond 504 151 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema primitia
28437893 28437893 PRJNA594101_S_NODE_31966_length_304_cov_1.372294_g31664_i0 PRJNA594101 31966 304 1.372294 4.17177376 Leptospira sp. 178 Bacteria Bacteria 136 1.63e-38   NR MCU0824711.1 178 g31664 i0 72.7 0.868421052631579 88 24 86.8 0 293 30 73 160 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 264 136 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
28532654 28532654 PRJNA594101_S_NODE_21687_length_361_cov_1.222222_g21385_i0 PRJNA594101 21687 361 1.222222 4.41222142 Spirochaetota bacterium 2202144 Bacteria Bacteria 45.4 0.0164   NR MDH5680244.1 2202144 g21385 i0 35.1 0.806094182825485 97 57 79.8 2 11 298 355 446 MDH5680244.1 ATP-binding protein [Spirochaetota bacterium] diamond 291 45.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28546172 28546172 PRJNA594101_S_NODE_59187_length_221_cov_4.641892_g58885_i0 PRJNA594101 59187 221 4.641892 10.25858132 Treponema 157 Bacteria Bacteria 55.1 1.1e-6   NR MDR3337440.1 166 g58885 i0 54 1.99547511312217 50 23 67.9 0 54 203 13 62 MDR3337440.1 SDR family oxidoreductase [Treponema sp.] diamond 441 55.5 0.992792792792793 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28564111 28564111 PRJNA594101_S_NODE_27207_length_326_cov_1.217391_g26905_i0 PRJNA594101 27207 326 1.217391 3.96869466 Spirochaetales bacterium 2026792 Bacteria Bacteria 61.6 9.54e-9   NR MBP5448574.1 2026792 g26905 i0 39.6 3.38650306748466 91 47 83.7 3 7 279 135 217 MBP5448574.1 CAP domain-containing protein [Spirochaetales bacterium] diamond 1104 61.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28595852 28595852 PRJNA594101_S_NODE_56687_length_242_cov_0.911243_g56385_i0 PRJNA594101 56687 242 0.911243 2.20520806 Spirochaetales bacterium 2026792 Bacteria Bacteria 51.6 2.64e-5   NR MBO4387876.1 2026792 g56385 i0 37.2 2.60330578512397 78 46 94.2 3 240 13 135 211 MBO4387876.1 poly(A) polymerase [Spirochaetales bacterium] diamond 630 51.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28816393 28816393 PRJNA594101_S_NODE_428_length_1891_cov_2.294279_g354_i0 PRJNA594101 428 1891 2.294279 43.38481589 Leptospiraceae bacterium 2026757 Bacteria Bacteria 49.7 0.0306   NR HMY67815.1 2026757 g354 i0 30.1 0.42199894235854 133 78 20.5 5 89 475 34 155 HMY67815.1 C2 family cysteine protease [Leptospiraceae bacterium] diamond 798 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29164216 29164216 PRJNA594101_S_NODE_41889_length_269_cov_1.571429_g41587_i0 PRJNA594101 41889 269 1.571429 4.22714401 Leptospiraceae bacterium 2026757 Bacteria Bacteria 46.6 0.00212   NR MBL0264784.1 2026757 g41587 i0 43.1 0.568773234200744 51 26 56.9 1 233 81 121 168 MBL0264784.1 hypothetical protein [Leptospiraceae bacterium] diamond 153 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29605657 29605657 PRJNA594101_S_NODE_38510_length_280_cov_1.275362_g38208_i0 PRJNA594101 38510 280 1.275362 3.5710136 Spirochaetales bacterium 2026792 Bacteria Bacteria 47.4 0.0014   NR MDD6957037.1 2026792 g38208 i0 70.8 0.257142857142857 24 7 25.7 0 150 79 189 212 MDD6957037.1 methionine--tRNA ligase [Spirochaetales bacterium] diamond 72 47.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29890398 29890398 PRJNA594101_S_NODE_52591_length_246_cov_2.670520_g52289_i0 PRJNA594101 52591 246 2.67052 6.5694792 Spirochaetales bacterium 2026792 Bacteria Bacteria 84.7 2.46e-17   NR MCF7929180.1 2026792 g52289 i0 50.6 0.98780487804878 81 40 98.8 0 3 245 242 322 MCF7929180.1 ADP-ribosylglycohydrolase family protein [Spirochaetales bacterium] diamond 243 84.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29935360 29935360 PRJNA594101_S_NODE_24191_length_343_cov_3.251852_g23889_i0 PRJNA594101 24191 343 3.251852 11.15385236 root 1 Root_unresolved Root_unresolved 78.6 1.01e-15   NR MDR1239190.1 166 g23889 i0 57.1 10.4868804664723 70 29 61.2 1 2 211 82 150 MDR1239190.1 phosphoglycerate kinase [Treponema sp.] diamond 3597 79.3 0.991172761664565 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30016687 30016687 PRJNA594101_S_NODE_4431_length_765_cov_15.381503_g4159_i0 PRJNA594101 4431 765 15.381503 117.66849795 Treponema sp. 166 Bacteria Bacteria 67.8 2.51e-9   NR MEE0352004.1 166 g4159 i0 36.7 1.23921568627451 158 90 62 6 696 223 91 238 MEE0352004.1 CAP domain-containing protein [Treponema sp.] diamond 948 67.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30047967 30047967 PRJNA594101_S_NODE_38031_length_281_cov_2.778846_g37729_i0 PRJNA594101 38031 281 2.778846 7.80855726 Leptospira sp. 178 Bacteria Bacteria 99.4 4.37e-24   NR MCU0824711.1 178 g37729 i0 64.6 0.875444839857651 82 29 87.5 0 34 279 1 82 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 246 99.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
30047976 30047976 PRJNA594101_S_NODE_44351_length_262_cov_1.629630_g44049_i0 PRJNA594101 44351 262 1.62963 4.2696306 Treponema sp. 166 Bacteria Bacteria 43.5 0.0244   NR MDR1985513.1 166 g44049 i0 41.4 0.66412213740458 58 29 66.4 1 38 211 91 143 MDR1985513.1 DEAD/DEAH box helicase [Treponema sp.] diamond 174 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30079577 30079577 PRJNA594101_S_NODE_2432_length_1004_cov_8.207304_g2230_i0 PRJNA594101 2432 1004 8.207304 82.40133216 Leptospiraceae bacterium 2026757 Bacteria Bacteria 63.5 2.91e-7   NR MCB1190498.1 2026757 g2230 i0 33.5 0.49003984063745 164 101 48.7 6 501 13 147 303 MCB1190498.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 492 63.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30364550 30364550 PRJNA594101_S_NODE_4112_length_793_cov_25.525000_g3846_i0 PRJNA594101 4112 793 25.525 202.41325 Leptospiraceae bacterium 2026757 Bacteria Bacteria 63.2 1.88e-7   NR MCB1190498.1 2026757 g3846 i0 32.9 1.23329129886507 164 102 61.7 6 49 537 147 303 MCB1190498.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 978 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31090821 31090821 PRJNA594101_S_NODE_3975_length_803_cov_19.910959_g3713_i0 PRJNA594101 3975 803 19.910959 159.88500077 Treponema sp. 166 Bacteria Bacteria 67 5.59e-9   NR MEE0352004.1 166 g3713 i0 36.7 1.18057285180573 158 90 59 6 734 261 91 238 MEE0352004.1 CAP domain-containing protein [Treponema sp.] diamond 948 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31357259 31357259 PRJNA594101_S_NODE_47796_length_253_cov_1.583333_g47494_i0 PRJNA594101 47796 253 1.583333 4.00583249 Pseudomonadati 3379134 Bacteria Bacteria 60.1 3.19e-8   NR MCX7809977.1 2026757 g47494 i0 40.7 3.17786561264822 54 32 64 0 236 75 353 406 MCX7809977.1 alpha-glucosidase [Leptospiraceae bacterium] diamond 804 60.5 0.993388429752066 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31547094 31547094 PRJNA594101_S_NODE_1056_length_1392_cov_63.699014_g939_i0 PRJNA594101 1056 1392 63.699014 886.69027488 Pseudomonadati 3379134 Bacteria Bacteria 75.5 3.43e-11   NR MDR2632347.1 166 g939 i0 27.5 1.68318965517241 189 121 38.1 5 34 564 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 2343 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31610232 31610232 PRJNA594101_S_NODE_30776_length_309_cov_1.305085_g30474_i0 PRJNA594101 30776 309 1.305085 4.03271265 Pseudomonadati 3379134 Bacteria Bacteria 43.5 0.0402   NR MBQ8211753.1 166 g30474 i0 36.5 1.59223300970874 63 35 56.3 2 288 115 175 237 MBQ8211753.1 hypothetical protein [Treponema sp.] diamond 492 43.9 0.990888382687927 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31754815 31754815 PRJNA594101_S_NODE_15657_length_419_cov_7.901734_g15355_i0 PRJNA594101 15657 419 7.901734 33.10826546 Leptospiraceae bacterium 2026757 Bacteria Bacteria 98.6 3.03e-24   NR MCB1177358.1 2026757 g15355 i0 70 0.429594272076372 60 18 43 0 215 36 1 60 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 180 98.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31768277 31768277 PRJNA594101_S_NODE_6697_length_630_cov_3.093357_g6401_i0 PRJNA594101 6697 630 3.093357 19.4881491 root 1 Root_unresolved Root_unresolved 48.1 0.0125   NR MBS7261707.1 166 g6401 i0 41.3 4.14761904761905 80 40 38.1 3 556 317 287 359 MBS7261707.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 2613 48.5 0.991752577319588 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31831387 31831387 PRJNA594101_S_NODE_40197_length_274_cov_1.965174_g39895_i0 PRJNA594101 40197 274 1.965174 5.38457676 Leptospira 171 Bacteria Bacteria 119 6.61e-29   NR MCZ8344247.1 178 g39895 i0 64.2 10.6423357664234 81 29 88.7 0 273 31 382 462 MCZ8344247.1 2-oxoglutarate dehydrogenase E1 component [Leptospira sp.] diamond 2916 120 0.991666666666667 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
31849762 31849762 PRJNA594101_S_NODE_6337_length_648_cov_1.859130_g6045_i0 PRJNA594101 6337 648 1.85913 12.0471624 Treponema pedis 409322 Bacteria Bacteria 97.1 1.87e-19   NR WP_024467250.1 409322 g6045 i0 31.8 0.976851851851852 211 136 96.3 3 640 17 64 269 WP_024467250.1 aldehyde dehydrogenase [Treponema pedis] diamond 633 97.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
31989674 31989674 PRJNA594101_S_NODE_11798_length_479_cov_8.891626_g11496_i0 PRJNA594101 11798 479 8.891626 42.59088854 Bacteria 2 Bacteria Bacteria 73.6 2.31e-13   NR WP_041395600.1 273376 g11496 i0 69.2 1.3027139874739 52 16 32.6 0 219 374 73 124 WP_041395600.1 RidA family protein [Parasphaerochaeta coccoides] diamond 624 74.3 0.990578734858681 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Parasphaerochaeta Parasphaerochaeta coccoides
32008058 32008058 PRJNA594101_S_NODE_47458_length_254_cov_1.276243_g47156_i0 PRJNA594101 47458 254 1.276243 3.24165722 Leptospira sp. 96542 3034711 Bacteria Bacteria 45.4 0.00493   NR MDF3818946.1 3034711 g47156 i0 37.7 0.909448818897638 77 45 90.9 1 242 12 1172 1245 MDF3818946.1 AAA family ATPase [Leptospira sp. 96542] diamond 231 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. 96542
32179796 32179796 PRJNA594101_S_NODE_55158_length_243_cov_3.094118_g54856_i0 PRJNA594101 55158 243 3.094118 7.51870674 Treponema 157 Bacteria Bacteria 62.8 1.68e-9   NR MBR4599524.1 166 g54856 i0 51.9 4 54 26 66.7 0 240 79 191 244 MBR4599524.1 CAP domain-containing protein [Treponema sp.] diamond 972 63.2 0.993670886075949 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32324710 32324710 PRJNA594101_S_NODE_15399_length_422_cov_26.859599_g15097_i0 PRJNA594101 15399 422 26.859599 113.34750778 Leptospiraceae bacterium 2026757 Bacteria Bacteria 78.2 3.33e-16   NR MCB1177358.1 2026757 g15097 i0 53.3 0.42654028436019 60 28 42.7 0 217 38 1 60 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 180 78.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32577647 32577647 PRJNA594101_S_NODE_58079_length_237_cov_2.475610_g57777_i0 PRJNA594101 58079 237 2.47561 5.8671957 Treponema sp. 166 Bacteria Bacteria 57.8 1.07e-7   NR MBQ9205232.1 166 g57777 i0 43.3 0.848101265822785 67 38 84.8 0 12 212 107 173 MBQ9205232.1 CAP domain-containing protein [Treponema sp.] diamond 201 57.8 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);;