RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA316313 · 31 ✖

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
1661060 1661060 PRJNA316313_P_NODE_174642_length_187_cov_3.913333_g173256_i0 PRJNA316313 174642 187 3.913333 7.31793271 Treponema vincentii 69710 Bacteria Bacteria 141 3.32e-29   NTclustered gi|2265136109|gb|CP051197.1| 69710 g173256 i0 100 2.03208556149733 76 0 81 0 112 187 215418 215343 Treponema vincentii strain OMZ 802 chromosome, complete genome blastn 380 141 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
2938903 2938903 PRJNA316313_P_NODE_493463_length_150_cov_4.044248_g492077_i0 PRJNA316313 493463 150 4.044248 6.066372 Treponema vincentii 69710 Bacteria Bacteria 261 1.86e-65   NTclustered gi|2265136109|gb|CP051197.1| 69710 g492077 i0 98 13.9666666666667 150 3 100 0 1 150 1495509 1495658 Treponema vincentii strain OMZ 802 chromosome, complete genome blastn 2095 261 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
3619116 3619116 PRJNA316313_P_NODE_456003_length_151_cov_3.403509_g454617_i0 PRJNA316313 456003 151 3.403509 5.13929859 Treponema 157 Bacteria Bacteria 145 1.98e-30   NTclustered gi|2265141765|gb|CP051199.1| 2563664 g454617 i0 100 18.2847682119205 78 0 100 0 1 78 2784469 2784546 Treponema sp. OMZ 788 chromosome, complete genome blastn 2761 145 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 788
7446229 7446229 PRJNA316313_P_NODE_407926_length_151_cov_6.271930_g406540_i0 PRJNA316313 407926 151 6.27193 9.4706143 Treponema 157 Bacteria Bacteria 124 2.5699999999999997e-24   NTclustered gi|2265193197|gb|CP058347.1| 158 g406540 i0 96.053 9.05960264900662 76 3 50 0 76 151 2315048 2314973 Treponema denticola strain OKA3 chromosome, complete genome blastn 1368 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
8041538 8041538 PRJNA316313_P_NODE_497487_length_150_cov_3.681416_g496101_i0 PRJNA316313 497487 150 3.681416 5.522124 Treponema denticola 158 Bacteria Bacteria 244 1.88e-60   NTclustered gi|2265193197|gb|CP058347.1| 158 g496101 i0 95.541 27.14 157 0 100 1 1 150 2774549 2774393 Treponema denticola strain OKA3 chromosome, complete genome blastn 4071 244 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
9315623 9315623 PRJNA316313_P_NODE_380128_length_160_cov_4.308943_g378742_i0 PRJNA316313 380128 160 4.308943 6.8943088 Treponema sp. 166 Bacteria Bacteria 81.3 3.21e-16   NR MEL3906793.1 166 g378742 i0 76 0.9375 50 12 93.8 0 11 160 514 563 MEL3906793.1 NAD(+) synthase [Treponema sp.] diamond 150 81.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
9316707 9316707 PRJNA316313_P_NODE_90948_length_212_cov_6.268571_g89562_i0 PRJNA316313 90948 212 6.268571 13.28937052 Treponema medium 58231 Bacteria Bacteria 70.9 3.02e-12   NR WP_206181573.1 58231 g89562 i0 100 0.933962264150943 33 0 46.7 0 211 113 134 166 WP_206181573.1 TonB-dependent receptor plug domain-containing protein [Treponema medium] diamond 198 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
11271772 11271772 PRJNA316313_P_NODE_483609_length_150_cov_5.407080_g482223_i0 PRJNA316313 483609 150 5.40708 8.11062 Treponema 157 Bacteria Bacteria 111 1.99e-20   NTclustered gi|1996291085|gb|CP027017.1| 58231 g482223 i0 93.333 3.15333333333333 75 5 50 0 1 75 2489682 2489756 Treponema medium strain T19 chromosome, complete genome blastn 473 111 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
13139760 13139760 PRJNA316313_P_NODE_116571_length_194_cov_2.980892_g115185_i0 PRJNA316313 116571 194 2.980892 5.78293048 Turneriella parva 29510 Bacteria Bacteria 63.9 7.74e-6   NTclustered gi|390609540|gb|CP002959.1| 869212 g115185 i0 93.023 0.221649484536082 43 3 22 0 16 58 2968284 2968242 Turneriella parva DSM 21527, complete genome blastn 43 63.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
14416715 14416715 PRJNA316313_P_NODE_423392_length_151_cov_4.728070_g422006_i0 PRJNA316313 423392 151 4.72807 7.1393857 Treponema denticola 158 Bacteria Bacteria 76.8 7.31e-10   NTclustered gi|2265166044|gb|CP051303.1| 158 g422006 i0 94 0.33112582781457 50 3 33 0 25 74 399915 399964 Treponema denticola strain OT2B chromosome, complete genome blastn 50 76.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
14416753 14416753 PRJNA316313_P_NODE_430992_length_151_cov_4.315789_g429606_i0 PRJNA316313 430992 151 4.315789 6.51684139 Treponema sp. OMZ 803 120682 Bacteria Bacteria 228 1.9099999999999994e-55   NTclustered gi|2265127813|gb|CP051195.1| 120682 g429606 i0 93.168 9.55629139072848 161 1 100 5 1 151 1502737 1502577 Treponema sp. OMZ 803 strain BF2M chromosome, complete genome blastn 1443 228 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 803
15689505 15689505 PRJNA316313_P_NODE_257813_length_187_cov_2.760000_g256427_i0 PRJNA316313 257813 187 2.76 5.1612 Treponema denticola 158 Bacteria Bacteria 141 3.32e-29   NTclustered gi|2277007739|gb|CP038800.1| 158 g256427 i0 100 1.62566844919786 76 0 81 0 112 187 765562 765487 Treponema denticola strain ATCC 700768 chromosome, complete genome blastn 304 141 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
15690780 15690780 PRJNA316313_P_NODE_463433_length_151_cov_3.236842_g462047_i0 PRJNA316313 463433 151 3.236842 4.88763142 Treponema denticola 158 Bacteria Bacteria 126 7.16e-25   NTclustered gi|2265199313|gb|CP058624.1| 158 g462047 i0 96.104 1.88079470198676 77 3 51 0 75 151 2770023 2770099 Treponema denticola strain OMZ 854 chromosome, complete genome blastn 284 126 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
20193950 20193950 PRJNA316313_P_NODE_292616_length_187_cov_2.480000_g291230_i0 PRJNA316313 292616 187 2.48 4.6376 Treponema 157 Bacteria Bacteria 141 3.32e-29   NTclustered gi|2265136109|gb|CP051197.1| 69710 g291230 i0 100 4.82887700534759 76 0 80 0 1 76 201238 201313 Treponema vincentii strain OMZ 802 chromosome, complete genome blastn 903 141 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
24612318 24612318 PRJNA316313_P_NODE_122840_length_190_cov_3.686275_g121454_i0 PRJNA316313 122840 190 3.686275 7.0039225 Leptospira santarosai 28183 Bacteria Bacteria 62.1 2.71e-5   NTclustered gi|1370526542|gb|CP027843.1| 28183 g121454 i0 88.235 7.99473684210526 51 6 27 0 58 108 2224035 2223985 Leptospira santarosai strain U160 chromosome I blastn 1519 62.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira santarosai
26916286 26916286 PRJNA316313_P_NODE_173442_length_187_cov_3.940000_g172056_i0 PRJNA316313 173442 187 3.94 7.3678 Treponema lecithinolyticum 53418 Bacteria Bacteria 50.8 2.37e-5   NR WP_314744023.1 53418 g172056 i0 31.3 3.68983957219251 115 24 96.3 1 182 3 42 156 WP_314744023.1 beta-N-acetylhexosaminidase, partial [Treponema lecithinolyticum] diamond 690 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema lecithinolyticum
27327438 27327438 PRJNA316313_P_NODE_196103_length_187_cov_3.506667_g194717_i0 PRJNA316313 196103 187 3.506667 6.55746729 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 53.1 2.28e-6   NR MFA7188459.1 2791017 g194717 i0 80.6 1.26737967914438 31 6 49.7 0 95 187 157 187 MFA7188459.1 hypothetical protein [Sphaerochaetaceae bacterium] diamond 237 53.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
27516878 27516878 PRJNA316313_P_NODE_213403_length_187_cov_3.240000_g212017_i0 PRJNA316313 213403 187 3.24 6.0588 Treponema sp. 166 Bacteria Bacteria 55.8 2.85e-7   NR MBR3544349.1 166 g212017 i0 67.7 0.994652406417112 62 20 99.5 0 186 1 94 155 MBR3544349.1 deoxyribose-phosphate aldolase [Treponema sp.] diamond 186 55.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27738213 27738213 PRJNA316313_P_NODE_165444_length_187_cov_4.133333_g164058_i0 PRJNA316313 165444 187 4.133333 7.72933271 Treponema sp. 166 Bacteria Bacteria 46.2 0.00103   NR MFC2602519.1 166 g164058 i0 100 0.401069518716578 25 0 40.1 0 75 1 245 269 MFC2602519.1 hemolysin III family protein [Treponema sp.] diamond 75 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27990630 27990630 PRJNA316313_P_NODE_313565_length_187_cov_2.333333_g312179_i0 PRJNA316313 313565 187 2.333333 4.36333271 Thiospirochaeta perfilievii 252967 Bacteria Bacteria 50.1 4.44e-5   NR WP_149568788.1 252967 g312179 i0 95.8 1.54010695187166 24 1 38.5 0 74 3 46 69 WP_149568788.1 ATP-binding protein [Thiospirochaeta perfilievii] diamond 288 50.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Thiospirochaeta Thiospirochaeta perfilievii
28464211 28464211 PRJNA316313_P_NODE_155906_length_187_cov_4.453333_g154520_i0 PRJNA316313 155906 187 4.453333 8.32773271 Spirochaetota bacterium 2202144 Bacteria Bacteria 50.1 5.79e-6   NR TXG82031.1 2202144 g154520 i0 96.2 0.417112299465241 26 1 41.7 0 187 110 67 92 TXG82031.1 MAG: VRR-NUC domain-containing protein [Spirochaetota bacterium] diamond 78 50.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29379736 29379736 PRJNA316313_P_NODE_263069_length_187_cov_2.680000_g261683_i0 PRJNA316313 263069 187 2.68 5.0116 Treponema vincentii 69710 Bacteria Bacteria 49.7 6.09e-5   NR WP_006188679.1 69710 g261683 i0 95.8 0.385026737967914 24 1 38.5 0 182 111 96 119 WP_006188679.1 hypothetical protein [Treponema vincentii] diamond 72 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
29934099 29934099 PRJNA316313_P_NODE_136211_length_187_cov_5.633333_g134825_i0 PRJNA316313 136211 187 5.633333 10.53433271 Bacteria 2 Bacteria Bacteria 42.4 0.0246   NR WP_147624564.1 158 g134825 i0 68 2.32620320855615 25 8 40.1 0 1 75 440 464 WP_147624564.1 aminoacyl-histidine dipeptidase [Treponema denticola] diamond 435 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
30611541 30611541 PRJNA316313_P_NODE_481553_length_150_cov_5.929204_g480167_i0 PRJNA316313 481553 150 5.929204 8.893806 Treponema sp. 166 Bacteria Bacteria 52 5.55e-6   NR MCR5288699.1 166 g480167 i0 64.5 4.22 31 11 62 0 94 2 91 121 MCR5288699.1 cache domain-containing protein [Treponema sp.] diamond 633 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30818615 30818615 PRJNA316313_P_NODE_420674_length_151_cov_4.894737_g419288_i0 PRJNA316313 420674 151 4.894737 7.39105287 Treponema 157 Bacteria Bacteria 56.2 1.74e-7   NR MBO4858571.1 166 g419288 i0 100 3.05960264900662 25 0 49.7 0 149 75 170 194 MBO4858571.1 N-acetylneuraminate synthase family protein [Treponema sp.] diamond 462 56.6 0.992932862190813 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31450874 31450874 PRJNA316313_P_NODE_397856_length_152_cov_4.739130_g396470_i0 PRJNA316313 397856 152 4.73913 7.2034776 root 1 Root_unresolved Root_unresolved 72 4.91e-13   NR WP_317573642.1 2023197 g396470 i0 69.4 4.85526315789474 49 15 96.7 0 147 1 180 228 WP_317573642.1 hypothetical protein [Leptospira ellisii] diamond 738 72.4 0.994475138121547 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ellisii
31640458 31640458 PRJNA316313_P_NODE_236916_length_187_cov_2.973333_g235530_i0 PRJNA316313 236916 187 2.973333 5.56013271 Bacteria 2 Bacteria Bacteria 42.4 0.0244   NR MBO4279013.1 2026792 g235530 i0 72 1.92513368983957 25 7 40.1 0 76 2 5 29 MBO4279013.1 hypothetical protein [Spirochaetales bacterium] diamond 360 42.7 0.992974238875878 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32256243 32256243 PRJNA316313_P_NODE_175698_length_187_cov_3.893333_g174312_i0 PRJNA316313 175698 187 3.893333 7.28053271 Sphaerochaeta sp. 1972642 Bacteria Bacteria 72.8 4.31e-13   NR MCK9599440.1 1972642 g174312 i0 65.6 0.978609625668449 61 17 97.9 1 185 3 213 269 MCK9599440.1 hypothetical protein [Sphaerochaeta sp.] diamond 183 72.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
32634964 32634964 PRJNA316313_P_NODE_295800_length_187_cov_2.453333_g294414_i0 PRJNA316313 295800 187 2.453333 4.58773271 Treponema lecithinolyticum 53418 Bacteria Bacteria 58.9 3e-8   NR WP_021687945.1 53418 g294414 i0 100 0.401069518716578 25 0 40.1 0 75 1 258 282 WP_021687945.1 ABC transporter permease [Treponema lecithinolyticum] diamond 75 58.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema lecithinolyticum
32792457 32792457 PRJNA316313_P_NODE_419860_length_151_cov_4.964912_g418474_i0 PRJNA316313 419860 151 4.964912 7.49701712 Spirochaetota bacterium 2202144 Bacteria Bacteria 48.9 5.15e-5   NR TXG86432.1 2202144 g418474 i0 84.6 0.516556291390728 26 4 51.7 0 1 78 104 129 TXG86432.1 MAG: hypothetical protein E6R13_00420 [Spirochaetota bacterium] diamond 78 48.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32886901 32886901 PRJNA316313_P_NODE_114900_length_195_cov_3.183544_g113514_i0 PRJNA316313 114900 195 3.183544 6.2079108 Spirochaetota bacterium 2202144 Bacteria Bacteria 78.2 6.24e-15   NR TXG85444.1 2202144 g113514 i0 97.5 0.615384615384615 40 1 61.5 0 75 194 92 131 TXG85444.1 MAG: hypothetical protein E6R13_02115 [Spirochaetota bacterium] diamond 120 78.2 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);;