RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1249042" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1249042 · 20 ✖

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
5457862 5457862 PRJNA1249042_S_NODE_38125_length_227_cov_1.788043_g37911_i0 PRJNA1249042 38125 227 1.788043 4.05885761 Treponema bryantii 163 Bacteria Bacteria 292 1.0899999999999999e-74   NTclustered gi|2581915939|dbj|AP025286.1| 163 g37911 i0 89.868 1 227 23 100 0 1 227 500893 501119 Treponema bryantii JCM 32280 DNA, complete genome blastn 227 292 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
6732279 6732279 PRJNA1249042_S_NODE_45846_length_215_cov_3.912791_g45632_i0 PRJNA1249042 45846 215 3.912791 8.41250065 Treponema sp. 166 Bacteria Bacteria 224 3.8e-54   NTclustered gi|2189480979|gb|CP091737.1| 166 g45632 i0 93.421 32.4976744186047 152 8 87 2 41 192 1830582 1830731 MAG: Treponema sp. isolate nC27_bin.160.fa chromosome blastn 6987 224 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
15657211 15657211 PRJNA1249042_S_NODE_17453_length_272_cov_3.489083_g17239_i0 PRJNA1249042 17453 272 3.489083 9.49030576 Treponema sp. 166 Bacteria Bacteria 180 1.6899999999999996e-55   NR MBQ5646496.1 166 g17239 i0 100 1.98529411764706 90 0 99.3 0 1 270 39 128 MBQ5646496.1 HD domain-containing protein [Treponema sp.] diamond 540 180 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26852374 26852374 PRJNA1249042_S_NODE_100481_length_161_cov_1.593220_g100267_i0 PRJNA1249042 100481 161 1.59322 2.5650842 Leptospira borgpetersenii 174 Bacteria Bacteria 53.9 2.12e-7   NR WP_228003977.1 174 g100267 i0 54.2 5.88819875776398 48 22 89.4 0 161 18 13 60 WP_228003977.1 hypothetical protein, partial [Leptospira borgpetersenii] diamond 948 53.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira borgpetersenii
27579120 27579120 PRJNA1249042_S_NODE_44484_length_217_cov_3.091954_g44270_i0 PRJNA1249042 44484 217 3.091954 6.70954018 Treponema sp. 166 Bacteria Bacteria 138 8.09e-39   NR MBR0544620.1 166 g44270 i0 100 0.995391705069124 72 0 99.5 0 1 216 52 123 MBR0544620.1 LPS export ABC transporter periplasmic protein LptC [Treponema sp.] diamond 216 138 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28084261 28084261 PRJNA1249042_S_NODE_114245_length_152_cov_0.880734_g114031_i0 PRJNA1249042 114245 152 0.880734 1.33871568 Treponema sp. 166 Bacteria Bacteria 110 6.65e-28   NR MBQ1174811.1 166 g114031 i0 100 0.986842105263158 50 0 98.7 0 2 151 13 62 MBQ1174811.1 M28 family peptidase [Treponema sp.] diamond 150 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28336947 28336947 PRJNA1249042_S_NODE_113006_length_152_cov_2.642202_g112792_i0 PRJNA1249042 113006 152 2.642202 4.01614704 Treponema sp. 166 Bacteria Bacteria 102 1.3899999999999998e-23   NR MBQ5908680.1 166 g112792 i0 100 0.986842105263158 50 0 98.7 0 2 151 797 846 MBQ5908680.1 endopeptidase La [Treponema sp.] diamond 150 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29536763 29536763 PRJNA1249042_S_NODE_56790_length_202_cov_0.905660_g56576_i0 PRJNA1249042 56790 202 0.90566 1.8294332 uncultured Treponema sp. 162155 Bacteria Bacteria 134 1.77e-36   NR WP_308690280.1 162155 g56576 i0 95.5 0.995049504950495 67 3 99.5 0 1 201 124 190 WP_308690280.1 hypothetical protein [uncultured Treponema sp.] diamond 201 134 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
29915869 29915869 PRJNA1249042_S_NODE_86291_length_172_cov_2.550388_g86077_i0 PRJNA1249042 86291 172 2.550388 4.38666736 Spirochaetales bacterium 2026792 Bacteria Bacteria 41.6 0.0378   NR NNM53122.1 2026792 g86077 i0 42.9 0.854651162790698 49 28 85.5 0 17 163 121 169 NNM53122.1 hypothetical protein [Spirochaetales bacterium] diamond 147 41.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29997060 29997060 PRJNA1249042_S_NODE_86071_length_172_cov_3.720930_g85857_i0 PRJNA1249042 86071 172 3.72093 6.3999996 Treponema 157 Bacteria Bacteria 108 1.3199999999999999e-28   NR WP_287045960.1 166 g85857 i0 94.6 2.93023255813953 56 3 97.7 0 3 170 69 124 WP_287045960.1 hypothetical protein [Treponema sp.] diamond 504 109 0.990825688073395 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30231633 30231633 PRJNA1249042_S_NODE_66372_length_191_cov_2.222973_g66158_i0 PRJNA1249042 66372 191 2.222973 4.24587843 Treponema sp. 166 Bacteria Bacteria 119 9.76e-31   NR MBQ5908584.1 166 g66158 i0 100 0.989528795811518 63 0 99 0 1 189 102 164 MBQ5908584.1 alpha/beta hydrolase [Treponema sp.] diamond 189 119 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30390031 30390031 PRJNA1249042_S_NODE_79013_length_179_cov_1.382353_g78799_i0 PRJNA1249042 79013 179 1.382353 2.47441187 Treponema sp. 166 Bacteria Bacteria 109 4.4e-26   NR MBQ5999559.1 166 g78799 i0 93.2 0.988826815642458 59 4 98.9 0 179 3 458 516 MBQ5999559.1 ABC transporter ATP-binding protein [Treponema sp.] diamond 177 109 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30691922 30691922 PRJNA1249042_S_NODE_102133_length_160_cov_1.205128_g101919_i0 PRJNA1249042 102133 160 1.205128 1.9282048 Bacteria 2 Bacteria Bacteria 102 2.65e-25   NR MBQ5907760.1 166 g101919 i0 100 3.9 52 0 97.5 0 158 3 4 55 MBQ5907760.1 Rpn family recombination-promoting nuclease/putative transposase [Treponema sp.] diamond 624 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31053395 31053395 PRJNA1249042_S_NODE_16895_length_274_cov_3.865801_g16681_i0 PRJNA1249042 16895 274 3.865801 10.59229474 Treponema porcinum 261392 Bacteria Bacteria 178 1.16e-51   NR WP_078931959.1 261392 g16681 i0 100 0.996350364963504 91 0 99.6 0 2 274 21 111 WP_078931959.1 hypothetical protein [Treponema porcinum] diamond 273 178 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema porcinum
31210599 31210599 PRJNA1249042_S_NODE_91375_length_168_cov_1.536000_g91161_i0 PRJNA1249042 91375 168 1.536 2.58048 Treponema sp. 166 Bacteria Bacteria 95.9 2.4199999999999998e-23   NR MBQ5908591.1 166 g91161 i0 97.9 0.857142857142857 48 1 85.7 0 149 6 1 48 MBQ5908591.1 hypothetical protein [Treponema sp.] diamond 144 95.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31337499 31337499 PRJNA1249042_S_NODE_49016_length_211_cov_2.315476_g48802_i0 PRJNA1249042 49016 211 2.315476 4.88565436 Treponema primitia 88058 Bacteria Bacteria 42 0.0438   NR WP_010262386.1 88058 g48802 i0 38.2 0.966824644549763 68 38 91 1 15 206 28 95 WP_010262386.1 acyltransferase family protein [Treponema primitia] diamond 204 42 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema primitia
31812083 31812083 PRJNA1249042_S_NODE_31457_length_238_cov_3.374359_g31243_i0 PRJNA1249042 31457 238 3.374359 8.03097442 Treponema sp. 166 Bacteria Bacteria 103 1.87e-23   NR MEE0885554.1 166 g31243 i0 81.7 0.756302521008403 60 11 75.6 0 58 237 1 60 MEE0885554.1 hypothetical protein [Treponema sp.] diamond 180 103 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31988212 31988212 PRJNA1249042_S_NODE_28478_length_244_cov_3.039801_g28264_i0 PRJNA1249042 28478 244 3.039801 7.41711444 Treponema 157 Bacteria Bacteria 154 5.04e-44   NR MBQ6566758.1 166 g28264 i0 86.4 4.97950819672131 81 11 99.6 0 243 1 151 231 MBQ6566758.1 HTH domain-containing protein [Treponema sp.] diamond 1215 155 0.993548387096774 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32697197 32697197 PRJNA1249042_S_NODE_65380_length_192_cov_2.389262_g65166_i0 PRJNA1249042 65380 192 2.389262 4.58738304 Treponema sp. 166 Bacteria Bacteria 130 1.7299999999999998e-35   NR MEE1212642.1 166 g65166 i0 100 0.984375 63 0 98.4 0 3 191 127 189 MEE1212642.1 UPF0158 family protein [Treponema sp.] diamond 189 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32854687 32854687 PRJNA1249042_S_NODE_68140_length_189_cov_2.445205_g67926_i0 PRJNA1249042 68140 189 2.445205 4.62143745 Spirochaetia bacterium 2053615 Bacteria Bacteria 124 2.44e-35   NR MCI6317124.1 2053615 g67926 i0 96.8 1 63 2 100 0 189 1 7 69 MCI6317124.1 ATP-dependent Clp protease adaptor ClpS [Spirochaetia bacterium] diamond 189 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia 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);;