RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJNA737474" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 35 ✖

tax_kingdom 1

bioproject 1

  • PRJNA737474 · 35 ✖

analysis 1

  • diamond · 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
25712134 25712134 PRJNA737474e_S_NODE_5434_length_458_cov_2.714286_g4554_i0 PRJNA737474 5434 458 2.714286 12.43142988 Treponema sp. 166 Bacteria Bacteria 158 2.2899999999999998e-43   NR MFC2330103.1 166 g4554 i0 98.7 0.497816593886463 76 1 49.8 0 225 452 1 76 MFC2330103.1 argininosuccinate synthase [Treponema sp.] diamond 228 158 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26036803 26036803 PRJNA737474e_S_NODE_14796_length_320_cov_1.817814_g13914_i0 PRJNA737474 14796 320 1.817814 5.8170048 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 81.6 2.01e-15   NR MCF0237448.1 2791017 g13914 i0 46 2.925 100 39 87.2 4 42 320 225 316 MCF0237448.1 family 43 glycosylhydrolase [Sphaerochaetaceae bacterium] diamond 936 81.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
26112450 26112450 PRJNA737474b_S_NODE_17941_length_378_cov_3.836066_g16902_i0 PRJNA737474 17941 378 3.836066 14.50032948 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 228 1.52e-74   NR WP_187152238.1 1580831 g16902 i0 93.9 0.912698412698413 115 7 91.3 0 32 376 7 121 WP_187152238.1 alginate export family protein, partial [Treponema endosymbiont of Eucomonympha sp.] diamond 345 228 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
26253014 26253014 PRJNA737474d_S_NODE_11510_length_453_cov_7.692105_g10925_i0 PRJNA737474 11510 453 7.692105 34.84523565 Spirochaetales bacterium 2026792 Bacteria Bacteria 55.1 1.75e-5   NR MEI8096416.1 2026792 g10925 i0 27.5 0.721854304635762 109 67 64.2 1 7 297 670 778 MEI8096416.1 fibronectin type III domain-containing protein [Spirochaetales bacterium] diamond 327 55.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32919634 32919634 PRJNA737474f_S_NODE_246633_length_245_cov_1.139535_g245955_i0 PRJNA737474 246633 245 1.139535 2.79186075 Treponema sp. 166 Bacteria Bacteria 52.4 1.21e-5   NR HBG64917.1 166 g245955 i0 42.6 1.71428571428571 61 34 73.5 1 214 35 78 138 HBG64917.1 glycosyl transferase [Treponema sp.] diamond 420 52.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32920646 32920646 PRJNA737474g_S_NODE_36209_length_474_cov_9.109726_g34922_i0 PRJNA737474 36209 474 9.109726 43.18010124 Spirochaetota bacterium 2202144 Bacteria Bacteria 65.9 3.55e-9   NR MEW5816844.1 2202144 g34922 i0 44.4 0.39873417721519 63 31 39.9 1 11 199 538 596 MEW5816844.1 alpha-amylase family glycosyl hydrolase [Spirochaetota bacterium] diamond 189 65.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32924688 32924688 PRJNA737474g_S_NODE_279577_length_257_cov_1.804348_g278283_i0 PRJNA737474 279577 257 1.804348 4.63717436 Pleomorphochaeta 1920504 Bacteria Bacteria 106 6.870000000000001e-27   NR MDC7244240.1 1920505 g278283 i0 59 1.93774319066148 83 33 95.7 1 250 5 89 171 MDC7244240.1 phosphoribosyltransferase [Pleomorphochaeta sp.] diamond 498 107 0.990654205607477 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Pleomorphochaeta Pleomorphochaeta sp.
32937813 32937813 PRJNA737474g_S_NODE_356785_length_247_cov_2.149425_g355491_i0 PRJNA737474 356785 247 2.149425 5.30907975 Leptospiraceae bacterium 2026757 Bacteria Bacteria 47 0.00108   NR MCB1169781.1 2026757 g355491 i0 35.4 2.96356275303644 79 42 96 2 9 245 169 238 MCB1169781.1 dioxygenase [Leptospiraceae bacterium] diamond 732 47 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32941470 32941470 PRJNA737474b_S_NODE_25329_length_318_cov_9.824490_g24290_i0 PRJNA737474 25329 318 9.82449 31.2418782 Bacteria 2 Bacteria Bacteria 79 1.76e-14   NR MDF1567988.1 1898206 g24290 i0 85 4.52830188679245 40 6 37.7 0 297 178 592 631 MDF1567988.1 formate--tetrahydrofolate ligase [Spirochaetaceae bacterium] diamond 1440 79.7 0.991217063989962 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32953111 32953111 PRJNA737474c_S_NODE_4826_length_489_cov_1.932692_g3999_i0 PRJNA737474 4826 489 1.932692 9.45086388 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 173 3.3e-47   NR MCF0237448.1 2791017 g3999 i0 50.9 0.975460122699387 159 78 97.5 0 484 8 360 518 MCF0237448.1 family 43 glycosylhydrolase [Sphaerochaetaceae bacterium] diamond 477 173 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
32953679 32953679 PRJNA737474e_S_NODE_34210_length_235_cov_3.716049_g33328_i0 PRJNA737474 34210 235 3.716049 8.73271515 Spirochaetales bacterium 2026792 Bacteria Bacteria 108 1.64e-25   NR MDD7200396.1 2026792 g33328 i0 64.1 1.99148936170213 78 25 95.7 1 2 226 102 179 MDD7200396.1 family 43 glycosylhydrolase [Spirochaetales bacterium] diamond 468 108 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32958909 32958909 PRJNA737474f_S_NODE_28674_length_401_cov_1.832317_g27997_i0 PRJNA737474 28674 401 1.832317 7.34759117 root 1 Root_unresolved Root_unresolved 112 5.8200000000000006e-27   NR MCE9502068.1 178 g27997 i0 57.7 1.76558603491272 78 33 58.4 0 399 166 264 341 MCE9502068.1 cyclopropane-fatty-acyl-phospholipid synthase family protein [Leptospira sp.] diamond 708 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32970242 32970242 PRJNA737474c_S_NODE_30274_length_232_cov_2.893082_g29443_i0 PRJNA737474 30274 232 2.893082 6.71195024 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 137 1.26e-39   NR WP_187149558.1 1580831 g29443 i0 98.5 0.853448275862069 66 1 85.3 0 200 3 9 74 WP_187149558.1 alginate export family protein, partial [Treponema endosymbiont of Eucomonympha sp.] diamond 198 137 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
32970889 32970889 PRJNA737474f_S_NODE_13226_length_554_cov_3.222453_g12561_i0 PRJNA737474 13226 554 3.222453 17.85238962 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 115 1.38e-26   NR MFA6688828.1 2791017 g12561 i0 55.1 1.07761732851986 98 44 53.1 0 1 294 348 445 MFA6688828.1 diaminobutyrate--2-oxoglutarate transaminase [Sphaerochaetaceae bacterium] diamond 597 115 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
32970935 32970935 PRJNA737474f_S_NODE_146474_length_268_cov_1.287179_g145796_i0 PRJNA737474 146474 268 1.287179 3.44963972 Spirochaetales bacterium 2026792 Bacteria Bacteria 84.3 4.59e-17   NR MBN2509503.1 2026792 g145796 i0 44.9 1.58955223880597 69 38 77.2 0 207 1 133 201 MBN2509503.1 zinc-ribbon domain-containing protein [Spirochaetales bacterium] diamond 426 84.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32976234 32976234 PRJNA737474g_S_NODE_394274_length_244_cov_1.350877_g392980_i0 PRJNA737474 394274 244 1.350877 3.29613988 Pseudomonadati 3379134 Bacteria Bacteria 48.5 2.45e-4   NR MCL2044507.1 166 g392980 i0 45.9 6.34426229508197 61 30 75 1 30 212 165 222 MCL2044507.1 HAD family hydrolase [Treponema sp.] diamond 1548 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
33004230 33004230 PRJNA737474c_S_NODE_8683_length_374_cov_4.697674_g7852_i0 PRJNA737474 8683 374 4.697674 17.56930076 Spirochaetales bacterium 2026792 Bacteria Bacteria 156 1.08e-41   NR MDD7200396.1 2026792 g7852 i0 71.4 3.44117647058824 105 30 84.2 0 52 366 32 136 MDD7200396.1 family 43 glycosylhydrolase [Spirochaetales bacterium] diamond 1287 156 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
33005397 33005397 PRJNA737474f_S_NODE_92403_length_296_cov_1.197309_g91725_i0 PRJNA737474 92403 296 1.197309 3.54403464 Candidatus Gallitreponema excrementavium 2840840 Bacteria Bacteria 46.2 5.69e-4   NR MBO8458629.1 2840840 g91725 i0 42.6 0.547297297297297 54 30 54.7 1 14 175 36 88 MBO8458629.1 30S ribosomal protein S15 [Candidatus Gallitreponema excrementavium] diamond 162 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales   Candidatus Gallitreponema Candidatus Gallitreponema excrementavium
33009946 33009946 PRJNA737474f_S_NODE_141131_length_270_cov_2.304569_g140453_i0 PRJNA737474 141131 270 2.304569 6.2223363 Bacteria candidate phyla 1783234 Bacteria Bacteria 80.9 2.72e-16   NR WP_012671820.1 159 g140453 i0 56.2 6.72222222222222 73 31 81.1 1 258 40 153 224 WP_012671820.1 pseudouridine synthase [Brachyspira hyodysenteriae] diamond 1815 81.6 0.991421568627451 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hyodysenteriae
33021381 33021381 PRJNA737474d_S_NODE_17092_length_371_cov_3.184564_g16498_i0 PRJNA737474 17092 371 3.184564 11.81473244 Treponema endosymbiont of Eucomonympha sp. 1580831 Bacteria Bacteria 157 1.19e-46   NR WP_228378758.1 1580831 g16498 i0 97.6 0.671159029649596 83 2 67.1 0 122 370 1 83 WP_228378758.1 DoxX family protein, partial [Treponema endosymbiont of Eucomonympha sp.] diamond 249 157 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema endosymbiont of Eucomonympha sp.
33022411 33022411 PRJNA737474f_S_NODE_42004_length_357_cov_1.447183_g41326_i0 PRJNA737474 42004 357 1.447183 5.16644331 Spirochaetota bacterium 2202144 Bacteria Bacteria 87 5.9e-18   NR MFC1669629.1 2202144 g41326 i0 39 0.991596638655462 118 67 97.5 2 352 5 85 199 MFC1669629.1 SDR family NAD(P)-dependent oxidoreductase [Spirochaetota bacterium] diamond 354 87 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
33023037 33023037 PRJNA737474g_S_NODE_220980_length_271_cov_2.035354_g219686_i0 PRJNA737474 220980 271 2.035354 5.51580934 Spirochaetes bacterium GWB1_36_13 1802174 Bacteria Bacteria 68.9 3.21e-11   NR OHD11784.1 1802174 g219686 i0 33 5.87822878228782 91 60 99.6 1 2 271 489 579 OHD11784.1 MAG: hypothetical protein A2Y41_09870 [Spirochaetes bacterium GWB1_36_13] diamond 1593 68.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_36_13
33027083 33027083 PRJNA737474f_S_NODE_159172_length_263_cov_2.026316_g158494_i0 PRJNA737474 159172 263 2.026316 5.32921108 Pseudomonadati 3379134 Bacteria Bacteria 78.6 1.18e-14   NR HQH99510.1 2202144 g158494 i0 65.3 2.21292775665399 49 17 55.9 0 247 101 733 781 HQH99510.1 PEP/pyruvate-binding domain-containing protein [Spirochaetota bacterium] diamond 582 78.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
33044092 33044092 PRJNA737474f_S_NODE_22372_length_437_cov_2.802198_g21695_i0 PRJNA737474 22372 437 2.802198 12.24560526 Pleomorphochaeta 1920504 Bacteria Bacteria 79.7 1.88e-15   NR MDC7244240.1 1920505 g21695 i0 55.4 1.33180778032037 65 28 43.9 1 324 133 107 171 MDC7244240.1 phosphoribosyltransferase [Pleomorphochaeta sp.] diamond 582 80.5 0.990062111801242 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Pleomorphochaeta Pleomorphochaeta sp.
33044175 33044175 PRJNA737474f_S_NODE_66716_length_318_cov_1.065306_g66038_i0 PRJNA737474 66716 318 1.065306 3.38767308 Leptospira 171 Bacteria Bacteria 123 1.72e-33   NR WP_135760341.1 1193500 g66038 i0 79.2 2.71698113207547 72 15 67.9 0 94 309 43 114 WP_135760341.1 VOC family protein [Leptospira idonii] diamond 864 124 0.991935483870968 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira idonii
33044372 33044372 PRJNA737474g_S_NODE_42340_length_441_cov_1.967391_g41050_i0 PRJNA737474 42340 441 1.967391 8.67619431 PVC group 1783257 Bacteria Bacteria 45.8 0.0228   NR WP_074931079.1 163 g41050 i0 21.8 6.22448979591837 133 103 90.5 1 9 407 36 167 WP_074931079.1 ABC transporter ATP-binding protein [Treponema bryantii] diamond 2745 46.2 0.991341991341991 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
33057573 33057573 PRJNA737474g_S_NODE_60157_length_384_cov_1.073955_g58864_i0 PRJNA737474 60157 384 1.073955 4.1239872 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 169 2.23e-46   NR MCF0237448.1 2791017 g58864 i0 58.3 0.9921875 127 53 99.2 0 382 2 285 411 MCF0237448.1 family 43 glycosylhydrolase [Sphaerochaetaceae bacterium] diamond 381 169 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
33073258 33073258 PRJNA737474f_S_NODE_229165_length_247_cov_1.327586_g228487_i0 PRJNA737474 229165 247 1.327586 3.27913742 Brachyspira catarrhinii 2528966 Bacteria Bacteria 46.2 0.0023   NR WP_137997320.1 2528966 g228487 i0 39 0.995951417004049 82 47 96 1 237 1 123 204 WP_137997320.1 hypothetical protein [Brachyspira catarrhinii] diamond 246 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira catarrhinii
33074253 33074253 PRJNA737474g_S_NODE_318485_length_251_cov_0.865169_g317191_i0 PRJNA737474 318485 251 0.865169 2.17157419 Leptospira ognonensis 2484945 Bacteria Bacteria 56.6 5.05e-7   NR WP_135625295.1 2484945 g317191 i0 36.9 3.14342629482072 84 40 86.1 2 238 23 198 280 WP_135625295.1 NHL repeat-containing protein [Leptospira ognonensis] diamond 789 56.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ognonensis
33095309 33095309 PRJNA737474f_S_NODE_18614_length_472_cov_1.736842_g17939_i0 PRJNA737474 18614 472 1.736842 8.19789424 Pseudomonadati 3379134 Bacteria Bacteria 60.1 3.4e-7   NR PKL30934.1 2013833 g17939 i0 31.7 3.05720338983051 123 76 77.5 4 77 442 62 177 PKL30934.1 MAG: hypothetical protein CVV45_15785 [Spirochaetae bacterium HGW-Spirochaetae-10] diamond 1443 60.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-10
33124405 33124405 PRJNA737474f_S_NODE_185487_length_255_cov_0.840659_g184809_i0 PRJNA737474 185487 255 0.840659 2.14368045 Leptospira sp. 178 Bacteria Bacteria 52 2.28e-5   NR MCZ8157590.1 178 g184809 i0 35.4 0.764705882352941 65 41 76.5 1 60 254 81 144 MCZ8157590.1 DASS family sodium-coupled anion symporter [Leptospira sp.] diamond 195 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
33124799 33124799 PRJNA737474f_S_NODE_64575_length_320_cov_1.639676_g63897_i0 PRJNA737474 64575 320 1.639676 5.2469632 Spirochaetales bacterium 2026792 Bacteria Bacteria 61.6 2.11e-8   NR HOX48843.1 2026792 g63897 i0 60 1.153125 50 20 46.9 0 270 121 174 223 HOX48843.1 ankyrin repeat domain-containing protein [Spirochaetales bacterium] diamond 369 61.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
33140587 33140587 PRJNA737474c_S_NODE_22071_length_264_cov_2.633508_g21240_i0 PRJNA737474 22071 264 2.633508 6.95246112 Pleomorphochaeta sp. 1920505 Bacteria Bacteria 63.2 3.06e-9   NR MDC7243778.1 1920505 g21240 i0 44.9 0.886363636363636 78 41 88.6 1 2 235 338 413 MDC7243778.1 hypothetical protein [Pleomorphochaeta sp.] diamond 234 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Pleomorphochaeta Pleomorphochaeta sp.
33159232 33159232 PRJNA737474g_S_NODE_196856_length_279_cov_0.932039_g195562_i0 PRJNA737474 196856 279 0.932039 2.60038881 Treponema berlinense 225004 Bacteria Bacteria 51.6 4.38e-5   NR WP_078931423.1 225004 g195562 i0 38.1 1.80645161290323 84 45 87.1 3 23 265 525 604 WP_078931423.1 DNA polymerase I [Treponema berlinense] diamond 504 51.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema berlinense
33163374 33163374 PRJNA737474f_S_NODE_153800_length_265_cov_2.182292_g153122_i0 PRJNA737474 153800 265 2.182292 5.7830738 Bacteria 2 Bacteria Bacteria 55.5 1.21e-6   NR MCK4542822.1 2026792 g153122 i0 42.6 6.24905660377359 61 35 69.1 0 242 60 18 78 MCK4542822.1 DnaJ domain-containing protein [Spirochaetales bacterium] diamond 1656 55.8 0.99462365591397806 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales 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);;