RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA835051", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 16 ✖

tax_phylum 1

  • Spirochaetota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA835051 · 16 ✖

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
3376736 3376736 PRJNA835051_S_NODE_33843_length_242_cov_2.170854_g33547_i0 PRJNA835051 33843 242 2.170854 5.25346668 Treponema sp. 166 Bacteria Bacteria 83.6 5.43e-18   NR MBR0545750.1 166 g33547 i0 97.6 0.520661157024793 42 1 52.1 0 242 117 131 172 MBR0545750.1 hypothetical protein [Treponema sp.] diamond 126 83.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
17404991 17404991 PRJNA835051_S_NODE_97774_length_171_cov_1.125000_g97478_i0 PRJNA835051 97774 171 1.125 1.92375 Thiospirochaeta perfilievii 252967 Bacteria Bacteria 54.7 0.004   NTclustered gi|1735508175|gb|CP035807.1| 252967 g97478 i0 100 0.169590643274854 29 0 17 0 141 169 155956 155984 Thiospirochaeta perfilievii strain P chromosome, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Thiospirochaeta Thiospirochaeta perfilievii
26865055 26865055 PRJNA835051_S_NODE_104581_length_166_cov_1.626016_g104285_i0 PRJNA835051 104581 166 1.626016 2.69918656 Treponema sp. 166 Bacteria Bacteria 114 1.12e-27   NR MBQ5906876.1 166 g104285 i0 100 0.993975903614458 55 0 99.4 0 166 2 1259 1313 MBQ5906876.1 phosphoribosylformylglycinamidine synthase [Treponema sp.] diamond 165 114 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27497111 27497111 PRJNA835051_S_NODE_55143_length_210_cov_1.694611_g54847_i0 PRJNA835051 55143 210 1.694611 3.5586831 Treponema sp. 166 Bacteria Bacteria 136 2.93e-38   NR MBQ1175205.1 166 g54847 i0 98.6 1 70 1 100 0 1 210 87 156 MBQ1175205.1 CPBP family intramembrane metalloprotease [Treponema sp.] diamond 210 136 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28002372 28002372 PRJNA835051_S_NODE_125465_length_153_cov_2.181818_g125169_i0 PRJNA835051 125465 153 2.181818 3.33818154 Borreliella garinii 29519 Bacteria Bacteria 40 0.0147   NR WP_210380402.1 29519 g125169 i0 69 0.568627450980392 29 9 56.9 0 66 152 2 30 WP_210380402.1 hypothetical protein, partial [Borreliella garinii] diamond 87 40 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii
28128641 28128641 PRJNA835051_S_NODE_57145_length_207_cov_3.884146_g56849_i0 PRJNA835051 57145 207 3.884146 8.04018222 Treponema sp. 166 Bacteria Bacteria 117 6.91e-32   NR MBQ2234740.1 166 g56849 i0 91.3 1 69 6 100 0 207 1 44 112 MBQ2234740.1 hypothetical protein [Treponema sp.] diamond 207 117 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28231452 28231452 PRJNA835051_S_NODE_15206_length_295_cov_1.698413_g14910_i0 PRJNA835051 15206 295 1.698413 5.01031835 Bacteria 2 Bacteria Bacteria 135 1.21e-37   NR MBE6351053.1 1898206 g14910 i0 71.6 6.30508474576271 88 25 89.5 0 291 28 130 217 MBE6351053.1 hypothetical protein [Spirochaetaceae bacterium] diamond 1860 136 0.992647058823529 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28254674 28254674 PRJNA835051_S_NODE_96966_length_171_cov_2.484375_g96670_i0 PRJNA835051 96966 171 2.484375 4.24828125 Treponema sp. 166 Bacteria Bacteria 100 1.47e-23   NR MCR5079764.1 166 g96670 i0 98.2 0.982456140350877 56 1 98.2 0 3 170 64 119 MCR5079764.1 calcium/sodium antiporter [Treponema sp.] diamond 168 100 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28381065 28381065 PRJNA835051_S_NODE_75786_length_188_cov_2.406897_g75490_i0 PRJNA835051 75786 188 2.406897 4.52496636 Borreliella garinii 29519 Bacteria Bacteria 40.8 0.0141   NR WP_369122472.1 29519 g75490 i0 47.1 0.813829787234043 51 25 78.2 1 5 151 19 69 WP_369122472.1 reverse transcriptase domain-containing protein [Borreliella garinii] diamond 153 40.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii
28412752 28412752 PRJNA835051_S_NODE_81346_length_183_cov_3.285714_g81050_i0 PRJNA835051 81346 183 3.285714 6.01285662 Treponema sp. 166 Bacteria Bacteria 123 2.49e-31   NR MEE1166669.1 166 g81050 i0 100 0.983606557377049 60 0 98.4 0 181 2 202 261 MEE1166669.1 histidine kinase N-terminal 7TM domain-containing protein [Treponema sp.] diamond 180 123 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29170575 29170575 PRJNA835051_S_NODE_78849_length_186_cov_0.832168_g78553_i0 PRJNA835051 78849 186 0.832168 1.54783248 Borreliella bavariensis 664662 Bacteria Bacteria 43.9 0.00161   NR WP_223147374.1 664662 g78553 i0 44.7 0.612903225806452 38 21 61.3 0 140 27 46 83 WP_223147374.1 hypothetical protein, partial [Borreliella bavariensis] diamond 114 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella bavariensis
29517638 29517638 PRJNA835051_S_NODE_124190_length_154_cov_1.621622_g123894_i0 PRJNA835051 124190 154 1.621622 2.49729788 Borreliella garinii 29519 Bacteria Bacteria 45.4 2.87e-4   NR WP_234932126.1 29519 g123894 i0 61.3 0.603896103896104 31 11 60.4 1 134 42 40 69 WP_234932126.1 hypothetical protein, partial [Borreliella garinii] diamond 93 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii
30789804 30789804 PRJNA835051_S_NODE_119334_length_157_cov_1.254386_g119038_i0 PRJNA835051 119334 157 1.254386 1.96938602 Treponema 157 Bacteria Bacteria 72.4 3.61e-15   NR MDD6654372.1 166 g119038 i0 97.3 2.12101910828025 37 1 70.7 0 155 45 40 76 MDD6654372.1 winged helix-turn-helix transcriptional regulator [Treponema sp.] diamond 333 72.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31508508 31508508 PRJNA835051_S_NODE_55996_length_209_cov_1.542169_g55700_i0 PRJNA835051 55996 209 1.542169 3.22313321 uncultured Treponema sp. 162155 Bacteria Bacteria 74.7 1.23e-13   NR WP_294428913.1 162155 g55700 i0 53.7 1.90909090909091 67 31 96.2 0 204 4 167 233 WP_294428913.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [uncultured Treponema sp.] diamond 399 74.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
32109421 32109421 PRJNA835051_S_NODE_92138_length_175_cov_1.431818_g91842_i0 PRJNA835051 92138 175 1.431818 2.5056815 Treponema sp. 166 Bacteria Bacteria 121 1.0599999999999998e-31   NR MBP3561436.1 166 g91842 i0 98.3 0.994285714285714 58 1 99.4 0 174 1 222 279 MBP3561436.1 alpha/beta hydrolase [Treponema sp.] diamond 174 121 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32267755 32267755 PRJNA835051_S_NODE_1398_length_592_cov_14.131148_g1142_i0 PRJNA835051 1398 592 14.131148 83.65639616 Leptospira interrogans 173 Bacteria Bacteria 76.6 9.24e-15   NR WP_181743529.1 173 g1142 i0 63.5 0.319256756756757 63 23 31.9 0 367 179 5 67 WP_181743529.1 hypothetical protein [Leptospira interrogans] diamond 189 76.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans

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);;