RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA924320", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 25 ✖

tax_kingdom 1

  • Pseudomonadati · 25 ✖

bioproject 1

  • PRJNA924320 · 25 ✖

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
3450129 3450129 PRJNA924320_S_NODE_4063_length_467_cov_3.502392_g3922_i0 PRJNA924320 4063 467 3.502392 16.35617064 Leptospiraceae bacterium 2026757 Bacteria Bacteria 157 5.189999999999999e-46   NR HNO24933.1 2026757 g3922 i0 77.1 0.674518201284797 105 24 67.5 0 465 151 43 147 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 315 157 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
18751011 18751011 PRJNA924320_S_NODE_6115_length_385_cov_2.648810_g5973_i0 PRJNA924320 6115 385 2.64881 10.1979185 Bacteria 2 Bacteria Bacteria 197 2.47e-62   NR MCC5815248.1 178 g5973 i0 71.7 74.438961038961 127 36 99 0 4 384 1 127 MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 28659 197 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
26834946 26834946 PRJNA924320_S_NODE_47261_length_166_cov_3.264957_g47119_i0 PRJNA924320 47261 166 3.264957 5.41982862 Spirochaetota bacterium 2202144 Bacteria Bacteria 44.7 0.00232   NR MBP7030025.1 2202144 g47119 i0 42.6 1.75301204819277 47 26 84.9 1 165 25 165 210 MBP7030025.1 nucleoside monophosphate kinase [Spirochaetota bacterium] diamond 291 44.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27411477 27411477 PRJNA924320_S_NODE_27323_length_206_cov_1.292994_g27181_i0 PRJNA924320 27323 206 1.292994 2.66356764 Treponema 157 Bacteria Bacteria 55.5 6.6e-7   NR MDR3337440.1 166 g27181 i0 54 2.14077669902913 50 23 72.8 0 35 184 13 62 MDR3337440.1 SDR family oxidoreductase [Treponema sp.] diamond 441 55.8 0.99462365591397806 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27474371 27474371 PRJNA924320_S_NODE_22423_length_222_cov_1.179191_g22281_i0 PRJNA924320 22423 222 1.179191 2.61780402 Bacteria 2 Bacteria Bacteria 81.6 5.45e-16   NR MCQ2585195.1 166 g22281 i0 66.1 10.4324324324324 56 19 75.7 0 170 3 356 411 MCQ2585195.1 ABC transporter ATP-binding protein/permease [Treponema sp.] diamond 2316 81.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27751493 27751493 PRJNA924320_S_NODE_45264_length_168_cov_1.285714_g45122_i0 PRJNA924320 45264 168 1.285714 2.15999952 Leptospirales bacterium 2604146 Bacteria Bacteria 42.4 0.0181   NR MBL8021551.1 2604146 g45122 i0 45.7 1.51785714285714 46 21 82.1 1 151 14 191 232 MBL8021551.1 signal peptide peptidase SppA [Leptospirales bacterium] diamond 255 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales bacterium
27908878 27908878 PRJNA924320_S_NODE_2465_length_589_cov_2.650000_g2332_i0 PRJNA924320 2465 589 2.65 15.6085 Treponema primitia 88058 Bacteria Bacteria 177 5.92e-49   NR WP_010253189.1 88058 g2332 i0 44.4 0.99830220713073 196 108 99.3 1 588 4 346 541 WP_010253189.1 glycoside hydrolase family 13 protein [Treponema primitia] diamond 588 177 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema primitia
28326694 28326694 PRJNA924320_S_NODE_51666_length_164_cov_0.886957_g51524_i0 PRJNA924320 51666 164 0.886957 1.45460948 root 1 Root_unresolved Root_unresolved 49.3 6.24e-5   NR MDR0465364.1 166 g51524 i0 53.1 2.63414634146341 49 22 87.8 1 162 19 276 324 MDR0465364.1 hypothetical protein [Treponema sp.] diamond 432 49.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28509115 28509115 PRJNA924320_S_NODE_40427_length_176_cov_2.433071_g40285_i0 PRJNA924320 40427 176 2.433071 4.28220496 Spirochaetia bacterium 2053615 Bacteria Bacteria 52.4 4.66e-6   NR GHV88706.1 2053615 g40285 i0 44.4 2.82954545454545 54 30 92 0 172 11 188 241 GHV88706.1 lipoprotein [Spirochaetia bacterium] diamond 498 52.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28698695 28698695 PRJNA924320_S_NODE_33507_length_190_cov_3.078014_g33365_i0 PRJNA924320 33507 190 3.078014 5.8482266 Spirochaetota bacterium 2202144 Bacteria Bacteria 64.7 3.21e-10   NR MCX7788561.1 2202144 g33365 i0 52.5 1.92631578947368 61 29 96.3 0 188 6 879 939 MCX7788561.1 NAD-glutamate dehydrogenase [Spirochaetota bacterium] diamond 366 64.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29298429 29298429 PRJNA924320_S_NODE_33329_length_191_cov_1.077465_g33187_i0 PRJNA924320 33329 191 1.077465 2.05795815 Leptospiraceae bacterium 2026757 Bacteria Bacteria 94 1.36e-21   NR MDX1958237.1 2026757 g33187 i0 59 0.958115183246073 61 25 95.8 0 7 189 54 114 MDX1958237.1 4,5-DOPA dioxygenase extradiol [Leptospiraceae bacterium] diamond 183 94 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29652599 29652599 PRJNA924320_S_NODE_310_length_1385_cov_56.295659_g291_i0 PRJNA924320 310 1385 56.295659 779.69487715 Pseudomonadati 3379134 Bacteria Bacteria 75.5 3.39e-11   NR MDR2632347.1 166 g291 i0 27.5 2.17472924187726 189 121 38.3 5 1342 812 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 3012 75.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29874051 29874051 PRJNA924320_S_NODE_54611_length_162_cov_1.353982_g54469_i0 PRJNA924320 54611 162 1.353982 2.19345084 Pseudomonadati 3379134 Bacteria Bacteria 50.8 1.67e-5   NR MCZ8154767.1 178 g54469 i0 66.7 2.18518518518519 36 10 66.7 1 116 9 92 125 MCZ8154767.1 alkaline phosphatase D family protein [Leptospira sp.] diamond 354 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
30182631 30182631 PRJNA924320_S_NODE_3712_length_485_cov_3.068807_g3572_i0 PRJNA924320 3712 485 3.068807 14.88371395 Treponema primitia 88058 Bacteria Bacteria 154 5.59e-41   NR WP_010253189.1 88058 g3572 i0 46.5 2.93814432989691 159 85 98.4 0 480 4 383 541 WP_010253189.1 glycoside hydrolase family 13 protein [Treponema primitia] diamond 1425 154 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema primitia
30656589 30656589 PRJNA924320_S_NODE_593_length_1093_cov_3.808429_g539_i0 PRJNA924320 593 1093 3.808429 41.62612897 Spirochaetia bacterium 2053615 Bacteria Bacteria 45.4 0.0227   NR MCF7941110.1 2053615 g539 i0 54.3 0.0960658737419945 35 16 9.6 0 989 1093 2 36 MCF7941110.1 RNA-binding protein [Spirochaetia bacterium] diamond 105 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30688091 30688091 PRJNA924320_S_NODE_47133_length_167_cov_0.864407_g46991_i0 PRJNA924320 47133 167 0.864407 1.44355969 Leptospiraceae bacterium 2026757 Bacteria Bacteria 43.5 0.00712   NR MCS7206235.1 2026757 g46991 i0 40 0.808383233532934 45 24 80.8 1 141 7 333 374 MCS7206235.1 L-2-hydroxyglutarate oxidase [Leptospiraceae bacterium] diamond 135 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30758678 30758678 PRJNA924320_S_NODE_1294_length_790_cov_5.701754_g1196_i0 PRJNA924320 1294 790 5.701754 45.0438566 Pseudomonadati 3379134 Bacteria Bacteria 77 2.78e-12   NR MBP7584680.1 2202144 g1196 i0 38 2.57848101265823 163 94 61.5 4 78 563 144 300 MBP7584680.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 2037 77 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31288491 31288491 PRJNA924320_S_NODE_24195_length_216_cov_0.898204_g24053_i0 PRJNA924320 24195 216 0.898204 1.94012064 Spirochaetales bacterium 2026792 Bacteria Bacteria 44.7 0.00538   NR MEI8094165.1 2026792 g24053 i0 30.6 1.72222222222222 62 43 86.1 0 5 190 398 459 MEI8094165.1 CTP synthase [Spirochaetales bacterium] diamond 372 44.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31390894 31390894 PRJNA924320_S_NODE_30596_length_197_cov_1.520270_g30454_i0 PRJNA924320 30596 197 1.52027 2.9949319 root 1 Root_unresolved Root_unresolved 47 2.04e-4   NR MBR1723227.1 166 g30454 i0 54.8 7.85786802030457 42 19 64 0 71 196 3 44 MBR1723227.1 RNA-binding protein [Treponema sp.] diamond 1548 47.4 0.991561181434599 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32111139 32111139 PRJNA924320_S_NODE_4418_length_448_cov_2.025063_g4277_i0 PRJNA924320 4418 448 2.025063 9.07228224 Alkalispirochaeta sp. 2024959 Bacteria Bacteria 181 1.98e-54   NR MFA7565770.1 2024959 g4277 i0 70.3 18.9776785714286 118 35 79 0 447 94 81 198 MFA7565770.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Alkalispirochaeta sp.] diamond 8502 181 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Alkalispirochaeta Alkalispirochaeta sp.
32364366 32364366 PRJNA924320_S_NODE_6339_length_379_cov_3.078788_g6197_i0 PRJNA924320 6339 379 3.078788 11.66860652 Spirochaetota bacterium 2202144 Bacteria Bacteria 58.9 3.46e-7   NR MCX7023101.1 2202144 g6197 i0 50.7 1.0844327176781 67 30 53 1 378 178 353 416 MCX7023101.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 411 58.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32617101 32617101 PRJNA924320_S_NODE_53140_length_163_cov_0.921053_g52998_i0 PRJNA924320 53140 163 0.921053 1.50131639 Leptospiraceae bacterium 2026757 Bacteria Bacteria 46.6 3.48e-4   NR MCS7205803.1 2026757 g52998 i0 55 0.736196319018405 40 18 73.6 0 122 3 1 40 MCS7205803.1 peptide deformylase [Leptospiraceae bacterium] diamond 120 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32718783 32718783 PRJNA924320_S_NODE_16420_length_251_cov_1.009901_g16278_i0 PRJNA924320 16420 251 1.009901 2.53485151 Pseudomonadati 3379134 Bacteria Bacteria 99 4e-22   NR MBL8994250.1 2053615 g16278 i0 63 6.2390438247012 73 26 87.3 1 247 29 357 428 MBL8994250.1 glycosyl transferase family 1 [Spirochaetia bacterium] diamond 1566 99 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32743154 32743154 PRJNA924320_S_NODE_18860_length_237_cov_1.462766_g18718_i0 PRJNA924320 18860 237 1.462766 3.46675542 Treponema sp. 166 Bacteria Bacteria 51.6 2.54e-5   NR MDR0718659.1 166 g18718 i0 38.5 2.93670886075949 78 44 97.5 3 236 6 63 137 MDR0718659.1 hypothetical protein [Treponema sp.] diamond 696 51.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32781563 32781563 PRJNA924320_S_NODE_57780_length_161_cov_0.910714_g57638_i0 PRJNA924320 57780 161 0.910714 1.46624954 root 1 Root_unresolved Root_unresolved 42.4 0.0164   NR WP_287282996.1 166 g57638 i0 40.9 3.52173913043478 44 26 82 0 30 161 183 226 WP_287282996.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 567 42.7 0.992974238875878 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);;