RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB81327" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJEB81327 · 17 ✖

analysis 1

  • diamond · 17 ✖

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