RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where bioproject = "PRJEB81327", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 28 ✖

tax_phylum 1

  • Spirochaetota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJEB81327 · 28 ✖

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
139926 139926 PRJEB81327_P_NODE_45021_length_252_cov_3.189944_g44413_i0 PRJEB81327 45021 252 3.189944 8.03865888 Treponema medium 58231 Bacteria Bacteria 466 6.89e-127   NTclustered gi|1996291085|gb|CP027017.1| 58231 g44413 i0 100 195.93253968254 252 0 100 0 1 252 1845860 1845609 Treponema medium strain T19 chromosome, complete genome blastn 49375 466 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
139969 139969 PRJEB81327_P_NODE_48021_length_250_cov_1.282486_g47413_i0 PRJEB81327 48021 250 1.282486 3.206215 Treponema denticola 158 Bacteria Bacteria 446 8.89e-121   NTclustered gi|2265190365|gb|CP054477.1| 158 g47413 i0 98.8 31.572 250 3 100 0 1 250 2119243 2119492 Treponema denticola strain OMZ 823 chromosome, complete genome blastn 7893 446 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
2271994 2271994 PRJEB81327_P_NODE_21682_length_298_cov_2.040000_g21074_i0 PRJEB81327 21682 298 2.04 6.0792 Treponema 157 Bacteria Bacteria 534 2.26e-147   NTclustered gi|1807378492|gb|CP048020.1| 69710 g21074 i0 98.993 194.926174496644 298 3 100 0 1 298 2079370 2079667 Treponema vincentii strain OMZ 804 chromosome, complete genome blastn 58088 534 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
3547850 3547850 PRJEB81327_P_NODE_7423_length_516_cov_2.952596_g6819_i0 PRJEB81327 7423 516 2.952596 15.23539536 Treponema 157 Bacteria Bacteria 937 0   NTclustered gi|1807378492|gb|CP048020.1| 69710 g6819 i0 99.419 196.085271317829 516 3 100 0 1 516 2739491 2738976 Treponema vincentii strain OMZ 804 chromosome, complete genome blastn 101180 937 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
12893108 12893108 PRJEB81327_P_NODE_19411_length_310_cov_3.396624_g18803_i0 PRJEB81327 19411 310 3.396624 10.5295344 Treponema vincentii 69710 Bacteria Bacteria 187 7.61e-43   NTclustered gi|2034589463|gb|CP050497.1| 69710 g18803 i0 89.726 3.29354838709677 146 15 95 0 163 308 2489746 2489891 Treponema vincentii strain OMZ 806 chromosome, complete genome blastn 1021 187 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
14168099 14168099 PRJEB81327_P_NODE_27372_length_283_cov_1.466667_g26764_i0 PRJEB81327 27372 283 1.466667 4.15066761 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 490 4.67e-134   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g26764 i0 98.214 156.802120141343 280 5 99 0 1 280 2590451 2590730 Treponema sp. Marseille-Q4132 chromosome blastn 44375 490 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
15442578 15442578 PRJEB81327_P_NODE_54333_length_247_cov_0.885057_g53725_i0 PRJEB81327 54333 247 0.885057 2.18609079 Spirochaeta lutea 1480694 Bacteria Bacteria 62.8 2.7e-10   NR WP_037547802.1 1480694 g53725 i0 67.4 0.558704453441296 46 14 55.9 1 108 245 8 52 WP_037547802.1 glycine cleavage system protein GcvH [Spirochaeta lutea] diamond 138 62.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta lutea
20123764 20123764 PRJEB81327_P_NODE_65736_length_240_cov_3.203593_g65128_i0 PRJEB81327 65736 240 3.203593 7.6886232 Treponema 157 Bacteria Bacteria 444 3.05e-120   NTclustered gi|2265136109|gb|CP051197.1| 69710 g65128 i0 100 184.720833333333 240 0 100 0 1 240 326286 326525 Treponema vincentii strain OMZ 802 chromosome, complete genome blastn 44333 444 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
21816415 21816415 PRJEB81327_P_NODE_22198_length_295_cov_5.954955_g21590_i0 PRJEB81327 22198 295 5.954955 17.56711725 Treponema sp. 166 Bacteria Bacteria 237 7.040000000000001e-58   NTclustered gi|2189480979|gb|CP091737.1| 166 g21590 i0 81.915 1.91186440677966 282 49 95 2 7 287 30060 29780 MAG: Treponema sp. isolate nC27_bin.160.fa chromosome blastn 564 237 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
21816512 21816512 PRJEB81327_P_NODE_29538_length_279_cov_1.495146_g28930_i0 PRJEB81327 29538 279 1.495146 4.17145734 Brachyspira intermedia 84377 Bacteria Bacteria 52.8 0.026   NTclustered gi|343385146|gb|CP002874.1| 1045858 g28930 i0 100 0.100358422939068 28 0 10 0 243 270 2801746 2801773 Brachyspira intermedia PWS/A, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira intermedia
23949753 23949753 PRJEB81327_P_NODE_9959_length_434_cov_2.351801_g9351_i0 PRJEB81327 9959 434 2.351801 10.20681634 Treponema 157 Bacteria Bacteria 774 0   NTclustered gi|1807378492|gb|CP048020.1| 69710 g9351 i0 98.848 189.267281105991 434 5 100 0 1 434 2078614 2078181 Treponema vincentii strain OMZ 804 chromosome, complete genome blastn 82142 780 0.992307692307692 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
24365659 24365659 PRJEB81327_P_NODE_37960_length_264_cov_2.764398_g37352_i0 PRJEB81327 37960 264 2.764398 7.29801072 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 483 7.219999999999998e-132   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g37352 i0 99.621 209.25 264 1 100 0 1 264 1779290 1779027 Treponema sp. Marseille-Q4132 chromosome blastn 55242 483 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
27382056 27382056 PRJEB81327_P_NODE_57823_length_245_cov_0.895349_g57215_i0 PRJEB81327 57823 245 0.895349 2.19360505 Spirochaetae bacterium HGW-Spirochaetae-1 2013832 Bacteria Bacteria 151 1.6699999999999998e-45   NR PKL32409.1 2013833 g57215 i0 98.6 0.869387755102041 71 1 86.9 0 243 31 36 106 PKL32409.1 MAG: hypothetical protein CVV45_12870 [Spirochaetae bacterium HGW-Spirochaetae-10] diamond 213 151 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-10
27476663 27476663 PRJEB81327_P_NODE_58223_length_245_cov_0.895349_g57615_i0 PRJEB81327 58223 245 0.895349 2.19360505 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 158 5.939999999999999e-46   NR MFA6687967.1 2791017 g57615 i0 98.8 0.991836734693878 81 1 99.2 0 244 2 24 104 MFA6687967.1 phosphatidate cytidylyltransferase [Sphaerochaetaceae bacterium] diamond 243 158 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
27824143 27824143 PRJEB81327_P_NODE_19804_length_310_cov_2.763713_g19196_i0 PRJEB81327 19804 310 2.763713 8.5675103 Leptonema illini 183 Bacteria Bacteria 179 9.86e-52   NR WP_002773396.1 183 g19196 i0 83.6 1.12258064516129 116 5 98.7 1 3 308 139 254 WP_002773396.1 TolC family protein [Leptonema illini] diamond 348 179 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
27981915 27981915 PRJEB81327_P_NODE_27565_length_283_cov_1.180952_g26957_i0 PRJEB81327 27565 283 1.180952 3.34209416 Leptospiraceae bacterium 2026757 Bacteria Bacteria 47.8 9.41e-4   NR MBP7283163.1 2026757 g26957 i0 32.2 2.80918727915194 87 54 92.2 2 6 266 225 306 MBP7283163.1 NADP-dependent oxidoreductase [Leptospiraceae bacterium] diamond 795 47.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28044965 28044965 PRJEB81327_P_NODE_46345_length_251_cov_0.865169_g45737_i0 PRJEB81327 46345 251 0.865169 2.17157419 Spirochaetota bacterium 2202144 Bacteria Bacteria 47 0.00126   NR HPJ35142.1 2202144 g45737 i0 56.3 0.776892430278884 32 14 38.2 0 2 97 328 359 HPJ35142.1 BMP family ABC transporter substrate-binding protein [Spirochaetota bacterium] diamond 195 47 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28550382 28550382 PRJEB81327_P_NODE_17887_length_320_cov_1.076923_g17279_i0 PRJEB81327 17887 320 1.076923 3.4461536 Leptospiraceae bacterium 2026757 Bacteria Bacteria 124 1.24e-33   NR HNO24933.1 2026757 g17279 i0 72.4 0.815625 87 24 81.6 0 319 59 56 142 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 261 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29654878 29654878 PRJEB81327_P_NODE_42150_length_257_cov_2.445652_g41542_i0 PRJEB81327 42150 257 2.445652 6.28532564 Treponema sp. 166 Bacteria Bacteria 179 4.62e-50   NR MCI7567329.1 166 g41542 i0 98.8 2.96498054474708 85 1 99.2 0 255 1 990 1074 MCI7567329.1 DEAD/DEAH box helicase family protein [Treponema sp.] diamond 762 179 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29876429 29876429 PRJEB81327_P_NODE_55071_length_246_cov_1.687861_g54463_i0 PRJEB81327 55071 246 1.687861 4.15213806 Treponema sp. 166 Bacteria Bacteria 45.8 0.00203   NR MDR2135581.1 166 g54463 i0 39.1 0.780487804878049 64 39 78 0 49 240 19 82 MDR2135581.1 flavin reductase family protein [Treponema sp.] diamond 192 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30445185 30445185 PRJEB81327_P_NODE_39333_length_262_cov_1.629630_g38725_i0 PRJEB81327 39333 262 1.62963 4.2696306 Spirochaetales bacterium 2026792 Bacteria Bacteria 60.8 1.59e-8   NR MDC7221901.1 2026792 g38725 i0 35.3 1.87786259541985 85 55 97.3 0 7 261 212 296 MDC7221901.1 ankyrin repeat domain-containing protein [Spirochaetales bacterium] diamond 492 60.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
31266608 31266608 PRJEB81327_P_NODE_41035_length_259_cov_2.204301_g40427_i0 PRJEB81327 41035 259 2.204301 5.70913959 Turneriella sp. 2717305 Bacteria Bacteria 124 6.78e-32   NR MFO1471150.1 2717305 g40427 i0 74.1 2.91891891891892 85 22 98.5 0 5 259 55 139 MFO1471150.1 D-alanine--D-alanine ligase family protein [Turneriella sp.] diamond 756 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella sp.
31393247 31393247 PRJEB81327_P_NODE_32636_length_274_cov_0.860697_g32028_i0 PRJEB81327 32636 274 0.860697 2.35830978 Treponema sp. 166 Bacteria Bacteria 43.5 0.0278   NR MDR2048500.1 166 g32028 i0 36.9 0.711678832116788 65 41 71.2 0 26 220 113 177 MDR2048500.1 GTPase ObgE [Treponema sp.] diamond 195 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31614462 31614462 PRJEB81327_P_NODE_48176_length_250_cov_0.870056_g47568_i0 PRJEB81327 48176 250 0.870056 2.17514 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 128 5.74e-36   NR OHD23895.1 1802176 g47568 i0 70.7 0.984 82 24 98.4 0 247 2 40 121 OHD23895.1 MAG: hypothetical protein A2Y38_20335 [Spirochaetes bacterium GWB1_59_5] diamond 246 128 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
32500545 32500545 PRJEB81327_P_NODE_12119_length_389_cov_1.449367_g11511_i0 PRJEB81327 12119 389 1.449367 5.63803763 Treponema sp. 166 Bacteria Bacteria 46.2 0.00523   NR MBD5443786.1 166 g11511 i0 54.8 0.786632390745501 31 14 23.9 0 147 55 121 151 MBD5443786.1 CAP domain-containing protein [Treponema sp.] diamond 306 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32532198 32532198 PRJEB81327_P_NODE_30619_length_277_cov_1.509804_g30011_i0 PRJEB81327 30619 277 1.509804 4.18215708 Treponema sp. 166 Bacteria Bacteria 104 2.8099999999999998e-24   NR MBP5174516.1 166 g30011 i0 79.4 1.94945848375451 63 13 68.2 0 87 275 1 63 MBP5174516.1 DNA adenine methylase [Treponema sp.] diamond 540 104 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32595223 32595223 PRJEB81327_P_NODE_19680_length_310_cov_2.915612_g19072_i0 PRJEB81327 19680 310 2.915612 9.0383972 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 45.4 0.00916   NR MCE5255809.1 1898206 g19072 i0 40 0.483870967741935 50 30 48.4 0 161 310 106 155 MCE5255809.1 ABC transporter ATP-binding protein/permease [Spirochaetaceae bacterium] diamond 150 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32815485 32815485 PRJEB81327_P_NODE_24380_length_288_cov_3.311628_g23772_i0 PRJEB81327 24380 288 3.311628 9.53748864 Spirochaetales bacterium 2026792 Bacteria Bacteria 142 1.17e-40   NR MBE7438530.1 2026792 g23772 i0 75.8 1.97916666666667 95 23 99 0 2 286 36 130 MBE7438530.1 ribosome recycling factor [Spirochaetales bacterium] diamond 570 142 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales 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);;