RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where bioproject = "PRJNA1028258", 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 · 29 ✖

tax_kingdom 1

  • Pseudomonadati · 29 ✖

bioproject 1

  • PRJNA1028258 · 29 ✖

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
1438884 1438884 PRJNA1028258_P_NODE_173742_length_225_cov_2.730769_g173179_i0 PRJNA1028258 173742 225 2.730769 6.14423025 root 1 Root_unresolved Root_unresolved 113 8.06e-30   NR WP_000585525.1 173 g173179 i0 71.4 13.44 70 20 93.3 0 224 15 91 160 WP_000585525.1 peroxiredoxin, partial [Leptospira interrogans] diamond 3024 114 0.991228070175439 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans
2281569 2281569 PRJNA1028258_P_NODE_87342_length_276_cov_1.227053_g86779_i0 PRJNA1028258 87342 276 1.227053 3.38666628 Leptospira 171 Bacteria Bacteria 62.1 4.22e-5   NTclustered gi|167774246|gb|CP000777.1| 355278 g86779 i0 100 4.1195652173913 33 0 12 0 49 81 2422536 2422504 Leptospira biflexa serovar Patoc strain 'Patoc 1 (Ames)' chromosome I, complete sequence blastn 1137 62.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira biflexa
9093264 9093264 PRJNA1028258_P_NODE_85748_length_278_cov_2.377990_g85185_i0 PRJNA1028258 85748 278 2.37799 6.6108122 Pseudomonadati 3379134 Bacteria Bacteria 63.5 2.63e-9   NR MBS7295491.1 166 g85185 i0 47.4 3.72302158273381 78 38 84.2 1 26 259 289 363 MBS7295491.1 hypothetical protein [Treponema sp.] diamond 1035 63.9 0.993740219092332 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
15467928 15467928 PRJNA1028258_P_NODE_5873_length_997_cov_2.878233_g5540_i0 PRJNA1028258 5873 997 2.878233 28.69598301 Spirochaetota bacterium 2202144 Bacteria Bacteria 365 3.98e-120   NR TAL31806.1 2202144 g5540 i0 57.3 9.11133400200602 314 122 93.6 4 20 952 188 492 TAL31806.1 MAG: glycosidase [Spirochaetota bacterium] diamond 9084 365 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
23116169 23116169 PRJNA1028258_P_NODE_157919_length_229_cov_0.887500_g157356_i0 PRJNA1028258 157919 229 0.8875 2.032375 Spirochaetota bacterium 2202144 Bacteria Bacteria 131 1.42e-36   NR RKY00569.1 2202144 g157356 i0 81.6 15.9301310043668 76 14 99.6 0 2 229 96 171 RKY00569.1 MAG: NADP-dependent isocitrate dehydrogenase, partial [Spirochaetota bacterium] diamond 3648 131 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
26837411 26837411 PRJNA1028258_P_NODE_93301_length_268_cov_1.070352_g92738_i0 PRJNA1028258 93301 268 1.070352 2.86854336 root 1 Root_unresolved Root_unresolved 123 2.6e-33   NR MFA7188478.1 2791017 g92738 i0 67 3.97388059701493 88 29 98.5 0 267 4 13 100 MFA7188478.1 HNH endonuclease [Sphaerochaetaceae bacterium] diamond 1065 123 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
26877141 26877141 PRJNA1028258_P_NODE_45001_length_377_cov_2.305195_g44438_i0 PRJNA1028258 45001 377 2.305195 8.69058515 Leptospiraceae bacterium 2026757 Bacteria Bacteria 77.8 2.9e-16   NR MCB1177358.1 2026757 g44438 i0 53.3 0.477453580901857 60 28 47.7 0 193 372 1 60 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 180 77.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27003181 27003181 PRJNA1028258_P_NODE_100982_length_260_cov_1.256545_g100419_i0 PRJNA1028258 100982 260 1.256545 3.267017 Spirochaetia bacterium 2053615 Bacteria Bacteria 91.7 2.13e-19   NR MBO7430917.1 2053615 g100419 i0 57.9 0.876923076923077 76 32 87.7 0 230 3 336 411 MBO7430917.1 diaminobutyrate--2-oxoglutarate transaminase family protein [Spirochaetia bacterium] diamond 228 91.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27129417 27129417 PRJNA1028258_P_NODE_124142_length_241_cov_1.238372_g123579_i0 PRJNA1028258 124142 241 1.238372 2.98447652 Leptospiraceae bacterium 2026757 Bacteria Bacteria 46.6 1.18e-4   NR MCB1177358.1 2026757 g123579 i0 46.7 0.560165975103734 45 22 53.5 1 144 16 1 45 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 135 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27351399 27351399 PRJNA1028258_P_NODE_158483_length_229_cov_0.887500_g157920_i0 PRJNA1028258 158483 229 0.8875 2.032375 Treponema sp. 166 Bacteria Bacteria 95.9 4.66e-21   NR MCL2319834.1 166 g157920 i0 63 4.75545851528384 73 27 95.6 0 227 9 42 114 MCL2319834.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Treponema sp.] diamond 1089 95.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27375183 27375183 PRJNA1028258_P_NODE_43523_length_384_cov_0.901587_g42960_i0 PRJNA1028258 43523 384 0.901587 3.46209408 Bacteria 2 Bacteria Bacteria 180 3.579999999999999e-54   NR QOS39501.1 744512 g42960 i0 70.1 6.9453125 127 37 99.2 1 382 2 118 243 QOS39501.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Treponema rectale] diamond 2667 180 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema rectale
28645796 28645796 PRJNA1028258_P_NODE_10327_length_783_cov_1.439776_g9863_i0 PRJNA1028258 10327 783 1.439776 11.27344608 Leptospiraceae bacterium 2026757 Bacteria Bacteria 66.6 1.48e-8   NR MCB1188831.1 2026757 g9863 i0 39.5 0.651340996168582 81 49 31 0 4 246 179 259 MCB1188831.1 hypothetical protein [Leptospiraceae bacterium] diamond 510 66.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28709047 28709047 PRJNA1028258_P_NODE_64387_length_319_cov_0.852000_g63824_i0 PRJNA1028258 64387 319 0.852 2.71788 Leptospira iowaensis 3235171 Bacteria Bacteria 48.9 6.17e-4   NR XDD47065.1 3235171 g63824 i0 30.7 0.949843260188088 101 68 93.1 1 300 4 412 512 XDD47065.1 ankyrin repeat domain-containing protein [Leptospira iowaensis] diamond 303 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira iowaensis
29371990 29371990 PRJNA1028258_P_NODE_57309_length_336_cov_1.595506_g56746_i0 PRJNA1028258 57309 336 1.595506 5.36090016 Leptospiraceae bacterium 2026757 Bacteria Bacteria 67 3.17e-12   NR MCB1177358.1 2026757 g56746 i0 49.1 0.473214285714286 53 25 45.5 1 182 334 1 53 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 159 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29403495 29403495 PRJNA1028258_P_NODE_146369_length_232_cov_0.871166_g145806_i0 PRJNA1028258 146369 232 0.871166 2.02110512 Leptospira ellinghausenii 1917822 Bacteria Bacteria 43.1 0.0202   NR WP_108961599.1 1917822 g145806 i0 32.8 0.75 58 38 73.7 1 229 59 107 164 WP_108961599.1 hypothetical protein [Leptospira ellinghausenii] diamond 174 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ellinghausenii
29592559 29592559 PRJNA1028258_P_NODE_86830_length_277_cov_1.024038_g86267_i0 PRJNA1028258 86830 277 1.024038 2.83658526 Spirochaetota bacterium 2202144 Bacteria Bacteria 47.8 9.63e-4   NR HPC40703.1 2202144 g86267 i0 35.7 1.66787003610108 84 49 85.6 2 248 12 463 546 HPC40703.1 DUF2341 domain-containing protein [Spirochaetota bacterium] diamond 462 47.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29813855 29813855 PRJNA1028258_P_NODE_43571_length_383_cov_2.503185_g43008_i0 PRJNA1028258 43571 383 2.503185 9.58719855 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 58.2 2.61e-7   NR OHD18884.1 1802176 g43008 i0 37.3 0.924281984334204 118 64 84.6 2 19 342 14 131 OHD18884.1 MAG: hypothetical protein A2Y38_14560 [Spirochaetes bacterium GWB1_59_5] diamond 354 58.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
30129535 30129535 PRJNA1028258_P_NODE_31992_length_449_cov_1.121053_g31430_i0 PRJNA1028258 31992 449 1.121053 5.03352797 Leptospiraceae bacterium 2026757 Bacteria Bacteria 80.1 1.06e-14   NR MBK8394169.1 2026757 g31430 i0 34.5 3.98886414253898 148 79 90.9 6 36 443 44 185 MBK8394169.1 aldose 1-epimerase [Leptospiraceae bacterium] diamond 1791 80.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30501089 30501089 PRJNA1028258_P_NODE_112113_length_251_cov_0.994505_g111550_i0 PRJNA1028258 112113 251 0.994505 2.49620755 Leptospira 171 Bacteria Bacteria 79 7.54e-15   NR WP_061249615.1 28452 g111550 i0 56.8 6.83665338645418 81 35 96.8 0 5 247 724 804 WP_061249615.1 Ig-like domain-containing protein [Leptospira alstonii] diamond 1716 79 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira alstonii
30627331 30627331 PRJNA1028258_P_NODE_71453_length_304_cov_1.208511_g70890_i0 PRJNA1028258 71453 304 1.208511 3.67387344 Treponema 157 Bacteria Bacteria 63.2 4.81e-9   NR MDR2951739.1 166 g70890 i0 35.4 3.71052631578947 96 58 94.7 1 293 6 354 445 MDR2951739.1 caspase family protein [Treponema sp.] diamond 1128 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30848661 30848661 PRJNA1028258_P_NODE_167674_length_227_cov_0.898734_g167111_i0 PRJNA1028258 167674 227 0.898734 2.04012618 root 1 Root_unresolved Root_unresolved 57.8 1.53e-7   NR MDR1929651.1 166 g167111 i0 43.9 6.31718061674009 66 36 85.9 1 197 3 419 484 MDR1929651.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 1434 57.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30888146 30888146 PRJNA1028258_P_NODE_134834_length_235_cov_0.855422_g134271_i0 PRJNA1028258 134834 235 0.855422 2.0102417 Leptonema illini 183 Bacteria Bacteria 163 4.0199999999999994e-46   NR WP_002773396.1 183 g134271 i0 100 0.995744680851064 78 0 99.6 0 235 2 62 139 WP_002773396.1 TolC family protein [Leptonema illini] diamond 234 163 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
31994890 31994890 PRJNA1028258_P_NODE_143358_length_233_cov_0.865854_g142795_i0 PRJNA1028258 143358 233 0.865854 2.01743982 Leptospiraceae bacterium 2026757 Bacteria Bacteria 41.6 0.0164   NR HNK94126.1 2026757 g142795 i0 68 0.321888412017167 25 8 32.2 0 201 127 1 25 HNK94126.1 hypothetical protein [Leptospiraceae bacterium] diamond 75 41.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32311609 32311609 PRJNA1028258_P_NODE_179419_length_222_cov_2.607843_g178856_i0 PRJNA1028258 179419 222 2.607843 5.78941146 Leptospiraceae bacterium 2026757 Bacteria Bacteria 40.8 0.0181   NR MCX8000324.1 2026757 g178856 i0 63 0.364864864864865 27 10 36.5 0 12 92 11 37 MCX8000324.1 2-isopropylmalate synthase [Leptospiraceae bacterium] diamond 81 40.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32366813 32366813 PRJNA1028258_P_NODE_110519_length_252_cov_1.311475_g109956_i0 PRJNA1028258 110519 252 1.311475 3.304917 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 103 3.44e-24   NR MCH5293978.1 166 g109956 i0 60.5 5.88095238095238 81 31 96.4 1 10 252 131 210 MCH5293978.1 2-hydroxyacid dehydrogenase [Treponema sp.] diamond 1482 103 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32406313 32406313 PRJNA1028258_P_NODE_173259_length_226_cov_0.904459_g172696_i0 PRJNA1028258 173259 226 0.904459 2.04407734 Leptospiraceae bacterium 2026757 Bacteria Bacteria 73.2 5.7e-13   NR MCB1325739.1 2026757 g172696 i0 50 2.00442477876106 76 37 99.6 1 2 226 450 525 MCB1325739.1 adenylate/guanylate cyclase domain-containing protein [Leptospiraceae bacterium] diamond 453 73.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32650717 32650717 PRJNA1028258_P_NODE_165720_length_227_cov_1.626582_g165157_i0 PRJNA1028258 165720 227 1.626582 3.69234114 root 1 Root_unresolved Root_unresolved 43.5 0.00505   NR MDR1025151.1 166 g165157 i0 39.1 4.28193832599119 64 38 84.6 1 220 29 18 80 MDR1025151.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 972 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32753344 32753344 PRJNA1028258_P_NODE_154560_length_230_cov_0.881988_g153997_i0 PRJNA1028258 154560 230 0.881988 2.0285724 Candidatus Gallitreponema excrementavium 2840840 Bacteria Bacteria 64.3 6.67e-10   NR MBO8458233.1 2840840 g153997 i0 60.9 2.98695652173913 46 18 60 0 189 52 224 269 MBO8458233.1 2-hydroxyacid dehydrogenase [Candidatus Gallitreponema excrementavium] diamond 687 64.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales   Candidatus Gallitreponema Candidatus Gallitreponema excrementavium
32784725 32784725 PRJNA1028258_P_NODE_168080_length_227_cov_0.898734_g167517_i0 PRJNA1028258 168080 227 0.898734 2.04012618 Spirochaetota bacterium 2202144 Bacteria Bacteria 67.8 4.39e-11   NR MCX7677802.1 2202144 g167517 i0 49.3 1.87665198237885 71 32 93.8 1 15 227 259 325 MCX7677802.1 asparagine--tRNA ligase [Spirochaetota bacterium] diamond 426 67.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota 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);;