RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

36 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 36 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1240804 · 36 ✖

analysis 1

  • diamond · 36 ✖

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
5452146 5452146 PRJNA1240804_P_NODE_61445_length_203_cov_1.311688_g61079_i0 PRJNA1240804 61445 203 1.311688 2.66272664 Sphaerochaeta sp. 1972642 Bacteria Bacteria 122 1.46e-30   NR MCH3908097.1 1972642 g61079 i0 100 0.931034482758621 63 0 93.1 0 202 14 323 385 MCH3908097.1 bifunctional aspartate kinase/homoserine dehydrogenase I [Sphaerochaeta sp.] diamond 189 122 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
27010052 27010052 PRJNA1240804_P_NODE_114382_length_168_cov_0.873950_g114016_i0 PRJNA1240804 114382 168 0.87395 1.468236 Treponema sp. 166 Bacteria Bacteria 110 5.18e-29   NR NLJ09852.1 166 g114016 i0 100 0.910714285714286 51 0 91.1 0 167 15 56 106 NLJ09852.1 hypothetical protein [Treponema sp.] diamond 153 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27010164 27010164 PRJNA1240804_P_NODE_91062_length_179_cov_1.446154_g90696_i0 PRJNA1240804 91062 179 1.446154 2.58861566 Spirochaetales bacterium 2026792 Bacteria Bacteria 114 1.4e-28   NR RPI94506.1 2026792 g90696 i0 98.1 3.62011173184358 54 1 90.5 0 177 16 180 233 RPI94506.1 MAG: dissimilatory-type sulfite reductase subunit beta [Spirochaetales bacterium] diamond 648 114 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27091711 27091711 PRJNA1240804_P_NODE_73802_length_191_cov_1.077465_g73436_i0 PRJNA1240804 73802 191 1.077465 2.05795815 Bacteria 2 Bacteria Bacteria 107 1.07e-25   NR MDR0586209.1 166 g73436 i0 86.2 25.5078534031414 58 8 91.1 0 16 189 265 322 MDR0586209.1 cobalamin-independent methionine synthase II family protein [Treponema sp.] diamond 4872 108 0.990740740740741 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27660494 27660494 PRJNA1240804_P_NODE_136584_length_164_cov_0.904348_g136218_i0 PRJNA1240804 136584 164 0.904348 1.48313072 Pseudomonadati 3379134 Bacteria Bacteria 56.6 1.42e-7   NR WP_109022055.1 1917830 g136218 i0 84.4 3.49390243902439 32 5 58.5 0 149 54 140 171 WP_109022055.1 AraC family transcriptional regulator [Leptospira kobayashii] diamond 573 56.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira kobayashii
27737162 27737162 PRJNA1240804_P_NODE_133364_length_165_cov_0.896552_g132998_i0 PRJNA1240804 133364 165 0.896552 1.4793108 Spirochaetota bacterium 2202144 Bacteria Bacteria 98.6 2.74e-22   NR MBP7605021.1 2202144 g132998 i0 92 0.909090909090909 50 4 90.9 0 15 164 684 733 MBP7605021.1 fused MFS/spermidine synthase [Spirochaetota bacterium] diamond 150 98.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27944560 27944560 PRJNA1240804_P_NODE_97145_length_175_cov_1.507937_g96779_i0 PRJNA1240804 97145 175 1.507937 2.63888975 Sphaerochaeta 399320 Bacteria Bacteria 107 1.3e-25   NR MCI2045297.1 1972642 g96779 i0 98.1 1.78285714285714 52 1 89.1 0 7 162 182 233 MCI2045297.1 MATE family efflux transporter [Sphaerochaeta sp.] diamond 312 107 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
28021154 28021154 PRJNA1240804_P_NODE_115885_length_168_cov_0.873950_g115519_i0 PRJNA1240804 115885 168 0.87395 1.468236 Treponema sp. 166 Bacteria Bacteria 95.9 2.6099999999999994e-23   NR HPC70614.1 166 g115519 i0 100 3.21428571428571 45 0 80.4 0 136 2 64 108 HPC70614.1 HAD-IIB family hydrolase [Treponema sp.] diamond 540 95.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28070733 28070733 PRJNA1240804_P_NODE_137385_length_164_cov_0.904348_g137019_i0 PRJNA1240804 137385 164 0.904348 1.48313072 Bacteria 2 Bacteria Bacteria 50.4 2.11e-5   NR MDR1030278.1 166 g137019 i0 69.7 1.75609756097561 33 10 60.4 0 149 51 226 258 MDR1030278.1 ABC transporter permease [Treponema sp.] diamond 288 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28115592 28115592 PRJNA1240804_P_NODE_113905_length_168_cov_0.873950_g113539_i0 PRJNA1240804 113905 168 0.87395 1.468236 Sphaerochaeta sp. 1972642 Bacteria Bacteria 78.6 4.47e-16   NR MCH3907915.1 1972642 g113539 i0 97.6 0.75 42 1 75 0 5 130 180 221 MCH3907915.1 ABC transporter permease [Sphaerochaeta sp.] diamond 126 78.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
28147471 28147471 PRJNA1240804_P_NODE_112445_length_168_cov_1.352941_g112079_i0 PRJNA1240804 112445 168 1.352941 2.27294088 Spirochaetales bacterium 2026792 Bacteria Bacteria 73.6 1.65e-13   NR MCH5149402.1 2026792 g112079 i0 75 0.785714285714286 44 11 78.6 0 37 168 272 315 MCH5149402.1 glycosyltransferase family 4 protein [Spirochaetales bacterium] diamond 132 73.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
28368277 28368277 PRJNA1240804_P_NODE_48866_length_221_cov_0.883721_g48500_i0 PRJNA1240804 48866 221 0.883721 1.95302341 Spirochaetota bacterium 2202144 Bacteria Bacteria 48.9 1.89e-4   NR TXH10479.1 2202144 g48500 i0 34.8 0.895927601809955 66 43 89.6 0 12 209 429 494 TXH10479.1 MAG: hypothetical protein E6R04_05240 [Spirochaetota bacterium] diamond 198 48.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28463213 28463213 PRJNA1240804_P_NODE_108486_length_169_cov_0.866667_g108120_i0 PRJNA1240804 108486 169 0.866667 1.46466723 Leptospira sp. severe_ 178 Bacteria Bacteria 94.7 1.57e-21   NR WP_229266742.1 2838237 g108120 i0 88.5 0.923076923076923 52 6 92.3 0 162 7 37 88 WP_229266742.1 AraC family transcriptional regulator [Leptospira sp. severe_002] diamond 156 94.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. severe_002
29126420 29126420 PRJNA1240804_P_NODE_43729_length_230_cov_1.071823_g43363_i0 PRJNA1240804 43729 230 1.071823 2.4651929 Sphaerochaeta sp. 1972642 Bacteria Bacteria 128 4.04e-34   NR MCI2045621.1 1972642 g43363 i0 94.4 0.939130434782609 72 4 93.9 0 15 230 97 168 MCI2045621.1 ABC transporter permease subunit [Sphaerochaeta sp.] diamond 216 128 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
29536570 29536570 PRJNA1240804_P_NODE_131450_length_165_cov_0.896552_g131084_i0 PRJNA1240804 131450 165 0.896552 1.4793108 Leptospira sp. severe_ 178 Bacteria Bacteria 100 6.29e-25   NR WP_229266502.1 2838237 g131084 i0 92 0.909090909090909 50 4 90.9 0 162 13 44 93 WP_229266502.1 hypothetical protein [Leptospira sp. severe_002] diamond 150 100 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. severe_002
29617558 29617558 PRJNA1240804_P_NODE_52050_length_216_cov_1.047904_g51684_i0 PRJNA1240804 52050 216 1.047904 2.26347264 Spirochaetales 136 Bacteria Bacteria 119 2.94e-32   NR HAL93448.1 1898206 g51684 i0 90.8 5.41666666666667 65 6 90.3 0 14 208 116 180 HAL93448.1 50S ribosomal protein L6 [Spirochaetaceae bacterium] diamond 1170 120 0.991666666666667 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29712254 29712254 PRJNA1240804_P_NODE_69570_length_194_cov_1.331034_g69204_i0 PRJNA1240804 69570 194 1.331034 2.58220596 Sphaerochaeta 399320 Bacteria Bacteria 110 2.7e-26   NR MCI2075815.1 1972642 g69204 i0 100 1.82474226804124 59 0 91.2 0 15 191 329 387 MCI2075815.1 MFS transporter [Sphaerochaeta sp.] diamond 354 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
30295105 30295105 PRJNA1240804_P_NODE_47712_length_223_cov_0.879310_g47346_i0 PRJNA1240804 47712 223 0.87931 1.9608613 Treponema sp. 166 Bacteria Bacteria 51.2 3.02e-5   NR MCL2068176.1 166 g47346 i0 45.6 1.82959641255605 68 37 91.5 0 17 220 338 405 MCL2068176.1 fibronectin type III domain-containing protein [Treponema sp.] diamond 408 51.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30358347 30358347 PRJNA1240804_P_NODE_36252_length_247_cov_0.949495_g35886_i0 PRJNA1240804 36252 247 0.949495 2.34525265 Sphaerochaeta sp. 1972642 Bacteria Bacteria 110 1.02e-28   NR MCH3920730.1 1972642 g35886 i0 96.4 0.668016194331984 55 2 66.8 0 167 3 1 55 MCH3920730.1 SsrA-binding protein SmpB [Sphaerochaeta sp.] diamond 165 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
30389925 30389925 PRJNA1240804_P_NODE_98173_length_174_cov_2.232000_g97807_i0 PRJNA1240804 98173 174 2.232 3.88368 Spirochaetia bacterium 2053615 Bacteria Bacteria 76.3 2.21e-14   NR MCH3918220.1 2053615 g97807 i0 72.3 0.810344827586207 47 13 81 0 160 20 1 47 MCH3918220.1 glycosyl hydrolase-related protein [Spirochaetia bacterium] diamond 141 76.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30547407 30547407 PRJNA1240804_P_NODE_126713_length_166_cov_0.888889_g126347_i0 PRJNA1240804 126713 166 0.888889 1.47555574 Sphaerochaeta sp. 1972642 Bacteria Bacteria 109 4.44e-26   NR MCH3908401.1 1972642 g126347 i0 100 0.993975903614458 55 0 99.4 0 2 166 237 291 MCH3908401.1 NAD(+) synthase [Sphaerochaeta sp.] diamond 165 109 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
30642003 30642003 PRJNA1240804_P_NODE_103113_length_171_cov_1.639344_g102747_i0 PRJNA1240804 103113 171 1.639344 2.80327824 Gracilinema caldarium 215591 Bacteria Bacteria 99.8 1.1200000000000001e-22   NR WP_304244872.1 215591 g102747 i0 100 0.894736842105263 51 0 89.5 0 17 169 13 63 WP_304244872.1 CarD family transcriptional regulator, partial [Gracilinema caldarium] diamond 153 99.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Breznakiellaceae Gracilinema Gracilinema caldarium
30736852 30736852 PRJNA1240804_P_NODE_125054_length_166_cov_0.888889_g124688_i0 PRJNA1240804 125054 166 0.888889 1.47555574 Sphaerochaeta sp. 1972642 Bacteria Bacteria 62.8 1.11e-9   NR MCI2128228.1 1972642 g124688 i0 85.7 0.632530120481928 35 5 63.3 0 153 49 319 353 MCI2128228.1 tyrosine--tRNA ligase [Sphaerochaeta sp.] diamond 105 62.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
30895190 30895190 PRJNA1240804_P_NODE_49814_length_219_cov_1.558824_g49448_i0 PRJNA1240804 49814 219 1.558824 3.41382456 Leptospiraceae bacterium 2026757 Bacteria Bacteria 83.6 1.12e-16   NR MBL8032576.1 2026757 g49448 i0 60.3 2.79452054794521 68 26 91.8 1 205 5 281 348 MBL8032576.1 hypothetical protein [Leptospiraceae bacterium] diamond 612 83.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31178995 31178995 PRJNA1240804_P_NODE_128095_length_166_cov_0.888889_g127729_i0 PRJNA1240804 128095 166 0.888889 1.47555574 Sphaerochaeta sp. 1972642 Bacteria Bacteria 70.9 1.52e-12   NR MCK9599151.1 1972642 g127729 i0 67.4 0.831325301204819 46 15 83.1 0 164 27 29 74 MCK9599151.1 hypothetical protein [Sphaerochaeta sp.] diamond 138 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
31464150 31464150 PRJNA1240804_P_NODE_110436_length_169_cov_0.866667_g110070_i0 PRJNA1240804 110436 169 0.866667 1.46466723 Gracilinema caldarium 215591 Bacteria Bacteria 106 2.56e-26   NR WP_013970217.1 215591 g110070 i0 100 1.81065088757396 51 0 90.5 0 2 154 186 236 WP_013970217.1 carbohydrate ABC transporter permease [Gracilinema caldarium] diamond 306 106 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Breznakiellaceae Gracilinema Gracilinema caldarium
31527269 31527269 PRJNA1240804_P_NODE_108476_length_169_cov_0.866667_g108110_i0 PRJNA1240804 108476 169 0.866667 1.46466723 Treponema sp. 166 Bacteria Bacteria 63.2 1.69e-11   NR NLJ09236.1 166 g108110 i0 100 0.461538461538462 26 0 46.2 0 169 92 44 69 NLJ09236.1 hypothetical protein [Treponema sp.] diamond 78 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31622004 31622004 PRJNA1240804_P_NODE_149956_length_162_cov_0.920354_g149590_i0 PRJNA1240804 149956 162 0.920354 1.49097348 Sphaerochaeta sp. 1972642 Bacteria Bacteria 58.9 2.34e-8   NR MCI2127836.1 1972642 g149590 i0 82.4 0.62962962962963 34 6 63 0 148 47 384 417 MCI2127836.1 phosphoribosylamine--glycine ligase [Sphaerochaeta sp.] diamond 102 58.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
31811881 31811881 PRJNA1240804_P_NODE_118817_length_167_cov_0.881356_g118451_i0 PRJNA1240804 118817 167 0.881356 1.47186452 Sphaerochaeta sp. 1972642 Bacteria Bacteria 70.9 1.56e-12   NR MCH3908611.1 1972642 g118451 i0 100 0.664670658682635 37 0 66.5 0 53 163 1 37 MCH3908611.1 hypothetical protein [Sphaerochaeta sp.] diamond 111 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
32001658 32001658 PRJNA1240804_P_NODE_110358_length_169_cov_0.866667_g109992_i0 PRJNA1240804 110358 169 0.866667 1.46466723 Sphaerochaeta sp. 1972642 Bacteria Bacteria 98.6 2.99e-22   NR MCI2097634.1 1972642 g109992 i0 98.1 0.923076923076923 52 1 92.3 0 169 14 668 719 MCI2097634.1 efflux RND transporter permease subunit [Sphaerochaeta sp.] diamond 156 98.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
32286765 32286765 PRJNA1240804_P_NODE_110039_length_169_cov_0.866667_g109673_i0 PRJNA1240804 110039 169 0.866667 1.46466723 Gracilinema caldarium 215591 Bacteria Bacteria 93.6 5.83e-21   NR WP_304241857.1 215591 g109673 i0 96.3 0.958579881656805 54 2 95.9 0 164 3 255 308 WP_304241857.1 LptF/LptG family permease [Gracilinema caldarium] diamond 162 93.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Breznakiellaceae Gracilinema Gracilinema caldarium
32286786 32286786 PRJNA1240804_P_NODE_132939_length_165_cov_0.896552_g132573_i0 PRJNA1240804 132939 165 0.896552 1.4793108 Spirochaetales bacterium 2026792 Bacteria Bacteria 57 1.18e-7   NR MBR6348847.1 2026792 g132573 i0 50.9 0.963636363636364 53 22 89.1 1 149 3 10 62 MBR6348847.1 hypothetical protein [Spirochaetales bacterium] diamond 159 57 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32318512 32318512 PRJNA1240804_P_NODE_88519_length_181_cov_1.075758_g88153_i0 PRJNA1240804 88519 181 1.075758 1.94712198 Treponema sp. 166 Bacteria Bacteria 54.3 1.25e-6   NR MDR1301078.1 166 g88153 i0 60.5 0.712707182320442 43 17 71.3 0 5 133 260 302 MDR1301078.1 ATP-binding cassette domain-containing protein [Treponema sp.] diamond 129 54.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32476488 32476488 PRJNA1240804_P_NODE_133079_length_165_cov_0.896552_g132713_i0 PRJNA1240804 133079 165 0.896552 1.4793108 Leptospiraceae bacterium 2026757 Bacteria Bacteria 62.4 6.08e-10   NR MCX7811843.1 2026757 g132713 i0 78.4 0.672727272727273 37 8 67.3 0 16 126 32 68 MCX7811843.1 DUF4352 domain-containing protein [Leptospiraceae bacterium] diamond 111 62.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32476496 32476496 PRJNA1240804_P_NODE_139339_length_164_cov_0.904348_g138973_i0 PRJNA1240804 139339 164 0.904348 1.48313072 Spirochaetales bacterium 2026792 Bacteria Bacteria 92.4 3.71e-20   NR MBR5669231.1 2026792 g138973 i0 85.4 0.878048780487805 48 7 87.8 0 159 16 298 345 MBR5669231.1 IS1182 family transposase [Spirochaetales bacterium] diamond 144 92.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32760110 32760110 PRJNA1240804_P_NODE_108740_length_169_cov_0.866667_g108374_i0 PRJNA1240804 108740 169 0.866667 1.46466723 Spirochaetota bacterium 2202144 Bacteria Bacteria 107 2.34e-28   NR MBP7602610.1 2202144 g108374 i0 100 5.64497041420118 53 0 94.1 0 164 6 75 127 MBP7602610.1 PaaI family thioesterase [Spirochaetota bacterium] diamond 954 107 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);;