RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 23 ✖

bioproject 1

  • PRJNA1122875 · 23 ✖

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
5380654 5380654 PRJNA1122875_P_NODE_20705_length_366_cov_1.313993_g20481_i0 PRJNA1122875 20705 366 1.313993 4.80921438 Leptospira weilii 28184 Bacteria Bacteria 56.5 0.003   NTclustered gi|1700671430|gb|CP040840.1| 28184 g20481 i0 100 0.163934426229508 30 0 8 0 295 324 1362970 1362941 Leptospira weilii strain CUDO6 chromosome I, complete sequence blastn 60 56.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira weilii
9205407 9205407 PRJNA1122875_P_NODE_12408_length_473_cov_1.155000_g12185_i0 PRJNA1122875 12408 473 1.155 5.46315 Rectinema sp. 1937017 Bacteria Bacteria 177 2.41e-51   NR MEN6364430.1 1937017 g12185 i0 88.7 4.93446088794926 97 11 61.5 0 3 293 260 356 MEN6364430.1 type I glyceraldehyde-3-phosphate dehydrogenase [Rectinema sp.] diamond 2334 177 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae Rectinema Rectinema sp.
13031429 13031429 PRJNA1122875_P_NODE_42751_length_252_cov_0.782123_g42527_i0 PRJNA1122875 42751 252 0.782123 1.97094996 Spirochaetota bacterium 2202144 Bacteria Bacteria 115 2.8700000000000003e-21   NTclustered gi|2649718696|emb|OZ001226.1| 2202144 g42527 i0 85.455 5.94444444444444 110 16 44 0 143 252 74373 74482 MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19 blastn 1498 115 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
26975153 26975153 PRJNA1122875_P_NODE_15682_length_421_cov_2.893678_g15458_i0 PRJNA1122875 15682 421 2.893678 12.18238438 Spirochaetota bacterium 2202144 Bacteria Bacteria 108 8.580000000000001e-27   NR MCU0821823.1 2202144 g15458 i0 40.8 2.5938242280285 125 57 89.1 2 6 380 48 155 MCU0821823.1 SET domain-containing protein-lysine N-methyltransferase [Spirochaetota bacterium] diamond 1092 108 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27228072 27228072 PRJNA1122875_P_NODE_27143_length_317_cov_1.213115_g26919_i0 PRJNA1122875 27143 317 1.213115 3.84557455 Spirochaetota bacterium 2202144 Bacteria Bacteria 92 2.81e-19   NR MBP7585203.1 2202144 g26919 i0 58 4.81703470031546 81 34 76.7 0 292 50 317 397 MBP7585203.1 ATP-binding protein [Spirochaetota bacterium] diamond 1527 92 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27733863 27733863 PRJNA1122875_P_NODE_42024_length_254_cov_1.734807_g41800_i0 PRJNA1122875 42024 254 1.734807 4.40640978 Candidatus Gallitreponema excrementavium 2840840 Bacteria Bacteria 45.8 0.00339   NR MBO8457554.1 2840840 g41800 i0 48.8 0.484251968503937 41 21 48.4 0 212 90 381 421 MBO8457554.1 coproporphyrinogen III oxidase family protein [Candidatus Gallitreponema excrementavium] diamond 123 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales   Candidatus Gallitreponema Candidatus Gallitreponema excrementavium
27891242 27891242 PRJNA1122875_P_NODE_15685_length_421_cov_2.413793_g15461_i0 PRJNA1122875 15685 421 2.413793 10.16206853 Spirochaetota bacterium 2202144 Bacteria Bacteria 50.1 1.54e-4   NR HNX23779.1 2202144 g15461 i0 30.8 2.40855106888361 91 60 64.1 3 12 281 50 138 HNX23779.1 hypothetical protein [Spirochaetota bacterium] diamond 1014 50.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28112288 28112288 PRJNA1122875_P_NODE_10745_length_506_cov_2.512702_g10524_i0 PRJNA1122875 10745 506 2.512702 12.71427212 Treponema ruminis 744515 Bacteria Bacteria 45.8 0.0352   NR WP_184661718.1 744515 g10524 i0 36 0.444664031620553 75 43 44.5 1 420 196 186 255 WP_184661718.1 DUF1015 domain-containing protein [Treponema ruminis] diamond 225 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema ruminis
28417599 28417599 PRJNA1122875_P_NODE_19846_length_374_cov_1.411960_g19622_i0 PRJNA1122875 19846 374 1.41196 5.2807304 Turneriella 338321 Bacteria Bacteria 110 1.3100000000000002e-27   NR MBN8222660.1 2202144 g19622 i0 81.3 1.02673796791444 64 12 51.3 0 369 178 122 185 MBN8222660.1 FAD-dependent oxidoreductase [Spirochaetota bacterium] diamond 384 110 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28554627 28554627 PRJNA1122875_P_NODE_31427_length_291_cov_1.481651_g31203_i0 PRJNA1122875 31427 291 1.481651 4.31160441 Spirochaetia bacterium 2053615 Bacteria Bacteria 58.2 1.93e-7   NR HEQ70936.1 2053615 g31203 i0 50 2.02061855670103 54 27 55.7 0 288 127 208 261 HEQ70936.1 molecular chaperone DnaJ [Spirochaetia bacterium] diamond 588 58.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29017666 29017666 PRJNA1122875_P_NODE_38368_length_268_cov_1.282051_g38144_i0 PRJNA1122875 38368 268 1.282051 3.43589668 Pseudomonadati 3379134 Bacteria Bacteria 53.5 6.48e-6   NR MDR2257590.1 166 g38144 i0 49 4.28731343283582 51 26 57.1 0 266 114 217 267 MDR2257590.1 SDR family oxidoreductase [Treponema sp.] diamond 1149 53.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29217675 29217675 PRJNA1122875_P_NODE_13869_length_447_cov_2.470588_g13645_i0 PRJNA1122875 13869 447 2.470588 11.04352836 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 119 7.46e-29   NR MFP4301054.1 1898206 g13645 i0 44.2 2.91275167785235 147 79 98.7 3 446 6 123 266 MFP4301054.1 ABC transporter substrate-binding protein [Spirochaetaceae bacterium] diamond 1302 119 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29501581 29501581 PRJNA1122875_P_NODE_41330_length_257_cov_1.342391_g41106_i0 PRJNA1122875 41330 257 1.342391 3.44994487 Brachyspira hyodysenteriae 159 Bacteria Bacteria 48.1 5.24e-4   NR WP_012671201.1 159 g41106 i0 66.7 0.840466926070039 36 11 42 1 123 16 27 61 WP_012671201.1 glycosyltransferase family 2 protein [Brachyspira hyodysenteriae] diamond 216 48.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hyodysenteriae
29869834 29869834 PRJNA1122875_P_NODE_32111_length_289_cov_1.287037_g31887_i0 PRJNA1122875 32111 289 1.287037 3.71953693 root 1 Root_unresolved Root_unresolved 54.3 2.35e-7   NR MBQ6780847.1 166 g31887 i0 49.1 6.21799307958478 53 27 55 0 289 131 11 63 MBQ6780847.1 SEL1-like repeat protein [Treponema sp.] diamond 1797 54.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30596332 30596332 PRJNA1122875_P_NODE_48093_length_246_cov_1.566474_g47869_i0 PRJNA1122875 48093 246 1.566474 3.85352604 Pseudomonadati 3379134 Bacteria Bacteria 48.5 3.94e-5   NR WP_287281463.1 166 g47869 i0 53.8 2.53658536585366 39 18 47.6 0 45 161 46 84 WP_287281463.1 RNA recognition motif domain-containing protein [Treponema sp.] diamond 624 48.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30733587 30733587 PRJNA1122875_P_NODE_27854_length_312_cov_1.489540_g27630_i0 PRJNA1122875 27854 312 1.48954 4.6473648 Leptospiraceae bacterium 2026757 Bacteria Bacteria 80.1 6.3e-15   NR MBP9889133.1 2026757 g27630 i0 48.8 0.788461538461538 82 39 78.8 1 249 4 443 521 MBP9889133.1 NCS2 family permease [Leptospiraceae bacterium] diamond 246 80.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31449957 31449957 PRJNA1122875_P_NODE_42236_length_254_cov_0.872928_g42012_i0 PRJNA1122875 42236 254 0.872928 2.21723712 Bacteria 2 Bacteria Bacteria 102 4.92e-25   NR OQA62587.1 1852911 g42012 i0 67.6 7.99606299212598 68 22 80.3 0 210 7 2 69 OQA62587.1 MAG: Acetyltransferase (GNAT) family protein [Spirochaetes bacterium ADurb.Bin269] diamond 2031 103 0.990291262135922 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium ADurb.Bin269
31492418 31492418 PRJNA1122875_P_NODE_40496_length_260_cov_1.647059_g40272_i0 PRJNA1122875 40496 260 1.647059 4.2823534 Spirochaetota bacterium 2202144 Bacteria Bacteria 94.7 2.35e-20   NR TXH08342.1 2202144 g40272 i0 50 0.992307692307692 86 43 99.2 0 258 1 469 554 TXH08342.1 MAG: hypothetical protein E6R04_10880 [Spirochaetota bacterium] diamond 258 94.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31776899 31776899 PRJNA1122875_P_NODE_7877_length_580_cov_1.187377_g7659_i0 PRJNA1122875 7877 580 1.187377 6.8867866 Leptospiraceae bacterium 2026757 Bacteria Bacteria 90.5 2.19e-17   NR MCB1176098.1 2026757 g7659 i0 35.7 1.07068965517241 207 112 98.3 8 570 1 158 360 MCB1176098.1 NHL repeat-containing protein [Leptospiraceae bacterium] diamond 621 90.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32219913 32219913 PRJNA1122875_P_NODE_2818_length_867_cov_1.481108_g2650_i0 PRJNA1122875 2818 867 1.481108 12.84120636 Leptospiraceae bacterium 2026757 Bacteria Bacteria 152 1.33e-40   NR HMV79346.1 2026757 g2650 i0 37.4 1.73356401384083 246 134 78.9 5 184 867 5 248 HMV79346.1 hypothetical protein [Leptospiraceae bacterium] diamond 1503 152 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32788193 32788193 PRJNA1122875_P_NODE_51400_length_243_cov_0.905882_g51176_i0 PRJNA1122875 51400 243 0.905882 2.20129326 Treponema sp. GWB1_62_6 1802379 Bacteria Bacteria 42.7 0.0365   NR OHE61627.1 1802379 g51176 i0 63 0.333333333333333 27 10 33.3 0 82 2 401 427 OHE61627.1 MAG: hypothetical protein A2Z99_04185 [Treponema sp. GWB1_62_6] diamond 81 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. GWB1_62_6
32819794 32819794 PRJNA1122875_P_NODE_42120_length_254_cov_1.353591_g41896_i0 PRJNA1122875 42120 254 1.353591 3.43812114 Leptospira sp. 178 Bacteria Bacteria 67 2.23e-12   NR MCU0824232.1 178 g41896 i0 44.9 0.921259842519685 78 42 92.1 1 235 2 1 77 MCU0824232.1 EF-hand domain-containing protein [Leptospira sp.] diamond 234 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
32851240 32851240 PRJNA1122875_P_NODE_51840_length_243_cov_0.905882_g51616_i0 PRJNA1122875 51840 243 0.905882 2.20129326 Leptospira ellisii 2023197 Bacteria Bacteria 61.6 5.28e-9   NR WP_100765539.1 2023197 g51616 i0 34.6 2.87654320987654 81 53 100 0 243 1 18 98 WP_100765539.1 dienelactone hydrolase family protein [Leptospira ellisii] diamond 699 61.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira ellisii

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