RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where bioproject = "PRJNA980585" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA980585 · 24 ✖

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
954556 954556 PRJNA980585_P_NODE_22221_length_310_cov_2.957806_g21967_i0 PRJNA980585 22221 310 2.957806 9.1691986 Candidatus Haliotispira prima 3034016 Bacteria Bacteria 54.7 0.008   NTclustered gi|2496317507|gb|CP123443.1| 3034016 g21967 i0 96.875 0.193548387096774 32 1 10 0 68 99 3002081 3002112 Candidatus Haliotispira prima strain SP-2023 chromosome blastn 60 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Candidatus Haliotispira Candidatus Haliotispira prima
3505535 3505535 PRJNA980585_P_NODE_45923_length_249_cov_0.875000_g45669_i0 PRJNA980585 45923 249 0.875 2.17875 Spirochaetota bacterium 2202144 Bacteria Bacteria 132 2.81e-26   NTclustered gi|2621703426|emb|OY760686.1| 2202144 g45669 i0 86.667 34.3333333333333 120 15 48 1 3 122 1138 1256 MAG: Spirochaetota bacterium isolate b615e79e-4617-45ea-95f9-f7a736470f88 genome assembly, chromosome: 1 blastn 8549 132 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
13708268 13708268 PRJNA980585_P_NODE_26611_length_289_cov_1.393519_g26357_i0 PRJNA980585 26611 289 1.393519 4.02726991 Leptospira sp. severe_002 2838237 Bacteria Bacteria 143 1.54e-29   NTclustered gi|2120242214|gb|CP075692.1| 2838237 g26357 i0 90.654 31.9930795847751 107 10 37 0 5 111 451801 451907 Leptospira sp. severe_002 chromosome 1 blastn 9246 143 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. severe_002
20081662 20081662 PRJNA980585_P_NODE_55516_length_244_cov_0.900585_g55262_i0 PRJNA980585 55516 244 0.900585 2.1974274 Pseudomonadati 3379134 Bacteria Bacteria 108 1.07e-25   NR MCL2043231.1 166 g55262 i0 74.2 13.4262295081967 66 17 81.1 0 2 199 237 302 MCL2043231.1 asparagine--tRNA ligase [Treponema sp.] diamond 3276 108 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
21357266 21357266 PRJNA980585_P_NODE_7137_length_486_cov_2.230024_g6883_i0 PRJNA980585 7137 486 2.230024 10.83791664 Pseudomonadati 3379134 Bacteria Bacteria 175 1.33e-49   NR MCB1156179.1 2026757 g6883 i0 66.7 10.8888888888889 126 39 77.8 1 484 107 313 435 MCB1156179.1 adenosylhomocysteinase [Leptospiraceae bacterium] diamond 5292 175 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
22631998 22631998 PRJNA980585_P_NODE_43618_length_250_cov_0.870056_g43364_i0 PRJNA980585 43618 250 0.870056 2.17514 Leptospira cinconiae 3235173 Bacteria Bacteria 457 4.1099999999999985e-124   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g43364 i0 99.6 29.12 250 1 100 0 1 250 3191142 3191391 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 7280 457 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
27658235 27658235 PRJNA980585_P_NODE_40884_length_251_cov_0.865169_g40630_i0 PRJNA980585 40884 251 0.865169 2.17157419 Treponema socranskii 53419 Bacteria Bacteria 127 1.19e-36   NR MFC2387864.1 69713 g40630 i0 100 0.752988047808765 63 0 75.3 0 62 250 1 63 MFC2387864.1 N-acetylmuramoyl-L-alanine amidase [Treponema socranskii subsp. buccale] diamond 189 127 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema socranskii
27696054 27696054 PRJNA980585_P_NODE_18124_length_335_cov_1.874046_g17870_i0 PRJNA980585 18124 335 1.874046 6.2780541 Bacteria 2 Bacteria Bacteria 69.3 2.3e-11   NR MDR2733537.1 2202144 g17870 i0 34.7 2.6955223880597 101 62 90.4 1 333 31 151 247 MDR2733537.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 903 69.7 0.994261119081779 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28194608 28194608 PRJNA980585_P_NODE_57386_length_243_cov_0.905882_g57132_i0 PRJNA980585 57386 243 0.905882 2.20129326 Turneriella sp. 2717305 Bacteria Bacteria 56.2 2.93e-8   NR MFO1472965.1 2717305 g57132 i0 39.1 1.79012345679012 64 39 79 0 12 203 14 77 MFO1472965.1 ribbon-helix-helix domain-containing protein [Turneriella sp.] diamond 435 56.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella sp.
28289357 28289357 PRJNA980585_P_NODE_51946_length_245_cov_1.686047_g51692_i0 PRJNA980585 51946 245 1.686047 4.13081515 Treponema sp. 166 Bacteria Bacteria 43.5 0.0192   NR MCL2180596.1 166 g51692 i0 41 0.477551020408163 39 23 47.8 0 122 6 103 141 MCL2180596.1 glycoside hydrolase family 11 protein [Treponema sp.] diamond 117 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28415940 28415940 PRJNA980585_P_NODE_41006_length_251_cov_0.865169_g40752_i0 PRJNA980585 41006 251 0.865169 2.17157419 Spirochaetota bacterium 2202144 Bacteria Bacteria 81.3 1.13e-15   NR MBP7737437.1 2202144 g40752 i0 59.4 2.45019920318725 64 26 76.5 0 195 4 59 122 MBP7737437.1 neutral/alkaline ceramidase [Spirochaetota bacterium] diamond 615 81.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28485116 28485116 PRJNA980585_P_NODE_53446_length_245_cov_0.895349_g53192_i0 PRJNA980585 53446 245 0.895349 2.19360505 Treponema 157 Bacteria Bacteria 88.2 3.71e-18   NR MDR0600870.1 166 g53192 i0 54.4 2.80408163265306 79 34 96.7 1 244 8 401 477 MDR0600870.1 alpha-glucosidase [Treponema sp.] diamond 687 89 0.991011235955056 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29331422 29331422 PRJNA980585_P_NODE_17689_length_338_cov_1.739623_g17435_i0 PRJNA980585 17689 338 1.739623 5.87992574 Spirochaetota bacterium 2202144 Bacteria Bacteria 82.8 9.11e-16   NR HMB20739.1 2202144 g17435 i0 41.3 3.76331360946746 92 54 81.7 0 3 278 289 380 HMB20739.1 aspartate aminotransferase family protein [Spirochaetota bacterium] diamond 1272 82.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30405722 30405722 PRJNA980585_P_NODE_25553_length_293_cov_1.395455_g25299_i0 PRJNA980585 25553 293 1.395455 4.08868315 Leptospiraceae bacterium 2026757 Bacteria Bacteria 41.2 0.0261   NR MCB1177358.1 2026757 g25299 i0 55.9 0.348122866894198 34 13 32.8 1 182 277 1 34 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 102 41.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30689566 30689566 PRJNA980585_P_NODE_40433_length_251_cov_0.865169_g40179_i0 PRJNA980585 40433 251 0.865169 2.17157419 Gracilinema caldarium 215591 Bacteria Bacteria 159 1.02e-44   NR WP_304241285.1 215591 g40179 i0 96.4 0.99203187250996006 83 3 99.2 0 250 2 24 106 WP_304241285.1 ATP-binding protein [Gracilinema caldarium] diamond 249 159 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Breznakiellaceae Gracilinema Gracilinema caldarium
30942619 30942619 PRJNA980585_P_NODE_43594_length_250_cov_0.870056_g43340_i0 PRJNA980585 43594 250 0.870056 2.17514 Treponema lecithinolyticum 53418 Bacteria Bacteria 45.1 0.00604   NR WP_021686586.1 53418 g43340 i0 87 0.276 23 3 27.6 0 248 180 613 635 WP_021686586.1 AMP-dependent synthetase/ligase [Treponema lecithinolyticum] diamond 69 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema lecithinolyticum
31037542 31037542 PRJNA980585_P_NODE_27115_length_288_cov_0.990698_g26861_i0 PRJNA980585 27115 288 0.990698 2.85321024 Candidatus Treponema equifaecale 3083139 Bacteria Bacteria 68.9 1.54e-11   NR MBQ0050607.1 3083139 g26861 i0 50 1.33333333333333 64 32 66.7 0 284 93 189 252 MBQ0050607.1 CAP domain-containing protein [Candidatus Treponema equifaecale] diamond 384 68.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Candidatus Treponema equifaecale
31543213 31543213 PRJNA980585_P_NODE_28976_length_282_cov_1.607656_g28722_i0 PRJNA980585 28976 282 1.607656 4.53358992 Spirochaetales bacterium 2026792 Bacteria Bacteria 75.5 3.6e-14   NR MDD7201844.1 2026792 g28722 i0 47.1 1.84042553191489 87 46 92.6 0 263 3 28 114 MDD7201844.1 SIMPL domain-containing protein [Spirochaetales bacterium] diamond 519 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31643969 31643969 PRJNA980585_P_NODE_42896_length_250_cov_0.870056_g42642_i0 PRJNA980585 42896 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 42 0.0089   NR MCR4741692.1 166 g42642 i0 53.8 1.5 39 18 46.8 0 121 5 4 42 MCR4741692.1 50S ribosomal protein L30 [Treponema sp.] diamond 375 42 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31954218 31954218 PRJNA980585_P_NODE_12657_length_384_cov_4.167203_g12403_i0 PRJNA980585 12657 384 4.167203 16.00205952 Leptospiraceae bacterium 2026757 Bacteria Bacteria 42.7 0.0249   NR HMV78240.1 2026757 g12403 i0 44.6 0.4375 56 25 43.8 3 179 346 29 78 HMV78240.1 hypothetical protein [Leptospiraceae bacterium] diamond 168 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32302719 32302719 PRJNA980585_P_NODE_32179_length_273_cov_2.495000_g31925_i0 PRJNA980585 32179 273 2.495 6.81135 Spirochaetota bacterium 2202144 Bacteria Bacteria 64.7 1e-9   NR MCX7023747.1 2202144 g31925 i0 39.7 3.34065934065934 73 42 80.2 1 10 228 88 158 MCX7023747.1 5'-nucleotidase C-terminal domain-containing protein [Spirochaetota bacterium] diamond 912 64.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32334340 32334340 PRJNA980585_P_NODE_53399_length_245_cov_0.895349_g53145_i0 PRJNA980585 53399 245 0.895349 2.19360505 Olavius algarvensis spirochete endosymbiont 260710 Bacteria Bacteria 45.1 0.00581   NR WP_124032374.1 260710 g53145 i0 32 0.612244897959184 50 34 61.2 0 245 96 208 257 WP_124032374.1 ROK family protein [Olavius algarvensis spirochete endosymbiont] diamond 150 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Olavius algarvensis spirochete endosymbiont
32712930 32712930 PRJNA980585_P_NODE_23900_length_301_cov_2.206140_g23646_i0 PRJNA980585 23900 301 2.20614 6.6404814 Leptospiraceae bacterium 2026757 Bacteria Bacteria 55.5 1.52e-6   NR MBK7054861.1 2026757 g23646 i0 50 0.538205980066445 54 27 53.8 0 183 22 125 178 MBK7054861.1 hypothetical protein [Leptospiraceae bacterium] diamond 162 55.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32744629 32744629 PRJNA980585_P_NODE_30240_length_279_cov_1.368932_g29986_i0 PRJNA980585 30240 279 1.368932 3.81932028 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 53.9 6.99e-6   NR MDR0524905.1 1898206 g29986 i0 35.3 0.913978494623656 85 55 91.4 0 1 255 285 369 MDR0524905.1 insulinase family protein [Spirochaetaceae bacterium] diamond 255 53.9 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);;