RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493244 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
4282377 4282377 PRJNA493244_P_NODE_1321424_length_290_cov_3.248908_g1298300_i0 PRJNA493244 1321424 290 3.248908 9.4218332 Spirochaetota bacterium 2202144 Bacteria Bacteria 143 1.5999999999999996e-41   NR TXG85209.1 2202144 g1298300 i0 94.4 0.73448275862069 71 4 73.4 0 229 17 11 81 TXG85209.1 MAG: hypothetical protein E6R13_02270 [Spirochaetota bacterium] diamond 213 143 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
26727873 26727873 PRJNA493244_P_NODE_673301_length_587_cov_1.427757_g651200_i0 PRJNA493244 673301 587 1.427757 8.38093359 Spirochaetota bacterium 2202144 Bacteria Bacteria 361 2.8199999999999997e-125   NR TXG85206.1 2202144 g651200 i0 97.2 0.904599659284497 177 5 90.5 0 3 533 19 195 TXG85206.1 MAG: hypothetical protein E6R13_02255 [Spirochaetota bacterium] diamond 531 361 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27171076 27171076 PRJNA493244_P_NODE_1151222_length_346_cov_2.112281_g1128098_i0 PRJNA493244 1151222 346 2.112281 7.30849226 Spirochaetota bacterium 2202144 Bacteria Bacteria 147 7.03e-41   NR TXG85205.1 2202144 g1128098 i0 80.9 0.815028901734104 94 18 81.5 0 65 346 1 94 TXG85205.1 MAG: WYL domain-containing transcriptional regulator [Spirochaetota bacterium] diamond 282 147 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27282136 27282136 PRJNA493244_P_NODE_1003583_length_405_cov_3.244186_g980490_i0 PRJNA493244 1003583 405 3.244186 13.1389533 Treponema 157 Bacteria Bacteria 71.2 8.72e-12   NR WP_206183207.1 409322 g980490 i0 42.2 1.88148148148148 128 57 88.9 6 403 44 68 186 WP_206183207.1 pseudouridine synthase [Treponema pedis] diamond 762 71.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
27313847 27313847 PRJNA493244_P_NODE_1449403_length_255_cov_2.015464_g1426278_i0 PRJNA493244 1449403 255 2.015464 5.1394332 Pseudomonadati 3379134 Bacteria Bacteria 89 2.12e-18   NR WP_002666515.1 158 g1426278 i0 78.3 2.15294117647059 46 10 54.1 0 254 117 284 329 WP_002666515.1 glutamate--tRNA ligase [Treponema denticola] diamond 549 89 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
27613689 27613689 PRJNA493244_P_NODE_1136084_length_352_cov_0.879725_g1112962_i0 PRJNA493244 1136084 352 0.879725 3.096632 Spirochaetia bacterium 2053615 Bacteria Bacteria 140 1.58e-37   NR GHT76121.1 2053615 g1112962 i0 60.2 0.963068181818182 113 45 96.3 0 340 2 170 282 GHT76121.1 hypothetical protein FACS1894124_8130 [Spirochaetia bacterium] diamond 339 140 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27945301 27945301 PRJNA493244_P_NODE_783505_length_516_cov_4.028571_g760883_i0 PRJNA493244 783505 516 4.028571 20.78742636 Rectinema 1937016 Bacteria Bacteria 291 2.81e-90   NR OQB95945.1 1852908 g760883 i0 89.2 1.80813953488372 158 17 91.9 0 507 34 528 685 OQB95945.1 MAG: Coenzyme A disulfide reductase [Spirochaetes bacterium ADurb.Bin110] diamond 933 291 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium ADurb.Bin110
28134834 28134834 PRJNA493244_P_NODE_1133945_length_352_cov_4.264605_g1110823_i0 PRJNA493244 1133945 352 4.264605 15.0114096 Treponema 157 Bacteria Bacteria 49.7 4.34e-4   NR WP_002679979.1 157 g1110823 i0 42.2 2.48011363636364 45 26 38.4 0 136 2 52 96 WP_002679979.1 MULTISPECIES: formylglycine-generating enzyme family protein [Treponema] diamond 873 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema  
29097674 29097674 PRJNA493244_P_NODE_619908_length_625_cov_6.485816_g598191_i0 PRJNA493244 619908 625 6.485816 40.53635 Spirochaetales bacterium 2026792 Bacteria Bacteria 157 1.46e-44   NR MBT89930.1 2026792 g598191 i0 55.4 0.5808 121 53 57.6 1 364 5 4 124 MBT89930.1 imidazole glycerol phosphate synthase subunit HisH [Spirochaetales bacterium] diamond 363 157 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29744709 29744709 PRJNA493244_P_NODE_1452090_length_254_cov_8.414508_g1428965_i0 PRJNA493244 1452090 254 8.414508 21.37285032 root 1 Root_unresolved Root_unresolved 51.6 3.18e-5   NR MCL2834550.1 166 g1428965 i0 67.6 14.4212598425197 34 11 40.2 0 230 129 557 590 MCL2834550.1 ABC transporter ATP-binding protein/permease [Treponema sp.] diamond 3663 52 0.992307692307692 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29823482 29823482 PRJNA493244_P_NODE_1017711_length_399_cov_2.609467_g994611_i0 PRJNA493244 1017711 399 2.609467 10.41177333 Spirochaetota bacterium 2202144 Bacteria Bacteria 75.5 8.04e-13   NR TXG84646.1 2202144 g994611 i0 36.1 1 133 73 98.5 4 398 6 150 272 TXG84646.1 MAG: hypothetical protein E6R13_02910 [Spirochaetota bacterium] diamond 399 75.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30408688 30408688 PRJNA493244_P_NODE_1494393_length_244_cov_1.863388_g1471268_i0 PRJNA493244 1494393 244 1.863388 4.54666672 Bacteria 2 Bacteria Bacteria 41.2 0.0289   NR WP_085169531.1 159 g1471268 i0 64.5 0.762295081967213 31 11 38.1 0 233 141 25 55 WP_085169531.1 hypothetical protein [Brachyspira hyodysenteriae] diamond 186 41.6 0.990384615384615 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hyodysenteriae
30456026 30456026 PRJNA493244_P_NODE_880573_length_463_cov_6.686567_g857648_i0 PRJNA493244 880573 463 6.686567 30.95880521 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 223 1.49e-71   NR MBQ7612067.1 1898206 g857648 i0 84 3.23974082073434 125 20 81 0 384 10 1 125 MBQ7612067.1 iron-sulfur cluster assembly scaffold protein [Spirochaetaceae bacterium] diamond 1500 223 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30487257 30487257 PRJNA493244_P_NODE_1047753_length_386_cov_3.452308_g1024640_i0 PRJNA493244 1047753 386 3.452308 13.32590888 Spirochaetota bacterium 2202144 Bacteria Bacteria 209 1.45e-64   NR TXG85205.1 2202144 g1024640 i0 78.9 0.994818652849741 128 27 99.5 0 3 386 122 249 TXG85205.1 MAG: WYL domain-containing transcriptional regulator [Spirochaetota bacterium] diamond 384 209 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30739957 30739957 PRJNA493244_P_NODE_1641174_length_212_cov_1.271523_g1618049_i0 PRJNA493244 1641174 212 1.271523 2.69562876 Spirochaetia bacterium 2053615 Bacteria Bacteria 61.2 6.91e-9   NR GHT76121.1 2053615 g1618049 i0 46.9 0.905660377358491 64 34 90.6 0 3 194 89 152 GHT76121.1 hypothetical protein FACS1894124_8130 [Spirochaetia bacterium] diamond 192 61.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31435197 31435197 PRJNA493244_P_NODE_1117396_length_358_cov_8.309764_g1094274_i0 PRJNA493244 1117396 358 8.309764 29.74895512 Treponema sp. 166 Bacteria Bacteria 49.7 1.57e-4   NR MDR1804528.1 166 g1094274 i0 31.9 0.972067039106145 116 51 83 3 46 342 33 137 MDR1804528.1 Hsp20/alpha crystallin family protein [Treponema sp.] diamond 348 49.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31498740 31498740 PRJNA493244_P_NODE_822836_length_494_cov_2.866051_g800079_i0 PRJNA493244 822836 494 2.866051 14.15829194 Treponema sp. Marseille-Q4523 2810610 Bacteria Bacteria 89 5.46e-18   NR WP_205076205.1 2810610 g800079 i0 43.3 2.18623481781377 120 68 72.9 0 18 377 147 266 WP_205076205.1 Rpn family recombination-promoting nuclease/putative transposase [Treponema sp. Marseille-Q4523] diamond 1080 89 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4523
31530374 31530374 PRJNA493244_P_NODE_1126716_length_355_cov_2.258503_g1103594_i0 PRJNA493244 1126716 355 2.258503 8.01768565 Leptospiraceae bacterium 2026757 Bacteria Bacteria 82 1.22e-15   NR MCB1175974.1 2026757 g1103594 i0 37.9 0.980281690140845 116 70 96.3 2 354 13 151 266 MCB1175974.1 type III PLP-dependent enzyme [Leptospiraceae bacterium] diamond 348 82 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31688260 31688260 PRJNA493244_P_NODE_1341177_length_285_cov_1.142857_g1318053_i0 PRJNA493244 1341177 285 1.142857 3.25714245 Treponema sp. OMZ 788 2563664 Bacteria Bacteria 94.7 4.2e-21   NR WP_253678271.1 2563664 g1318053 i0 49.4 3.48421052631579 81 41 85.3 0 245 3 116 196 WP_253678271.1 ComF family protein [Treponema sp. OMZ 788] diamond 993 94.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 788
31751475 31751475 PRJNA493244_P_NODE_1365997_length_278_cov_1.129032_g1342872_i0 PRJNA493244 1365997 278 1.129032 3.13870896 Leptospiraceae bacterium 2026757 Bacteria Bacteria 96.3 1.1200000000000001e-22   NR HMV44079.1 2026757 g1342872 i0 67.2 1.43525179856115 67 22 72.3 0 278 78 114 180 HMV44079.1 hypothetical protein [Leptospiraceae bacterium] diamond 399 96.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31751504 31751504 PRJNA493244_P_NODE_599597_length_641_cov_4.137931_g578069_i0 PRJNA493244 599597 641 4.137931 26.52413771 unclassified Treponema 2638727 Bacteria Bacteria 135 3.6399999999999997e-34   NR WP_253691765.1 2638727 g578069 i0 55.3 2.99063962558502 150 57 66.9 4 35 463 3 149 WP_253691765.1 MULTISPECIES: LysM peptidoglycan-binding domain-containing protein [unclassified Treponema] diamond 1917 135 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema  
32004740 32004740 PRJNA493244_P_NODE_1684458_length_206_cov_0.882759_g1661333_i0 PRJNA493244 1684458 206 0.882759 1.81848354 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 42.4 0.00529   NR MFA7019191.1 2791017 g1661333 i0 90.5 0.305825242718447 21 2 30.6 0 83 21 1 21 MFA7019191.1 hypothetical protein [Sphaerochaetaceae bacterium] diamond 63 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
32052302 32052302 PRJNA493244_P_NODE_1560618_length_229_cov_1.523810_g1537493_i0 PRJNA493244 1560618 229 1.52381 3.4895249 Treponema 157 Bacteria Bacteria 138 4.9099999999999995e-37   NR WP_255812155.1 158 g1537493 i0 81.6 4.97816593886463 76 14 99.6 0 228 1 123 198 WP_255812155.1 transglycosylase SLT domain-containing protein [Treponema denticola] diamond 1140 138 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
32321448 32321448 PRJNA493244_P_NODE_928739_length_439_cov_13.714286_g905744_i0 PRJNA493244 928739 439 13.714286 60.20571554 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 171 7.38e-50   NR MFA6935579.1 2791017 g905744 i0 97.6 0.567198177676538 83 2 56.7 0 19 267 223 305 MFA6935579.1 hypothetical protein [Sphaerochaetaceae bacterium] diamond 249 171 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
32384399 32384399 PRJNA493244_P_NODE_1707199_length_203_cov_0.901408_g1684074_i0 PRJNA493244 1707199 203 0.901408 1.82985824 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 45.8 0.00176   NR MDY3769163.1 2791017 g1684074 i0 45.2 0.620689655172414 42 23 62.1 0 60 185 267 308 MDY3769163.1 restriction endonuclease subunit S [Sphaerochaetaceae bacterium] diamond 126 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
32605673 32605673 PRJNA493244_P_NODE_1733360_length_196_cov_3.651852_g1710235_i0 PRJNA493244 1733360 196 3.651852 7.15762992 Spirochaetota bacterium 2202144 Bacteria Bacteria 47.4 4.47e-4   NR HPS56622.1 2202144 g1710235 i0 55.3 4.82142857142857 38 17 58.2 0 30 143 364 401 HPS56622.1 M14 family carboxypeptidase N/E [Spirochaetota bacterium] diamond 945 47.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32888924 32888924 PRJNA493244_P_NODE_383680_length_858_cov_2.992472_g365879_i0 PRJNA493244 383680 858 2.992472 25.67540976 Treponema pedis 409322 Bacteria Bacteria 185 3.4599999999999996e-54   NR WP_020964460.1 409322 g365879 i0 53 2.13286713286713 202 83 67.5 5 853 275 7 205 WP_020964460.1 ribosome biogenesis GTP-binding protein YihA/YsxC [Treponema pedis] diamond 1830 185 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis

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