RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 24 ✖

bioproject 1

  • PRJNA976345 · 24 ✖

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
947742 947742 PRJNA976345_P_NODE_121341_length_178_cov_2.412587_g119733_i0 PRJNA976345 121341 178 2.412587 4.29440486 Treponema denticola 158 Bacteria Bacteria 139 1.1199999999999999e-28   NTclustered gi|2265166044|gb|CP051303.1| 158 g119733 i0 100 9.17977528089888 75 0 84 0 1 75 1536483 1536557 Treponema denticola strain OT2B chromosome, complete genome blastn 1634 139 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
4776923 4776923 PRJNA976345_P_NODE_59544_length_230_cov_2.194872_g57936_i0 PRJNA976345 59544 230 2.194872 5.0482056 Treponema sp. OMZ 788 2563664 Bacteria Bacteria 52.8 0.021   NTclustered gi|2265141765|gb|CP051199.1| 2563664 g57936 i0 100 0.121739130434783 28 0 12 0 62 89 2515017 2515044 Treponema sp. OMZ 788 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 788
7645245 7645245 PRJNA976345_P_NODE_199466_length_150_cov_1.373913_g197858_i0 PRJNA976345 199466 150 1.373913 2.0608695 Borrelia 138 Bacteria Bacteria 54.7 0.003   NTclustered gi|576104362|gb|CP004146.1| 1293576 g197858 i0 100 0.766666666666667 29 0 19 0 71 99 390147 390119 Borrelia hermsii YOR, complete genome blastn 115 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia nietonii
8919852 8919852 PRJNA976345_P_NODE_134967_length_173_cov_1.630435_g133359_i0 PRJNA976345 134967 173 1.630435 2.82065255 Brachyspira 29521 Bacteria Bacteria 54.7 0.004   NTclustered gi|2021755399|gb|CP046930.1| 159 g133359 i0 96.97 2.28901734104046 33 0 18 1 1 32 546839 546871 Brachyspira hyodysenteriae strain BHZ375 chromosome, complete genome blastn 396 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hyodysenteriae
9875928 9875928 PRJNA976345_P_NODE_130208_length_175_cov_2.185714_g128600_i0 PRJNA976345 130208 175 2.185714 3.8249995 Brachyspira intermedia 84377 Bacteria Bacteria 52.8 0.015   NTclustered gi|343385146|gb|CP002874.1| 1045858 g128600 i0 100 0.16 28 0 16 0 34 61 602231 602204 Brachyspira intermedia PWS/A, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira intermedia
10195760 10195760 PRJNA976345_P_NODE_169268_length_159_cov_1.604839_g167660_i0 PRJNA976345 169268 159 1.604839 2.55169401 Borreliella 64895 Bacteria Bacteria 52.8 0.013   NTclustered gi|2592014987|gb|CP118292.1| 29519 g167660 i0 96.774 1.34591194968553 31 1 19 0 28 58 11438 11468 Borreliella garinii strain 17-56Z1 plasmid lp17 blastn 214 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii
10196133 10196133 PRJNA976345_P_NODE_79368_length_206_cov_2.707602_g77760_i0 PRJNA976345 79368 206 2.707602 5.57766012 Treponema 157 Bacteria Bacteria 243 9.96e-60   NTclustered gi|719625061|gb|CP009227.1| 1539298 g77760 i0 87.864 12.6067961165049 206 25 100 0 1 206 1684343 1684548 Treponema sp. OMZ 838, complete genome blastn 2597 243 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 838
15295078 15295078 PRJNA976345_P_NODE_178772_length_156_cov_1.322314_g177164_i0 PRJNA976345 178772 156 1.322314 2.06280984 Treponema 157 Bacteria Bacteria 172 9.45e-39   NTclustered gi|1807378492|gb|CP048020.1| 69710 g177164 i0 86.538 4.94230769230769 156 21 100 0 1 156 1798600 1798445 Treponema vincentii strain OMZ 804 chromosome, complete genome blastn 771 172 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
16251509 16251509 PRJNA976345_P_NODE_53953_length_240_cov_1.390244_g52345_i0 PRJNA976345 53953 240 1.390244 3.3365856 Treponema brennaborense 81028 Bacteria Bacteria 54.7 0.006   NTclustered gi|332179772|gb|CP002696.1| 906968 g52345 i0 94.286 0.145833333333333 35 2 15 0 47 81 1851621 1851587 Treponema brennaborense DSM 12168, complete genome blastn 35 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema brennaborense
18800615 18800615 PRJNA976345_P_NODE_79015_length_207_cov_1.366279_g77407_i0 PRJNA976345 79015 207 1.366279 2.82819753 Treponema sp. OMZ 906 2563662 Bacteria Bacteria 287 4.56e-73   NTclustered gi|2265130757|gb|CP051196.1| 2563662 g77407 i0 93.717 7.38164251207729 191 12 92 0 2 192 2675193 2675383 Treponema sp. OMZ 906 chromosome, complete genome blastn 1528 287 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 906
23901242 23901242 PRJNA976345_P_NODE_6259_length_727_cov_8.170520_g4912_i0 PRJNA976345 6259 727 8.17052 59.3996804 Leptospira kirschneri 29507 Bacteria Bacteria 56.5 0.006   NTclustered gi|2355083728|gb|CP112976.1| 29507 g4912 i0 100 0.163686382393398 30 0 4 0 558 587 3816786 3816815 Leptospira kirschneri strain I-7 chromosome 1, complete sequence blastn 119 56.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira kirschneri
26772864 26772864 PRJNA976345_P_NODE_16701_length_414_cov_2.034301_g15112_i0 PRJNA976345 16701 414 2.034301 8.42200614 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 170 2.75e-49   NR MFA6734489.1 2791017 g15112 i0 63 0.978260869565217 135 50 97.8 0 2 406 138 272 MFA6734489.1 DUF932 domain-containing protein [Sphaerochaetaceae bacterium] diamond 405 170 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
26962601 26962601 PRJNA976345_P_NODE_21862_length_360_cov_2.378462_g20262_i0 PRJNA976345 21862 360 2.378462 8.5624632 Spirochaetia bacterium 2053615 Bacteria Bacteria 189 1.9e-55   NR HRV29226.1 2053615 g20262 i0 89.7 0.891666666666667 107 11 89.2 0 323 3 200 306 HRV29226.1 hypothetical protein [Spirochaetia bacterium] diamond 321 189 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27374057 27374057 PRJNA976345_P_NODE_79563_length_206_cov_2.222222_g77955_i0 PRJNA976345 79563 206 2.222222 4.57777732 Leptospiraceae bacterium 2026757 Bacteria Bacteria 42.7 0.0222   NR MCX7811863.1 2026757 g77955 i0 55.6 0.655339805825243 45 18 65.5 1 188 54 114 156 MCX7811863.1 alpha/beta hydrolase [Leptospiraceae bacterium] diamond 135 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30152181 30152181 PRJNA976345_P_NODE_19552_length_381_cov_2.387283_g17955_i0 PRJNA976345 19552 381 2.387283 9.09554823 Spirochaetia bacterium 2053615 Bacteria Bacteria 179 9.219999999999999e-54   NR HRS66228.1 2053615 g17955 i0 78.1 0.826771653543307 105 23 82.7 0 379 65 144 248 HRS66228.1 hypothetical protein [Spirochaetia bacterium] diamond 315 179 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30247428 30247428 PRJNA976345_P_NODE_151072_length_166_cov_1.221374_g149464_i0 PRJNA976345 151072 166 1.221374 2.02748084 Spirochaetia bacterium 2053615 Bacteria Bacteria 100 7.879999999999999e-23   NR HRV29560.1 2053615 g149464 i0 100 0.975903614457831 54 0 97.6 0 164 3 300 353 HRV29560.1 Rho termination factor N-terminal domain-containing protein [Spirochaetia bacterium] diamond 162 100 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30374049 30374049 PRJNA976345_P_NODE_75972_length_210_cov_1.525714_g74364_i0 PRJNA976345 75972 210 1.525714 3.2039994 Leptospira brenneri 2023182 Bacteria Bacteria 42 0.0414   NR WP_100792319.1 2023182 g74364 i0 38.9 0.771428571428571 54 32 77.1 1 162 1 3 55 WP_100792319.1 hypothetical protein [Leptospira brenneri] diamond 162 42 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira brenneri
30380183 30380183 PRJNA976345_P_NODE_181292_length_155_cov_1.708333_g179684_i0 PRJNA976345 181292 155 1.708333 2.64791615 Bacteria 2 Bacteria Bacteria 65.1 6.93e-11   NR MCL2180279.1 166 g179684 i0 82.5 9.29032258064516 40 7 77.4 0 120 1 15 54 MCL2180279.1 NAD(+) synthase [Treponema sp.] diamond 1440 65.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32175916 32175916 PRJNA976345_P_NODE_175178_length_157_cov_1.622951_g173570_i0 PRJNA976345 175178 157 1.622951 2.54803307 Spirochaetia bacterium 2053615 Bacteria Bacteria 91.3 6.04e-20   NR HRS66670.1 2053615 g173570 i0 92.3 2.98089171974522 52 4 99.4 0 2 157 292 343 HRS66670.1 hypothetical protein [Spirochaetia bacterium] diamond 468 91.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32428886 32428886 PRJNA976345_P_NODE_115579_length_180_cov_1.917241_g113971_i0 PRJNA976345 115579 180 1.917241 3.4510338 Treponema sp. OMZ 799 2563668 Bacteria Bacteria 42 0.0295   NR WP_253707661.1 2563668 g113971 i0 42.6 0.783333333333333 47 21 78.3 1 170 30 208 248 WP_253707661.1 JAB domain-containing protein [Treponema sp. OMZ 799] diamond 141 42 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 799
32524038 32524038 PRJNA976345_P_NODE_15939_length_424_cov_3.776350_g14352_i0 PRJNA976345 15939 424 3.77635 16.011724 Spirochaetia bacterium 2053615 Bacteria Bacteria 57 2.47e-6   NR GHV60830.1 2053615 g14352 i0 61 0.290094339622642 41 16 29 0 420 298 153 193 GHV60830.1 hypothetical protein AGMMS49587_03450 [Spirochaetia bacterium] diamond 123 57 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32524046 32524046 PRJNA976345_P_NODE_175219_length_157_cov_1.614754_g173611_i0 PRJNA976345 175219 157 1.614754 2.53516378 Spirochaetia bacterium 2053615 Bacteria Bacteria 38.9 0.0446   NR HRV29504.1 2053615 g173611 i0 100 0.32484076433121 17 0 32.5 0 107 157 1 17 HRV29504.1 hypothetical protein [Spirochaetia bacterium] diamond 51 38.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32712862 32712862 PRJNA976345_P_NODE_72280_length_214_cov_1.530726_g70672_i0 PRJNA976345 72280 214 1.530726 3.27575364 Spirochaetia bacterium 2053615 Bacteria Bacteria 122 1.5199999999999998e-31   NR HRS66611.1 2053615 g70672 i0 87.9 1.85046728971963 66 8 92.5 0 2 199 247 312 HRS66611.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Spirochaetia bacterium] diamond 396 122 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32870316 32870316 PRJNA976345_P_NODE_92180_length_195_cov_2.762500_g90572_i0 PRJNA976345 92180 195 2.7625 5.386875 Treponema sp. 166 Bacteria Bacteria 122 6.679999999999999e-32   NR MFC2602318.1 166 g90572 i0 89.2 1 65 7 100 0 195 1 56 120 MFC2602318.1 tRNA pseudouridine(55) synthase TruB [Treponema sp.] diamond 195 122 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.

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