RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA760904", 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 · 20 ✖

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJNA760904 · 20 ✖

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
7121023 7121023 PRJNA760904_P_NODE_8106_length_313_cov_1.283333_g8049_i0 PRJNA760904 8106 313 1.283333 4.01683229 Treponema sp. 166 Bacteria Bacteria 157 3.31e-44   NR MCL2277732.1 166 g8049 i0 70.2 23.9233226837061 104 29 99.7 2 2 313 27 128 MCL2277732.1 glutamine synthetase III [Treponema sp.] diamond 7488 157 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
16507828 16507828 PRJNA760904_P_NODE_12633_length_266_cov_1.564767_g12576_i0 PRJNA760904 12633 266 1.564767 4.16228022 Treponema 157 Bacteria Bacteria 244 3.74e-60   NTclustered gi|2034589463|gb|CP050497.1| 69710 g12576 i0 83.721 1.91729323308271 258 42 97 0 9 266 1374216 1373959 Treponema vincentii strain OMZ 806 chromosome, complete genome blastn 510 244 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
27748316 27748316 PRJNA760904_P_NODE_14104_length_255_cov_1.230769_g14047_i0 PRJNA760904 14104 255 1.230769 3.13846095 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 119 6.599999999999998e-29   NR MCF7913854.1 1898206 g14047 i0 65.1 0.976470588235294 83 28 97.6 1 6 254 487 568 MCF7913854.1 6-phosphofructokinase [Spirochaetaceae bacterium] diamond 249 119 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28253200 28253200 PRJNA760904_P_NODE_5406_length_369_cov_1.513514_g5349_i0 PRJNA760904 5406 369 1.513514 5.58486666 Spirochaetia bacterium 2053615 Bacteria Bacteria 64.7 6.51e-10   NR MCE9597456.1 2053615 g5349 i0 48.1 0.642276422764228 79 39 62.6 1 335 105 1 79 MCE9597456.1 hypothetical protein [Spirochaetia bacterium] diamond 237 64.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28316487 28316487 PRJNA760904_P_NODE_7846_length_317_cov_1.262295_g7789_i0 PRJNA760904 7846 317 1.262295 4.00147515 Treponema sp. 166 Bacteria Bacteria 57.4 6.18e-7   NR MCL2801746.1 166 g7789 i0 58.5 2.01577287066246 53 20 50.2 1 156 314 44 94 MCL2801746.1 caspase family protein [Treponema sp.] diamond 639 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28726893 28726893 PRJNA760904_P_NODE_3347_length_450_cov_2.055703_g3290_i0 PRJNA760904 3347 450 2.055703 9.2506635 Spirochaetota bacterium 2202144 Bacteria Bacteria 62.4 1.49e-8   NR MEM7180207.1 2202144 g3290 i0 41.5 0.786666666666667 118 55 76.7 4 99 443 17 123 MEM7180207.1 lysoplasmalogenase [Spirochaetota bacterium] diamond 354 62.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29200687 29200687 PRJNA760904_P_NODE_669_length_904_cov_2.624549_g624_i0 PRJNA760904 669 904 2.624549 23.72592296 Spirochaetota bacterium 2202144 Bacteria Bacteria 73.2 1.93e-10   NR NBC28545.1 2202144 g624 i0 26.8 0.630530973451327 190 129 62.7 3 331 897 83 263 NBC28545.1 ABC transporter substrate-binding protein [Spirochaetota bacterium] diamond 570 73.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29273144 29273144 PRJNA760904_P_NODE_69_length_2058_cov_10.815113_g38_i1 PRJNA760904 69 2058 10.815113 222.57502554 Bacteria 2 Bacteria Bacteria 119 7.17e-25   NR MCX7810722.1 2026757 g38 i1 26.4 1.10932944606414 383 244 53.4 11 1927 830 37 398 MCX7810722.1 amino acid ABC transporter substrate-binding protein [Leptospiraceae bacterium] diamond 2283 119 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29452768 29452768 PRJNA760904_P_NODE_5070_length_379_cov_0.856209_g5013_i0 PRJNA760904 5070 379 0.856209 3.24503211 Spirochaetota bacterium 2202144 Bacteria Bacteria 139 3.7e-36   NR MBN1532559.1 2202144 g5013 i0 47.6 2.95250659630607 126 63 99.7 1 1 378 285 407 MBN1532559.1 SET domain-containing protein-lysine N-methyltransferase [Spirochaetota bacterium] diamond 1119 139 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29958297 29958297 PRJNA760904_P_NODE_17911_length_246_cov_0.890173_g17854_i0 PRJNA760904 17911 246 0.890173 2.18982558 Spirochaetae bacterium HGW-Spirochaetae-1 2013832 Bacteria Bacteria 44.3 0.0109   NR PKL34765.1 2013833 g17854 i0 43.8 1.4390243902439 64 19 74.4 2 188 6 369 418 PKL34765.1 MAG: hypothetical protein CVV45_01350 [Spirochaetae bacterium HGW-Spirochaetae-10] diamond 354 44.3 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-10
30274550 30274550 PRJNA760904_P_NODE_20892_length_241_cov_0.916667_g20835_i0 PRJNA760904 20892 241 0.916667 2.20916747 Treponema sp. 166 Bacteria Bacteria 51.2 3.53e-5   NR MBR1640235.1 166 g20835 i0 42.7 0.933609958506224 75 39 92.1 2 230 9 374 445 MBR1640235.1 ankyrin repeat domain-containing protein [Treponema sp.] diamond 225 51.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30274556 30274556 PRJNA760904_P_NODE_6752_length_337_cov_1.750000_g6695_i0 PRJNA760904 6752 337 1.75 5.8975 Leptospiraceae bacterium 2026757 Bacteria Bacteria 50.8 1.69e-4   NR MBP7282125.1 2026757 g6695 i0 51.2 0.382789317507418 43 21 38.3 0 337 209 1017 1059 MBP7282125.1 tetratricopeptide repeat protein [Leptospiraceae bacterium] diamond 129 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30464274 30464274 PRJNA760904_P_NODE_6933_length_334_cov_0.904215_g6876_i0 PRJNA760904 6933 334 0.904215 3.0200781 Spirochaetota bacterium 2202144 Bacteria Bacteria 73.9 1.21e-12   NR MDH4128113.1 2202144 g6876 i0 43.8 0.79940119760479 89 49 79.9 1 269 3 726 813 MDH4128113.1 VIT domain-containing protein [Spirochaetota bacterium] diamond 267 73.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31443528 31443528 PRJNA760904_P_NODE_19836_length_242_cov_1.183432_g19779_i0 PRJNA760904 19836 242 1.183432 2.86390544 Spirochaetota bacterium 2202144 Bacteria Bacteria 43.9 0.0146   NR MDH4128113.1 2202144 g19779 i0 36.8 0.942148760330578 76 45 93 3 225 1 218 291 MDH4128113.1 VIT domain-containing protein [Spirochaetota bacterium] diamond 228 43.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31674539 31674539 PRJNA760904_P_NODE_8777_length_302_cov_3.270742_g8720_i0 PRJNA760904 8777 302 3.270742 9.87764084 Leptospira 171 Bacteria Bacteria 130 2.11e-34   NR MDZ4728104.1 178 g8720 i0 65 3.1887417218543 80 28 79.5 0 300 61 201 280 MDZ4728104.1 acyl-CoA desaturase [Leptospira sp.] diamond 963 131 0.99236641221374 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32012985 32012985 PRJNA760904_P_NODE_10298_length_285_cov_1.245283_g10241_i0 PRJNA760904 10298 285 1.245283 3.54905655 Spirochaetales bacterium 2026792 Bacteria Bacteria 120 2.11e-29   NR HOX31087.1 2026792 g10241 i0 60.5 2.71578947368421 86 32 90.5 1 261 4 440 523 HOX31087.1 aspartate carbamoyltransferase [Spirochaetales bacterium] diamond 774 120 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32329710 32329710 PRJNA760904_P_NODE_8459_length_307_cov_3.658120_g8402_i0 PRJNA760904 8459 307 3.65812 11.2304284 Spirochaetales bacterium 2026792 Bacteria Bacteria 96.3 3.14e-22   NR MFP4377744.1 2026792 g8402 i0 55.6 1.76872964169381 90 40 87.9 0 281 12 118 207 MFP4377744.1 adenylate kinase [Spirochaetales bacterium] diamond 543 96.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32392634 32392634 PRJNA760904_P_NODE_14199_length_254_cov_1.425414_g14142_i0 PRJNA760904 14199 254 1.425414 3.62055156 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 108 9.96e-26   NR MCE5255577.1 1898206 g14142 i0 58.3 0.992125984251969 84 35 99.2 0 254 3 97 180 MCE5255577.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Spirochaetaceae bacterium] diamond 252 108 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32519481 32519481 PRJNA760904_P_NODE_2839_length_484_cov_1.418491_g2782_i0 PRJNA760904 2839 484 1.418491 6.86549644 Spirochaetales bacterium 2026792 Bacteria Bacteria 87.4 1.41e-16   NR MBN1409698.1 2026792 g2782 i0 35.9 1.79752066115702 145 92 89.9 1 436 2 1131 1274 MBN1409698.1 carbohydrate binding domain-containing protein [Spirochaetales bacterium] diamond 870 87.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32551163 32551163 PRJNA760904_P_NODE_6199_length_349_cov_0.826087_g6142_i0 PRJNA760904 6199 349 0.826087 2.88304363 Leptospira chreensis 2810035 Bacteria Bacteria 50.4 1.5e-4   NR WP_232373698.1 2810035 g6142 i0 35.4 0.851002865329513 99 57 79.1 2 74 349 93 191 WP_232373698.1 DUF6962 family protein [Leptospira chreensis] diamond 297 50.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira chreensis

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