RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where bioproject = "PRJNA662254" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 33 ✖

tax_kingdom 1

bioproject 1

  • PRJNA662254 · 33 ✖

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
8281438 8281438 PRJNA662254_P_NODE_27267_length_317_cov_1.262295_g26616_i0 PRJNA662254 27267 317 1.262295 4.00147515 Bacteria 2 Bacteria Bacteria 204 3.79e-59   NR MDP3177268.1 1898206 g26616 i0 90.5 4.96845425867508 105 10 99.4 0 3 317 338 442 MDP3177268.1 DNA-directed RNA polymerase subunit beta [Spirochaetaceae bacterium] diamond 1575 204 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
10090567 10090567 PRJNA662254_P_NODE_61968_length_243_cov_0.905882_g61317_i0 PRJNA662254 61968 243 0.905882 2.20129326 Spirochaetia bacterium 2053615 Bacteria Bacteria 110 7.17e-26   NR HRY54358.1 2053615 g61317 i0 64.6 1.18518518518519 96 18 98.8 1 242 3 384 479 HRY54358.1 3'-5' exonuclease [Spirochaetia bacterium] diamond 288 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
12107671 12107671 PRJNA662254_P_NODE_47390_length_250_cov_0.870056_g46739_i0 PRJNA662254 47390 250 0.870056 2.17514 Spirochaetales bacterium 2026792 Bacteria Bacteria 131 4.1799999999999995e-35   NR MEI8094335.1 2026792 g46739 i0 74.4 0.984 82 21 98.4 0 5 250 157 238 MEI8094335.1 SDR family NAD(P)-dependent oxidoreductase [Spirochaetales bacterium] diamond 246 131 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
17206391 17206391 PRJNA662254_P_NODE_57414_length_245_cov_0.895349_g56763_i0 PRJNA662254 57414 245 0.895349 2.19360505 Spirochaetota bacterium 2202144 Bacteria Bacteria 161 5.51e-46   NR MEI6876724.1 2202144 g56763 i0 91.4 4.95918367346939 81 7 99.2 0 2 244 188 268 MEI6876724.1 BMP family ABC transporter substrate-binding protein [Spirochaetota bacterium] diamond 1215 161 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
19013518 19013518 PRJNA662254_P_NODE_47855_length_250_cov_0.870056_g47204_i0 PRJNA662254 47855 250 0.870056 2.17514 Spirochaetota bacterium 2202144 Bacteria Bacteria 158 6.849999999999999e-45   NR HMB01236.1 2202144 g47204 i0 89.2 1.992 83 9 99.6 0 1 249 287 369 HMB01236.1 elongation factor Tu [Spirochaetota bacterium] diamond 498 158 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
21030972 21030972 PRJNA662254_P_NODE_65617_length_241_cov_0.916667_g64966_i0 PRJNA662254 65617 241 0.916667 2.20916747 Spirochaetia bacterium 2053615 Bacteria Bacteria 52.8 0.022   NTclustered gi|2907625705|emb|OZ223265.1| 2053615 g64966 i0 100 0.116182572614108 28 0 12 0 158 185 139173 139146 MAG: Spirochaetia bacterium isolate 50ab941f-e521-41e2-bb97-00a459704a5b genome assembly, chromosome: 2 blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
22305593 22305593 PRJNA662254_P_NODE_45658_length_251_cov_0.865169_g45007_i0 PRJNA662254 45658 251 0.865169 2.17157419 Spirochaetia bacterium 2053615 Bacteria Bacteria 121 4.3000000000000004e-30   NR MCF7943624.1 2053615 g45007 i0 69.9 6.94422310756972 83 25 99.2 0 1 249 184 266 MCF7943624.1 carbohydrate kinase [Spirochaetia bacterium] diamond 1743 121 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
26606401 26606401 PRJNA662254_P_NODE_55881_length_246_cov_0.890173_g55230_i0 PRJNA662254 55881 246 0.890173 2.18982558 Rectinemataceae bacterium 3064674 Bacteria Bacteria 135 8.71e-36   NR HTX74032.1 3064674 g55230 i0 92 1.89024390243902 75 6 91.5 0 1 225 97 171 HTX74032.1 chemotaxis protein CheW [Rectinemataceae bacterium] diamond 465 135 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
26669635 26669635 PRJNA662254_P_NODE_47621_length_250_cov_0.870056_g46970_i0 PRJNA662254 47621 250 0.870056 2.17514 Rectinemataceae bacterium 3064674 Bacteria Bacteria 160 1.86e-45   NR HUX38341.1 3064674 g46970 i0 97.6 3.924 82 2 98.4 0 248 3 75 156 HUX38341.1 ABC transporter substrate-binding protein [Rectinemataceae bacterium] diamond 981 160 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
27018136 27018136 PRJNA662254_P_NODE_53062_length_247_cov_0.885057_g52411_i0 PRJNA662254 53062 247 0.885057 2.18609079 Rectinemataceae bacterium 3064674 Bacteria Bacteria 136 3.13e-36   NR HTX73484.1 3064674 g52411 i0 84.1 1.9919028340081 82 13 99.6 0 2 247 121 202 HTX73484.1 FliG C-terminal domain-containing protein [Rectinemataceae bacterium] diamond 492 136 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
27334481 27334481 PRJNA662254_P_NODE_56023_length_246_cov_0.890173_g55372_i0 PRJNA662254 56023 246 0.890173 2.18982558 Spirochaetia bacterium 2053615 Bacteria Bacteria 109 1.47e-25   NR MCE5300572.1 2053615 g55372 i0 62.5 0.975609756097561 80 30 97.6 0 1 240 32 111 MCE5300572.1 OmpA family protein [Spirochaetia bacterium] diamond 240 109 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27460822 27460822 PRJNA662254_P_NODE_60983_length_243_cov_0.905882_g60332_i0 PRJNA662254 60983 243 0.905882 2.20129326 Rectinemataceae bacterium 3064674 Bacteria Bacteria 42.7 0.0368   NR HUW40889.1 3064674 g60332 i0 32.2 0.728395061728395 59 40 72.8 0 10 186 63 121 HUW40889.1 methyl-accepting chemotaxis protein [Rectinemataceae bacterium] diamond 177 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
27871006 27871006 PRJNA662254_P_NODE_47805_length_250_cov_0.870056_g47154_i0 PRJNA662254 47805 250 0.870056 2.17514 Leptospiraceae bacterium 2026757 Bacteria Bacteria 44.3 0.00999   NR MCB1140804.1 2026757 g47154 i0 36.4 0.924 77 38 90 2 239 15 152 219 MCB1140804.1 hypothetical protein [Leptospiraceae bacterium] diamond 231 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27997545 27997545 PRJNA662254_P_NODE_51545_length_248_cov_0.880000_g50894_i0 PRJNA662254 51545 248 0.88 2.1824 Spirochaetota bacterium 2202144 Bacteria Bacteria 92.8 5.12e-20   NR MDH4129554.1 2202144 g50894 i0 51.2 3.96774193548387 82 40 99.2 0 246 1 279 360 MDH4129554.1 restriction endonuclease subunit S [Spirochaetota bacterium] diamond 984 92.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28198820 28198820 PRJNA662254_P_NODE_51206_length_248_cov_0.880000_g50555_i0 PRJNA662254 51206 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 71.2 3.54e-12   NR MDR1215910.1 166 g50555 i0 50.7 13.4758064516129 73 36 88.3 0 246 28 151 223 MDR1215910.1 fibronectin type III domain-containing protein [Treponema sp.] diamond 3342 71.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28198824 28198824 PRJNA662254_P_NODE_61026_length_243_cov_0.905882_g60375_i0 PRJNA662254 61026 243 0.905882 2.20129326 Spirochaetales 136 Bacteria Bacteria 79 1.45e-15   NR WP_244882876.1 163 g60375 i0 54.2 7.27160493827161 59 27 72.8 0 242 66 194 252 WP_244882876.1 sugar transferase [Treponema bryantii] diamond 1767 79.3 0.996216897856242 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
28344679 28344679 PRJNA662254_P_NODE_48066_length_250_cov_0.870056_g47415_i0 PRJNA662254 48066 250 0.870056 2.17514 Rectinemataceae bacterium 3064674 Bacteria Bacteria 87.4 7.65e-18   NR HUX42095.1 3064674 g47415 i0 58.5 0.984 82 34 98.4 0 250 5 189 270 HUX42095.1 histidine kinase dimerization/phosphoacceptor domain -containing protein [Rectinemataceae bacterium] diamond 246 87.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
28439571 28439571 PRJNA662254_P_NODE_51486_length_248_cov_0.880000_g50835_i0 PRJNA662254 51486 248 0.88 2.1824 Spirochaetales bacterium 2026792 Bacteria Bacteria 123 8.46e-31   NR HOX31930.1 2026792 g50835 i0 84.7 0.870967741935484 72 11 87.1 0 31 246 218 289 HOX31930.1 DUF115 domain-containing protein [Spirochaetales bacterium] diamond 216 123 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29039614 29039614 PRJNA662254_P_NODE_57548_length_245_cov_0.895349_g56897_i0 PRJNA662254 57548 245 0.895349 2.19360505 Spirochaetales bacterium 2026792 Bacteria Bacteria 67 1.05e-11   NR HOX32041.1 2026792 g56897 i0 46.1 0.930612244897959 76 36 93.1 2 15 242 20 90 HOX32041.1 hypothetical protein [Spirochaetales bacterium] diamond 228 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29165863 29165863 PRJNA662254_P_NODE_54789_length_246_cov_0.890173_g54138_i0 PRJNA662254 54789 246 0.890173 2.18982558 Spirochaetia bacterium 2053615 Bacteria Bacteria 112 9.84e-27   NR MCE5299994.1 2053615 g54138 i0 64.2 1.97560975609756 81 29 98.8 0 2 244 119 199 MCE5299994.1 YifB family Mg chelatase-like AAA ATPase [Spirochaetia bacterium] diamond 486 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29323390 29323390 PRJNA662254_P_NODE_53409_length_247_cov_0.885057_g52758_i0 PRJNA662254 53409 247 0.885057 2.18609079 Spirochaetia bacterium 2053615 Bacteria Bacteria 131 2.1399999999999993e-34   NR HUI69324.1 2053615 g52758 i0 81.7 3.98380566801619 82 15 99.6 0 1 246 276 357 HUI69324.1 FtsX-like permease family protein [Spirochaetia bacterium] diamond 984 131 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29670493 29670493 PRJNA662254_P_NODE_64590_length_241_cov_0.916667_g63939_i0 PRJNA662254 64590 241 0.916667 2.20916747 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 76.3 5.95e-14   NR MCP5453143.1 1898206 g63939 i0 45.5 0.95850622406639 77 42 95.9 0 11 241 2665 2741 MCP5453143.1 hypothetical protein [Spirochaetaceae bacterium] diamond 231 76.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30061837 30061837 PRJNA662254_P_NODE_47051_length_250_cov_0.870056_g46400_i0 PRJNA662254 47051 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 140 6.47e-38   NR MDP3179021.1 1898206 g46400 i0 79.3 2.94 82 17 98.4 0 248 3 249 330 MDP3179021.1 cell division protein FtsA [Spirochaetaceae bacterium] diamond 735 140 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30681529 30681529 PRJNA662254_P_NODE_61113_length_243_cov_0.905882_g60462_i0 PRJNA662254 61113 243 0.905882 2.20129326 Spirochaetales bacterium 2026792 Bacteria Bacteria 81.6 1.53e-17   NR HOX92959.1 2026792 g60462 i0 50 1.01234567901235 82 38 97.5 1 243 7 61 142 HOX92959.1 hypothetical protein [Spirochaetales bacterium] diamond 246 81.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30997806 30997806 PRJNA662254_P_NODE_63914_length_242_cov_0.911243_g63263_i0 PRJNA662254 63914 242 0.911243 2.20520806 Spirochaetota bacterium 2202144 Bacteria Bacteria 122 7.530000000000001e-33   NR MEI6875424.1 2202144 g63263 i0 73.8 3.96694214876033 80 21 99.2 0 240 1 111 190 MEI6875424.1 YdeI family protein [Spirochaetota bacterium] diamond 960 122 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31073144 31073144 PRJNA662254_P_NODE_49295_length_249_cov_0.875000_g48644_i0 PRJNA662254 49295 249 0.875 2.17875 Bacteria 2 Bacteria Bacteria 58.2 9.52e-8   NR MDR2485338.1 166 g48644 i0 61.5 3.91566265060241 39 15 47 0 3 119 49 87 MDR2485338.1 WD40 repeat domain-containing protein [Treponema sp.] diamond 975 58.5 0.994871794871795 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31313749 31313749 PRJNA662254_P_NODE_49935_length_249_cov_0.875000_g49284_i0 PRJNA662254 49935 249 0.875 2.17875 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 129 1.21e-34   NR MDP3176438.1 1898206 g49284 i0 79.3 0.987951807228916 82 17 98.8 0 2 247 100 181 MDP3176438.1 SDR family NAD(P)-dependent oxidoreductase [Spirochaetaceae bacterium] diamond 246 129 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31313757 31313757 PRJNA662254_P_NODE_55415_length_246_cov_0.890173_g54764_i0 PRJNA662254 55415 246 0.890173 2.18982558 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 103 7.090000000000001e-26   NR MDP3179374.1 1898206 g54764 i0 69.1 0.98780487804878 81 25 98.8 0 2 244 15 95 MDP3179374.1 hypothetical protein [Spirochaetaceae bacterium] diamond 243 103 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31440187 31440187 PRJNA662254_P_NODE_44916_length_251_cov_0.865169_g44265_i0 PRJNA662254 44916 251 0.865169 2.17157419 Spirochaetales bacterium 2026792 Bacteria Bacteria 134 8.01e-37   NR MBE7437837.1 2026792 g44265 i0 71.1 3.9681274900398402 83 24 99.2 0 251 3 15 97 MBE7437837.1 hypothetical protein [Spirochaetales bacterium] diamond 996 134 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31440195 31440195 PRJNA662254_P_NODE_55076_length_246_cov_0.890173_g54425_i0 PRJNA662254 55076 246 0.890173 2.18982558 Rectinemataceae bacterium 3064674 Bacteria Bacteria 124 1.5299999999999999e-31   NR HTX72480.1 3064674 g54425 i0 69.5 1 82 25 100 0 1 246 122 203 HTX72480.1 cysteine desulfurase [Rectinemataceae bacterium] diamond 246 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
32136333 32136333 PRJNA662254_P_NODE_59398_length_244_cov_0.900585_g58747_i0 PRJNA662254 59398 244 0.900585 2.1974274 Spirochaetia bacterium 2053615 Bacteria Bacteria 107 9.14e-25   NR MCE5300997.1 2053615 g58747 i0 65.8 0.971311475409836 79 27 97.1 0 2 238 616 694 MCE5300997.1 SpoIIE family protein phosphatase [Spirochaetia bacterium] diamond 237 107 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32799356 32799356 PRJNA662254_P_NODE_60920_length_243_cov_0.905882_g60269_i0 PRJNA662254 60920 243 0.905882 2.20129326 Treponema sp. 166 Bacteria Bacteria 164 1.9599999999999998e-46   NR MDA8425760.1 166 g60269 i0 98.8 2.96296296296296 80 1 98.8 0 2 241 208 287 MDA8425760.1 chromosomal replication initiator protein DnaA [Treponema sp.] diamond 720 164 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32831091 32831091 PRJNA662254_P_NODE_58960_length_244_cov_0.900585_g58309_i0 PRJNA662254 58960 244 0.900585 2.1974274 Spirochaetota bacterium 2202144 Bacteria Bacteria 133 3.9e-35   NR MBN8221269.1 2202144 g58309 i0 80 0.983606557377049 80 16 98.4 0 3 242 13 92 MBN8221269.1 multidrug effflux MFS transporter [Spirochaetota bacterium] diamond 240 133 1 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);;