RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA520845 · 23 ✖

analysis 1

  • diamond · 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
13243773 13243773 PRJNA520845_P_NODE_200331_length_261_cov_1.638298_g198832_i0 PRJNA520845 200331 261 1.638298 4.27595778 Spirochaetae bacterium HGW-Spirochaetae-6 2013838 Bacteria Bacteria 143 6.3e-41   NR PKL13565.1 2013838 g198832 i0 81.2 13.6206896551724 85 16 97.7 0 6 260 123 207 PKL13565.1 MAG: adenosylhomocysteinase, partial [Spirochaetae bacterium HGW-Spirochaetae-6] diamond 3555 143 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-6
15794417 15794417 PRJNA520845_P_NODE_29193_length_707_cov_3.156151_g27771_i0 PRJNA520845 29193 707 3.156151 22.31398757 root 1 Root_unresolved Root_unresolved 254 2.38e-75   NR RKY03888.1 2202144 g27771 i0 68.8 5.54172560113154 186 58 78.9 0 145 702 5 190 RKY03888.1 MAG: pyruvate, phosphate dikinase [Spirochaetota bacterium] diamond 3918 254 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
19618432 19618432 PRJNA520845_P_NODE_56856_length_494_cov_3.394299_g55362_i0 PRJNA520845 56856 494 3.394299 16.76783706 Leptospiraceae bacterium 2026757 Bacteria Bacteria 166 2.35e-49   NR HNO24933.1 2026757 g55362 i0 93.8 0.582995951417004 96 6 58.3 0 492 205 52 147 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 288 166 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
22788617 22788617 PRJNA520845_P_NODE_207678_length_255_cov_1.692308_g206179_i0 PRJNA520845 207678 255 1.692308 4.3153854 Bacteria 2 Bacteria Bacteria 148 2.89e-40   NR WP_014804737.1 29510 g206179 i0 83.1 36.2 83 14 97.6 0 249 1 15 97 WP_014804737.1 adenosylhomocysteinase [Turneriella parva] diamond 9231 149 0.993288590604027 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva
26982327 26982327 PRJNA520845_P_NODE_176362_length_281_cov_0.918269_g174863_i0 PRJNA520845 176362 281 0.918269 2.58033589 Spirochaetia bacterium 2053615 Bacteria Bacteria 70.9 1.47e-13   NR MFO7729640.1 2053615 g174863 i0 62.7 0.629893238434164 59 21 61.9 1 106 279 11 69 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 177 70.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26982333 26982333 PRJNA520845_P_NODE_190502_length_269_cov_1.704082_g189003_i0 PRJNA520845 190502 269 1.704082 4.58398058 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 48.5 2.57e-4   NR MDR1230198.1 1898206 g189003 i0 35.9 1.88475836431227 64 41 71.4 0 48 239 63 126 MDR1230198.1 CAP domain-containing protein [Spirochaetaceae bacterium] diamond 507 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
27218809 27218809 PRJNA520845_P_NODE_95682_length_380_cov_1.003257_g94183_i0 PRJNA520845 95682 380 1.003257 3.8123766 Pseudomonadati 3379134 Bacteria Bacteria 52.4 7.14e-5   NR HNW29727.1 2202144 g94183 i0 35.7 1.43684210526316 84 50 63.2 1 327 88 482 565 HNW29727.1 adenylate/guanylate cyclase domain-containing protein [Spirochaetota bacterium] diamond 546 52.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27488108 27488108 PRJNA520845_P_NODE_185243_length_273_cov_2.500000_g183744_i0 PRJNA520845 185243 273 2.5 6.825 Spirochaetia bacterium 2053615 Bacteria Bacteria 171 1.71e-53   NR MFO7729640.1 2053615 g183744 i0 96.7 0.989010989010989 90 1 98.9 1 3 272 12 99 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 270 171 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27582661 27582661 PRJNA520845_P_NODE_126504_length_332_cov_1.189189_g125005_i0 PRJNA520845 126504 332 1.189189 3.94810748 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 75.9 2.63e-13   NR MCY4481588.1 1898206 g125005 i0 42.2 1.96987951807229 109 62 97.6 1 329 6 1594 1702 MCY4481588.1 SDR family NAD(P)-dependent oxidoreductase [Spirochaetaceae bacterium] diamond 654 75.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
27709610 27709610 PRJNA520845_P_NODE_96864_length_377_cov_2.608553_g95365_i0 PRJNA520845 96864 377 2.608553 9.83424481 Leptospiraceae bacterium 2026757 Bacteria Bacteria 78.2 2.05e-16   NR MCB1177358.1 2026757 g95365 i0 53.3 0.477453580901857 60 28 47.7 0 183 362 1 60 MCB1177358.1 hypothetical protein [Leptospiraceae bacterium] diamond 180 78.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27882225 27882225 PRJNA520845_P_NODE_172465_length_284_cov_0.914692_g170966_i0 PRJNA520845 172465 284 0.914692 2.59772528 root 1 Root_unresolved Root_unresolved 172 8.48e-49   NR WP_013314340.1 154 g170966 i0 88.3 61.5633802816901 94 11 99.3 0 2 283 18 111 WP_013314340.1 phosphoenolpyruvate mutase [Spirochaeta thermophila] diamond 17484 172 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Winmispirales Winmispiraceae Winmispira Winmispira thermophila
28435348 28435348 PRJNA520845_P_NODE_214506_length_251_cov_0.865169_g213007_i0 PRJNA520845 214506 251 0.865169 2.17157419 Spirochaetota bacterium 2202144 Bacteria Bacteria 126 5.9e-34   NR MBE3064887.1 2202144 g213007 i0 81.5 4.86454183266932 81 15 96.8 0 247 5 155 235 MBE3064887.1 ribokinase [Spirochaetota bacterium] diamond 1221 126 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28782477 28782477 PRJNA520845_P_NODE_70327_length_443_cov_1.959459_g68828_i0 PRJNA520845 70327 443 1.959459 8.68040337 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 59.7 1.21e-7   NR OHD18884.1 1802176 g68828 i0 36.4 1.53047404063205 118 65 73.1 2 25 348 14 131 OHD18884.1 MAG: hypothetical protein A2Y38_14560 [Spirochaetes bacterium GWB1_59_5] diamond 678 59.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
28940675 28940675 PRJNA520845_P_NODE_205328_length_257_cov_1.652174_g203829_i0 PRJNA520845 205328 257 1.652174 4.24608718 Spirochaetia bacterium 2053615 Bacteria Bacteria 84 7.57e-19   NR MFO7729640.1 2053615 g203829 i0 53.5 0.828793774319066 71 33 82.9 0 3 215 31 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 213 84 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28972096 28972096 PRJNA520845_P_NODE_123288_length_336_cov_1.326996_g121789_i0 PRJNA520845 123288 336 1.326996 4.45870656 Leptospiraceae bacterium 2026757 Bacteria Bacteria 69.3 5.28e-11   NR MCB1321430.1 2026757 g121789 i0 53.4 0.517857142857143 58 27 51.8 0 327 154 185 242 MCB1321430.1 carbonic anhydrase family protein [Leptospiraceae bacterium] diamond 174 69.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29555538 29555538 PRJNA520845_P_NODE_142010_length_313_cov_2.245833_g140511_i0 PRJNA520845 142010 313 2.245833 7.02945729 Pseudomonadati 3379134 Bacteria Bacteria 174 3.2599999999999996e-48   NR MCD6121863.1 2026792 g140511 i0 80.8 19.7348242811502 104 20 99.7 0 312 1 194 297 MCD6121863.1 pyruvate, phosphate dikinase [Spirochaetales bacterium] diamond 6177 174 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29649966 29649966 PRJNA520845_P_NODE_135390_length_321_cov_1.241935_g133891_i0 PRJNA520845 135390 321 1.241935 3.98661135 root 1 Root_unresolved Root_unresolved 46.6 2.94e-4   NR WP_335851018.1 84377 g133891 i0 46.7 1.38317757009346 45 22 42.1 1 310 176 20 62 WP_335851018.1 ankyrin repeat domain-containing protein, partial [Brachyspira intermedia] diamond 444 47 0.991489361702128 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira intermedia
29856184 29856184 PRJNA520845_P_NODE_70511_length_443_cov_1.002703_g69012_i0 PRJNA520845 70511 443 1.002703 4.44197429 Spirochaetota bacterium 2202144 Bacteria Bacteria 57 2.12e-6   NR MDR2733537.1 2202144 g69012 i0 33.3 6.46049661399549 120 69 73.8 3 401 75 82 201 MDR2733537.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 2862 57 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30551108 30551108 PRJNA520845_P_NODE_259233_length_242_cov_0.970414_g257734_i0 PRJNA520845 259233 242 0.970414 2.34840188 Spirochaetia bacterium 2053615 Bacteria Bacteria 61.6 3.87e-10   NR MFO7729640.1 2053615 g257734 i0 63 0.570247933884298 46 16 57 1 69 206 11 55 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 138 61.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31151063 31151063 PRJNA520845_P_NODE_138335_length_318_cov_0.942857_g136836_i0 PRJNA520845 138335 318 0.942857 2.99828526 Leptospira sp. 96542 3034711 Bacteria Bacteria 49.7 2.27e-4   NR MDF3821455.1 3034711 g136836 i0 61.4 0.415094339622642 44 15 39.6 2 276 151 133 176 MDF3821455.1 NAD-dependent epimerase/dehydratase family protein [Leptospira sp. 96542] diamond 132 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. 96542
31878712 31878712 PRJNA520845_P_NODE_102877_length_367_cov_1.044218_g101378_i0 PRJNA520845 102877 367 1.044218 3.83228006 Turneriella sp. 2717305 Bacteria Bacteria 63.2 9.83e-9   NR MFO1471462.1 2717305 g101378 i0 41.3 0.514986376021798 63 37 51.5 0 96 284 54 116 MFO1471462.1 CDP-alcohol phosphatidyltransferase family protein [Turneriella sp.] diamond 189 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella sp.
32290693 32290693 PRJNA520845_P_NODE_252659_length_244_cov_0.900585_g251160_i0 PRJNA520845 252659 244 0.900585 2.1974274 Spirochaetia bacterium 2053615 Bacteria Bacteria 50.8 6.44e-6   NR MFO7729640.1 2053615 g251160 i0 50 0.540983606557377 44 22 54.1 0 158 27 56 99 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 132 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32305917 32305917 PRJNA520845_P_NODE_150399_length_304_cov_2.000000_g148900_i0 PRJNA520845 150399 304 2 6.08 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 48.9 5.07e-4   NR MCK4796264.1 2202144 g148900 i0 44 1.46052631578947 50 27 48.4 1 6 152 144 193 MCK4796264.1 6-bladed beta-propeller [Spirochaetota bacterium] diamond 444 49.3 0.991886409736308 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);;