RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 28 ✖

bioproject 1

  • PRJNA752278 · 28 ✖

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
728510 728510 PRJNA752278_P_NODE_97701_length_243_cov_3.047059_g97498_i0 PRJNA752278 97701 243 3.047059 7.40435337 Sphaerochaeta sp. 1972642 Bacteria Bacteria 123 1.71e-30   NR MCI2076420.1 1972642 g97498 i0 100 0.641975308641975 52 0 64.2 0 86 241 395 446 MCI2076420.1 NAD-dependent DNA ligase LigA [Sphaerochaeta sp.] diamond 156 123 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
3279253 3279253 PRJNA752278_P_NODE_65783_length_262_cov_1.730159_g65580_i0 PRJNA752278 65783 262 1.730159 4.53301658 Leptospira cinconiae 3235173 Bacteria Bacteria 128 3.86e-25   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g65580 i0 100 0.263358778625954 69 0 26 0 1 69 2349492 2349560 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 69 128 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
5830440 5830440 PRJNA752278_P_NODE_109045_length_230_cov_4.191083_g108842_i0 PRJNA752278 109045 230 4.191083 9.6394909 Treponema medium 58231 Bacteria Bacteria 331 2.3600000000000002e-86   NTclustered gi|1996291085|gb|CP027017.1| 58231 g108842 i0 92.609 21.2304347826087 230 17 100 0 1 230 1995487 1995716 Treponema medium strain T19 chromosome, complete genome blastn 4883 331 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
17779037 17779037 PRJNA752278_P_NODE_92374_length_245_cov_2.988372_g92171_i0 PRJNA752278 92374 245 2.988372 7.3215114 Spirochaetia bacterium 2053615 Bacteria Bacteria 105 2.49e-26   NR MCI6799526.1 2053615 g92171 i0 70.6 1.71428571428571 68 20 83.3 0 241 38 115 182 MCI6799526.1 AHH domain-containing protein [Spirochaetia bacterium] diamond 420 105 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
18578428 18578428 PRJNA752278_P_NODE_101615_length_242_cov_0.911243_g101412_i0 PRJNA752278 101615 242 0.911243 2.20520806 Treponema pedis 409322 Bacteria Bacteria 388 1.46e-103   NTclustered gi|1928027651|gb|CP061839.1| 409322 g101412 i0 97.368 81.0537190082645 228 6 94 0 15 242 831688 831915 Treponema pedis strain KS1 chromosome, complete genome blastn 19615 388 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
24955069 24955069 PRJNA752278_P_NODE_98440_length_243_cov_1.600000_g98237_i0 PRJNA752278 98440 243 1.6 3.888 Turneriella parva 29510 Bacteria Bacteria 433 6.69e-117   NTclustered gi|390609540|gb|CP002959.1| 869212 g98237 i0 98.765 1 243 3 100 0 1 243 685598 685840 Turneriella parva DSM 21527, complete genome blastn 243 433 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
27147163 27147163 PRJNA752278_P_NODE_24762_length_329_cov_0.902344_g24559_i0 PRJNA752278 24762 329 0.902344 2.96871176 Spirochaetia bacterium 2053615 Bacteria Bacteria 125 1.02e-34   NR MFO7729640.1 2053615 g24559 i0 96.7 0.556231003039514 61 2 55.6 0 2 184 41 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 183 125 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27463737 27463737 PRJNA752278_P_NODE_10963_length_440_cov_1.811989_g10760_i0 PRJNA752278 10963 440 1.811989 7.9727516 Leptospira hartskeerlii 2023177 Bacteria Bacteria 117 1.3e-27   NR WP_100708197.1 2023177 g10760 i0 50 1.425 108 54 73.6 0 48 371 10 117 WP_100708197.1 hypothetical protein [Leptospira hartskeerlii] diamond 627 117 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira hartskeerlii
27811162 27811162 PRJNA752278_P_NODE_68404_length_260_cov_1.171123_g68201_i0 PRJNA752278 68404 260 1.171123 3.0449198 Leptospiraceae bacterium 2026757 Bacteria Bacteria 62.4 5.42e-9   NR MBK8397375.1 2026757 g68201 i0 47.4 0.657692307692308 57 30 65.8 0 250 80 381 437 MBK8397375.1 adenylate/guanylate cyclase domain-containing protein [Leptospiraceae bacterium] diamond 171 62.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28073351 28073351 PRJNA752278_P_NODE_23505_length_335_cov_1.977099_g23302_i0 PRJNA752278 23505 335 1.977099 6.62328165 Pseudomonadati 3379134 Bacteria Bacteria 45.4 0.0105   NR MBR5966588.1 166 g23302 i0 56.4 0.752238805970149 39 17 34.9 0 2 118 106 144 MBR5966588.1 sel1 repeat family protein [Treponema sp.] diamond 252 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28442554 28442554 PRJNA752278_P_NODE_14166_length_401_cov_1.673780_g13963_i0 PRJNA752278 14166 401 1.67378 6.7118578 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 86.7 8.82e-17   NR OHD26699.1 1802176 g13963 i0 56.5 0.516209476309227 69 30 51.6 0 4 210 140 208 OHD26699.1 MAG: hypothetical protein A2Y38_19225 [Spirochaetes bacterium GWB1_59_5] diamond 207 86.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
28695197 28695197 PRJNA752278_P_NODE_40947_length_286_cov_1.276995_g40744_i0 PRJNA752278 40947 286 1.276995 3.6522057 Sphaerochaeta sp. 1972642 Bacteria Bacteria 182 3.0299999999999997e-56   NR MCH3907410.1 1972642 g40744 i0 98.9 0.975524475524476 93 1 97.6 0 3 281 91 183 MCH3907410.1 YggT family protein [Sphaerochaeta sp.] diamond 279 182 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
28726584 28726584 PRJNA752278_P_NODE_30207_length_310_cov_1.670886_g30004_i0 PRJNA752278 30207 310 1.670886 5.1797466 Leptospiraceae bacterium 2026757 Bacteria Bacteria 50.4 1.41e-4   NR HMV77946.1 2026757 g30004 i0 60.6 0.319354838709677 33 13 31.9 0 269 171 289 321 HMV77946.1 zinc-binding dehydrogenase [Leptospiraceae bacterium] diamond 99 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28989336 28989336 PRJNA752278_P_NODE_13668_length_406_cov_1.642643_g13465_i0 PRJNA752278 13668 406 1.642643 6.66913058 Pseudomonadati 3379134 Bacteria Bacteria 76.6 1.45e-13   NR NCN10516.1 178 g13465 i0 38.1 3.14778325123153 118 56 87.2 3 355 2 126 226 NCN10516.1 diacylglycerol kinase family lipid kinase [Leptospira sp.] diamond 1278 76.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
29074101 29074101 PRJNA752278_P_NODE_64228_length_264_cov_1.209424_g64025_i0 PRJNA752278 64228 264 1.209424 3.19287936 Leptospira licerasiae 447106 Bacteria Bacteria 81.6 8.7e-16   NR WP_008591672.1 447106 g64025 i0 61.3 3.01136363636364 62 24 70.5 0 206 21 236 297 WP_008591672.1 cytochrome P450 [Leptospira licerasiae] diamond 795 81.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira licerasiae
29263137 29263137 PRJNA752278_P_NODE_53769_length_273_cov_2.965000_g53566_i0 PRJNA752278 53769 273 2.965 8.09445 Spirochaetia bacterium 2053615 Bacteria Bacteria 122 1.97e-33   NR HRV29575.1 2053615 g53566 i0 86.2 0.714285714285714 65 9 71.4 0 79 273 1 65 HRV29575.1 hypothetical protein [Spirochaetia bacterium] diamond 195 122 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29484123 29484123 PRJNA752278_P_NODE_62130_length_266_cov_1.212435_g61927_i0 PRJNA752278 62130 266 1.212435 3.2250771 Spirochaetales bacterium 2026792 Bacteria Bacteria 75.1 2.09e-14   NR MCK5672650.1 2026792 g61927 i0 46.8 0.868421052631579 77 41 86.8 0 35 265 1 77 MCK5672650.1 CDP-alcohol phosphatidyltransferase family protein [Spirochaetales bacterium] diamond 231 75.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30021405 30021405 PRJNA752278_P_NODE_7731_length_499_cov_2.326291_g7528_i0 PRJNA752278 7731 499 2.326291 11.60819209 uncultured Brachyspira sp. 221953 Bacteria Bacteria 43.1 0.0201   NR WP_297298998.1 221953 g7528 i0 60 0.37875751503006 30 12 18 0 480 391 19 48 WP_297298998.1 ankyrin repeat domain-containing protein [uncultured Brachyspira sp.] diamond 189 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
30432327 30432327 PRJNA752278_P_NODE_10133_length_453_cov_1.418421_g9930_i0 PRJNA752278 10133 453 1.418421 6.42544713 Spirochaetales bacterium 2026792 Bacteria Bacteria 43.1 0.029   NR MCK5154307.1 2026792 g9930 i0 39.4 0.437086092715232 66 37 42.4 2 234 43 22 86 MCK5154307.1 nucleotidyltransferase domain-containing protein [Spirochaetales bacterium] diamond 198 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30567966 30567966 PRJNA752278_P_NODE_65353_length_262_cov_3.571429_g65150_i0 PRJNA752278 65353 262 3.571429 9.35714398 Leptospira 171 Bacteria Bacteria 50.4 8.48e-5   NR WP_198014290.1 409998 g65150 i0 38.4 4.88931297709924 86 48 95 3 254 6 74 157 WP_198014290.1 Kelch repeat-containing protein [Leptospira wolffii] diamond 1281 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira wolffii
30589840 30589840 PRJNA752278_P_NODE_3673_length_652_cov_3.352332_g3476_i0 PRJNA752278 3673 652 3.352332 21.85720464 uncultured Brachyspira sp. 221953 Bacteria Bacteria 43.1 0.036   NR WP_297298998.1 221953 g3476 i0 60 0.138036809815951 30 12 13.8 0 633 544 19 48 WP_297298998.1 ankyrin repeat domain-containing protein [uncultured Brachyspira sp.] diamond 90 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira uncultured Brachyspira sp.
31064125 31064125 PRJNA752278_P_NODE_73595_length_254_cov_4.248619_g73392_i0 PRJNA752278 73595 254 4.248619 10.79149226 Spirochaetia bacterium 2053615 Bacteria Bacteria 129 1.12e-32   NR MCI5608630.1 2053615 g73392 i0 98.5 0.767716535433071 65 1 76.8 0 2 196 575 639 MCI5608630.1 AMP-binding protein [Spirochaetia bacterium] diamond 195 129 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31443212 31443212 PRJNA752278_P_NODE_107636_length_235_cov_2.259259_g107433_i0 PRJNA752278 107636 235 2.259259 5.30925865 Sphaerochaeta sp. 1972642 Bacteria Bacteria 102 6.67e-27   NR MCH3906890.1 1972642 g107433 i0 100 0.663829787234043 52 0 66.4 0 2 157 10 61 MCH3906890.1 hypothetical protein [Sphaerochaeta sp.] diamond 156 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
31443239 31443239 PRJNA752278_P_NODE_43956_length_283_cov_1.309524_g43753_i0 PRJNA752278 43956 283 1.309524 3.70595292 uncultured Sphaerochaeta sp. 886478 Bacteria Bacteria 152 5.01e-41   NR WP_319756230.1 886478 g43753 i0 83.9 2.95759717314488 93 15 98.6 0 1 279 175 267 WP_319756230.1 putative bifunctional diguanylate cyclase/phosphodiesterase [uncultured Sphaerochaeta sp.] diamond 837 152 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta uncultured Sphaerochaeta sp.
31917743 31917743 PRJNA752278_P_NODE_62637_length_265_cov_1.885417_g62434_i0 PRJNA752278 62637 265 1.885417 4.99635505 Spirochaetia bacterium 2053615 Bacteria Bacteria 80.9 1.67e-15   NR MCE9600158.1 2053615 g62434 i0 44.7 0.962264150943396 85 44 95.1 2 265 14 298 380 MCE9600158.1 flavin monoamine oxidase family protein [Spirochaetia bacterium] diamond 255 80.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32139309 32139309 PRJNA752278_P_NODE_96258_length_244_cov_0.900585_g96055_i0 PRJNA752278 96258 244 0.900585 2.1974274 Spirochaetota bacterium 2202144 Bacteria Bacteria 45.4 2.86e-4   NR RKX91173.1 2202144 g96055 i0 72 0.307377049180328 25 6 30.7 1 64 138 19 42 RKX91173.1 MAG: RsmB/NOP family class I SAM-dependent RNA methyltransferase, partial [Spirochaetota bacterium] diamond 75 45.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32171126 32171126 PRJNA752278_P_NODE_85698_length_248_cov_0.880000_g85495_i0 PRJNA752278 85698 248 0.88 2.1824 Leptospira meyeri 29508 Bacteria Bacteria 44.7 0.00828   NR WP_020777638.1 29508 g85495 i0 63.6 0.399193548387097 33 12 39.9 0 244 146 480 512 WP_020777638.1 tetratricopeptide repeat protein [Leptospira meyeri] diamond 99 44.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira meyeri
32802445 32802445 PRJNA752278_P_NODE_54440_length_273_cov_1.385000_g54237_i0 PRJNA752278 54440 273 1.385 3.78105 Sphaerochaeta sp. 1972642 Bacteria Bacteria 103 1.56e-23   NR MCH3907693.1 1972642 g54237 i0 96.1 0.56043956043956 51 2 56 0 271 119 546 596 MCH3907693.1 alpha-xylosidase [Sphaerochaeta sp.] diamond 153 103 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta 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);;