RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • Pseudomonadati · 33 ✖

bioproject 1

  • PRJNA1180292 · 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
318011 318011 PRJNA1180292_P_NODE_9801_length_249_cov_0.886364_g9669_i0 PRJNA1180292 9801 249 0.886364 2.20704636 Spirochaetes bacterium RBG_13_68_11 1802194 Bacteria Bacteria 124 1.33e-31   NR OHD68855.1 1802194 g9669 i0 95.5 0.795180722891566 66 3 79.5 0 1 198 391 456 OHD68855.1 MAG: HslU--HslV peptidase ATPase subunit, partial [Spirochaetes bacterium RBG_13_68_11] diamond 198 124 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_13_68_11
11796461 11796461 PRJNA1180292_P_NODE_12810_length_242_cov_0.923077_g12678_i0 PRJNA1180292 12810 242 0.923077 2.23384634 Spirochaetia bacterium 2053615 Bacteria Bacteria 150 7.509999999999998e-32   NTclustered gi|2621700913|emb|OY759747.1| 2053615 g12678 i0 80.829 0.797520661157025 193 35 79 2 13 204 1033305 1033114 MAG: Spirochaetia bacterium isolate 029c9a96-c795-42b2-9c0d-59f5314b817a genome assembly, chromosome: 1 blastn 193 150 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
17619018 17619018 PRJNA1180292_P_NODE_12114_length_244_cov_0.912281_g11982_i0 PRJNA1180292 12114 244 0.912281 2.22596564 Spirochaetales bacterium 2026792 Bacteria Bacteria 58.9 5.61e-8   NR MEI8096170.1 2026792 g11982 i0 82.9 0.430327868852459 35 6 43 0 243 139 232 266 MEI8096170.1 undecaprenyl-diphosphate phosphatase [Spirochaetales bacterium] diamond 105 58.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
18169463 18169463 PRJNA1180292_P_NODE_11735_length_245_cov_0.906977_g11603_i0 PRJNA1180292 11735 245 0.906977 2.22209365 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 128 7.999999999999999e-33   NR UCF97937.1 1898206 g11603 i0 75.3 7.86122448979592 81 20 99.2 0 2 244 259 339 UCF97937.1 MAG: ribonuclease Y [Spirochaetaceae bacterium] diamond 1926 128 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
18169547 18169547 PRJNA1180292_P_NODE_8495_length_252_cov_0.871508_g8363_i0 PRJNA1180292 8495 252 0.871508 2.19620016 Spirochaetales bacterium 2026792 Bacteria Bacteria 99 6.5e-22   NR MBN1834332.1 2026792 g8363 i0 61.4 0.988095238095238 83 32 98.8 0 3 251 512 594 MBN1834332.1 TrkH family potassium uptake protein [Spirochaetales bacterium] diamond 249 99 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
21994592 21994592 PRJNA1180292_P_NODE_8738_length_251_cov_0.876404_g8606_i0 PRJNA1180292 8738 251 0.876404 2.19977404 Spirochaetes bacterium RBG_16_67_19 1802196 Bacteria Bacteria 155 3.11e-44   NR OHD70338.1 1802196 g8606 i0 97.6 0.99203187250996006 83 2 99.2 0 3 251 22 104 OHD70338.1 MAG: adenosine deaminase [Spirochaetes bacterium RBG_16_67_19] diamond 249 155 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_16_67_19
21994605 21994605 PRJNA1180292_P_NODE_9698_length_249_cov_0.886364_g9566_i0 PRJNA1180292 9698 249 0.886364 2.20704636 Spirochaetota bacterium 2202144 Bacteria Bacteria 144 4.25e-42   NR HNX24982.1 2202144 g9566 i0 84 0.975903614457831 81 13 97.6 0 2 244 25 105 HNX24982.1 NAD(P)H-dependent oxidoreductase subunit E [Spirochaetota bacterium] diamond 243 144 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
24543809 24543809 PRJNA1180292_P_NODE_11760_length_245_cov_0.906977_g11628_i0 PRJNA1180292 11760 245 0.906977 2.22209365 Spirochaetales bacterium 2026792 Bacteria Bacteria 130 3.8800000000000005e-33   NR MBN2535219.1 2026792 g11628 i0 80 2.96326530612245 80 16 98 0 240 1 710 789 MBN2535219.1 pyruvate, phosphate dikinase [Spirochaetales bacterium] diamond 726 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
26787518 26787518 PRJNA1180292_P_NODE_12221_length_244_cov_0.912281_g12089_i0 PRJNA1180292 12221 244 0.912281 2.22596564 Spirochaetota bacterium 2202144 Bacteria Bacteria 83.6 1.46e-16   NR HPB82399.1 2202144 g12089 i0 52.6 1.91803278688525 78 37 95.9 0 242 9 177 254 HPB82399.1 exodeoxyribonuclease V subunit alpha [Spirochaetota bacterium] diamond 468 83.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27293457 27293457 PRJNA1180292_P_NODE_7963_length_253_cov_0.866667_g7831_i0 PRJNA1180292 7963 253 0.866667 2.19266751 Spirochaetales bacterium 2026792 Bacteria Bacteria 44.7 0.00897   NR NNM55354.1 2026792 g7831 i0 56.3 0.379446640316206 32 14 37.9 0 4 99 51 82 NNM55354.1 alpha-amylase [Spirochaetales bacterium] diamond 96 44.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27356842 27356842 PRJNA1180292_P_NODE_8703_length_251_cov_0.876404_g8571_i0 PRJNA1180292 8703 251 0.876404 2.19977404 Spirochaetia bacterium 2053615 Bacteria Bacteria 122 2.94e-31   NR HOV62331.1 2053615 g8571 i0 67.5 0.99203187250996006 83 27 99.2 0 3 251 35 117 HOV62331.1 site-specific DNA-methyltransferase [Spirochaetia bacterium] diamond 249 122 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27407660 27407660 PRJNA1180292_P_NODE_12383_length_243_cov_0.917647_g12251_i0 PRJNA1180292 12383 243 0.917647 2.22988221 Treponema 157 Bacteria Bacteria 135 3.3699999999999996e-35   NR WP_288906139.1 162155 g12251 i0 100 2.37037037037037 64 0 79 0 243 52 494 557 WP_288906139.1 HDIG domain-containing metalloprotein [uncultured Treponema sp.] diamond 576 135 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
27577725 27577725 PRJNA1180292_P_NODE_11144_length_246_cov_0.901734_g11012_i0 PRJNA1180292 11144 246 0.901734 2.21826564 Spirochaetales bacterium 2026792 Bacteria Bacteria 53.1 5.33e-6   NR MBT3271563.1 2026792 g11012 i0 67.7 0.378048780487805 31 10 37.8 0 1 93 193 223 MBT3271563.1 hypothetical protein [Spirochaetales bacterium] diamond 93 53.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27704393 27704393 PRJNA1180292_P_NODE_9204_length_250_cov_0.881356_g9072_i0 PRJNA1180292 9204 250 0.881356 2.20339 Spirochaetota bacterium 2202144 Bacteria Bacteria 150 7.2799999999999994e-40   NR MCX7030811.1 2202144 g9072 i0 88 0.996 83 10 99.6 0 2 250 49 131 MCX7030811.1 hypothetical protein [Spirochaetota bacterium] diamond 249 150 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28493485 28493485 PRJNA1180292_P_NODE_9907_length_249_cov_0.886364_g9775_i0 PRJNA1180292 9907 249 0.886364 2.20704636 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 108 1.27e-25   NR HAE20896.1 1898206 g9775 i0 64.9 1.78313253012048 74 26 89.2 0 1 222 378 451 HAE20896.1 chemotaxis protein CheW [Spirochaetaceae bacterium] diamond 444 108 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28872186 28872186 PRJNA1180292_P_NODE_10828_length_247_cov_0.896552_g10696_i0 PRJNA1180292 10828 247 0.896552 2.21448344 Spirochaetia bacterium 2053615 Bacteria Bacteria 103 9.53e-24   NR HTZ50591.1 2053615 g10696 i0 63 1.96761133603239 81 30 98.4 0 3 245 157 237 HTZ50591.1 L-fucose/L-arabinose isomerase family protein [Spirochaetia bacterium] diamond 486 103 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29061881 29061881 PRJNA1180292_P_NODE_9808_length_249_cov_0.886364_g9676_i0 PRJNA1180292 9808 249 0.886364 2.20704636 Spirochaetota bacterium 2202144 Bacteria Bacteria 138 8.43e-36   NR MBP7584854.1 2202144 g9676 i0 81.9 1 83 15 100 0 1 249 707 789 MBP7584854.1 phosphotransferase [Spirochaetota bacterium] diamond 249 138 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29125173 29125173 PRJNA1180292_P_NODE_9909_length_249_cov_0.886364_g9777_i0 PRJNA1180292 9909 249 0.886364 2.20704636 Spirochaetota bacterium 2202144 Bacteria Bacteria 86.3 7.03e-19   NR MCX7029111.1 2202144 g9777 i0 81.8 0.530120481927711 44 8 53 0 133 2 1 44 MCX7029111.1 hypothetical protein [Spirochaetota bacterium] diamond 132 86.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29188209 29188209 PRJNA1180292_P_NODE_12009_length_244_cov_0.912281_g11877_i0 PRJNA1180292 12009 244 0.912281 2.22596564 Spirochaetota bacterium 2202144 Bacteria Bacteria 84 1.21e-16   NR MEM7183862.1 2202144 g11877 i0 51.3 0.983606557377049 80 39 98.4 0 241 2 755 834 MEM7183862.1 AAA family ATPase [Spirochaetota bacterium] diamond 240 84 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29333442 29333442 PRJNA1180292_P_NODE_10529_length_247_cov_0.896552_g10397_i0 PRJNA1180292 10529 247 0.896552 2.21448344 Bacteria 2 Bacteria Bacteria 133 4.66e-34   NR MEI6386190.1 2202144 g10397 i0 70.7 2.98785425101215 82 24 99.6 0 1 246 912 993 MEI6386190.1 acyl-CoA dehydratase activase [Spirochaetota bacterium] diamond 738 134 0.992537313432836 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29377440 29377440 PRJNA1180292_P_NODE_7869_length_253_cov_0.866667_g7737_i0 PRJNA1180292 7869 253 0.866667 2.19266751 Spirochaetes bacterium RBG_13_68_11 1802194 Bacteria Bacteria 166 2.71e-47   NR OHD71589.1 1802194 g7737 i0 100 0.99604743083004 84 0 99.6 0 253 2 318 401 OHD71589.1 MAG: flagellar hook protein FlgE, partial [Spirochaetes bacterium RBG_13_68_11] diamond 252 166 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_13_68_11
29851182 29851182 PRJNA1180292_P_NODE_12611_length_243_cov_0.917647_g12479_i0 PRJNA1180292 12611 243 0.917647 2.22988221 Spirochaetia bacterium 2053615 Bacteria Bacteria 53.5 5.81e-6   NR HUZ18115.1 2053615 g12479 i0 37.3 0.925925925925926 75 47 92.6 0 228 4 352 426 HUZ18115.1 sugar ABC transporter substrate-binding protein [Spirochaetia bacterium] diamond 225 53.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30230157 30230157 PRJNA1180292_P_NODE_10132_length_248_cov_0.891429_g10000_i0 PRJNA1180292 10132 248 0.891429 2.21074392 Spirochaetales bacterium 2026792 Bacteria Bacteria 129 1.97e-34   NR HOX33459.1 2026792 g10000 i0 84.1 0.991935483870968 82 11 99.2 1 248 3 227 306 HOX33459.1 ATP-binding cassette domain-containing protein [Spirochaetales bacterium] diamond 246 129 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30672396 30672396 PRJNA1180292_P_NODE_10853_length_247_cov_0.896552_g10721_i0 PRJNA1180292 10853 247 0.896552 2.21448344 Spirochaetia bacterium 2053615 Bacteria Bacteria 80.5 5.88e-18   NR NBU97724.1 2053615 g10721 i0 67.3 0.631578947368421 52 17 63.2 0 1 156 7 58 NBU97724.1 hypothetical protein [Spirochaetia bacterium] diamond 156 80.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30893864 30893864 PRJNA1180292_P_NODE_10774_length_247_cov_0.896552_g10642_i0 PRJNA1180292 10774 247 0.896552 2.21448344 Treponema berlinense 225004 Bacteria Bacteria 64.3 4.27e-10   NR WP_303921486.1 225004 g10642 i0 90.6 0.388663967611336 32 3 38.9 0 151 246 1 32 WP_303921486.1 FAD-binding protein, partial [Treponema berlinense] diamond 96 64.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema berlinense
30925512 30925512 PRJNA1180292_P_NODE_12734_length_243_cov_0.888235_g12602_i0 PRJNA1180292 12734 243 0.888235 2.15841105 Spirochaetales bacterium 2026792 Bacteria Bacteria 135 7.679999999999999e-37   NR TFG62067.1 2026792 g12602 i0 77.5 1.97530864197531 80 18 98.8 0 241 2 35 114 TFG62067.1 MAG: HPr kinase/phosphorylase [Spirochaetales bacterium] diamond 480 135 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31133726 31133726 PRJNA1180292_P_NODE_9375_length_250_cov_0.881356_g9243_i0 PRJNA1180292 9375 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 150 4.5599999999999985e-43   NR OHD71988.1 1802195 g9243 i0 91.6 2.988 83 7 99.6 0 250 2 75 157 OHD71988.1 MAG: ATP-binding protein [Spirochaetes bacterium RBG_16_49_21] diamond 747 151 0.993377483443709 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium RBG_16_49_21
31146017 31146017 PRJNA1180292_P_NODE_8735_length_251_cov_0.876404_g8603_i0 PRJNA1180292 8735 251 0.876404 2.19977404 Spirochaetia bacterium 2053615 Bacteria Bacteria 110 2.17e-29   NR MCI6318002.1 2053615 g8603 i0 100 0.657370517928287 55 0 65.7 0 168 4 1 55 MCI6318002.1 DUF2442 domain-containing protein [Spirochaetia bacterium] diamond 165 110 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31241143 31241143 PRJNA1180292_P_NODE_7955_length_253_cov_0.866667_g7823_i0 PRJNA1180292 7955 253 0.866667 2.19266751 Treponema porcinum 261392 Bacteria Bacteria 168 5.97e-51   NR WP_273318504.1 261392 g7823 i0 98.8 0.99604743083004 84 1 99.6 0 1 252 42 125 WP_273318504.1 hypothetical protein [Treponema porcinum] diamond 252 168 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema porcinum
31810624 31810624 PRJNA1180292_P_NODE_10217_length_248_cov_0.891429_g10085_i0 PRJNA1180292 10217 248 0.891429 2.21074392 Spirochaetota bacterium 2202144 Bacteria Bacteria 107 5.0499999999999995e-25   NR MBP7605059.1 2202144 g10085 i0 76.8 0.991935483870968 82 19 99.2 0 1 246 266 347 MBP7605059.1 chemotaxis protein CheA [Spirochaetota bacterium] diamond 246 107 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31810639 31810639 PRJNA1180292_P_NODE_9297_length_250_cov_0.881356_g9165_i0 PRJNA1180292 9297 250 0.881356 2.20339 Spirochaetia bacterium 2053615 Bacteria Bacteria 124 1.13e-30   NR HET6452464.1 2053615 g9165 i0 68.8 7.836 80 25 96 0 10 249 332 411 HET6452464.1 alpha-glucan family phosphorylase [Spirochaetia bacterium] diamond 1959 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32190347 32190347 PRJNA1180292_P_NODE_13058_length_242_cov_0.923077_g12926_i0 PRJNA1180292 13058 242 0.923077 2.23384634 Spirochaetota bacterium 2202144 Bacteria Bacteria 67 3.18e-11   NR MCK4798684.1 2202144 g12926 i0 39.7 0.966942148760331 78 47 96.7 0 235 2 57 134 MCK4798684.1 hypothetical protein [Spirochaetota bacterium] diamond 234 67 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32285550 32285550 PRJNA1180292_P_NODE_10959_length_246_cov_0.901734_g10827_i0 PRJNA1180292 10959 246 0.901734 2.21826564 Spirochaetota bacterium 2202144 Bacteria Bacteria 119 1.4099999999999998e-31   NR MBE3065544.1 2202144 g10827 i0 78.4 0.902439024390244 74 16 90.2 0 2 223 124 197 MBE3065544.1 hypothetical protein [Spirochaetota bacterium] diamond 222 119 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);;