RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 35 ✖

bioproject 1

  • PRJNA743294 · 35 ✖

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
1198350 1198350 PRJNA743294_P_NODE_53801_length_245_cov_0.906977_g53345_i0 PRJNA743294 53801 245 0.906977 2.22209365 Bacteria 2 Bacteria Bacteria 139 1.46e-36   NR MCY7374192.1 1898206 g53345 i0 77.5 2.93877551020408 80 18 98 0 244 5 84 163 MCY7374192.1 aminotransferase class V-fold PLP-dependent enzyme [Spirochaetaceae bacterium] diamond 720 139 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
7100569 7100569 PRJNA743294_P_NODE_10606_length_486_cov_3.392252_g10150_i0 PRJNA743294 10606 486 3.392252 16.48634472 Sphaerochaeta sp. 1972642 Bacteria Bacteria 104 5.67e-25   NR HAN42901.1 1972642 g10150 i0 50 3.48148148148148 110 55 67.9 0 385 56 49 158 HAN42901.1 adenine phosphoribosyltransferase [Sphaerochaeta sp.] diamond 1692 104 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
12677894 12677894 PRJNA743294_P_NODE_11450_length_469_cov_2.290404_g10994_i0 PRJNA743294 11450 469 2.290404 10.74199476 Borreliella 64895 Bacteria Bacteria 52.8 0.046   NTclustered gi|2537428790|gb|CP124054.1| 373540 g10994 i0 100 0.238805970149254 28 0 6 0 369 396 770587 770614 Borreliella lanei strain CA-28-91 chromosome, complete genome blastn 112 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella lanei
13475853 13475853 PRJNA743294_P_NODE_26931_length_318_cov_4.106122_g26475_i0 PRJNA743294 26931 318 4.106122 13.05746796 Spirochaetia bacterium 2053615 Bacteria Bacteria 250 9.85e-62   NTclustered gi|2891482181|emb|OZ219914.1| 2053615 g26475 i0 86.266 123.122641509434 233 29 73 3 88 318 854128 854359 MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2 blastn 39153 250 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
23675151 23675151 PRJNA743294_P_NODE_48339_length_250_cov_6.745763_g47883_i0 PRJNA743294 48339 250 6.745763 16.8644075 Spirochaetia bacterium 2053615 Bacteria Bacteria 313 9.41e-81   NTclustered gi|2891482181|emb|OZ219914.1| 2053615 g47883 i0 91.667 118.256 228 16 91 2 23 250 856088 856312 MAG: Spirochaetia bacterium isolate 65460407-d738-4661-97af-02a88c6845d9 genome assembly, chromosome: 2 blastn 29564 313 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26735652 26735652 PRJNA743294_P_NODE_101_length_2700_cov_7.031214_g71_i0 PRJNA743294 101 2700 7.031214 189.842778 Spirochaetia bacterium 2053615 Bacteria Bacteria 82.8 7.39e-12   NR MDH5716307.1 2053615 g71 i0 29 0.584444444444444 238 130 25.4 8 640 1326 160 367 MDH5716307.1 DUF4215 domain-containing protein [Spirochaetia bacterium] diamond 1578 82.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26809580 26809580 PRJNA743294_P_NODE_56481_length_242_cov_0.923077_g56025_i0 PRJNA743294 56481 242 0.923077 2.23384634 Pseudomonadati 3379134 Bacteria Bacteria 57.8 1.56e-7   NR MCR5495058.1 166 g56025 i0 42.5 7.53719008264463 80 44 96.7 1 241 8 198 277 MCR5495058.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 1824 58.2 0.993127147766323 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27084313 27084313 PRJNA743294_P_NODE_50022_length_249_cov_0.886364_g49566_i0 PRJNA743294 50022 249 0.886364 2.20704636 Leptospirales bacterium 2604146 Bacteria Bacteria 45.4 0.00389   NR MES0490213.1 2604146 g49566 i0 37.7 1.81927710843373 77 48 92.8 0 6 236 103 179 MES0490213.1 precorrin-4 C(11)-methyltransferase [Leptospirales bacterium] diamond 453 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales bacterium
27463615 27463615 PRJNA743294_P_NODE_54483_length_244_cov_0.912281_g54027_i0 PRJNA743294 54483 244 0.912281 2.22596564 Brevinematales bacterium 2614249 Bacteria Bacteria 48.9 1.15e-4   NR MCX8028506.1 2614249 g54027 i0 37.7 2.52049180327869 61 38 75 0 183 1 93 153 MCX8028506.1 ankyrin repeat domain-containing protein [Brevinematales bacterium] diamond 615 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brevinematales     Brevinematales bacterium
27557904 27557904 PRJNA743294_P_NODE_17124_length_389_cov_4.363924_g16668_i0 PRJNA743294 17124 389 4.363924 16.97566436 Leptospiraceae bacterium 2026757 Bacteria Bacteria 80.1 4.09e-17   NR MCB1177358.1 2026757 g16668 i0 59.3 0.455012853470437 59 24 45.5 0 178 2 1 59 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 177 80.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27599957 27599957 PRJNA743294_P_NODE_39064_length_271_cov_2.828283_g38608_i0 PRJNA743294 39064 271 2.828283 7.66464693 FCB group 1783270 Bacteria Bacteria 51.2 5.18e-5   NR WP_014455849.1 46355 g38608 i0 31.8 5.57933579335793 88 53 93 3 258 7 173 257 WP_014455849.1 NADH:ubiquinone reductase (Na(+)-transporting) subunit F [Spirochaeta africana] diamond 1512 51.6 0.992248062015504 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta africana
27747777 27747777 PRJNA743294_P_NODE_19424_length_368_cov_1.311864_g18968_i0 PRJNA743294 19424 368 1.311864 4.82765952 Borrelia 138 Bacteria Bacteria 43.9 0.0471   NR WP_151552283.1 138 g18968 i0 28.6 0.970108695652174 119 66 85.6 4 27 341 118 231 WP_151552283.1 MULTISPECIES: TlyA family RNA methyltransferase [Borrelia] diamond 357 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia  
27883915 27883915 PRJNA743294_P_NODE_38605_length_273_cov_1.370000_g38149_i0 PRJNA743294 38605 273 1.37 3.7401 root 1 Root_unresolved Root_unresolved 105 2.77e-26   NR HAK45505.1 28185 g38149 i0 56 8.04395604395604 91 37 97.8 2 267 1 11 100 HAK45505.1 phosphoribosyltransferase [Spirochaeta sp.] diamond 2196 106 0.990566037735849 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta sp.
28094940 28094940 PRJNA743294_P_NODE_57805_length_236_cov_2.613497_g57349_i0 PRJNA743294 57805 236 2.613497 6.16785292 Leptospira terpstrae serovar Hualin str. LT 11-33 = ATCC 7 293075 Bacteria Bacteria 85.9 1.89e-18   NR EMY61817.1 1257025 g57349 i0 53.2 0.978813559322034 77 36 97.9 0 5 235 16 92 EMY61817.1 methyltransferase FkbM domain protein [Leptospira terpstrae serovar Hualin str. LT 11-33 = ATCC 700639] diamond 231 85.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira terpstrae
28189413 28189413 PRJNA743294_P_NODE_56606_length_242_cov_0.923077_g56150_i0 PRJNA743294 56606 242 0.923077 2.23384634 Spirochaetales bacterium 2026792 Bacteria Bacteria 51.6 2.74e-5   NR MBN2551734.1 2026792 g56150 i0 55.6 2.83884297520661 36 16 44.6 0 151 44 117 152 MBN2551734.1 serine/threonine protein kinase [Spirochaetales bacterium] diamond 687 51.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28410701 28410701 PRJNA743294_P_NODE_17706_length_383_cov_3.290323_g17250_i0 PRJNA743294 17706 383 3.290323 12.60193709 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 45.1 0.0267   NR MDR0569111.1 1898206 g17250 i0 30.9 0.861618798955614 110 69 86.2 2 28 357 29 131 MDR0569111.1 heavy metal translocating P-type ATPase [Spirochaetaceae bacterium] diamond 330 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28410757 28410757 PRJNA743294_P_NODE_53126_length_245_cov_1.813953_g52670_i0 PRJNA743294 53126 245 1.813953 4.44418485 Spirochaeta isovalerica 150 Bacteria Bacteria 43.9 0.0147   NR WP_184748135.1 150 g52670 i0 39.4 0.808163265306122 66 34 77.1 2 4 192 406 468 WP_184748135.1 sigma 54-interacting transcriptional regulator [Spirochaeta isovalerica] diamond 198 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta isovalerica
28568410 28568410 PRJNA743294_P_NODE_20387_length_360_cov_1.923345_g19931_i0 PRJNA743294 20387 360 1.923345 6.924042 Exilispira sp. 2699745 Bacteria Bacteria 120 5.7e-29   NR MCR4422338.1 2699745 g19931 i0 48.2 1.83333333333333 112 58 93.3 0 350 15 669 780 MCR4422338.1 endopeptidase La [Exilispira sp.] diamond 660 120 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales   Exilispira Exilispira sp.
28767934 28767934 PRJNA743294_P_NODE_1507_length_1146_cov_9.648649_g1268_i0 PRJNA743294 1507 1146 9.648649 110.57351754 Spirochaetales 136 Bacteria Bacteria 65.9 4.21e-8   NR MDR2632347.1 166 g1268 i0 30.5 1.2565445026178 118 77 30.6 3 9 359 151 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 1440 65.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29137154 29137154 PRJNA743294_P_NODE_8789_length_531_cov_2.417031_g8333_i0 PRJNA743294 8789 531 2.417031 12.83443461 Spirochaetia bacterium 2053615 Bacteria Bacteria 108 5.44e-24   NR MDR3237389.1 2053615 g8333 i0 36.7 3.0225988700565 177 98 99.4 3 531 4 253 416 MDR3237389.1 UDPGP type 1 family protein [Spirochaetia bacterium] diamond 1605 108 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29483899 29483899 PRJNA743294_P_NODE_3130_length_845_cov_1.718912_g2770_i0 PRJNA743294 3130 845 1.718912 14.5248064 Leptospiraceae bacterium 2026757 Bacteria Bacteria 85.9 2.86e-15   NR MCB1190498.1 2026757 g2770 i0 33.5 0.603550295857988 170 94 58.9 4 23 520 149 303 MCB1190498.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 510 85.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30031150 30031150 PRJNA743294_P_NODE_37931_length_275_cov_1.470297_g37475_i0 PRJNA743294 37931 275 1.470297 4.04331675 root 1 Root_unresolved Root_unresolved 114 1.03e-28   NR MDA3949013.1 28185 g37475 i0 62.6 11.9127272727273 91 34 99.3 0 3 275 61 151 MDA3949013.1 VIT1/CCC1 transporter family protein [Spirochaeta sp.] diamond 3276 115 0.991304347826087 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta sp.
30147104 30147104 PRJNA743294_P_NODE_33792_length_289_cov_1.083333_g33336_i0 PRJNA743294 33792 289 1.083333 3.13083237 Treponema sp. 166 Bacteria Bacteria 43.1 0.0441   NR MCK9168889.1 166 g33336 i0 27.9 0.892733564013841 86 62 89.3 0 7 264 74 159 MCK9168889.1 hypothetical protein [Treponema sp.] diamond 258 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30188971 30188971 PRJNA743294_P_NODE_33152_length_291_cov_1.403670_g32696_i0 PRJNA743294 33152 291 1.40367 4.0846797 Bacteria 2 Bacteria Bacteria 89.7 1.61e-20   NR KPJ81179.1 1704237 g32696 i0 41.7 11.340206185567 84 49 86.6 0 39 290 7 90 KPJ81179.1 MAG: hypothetical protein AMS17_19795, partial [Spirochaetes bacterium DG_61] diamond 3300 90.1 0.995560488346282 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium DG_61
30284278 30284278 PRJNA743294_P_NODE_52012_length_246_cov_3.687861_g51556_i0 PRJNA743294 52012 246 3.687861 9.07213806 Pseudomonadati 3379134 Bacteria Bacteria 131 3.3299999999999997e-35   NR WP_100713162.1 2023191 g51556 i0 75.3 2.96341463414634 81 20 98.8 0 244 2 220 300 WP_100713162.1 cysteine synthase A [Leptospira perolatii] diamond 729 131 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira perolatii
30432190 30432190 PRJNA743294_P_NODE_59093_length_229_cov_2.929487_g58637_i0 PRJNA743294 59093 229 2.929487 6.70852523 Spirochaetia bacterium 2053615 Bacteria Bacteria 52.8 9e-6   NR HUZ17244.1 2053615 g58637 i0 39.4 0.864628820960699 66 40 86.5 0 213 16 176 241 HUZ17244.1 glycosyltransferase family 2 protein [Spirochaetia bacterium] diamond 198 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30842578 30842578 PRJNA743294_P_NODE_25474_length_326_cov_5.213439_g25018_i0 PRJNA743294 25474 326 5.213439 16.99581114 Spirochaetota bacterium 2202144 Bacteria Bacteria 96.3 5.169999999999999e-23   NR NMB63638.1 2202144 g25018 i0 56.4 3.02760736196319 78 34 71.8 0 254 21 46 123 NMB63638.1 RidA family protein [Spirochaetota bacterium] diamond 987 96.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30842591 30842591 PRJNA743294_P_NODE_3534_length_801_cov_2.028846_g3153_i0 PRJNA743294 3534 801 2.028846 16.25105646 Spirochaetota bacterium 2202144 Bacteria Bacteria 90.1 2.59e-16   NR MBN8219929.1 2202144 g3153 i0 45.9 0.408239700374532 109 56 39.7 1 484 801 288 396 MBN8219929.1 hypothetical protein [Spirochaetota bacterium] diamond 327 90.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30937420 30937420 PRJNA743294_P_NODE_32694_length_292_cov_4.543379_g32238_i0 PRJNA743294 32694 292 4.543379 13.26666668 Leptospiraceae bacterium 2026757 Bacteria Bacteria 130 4.649999999999999e-37   NR MDX1958858.1 2026757 g32238 i0 57.9 1.96232876712329 95 40 97.6 0 6 290 8 102 MDX1958858.1 Mpo1-like protein [Leptospiraceae bacterium] diamond 573 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31032360 31032360 PRJNA743294_P_NODE_54455_length_244_cov_0.912281_g53999_i0 PRJNA743294 54455 244 0.912281 2.22596564 Spirochaetia bacterium 2053615 Bacteria Bacteria 42.4 0.0482   NR HKJ84492.1 2053615 g53999 i0 34.9 0.774590163934426 63 37 72.5 2 236 60 206 268 HKJ84492.1 uroporphyrinogen decarboxylase family protein [Spirochaetia bacterium] diamond 189 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31284842 31284842 PRJNA743294_P_NODE_47375_length_252_cov_0.871508_g46919_i0 PRJNA743294 47375 252 0.871508 2.19620016 Spirochaeta isovalerica 150 Bacteria Bacteria 56.2 6.6e-7   NR WP_184742443.1 150 g46919 i0 40.5 2.78571428571429 79 47 94 0 238 2 37 115 WP_184742443.1 ankyrin repeat domain-containing protein [Spirochaeta isovalerica] diamond 702 56.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta isovalerica
32202338 32202338 PRJNA743294_P_NODE_27278_length_317_cov_1.213115_g26822_i0 PRJNA743294 27278 317 1.213115 3.84557455 Spirochaetota bacterium 2202144 Bacteria Bacteria 53.9 1.05e-5   NR MBP7737327.1 2202144 g26822 i0 55.8 1.44794952681388 52 18 46.4 2 19 165 517 566 MBP7737327.1 hypothetical protein [Spirochaetota bacterium] diamond 459 53.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32265836 32265836 PRJNA743294_P_NODE_10258_length_494_cov_2.182898_g9802_i0 PRJNA743294 10258 494 2.182898 10.78351612 Spirochaetia bacterium 2053615 Bacteria Bacteria 102 5.34e-22   NR HUX49932.1 2053615 g9802 i0 49.6 1.28744939271255 117 56 71.1 2 10 360 250 363 HUX49932.1 beta-xylosidase [Spirochaetia bacterium] diamond 636 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32802218 32802218 PRJNA743294_P_NODE_24740_length_331_cov_1.205426_g24284_i0 PRJNA743294 24740 331 1.205426 3.98996006 Leptospira sp. 178 Bacteria Bacteria 159 1.3099999999999998e-47   NR MCU0824711.1 178 g24284 i0 81.1 0.861027190332326 95 18 86.1 0 47 331 30 124 MCU0824711.1 MFS transporter [Leptospira sp.] diamond 285 159 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32833755 32833755 PRJNA743294_P_NODE_14420_length_421_cov_4.525862_g13964_i0 PRJNA743294 14420 421 4.525862 19.05387902 Leptospiraceae bacterium 2026757 Bacteria Bacteria 102 9.54e-26   NR MCB1177358.1 2026757 g13964 i0 75 0.427553444180523 60 15 42.8 0 208 29 1 60 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 180 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae 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);;