RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA884104", tax_kingdom = "Pseudomonadati" 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

  • Pseudomonadati · 23 ✖

bioproject 1

  • PRJNA884104 · 23 ✖

analysis 1

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
16164154 16164154 PRJNA884104_S_NODE_74173_length_248_cov_0.880000_g73430_i0 PRJNA884104 74173 248 0.88 2.1824 Treponema 157 Bacteria Bacteria 106 1.15e-25   NR WP_022932233.1 163 g73430 i0 60.5 6.81048387096774 81 32 98 0 3 245 21 101 WP_022932233.1 aldo/keto reductase [Treponema bryantii] diamond 1689 107 0.990654205607477 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
17818759 17818759 PRJNA884104_S_NODE_40634_length_325_cov_1.170635_g39891_i0 PRJNA884104 40634 325 1.170635 3.80456375 Pseudomonadati 3379134 Bacteria Bacteria 87.8 3.01e-18   NR MDA8409400.1 166 g39891 i0 73.7 5.33538461538462 57 15 52.6 0 3 173 224 280 MDA8409400.1 pyridoxal 5'-phosphate synthase lyase subunit PdxS [Treponema sp.] diamond 1734 88.2 0.99546485260771 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27149822 27149822 PRJNA884104_S_NODE_73722_length_248_cov_0.880000_g72979_i0 PRJNA884104 73722 248 0.88 2.1824 Spirochaetota bacterium 2202144 Bacteria Bacteria 83.6 5.62e-17   NR MBU0936347.1 2202144 g72979 i0 51.2 1.04032258064516 86 37 98 2 248 6 154 239 MBU0936347.1 cation diffusion facilitator family transporter [Spirochaetota bacterium] diamond 258 83.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27149831 27149831 PRJNA884104_S_NODE_84262_length_242_cov_0.911243_g83519_i0 PRJNA884104 84262 242 0.911243 2.20520806 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 77.4 2.25e-14   NR TVQ24132.1 1898206 g83519 i0 48.5 2.52892561983471 68 35 84.3 0 204 1 287 354 TVQ24132.1 MAG: molecular chaperone DnaK [Spirochaetaceae bacterium] diamond 612 77.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
27181688 27181688 PRJNA884104_S_NODE_9582_length_653_cov_0.986207_g8877_i0 PRJNA884104 9582 653 0.986207 6.43993171 Spirochaetota bacterium 2202144 Bacteria Bacteria 197 1.03e-59   NR HOP64094.1 2202144 g8877 i0 47.9 4.33690658499234 190 90 83.6 2 653 108 46 234 HOP64094.1 M15 family metallopeptidase [Spirochaetota bacterium] diamond 2832 197 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27347995 27347995 PRJNA884104_S_NODE_37063_length_338_cov_1.867925_g36320_i0 PRJNA884104 37063 338 1.867925 6.3135865 Bacteria 2 Bacteria Bacteria 71.6 3.69e-12   NR HMW61978.1 2026757 g36320 i0 35.5 2.92899408284024 110 68 97.6 2 336 7 121 227 HMW61978.1 cyclic nucleotide-binding domain-containing protein [Leptospiraceae bacterium] diamond 990 71.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27592723 27592723 PRJNA884104_S_NODE_84324_length_242_cov_0.911243_g83581_i0 PRJNA884104 84324 242 0.911243 2.20520806 Treponema sp. 166 Bacteria Bacteria 51.6 2.7e-5   NR MDR0502921.1 166 g83581 i0 40.8 1.22727272727273 49 29 60.7 0 238 92 179 227 MDR0502921.1 tetratricopeptide repeat protein [Treponema sp.] diamond 297 51.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27907968 27907968 PRJNA884104_S_NODE_43725_length_314_cov_2.315353_g42982_i0 PRJNA884104 43725 314 2.315353 7.27020842 Spirochaetota bacterium 2202144 Bacteria Bacteria 57.8 1.51e-7   NR MDK2818705.1 2202144 g42982 i0 46.2 0.621019108280255 65 35 62.1 0 195 1 74 138 MDK2818705.1 ankyrin repeat domain-containing protein [Spirochaetota bacterium] diamond 195 57.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28129419 28129419 PRJNA884104_S_NODE_72245_length_249_cov_0.875000_g71502_i0 PRJNA884104 72245 249 0.875 2.17875 Leptonema sp. (in: bacteria) 2046886 Bacteria Bacteria 54.3 3.23e-6   NR MBW7858254.1 2046886 g71502 i0 45.3 0.771084337349398 64 33 77.1 2 193 2 109 170 MBW7858254.1 adenylate/guanylate cyclase domain-containing protein [Leptonema sp. (in: bacteria)] diamond 192 54.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema sp. (in: bacteria)
28318715 28318715 PRJNA884104_S_NODE_72606_length_249_cov_0.875000_g71863_i0 PRJNA884104 72606 249 0.875 2.17875 Treponema sp. 166 Bacteria Bacteria 71.6 2.72e-12   NR MCR5763801.1 166 g71863 i0 45.8 1 83 37 100 2 249 1 507 581 MCR5763801.1 response regulator [Treponema sp.] diamond 249 71.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28729265 28729265 PRJNA884104_S_NODE_72007_length_249_cov_0.875000_g71264_i0 PRJNA884104 72007 249 0.875 2.17875 Oceanispirochaeta sp. 2035350 Bacteria Bacteria 63.9 9.76e-10   NR WP_298005442.1 2035350 g71264 i0 42 0.975903614457831 81 47 97.6 0 248 6 168 248 WP_298005442.1 ankyrin repeat domain-containing protein [Oceanispirochaeta sp.] diamond 243 63.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Oceanispirochaeta Oceanispirochaeta sp.
28768589 28768589 PRJNA884104_S_NODE_54987_length_282_cov_1.464115_g54244_i0 PRJNA884104 54987 282 1.464115 4.1288043 Pseudomonadati 3379134 Bacteria Bacteria 66.2 1.85e-10   NR WP_272531401.1 1513297 g54244 i0 40.8 2.28723404255319 71 41 75.5 1 8 220 211 280 WP_272531401.1 alpha/beta fold hydrolase [Leptospira sp. GIMC2001] diamond 645 66.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. GIMC2001
28792203 28792203 PRJNA884104_S_NODE_66647_length_255_cov_0.906593_g65904_i0 PRJNA884104 66647 255 0.906593 2.31181215 Treponema sp. 166 Bacteria Bacteria 49.7 1.53e-4   NR MBD5427391.1 166 g65904 i0 47.1 0.6 51 27 60 0 1 153 45 95 MBD5427391.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 153 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29052971 29052971 PRJNA884104_S_NODE_26188_length_397_cov_1.157407_g25445_i0 PRJNA884104 26188 397 1.157407 4.59490579 Pseudomonadati 3379134 Bacteria Bacteria 48.1 8.03e-4   NR MDR2133756.1 166 g25445 i0 35.9 2.56926952141058 103 49 65 4 395 138 12 114 MDR2133756.1 Hsp70 family protein [Treponema sp.] diamond 1020 48.5 0.991752577319588 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29076680 29076680 PRJNA884104_S_NODE_85648_length_241_cov_0.916667_g84905_i0 PRJNA884104 85648 241 0.916667 2.20916747 Spirochaetota bacterium 2202144 Bacteria Bacteria 49.7 2.19e-5   NR MBN1499068.1 2202144 g84905 i0 37.7 0.659751037344398 53 33 66 0 8 166 40 92 MBN1499068.1 hypothetical protein [Spirochaetota bacterium] diamond 159 49.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30024046 30024046 PRJNA884104_S_NODE_86011_length_241_cov_0.916667_g85268_i0 PRJNA884104 86011 241 0.916667 2.20916747 Leptospira levettii 2023178 Bacteria Bacteria 46.6 0.00147   NR WP_238760294.1 2023178 g85268 i0 59.4 0.398340248962656 32 13 39.8 0 57 152 304 335 WP_238760294.1 zinc-binding dehydrogenase [Leptospira levettii] diamond 96 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira levettii
30442621 30442621 PRJNA884104_S_NODE_47933_length_302_cov_1.008734_g47190_i0 PRJNA884104 47933 302 1.008734 3.04637668 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 111 4.31e-27   NR NCN10353.1 178 g47190 i0 48.5 3.90397350993377 99 49 98.3 1 302 6 56 152 NCN10353.1 NAD(P)-dependent alcohol dehydrogenase [Leptospira sp.] diamond 1179 111 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
30687242 30687242 PRJNA884104_S_NODE_64293_length_260_cov_1.155080_g63550_i0 PRJNA884104 64293 260 1.15508 3.003208 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 111 2.69e-26   NR MDD4007402.1 2791017 g63550 i0 59 6.64615384615385 83 34 95.8 0 253 5 40 122 MDD4007402.1 type I DNA topoisomerase [Sphaerochaetaceae bacterium] diamond 1728 111 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
32110254 32110254 PRJNA884104_S_NODE_85638_length_241_cov_0.916667_g84895_i0 PRJNA884104 85638 241 0.916667 2.20916747 Brevinematales bacterium 2614249 Bacteria Bacteria 48.9 1.11e-4   NR MCX8028506.1 2614249 g84895 i0 37.7 3.54771784232365 61 38 75.9 0 55 237 93 153 MCX8028506.1 ankyrin repeat domain-containing protein [Brevinematales bacterium] diamond 855 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brevinematales     Brevinematales bacterium
32402953 32402953 PRJNA884104_S_NODE_52539_length_289_cov_1.069444_g51796_i0 PRJNA884104 52539 289 1.069444 3.09069316 Pseudomonadati 3379134 Bacteria Bacteria 45.8 0.00498   NR MCB1321183.1 2026757 g51796 i0 34.1 2.85467128027682 85 39 88.2 1 31 285 55 122 MCB1321183.1 hypothetical protein [Leptospiraceae bacterium] diamond 825 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32616218 32616218 PRJNA884104_S_NODE_33840_length_352_cov_4.207885_g33097_i0 PRJNA884104 33840 352 4.207885 14.8117552 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 58.2 1.93e-7   NR OHD18884.1 1802176 g33097 i0 36.4 1.00568181818182 118 65 92 2 325 2 14 131 OHD18884.1 MAG: hypothetical protein A2Y38_14560 [Spirochaetes bacterium GWB1_59_5] diamond 354 58.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
32773536 32773536 PRJNA884104_S_NODE_59300_length_271_cov_2.424242_g58557_i0 PRJNA884104 59300 271 2.424242 6.56969582 uncultured Treponema sp. 162155 Bacteria Bacteria 43.1 0.0381   NR WP_296028456.1 162155 g58557 i0 37.8 1.63837638376384 74 44 79.7 1 223 8 335 408 WP_296028456.1 right-handed parallel beta-helix repeat-containing protein [uncultured Treponema sp.] diamond 444 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
32773549 32773549 PRJNA884104_S_NODE_70420_length_250_cov_0.870056_g69677_i0 PRJNA884104 70420 250 0.870056 2.17514 Leptospiraceae bacterium 2026757 Bacteria Bacteria 86.7 1.48e-17   NR MCP5498089.1 2026757 g69677 i0 50.6 0.972 81 39 97.2 1 250 8 551 630 MCP5498089.1 AAA family ATPase [Leptospiraceae bacterium] diamond 243 86.7 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);;