RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA796753" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA796753 · 23 ✖

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
3768326 3768326 PRJNA796753_P_NODE_10623_length_426_cov_1.025496_g10311_i0 PRJNA796753 10623 426 1.025496 4.36861296 Treponema 157 Bacteria Bacteria 771 0   NTclustered gi|1807378492|gb|CP048020.1| 69710 g10311 i0 99.296 196.544600938967 426 3 100 0 1 426 2739055 2739480 Treponema vincentii strain OMZ 804 chromosome, complete genome blastn 83728 771 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
4609186 4609186 PRJNA796753_P_NODE_53564_length_241_cov_1.232143_g53252_i0 PRJNA796753 53564 241 1.232143 2.96946463 Treponema medium 58231 Bacteria Bacteria 427 3.079999999999999e-115   NTclustered gi|1996296230|gb|CP031393.1| 58231 g53252 i0 98.75 187.074688796681 240 3 99 0 2 241 1012976 1012737 Treponema medium strain ATCC 700293 chromosome, complete genome blastn 45085 427 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
8869866 8869866 PRJNA796753_P_NODE_28387_length_285_cov_1.566038_g28075_i0 PRJNA796753 28387 285 1.566038 4.4632083 Treponema 157 Bacteria Bacteria 516 7.77e-142   NTclustered gi|923140915|gb|KP101520.1| 166 g28075 i0 99.298 111.00350877193 285 2 100 0 1 285 1374 1090 Treponema sp. strain OMZ 804 16S ribosomal RNA gene, complete sequence blastn 31636 521 0.990403071017274 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
16519633 16519633 PRJNA796753_P_NODE_48113_length_245_cov_0.895349_g47801_i0 PRJNA796753 48113 245 0.895349 2.19360505 Treponema 157 Bacteria Bacteria 396 8.869999999999996e-106   NTclustered gi|1996291085|gb|CP027017.1| 58231 g47801 i0 95.951 83.0979591836735 247 4 100 4 1 245 1012117 1011875 Treponema medium strain T19 chromosome, complete genome blastn 20359 396 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
17794349 17794349 PRJNA796753_P_NODE_15534_length_363_cov_1.227586_g15222_i0 PRJNA796753 15534 363 1.227586 4.45613718 Treponema 157 Bacteria Bacteria 619 7.529999999999998e-173   NTclustered gi|2265127813|gb|CP051195.1| 120682 g15222 i0 97.521 190.457300275482 363 8 100 1 1 363 1961721 1962082 Treponema sp. OMZ 803 strain BF2M chromosome, complete genome blastn 69136 625 0.9904 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 803
18632091 18632091 PRJNA796753_P_NODE_18335_length_340_cov_1.910112_g18023_i0 PRJNA796753 18335 340 1.910112 6.4943808 Bacteria 2 Bacteria Bacteria 205 1.57e-60   NR MDA8408818.1 166 g18023 i0 82.3 54.7852941176471 113 20 99.7 0 339 1 190 302 MDA8408818.1 phosphoenolpyruvate carboxykinase (GTP) [Treponema sp.] diamond 18627 206 0.995145631067961 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26990320 26990320 PRJNA796753_P_NODE_29222_length_283_cov_0.961905_g28910_i0 PRJNA796753 29222 283 0.961905 2.72219115 Borrelia coriaceae ATCC 43381 1408429 Bacteria Bacteria 40.4 0.029   NR AHH10659.1 1408429 g28910 i0 54.2 0.254416961130742 24 11 25.4 0 179 250 12 35 AHH10659.1 hypothetical protein BCO_0900010 [Borrelia coriaceae ATCC 43381] diamond 72 40.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia coriaceae
27686028 27686028 PRJNA796753_P_NODE_37424_length_255_cov_1.631868_g37112_i0 PRJNA796753 37424 255 1.631868 4.1612634 Treponema sp. 166 Bacteria Bacteria 41.6 0.0276   NR MCL2065853.1 166 g37112 i0 41.7 0.705882352941177 60 23 56.5 2 218 75 30 89 MCL2065853.1 4Fe-4S binding protein [Treponema sp.] diamond 180 41.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27717681 27717681 PRJNA796753_P_NODE_38124_length_253_cov_1.283333_g37812_i0 PRJNA796753 38124 253 1.283333 3.24683249 Spirochaetales bacterium 2026792 Bacteria Bacteria 68.6 1.84e-12   NR NNM55191.1 2026792 g37812 i0 54.2 1.39920948616601 59 27 70 0 253 77 45 103 NNM55191.1 globin [Spirochaetales bacterium] diamond 354 68.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27906427 27906427 PRJNA796753_P_NODE_14805_length_370_cov_1.390572_g14493_i0 PRJNA796753 14805 370 1.390572 5.1451164 Treponema sp. 166 Bacteria Bacteria 113 3.28e-26   NR MDR1985538.1 166 g14493 i0 50.9 0.908108108108108 112 52 89.2 2 1 330 591 701 MDR1985538.1 methionine--tRNA ligase [Treponema sp.] diamond 336 113 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28001618 28001618 PRJNA796753_P_NODE_50665_length_243_cov_1.270588_g50353_i0 PRJNA796753 50665 243 1.270588 3.08752884 Spirochaetia bacterium 2053615 Bacteria Bacteria 43.5 0.0201   NR MCI6258456.1 2053615 g50353 i0 36.7 0.740740740740741 60 38 74.1 0 28 207 282 341 MCI6258456.1 pallilysin-related adhesin [Spirochaetia bacterium] diamond 180 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28033131 28033131 PRJNA796753_P_NODE_1525_length_1009_cov_1.930556_g1323_i0 PRJNA796753 1525 1009 1.930556 19.47931004 Leptospiraceae bacterium 2026757 Bacteria Bacteria 70.9 1.07e-10   NR MCB1309187.1 2026757 g1323 i0 38.4 0.906838453914767 99 57 28.5 3 957 670 40 137 MCB1309187.1 hypothetical protein [Leptospiraceae bacterium] diamond 915 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28578994 28578994 PRJNA796753_P_NODE_37967_length_253_cov_1.711111_g37655_i0 PRJNA796753 37967 253 1.711111 4.32911083 root 1 Root_unresolved Root_unresolved 50.4 7.89e-5   NR MCK5266708.1 2202144 g37655 i0 42 1.76679841897233 69 34 78.3 2 9 206 44 109 MCK5266708.1 PKD domain-containing protein [Spirochaetota bacterium] diamond 447 50.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30116904 30116904 PRJNA796753_P_NODE_12692_length_394_cov_1.691589_g12380_i0 PRJNA796753 12692 394 1.691589 6.66486066 Treponema sp. GWA1_62_8 1802378 Bacteria Bacteria 212 7.27e-67   NR OHE64650.1 1802378 g12380 i0 74 0.99746192893401 131 34 99.7 0 394 2 61 191 OHE64650.1 MAG: phosphoglyceromutase [Treponema sp. GWA1_62_8] diamond 393 212 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. GWA1_62_8
30243532 30243532 PRJNA796753_P_NODE_18892_length_337_cov_0.901515_g18580_i0 PRJNA796753 18892 337 0.901515 3.03810555 Spirochaetota bacterium 2202144 Bacteria Bacteria 80.5 5.71e-15   NR MDH5681529.1 2202144 g18580 i0 52.5 8.0919881305638 80 38 71.2 0 285 46 375 454 MDH5681529.1 aspartate kinase [Spirochaetota bacterium] diamond 2727 80.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30464992 30464992 PRJNA796753_P_NODE_29133_length_283_cov_1.319048_g28821_i0 PRJNA796753 29133 283 1.319048 3.73290584 Spirochaetota bacterium 2202144 Bacteria Bacteria 128 1.57e-35   NR MBP9044356.1 2202144 g28821 i0 60.2 1.98233215547703 93 37 98.6 0 279 1 51 143 MBP9044356.1 SET domain-containing protein-lysine N-methyltransferase [Spirochaetota bacterium] diamond 561 128 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30473865 30473865 PRJNA796753_P_NODE_1193_length_1115_cov_3.121881_g1016_i0 PRJNA796753 1193 1115 3.121881 34.80897315 Bacteria 2 Bacteria Bacteria 134 3.41e-30   NR MBQ7882329.1 166 g1016 i0 34.3 2.12825112107623 277 144 72.6 13 71 880 36 281 MBQ7882329.1 carbohydrate binding domain-containing protein [Treponema sp.] diamond 2373 134 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30685625 30685625 PRJNA796753_P_NODE_27873_length_287_cov_1.369159_g27561_i0 PRJNA796753 27873 287 1.369159 3.92948633 Spirochaetales bacterium 2026792 Bacteria Bacteria 88.6 4.98e-19   NR MBT89746.1 2026792 g27561 i0 53.4 4.56794425087108 88 40 92 1 265 2 147 233 MBT89746.1 beta-ketoacyl-ACP reductase [Spirochaetales bacterium] diamond 1311 88.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31136943 31136943 PRJNA796753_P_NODE_34955_length_263_cov_2.289474_g34643_i0 PRJNA796753 34955 263 2.289474 6.02131662 Pseudomonadati 3379134 Bacteria Bacteria 141 9.399999999999999e-39   NR WP_135648863.1 2484943 g34643 i0 77 6.92395437262357 87 20 99.2 0 3 263 60 146 WP_135648863.1 NAD(P)-dependent alcohol dehydrogenase [Leptospira sarikeiensis] diamond 1821 141 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sarikeiensis
31159324 31159324 PRJNA796753_P_NODE_2175_length_881_cov_3.315594_g1926_i0 PRJNA796753 2175 881 3.315594 29.21038314 Leptospiraceae bacterium 2026757 Bacteria Bacteria 126 1.5e-31   NR MDX1959828.1 2026757 g1926 i0 40.9 1.61407491486947 154 78 51.8 4 746 291 54 196 MDX1959828.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 1422 126 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31190939 31190939 PRJNA796753_P_NODE_19975_length_329_cov_1.804688_g19663_i0 PRJNA796753 19975 329 1.804688 5.93742352 Spirochaetes bacterium RIFOXYB1_FULL_32_8 1802197 Bacteria Bacteria 54.3 8.53e-6   NR OHD79183.1 1802197 g19663 i0 37.5 1.93313069908815 72 43 65.7 1 101 316 90 159 OHD79183.1 MAG: hypothetical protein A2355_15330, partial [Spirochaetes bacterium RIFOXYB1_FULL_32_8] diamond 636 54.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RIFOXYB1_FULL_32_8
32140302 32140302 PRJNA796753_P_NODE_11338_length_414_cov_3.568915_g11026_i0 PRJNA796753 11338 414 3.568915 14.7753081 Spirochaeta cellobiosiphila 504483 Bacteria Bacteria 102 1.9e-25   NR WP_028972830.1 504483 g11026 i0 57 2.57971014492754 79 34 57.2 0 108 344 3 81 WP_028972830.1 RNA recognition motif domain-containing protein [Spirochaeta cellobiosiphila] diamond 1068 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta cellobiosiphila
32866489 32866489 PRJNA796753_P_NODE_49760_length_244_cov_0.900585_g49448_i0 PRJNA796753 49760 244 0.900585 2.1974274 Leptospiraceae bacterium 2026757 Bacteria Bacteria 44.3 0.0104   NR HNO27018.1 2026757 g49448 i0 34.7 1.77049180327869 72 45 88.5 1 222 7 42 111 HNO27018.1 AAA family ATPase [Leptospiraceae bacterium] diamond 432 44.3 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);;