RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJEB39643" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJEB39643 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
58054 58054 PRJEB39643_P_NODE_43641_length_290_cov_1.419355_g43448_i0 PRJEB39643 43641 290 1.419355 4.1161295 Treponema sp. 166 Bacteria Bacteria 191 5.370000000000001e-59   NR MFC2329779.1 166 g43448 i0 96.9 0.993103448275862 96 3 99.3 0 288 1 149 244 MFC2329779.1 hemolysin family protein [Treponema sp.] diamond 288 191 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
3884144 3884144 PRJEB39643_P_NODE_40244_length_296_cov_2.215247_g40051_i0 PRJEB39643 40244 296 2.215247 6.55713112 Bacteria 2 Bacteria Bacteria 169 1.5599999999999994e-48   NR WP_135698469.1 409998 g40051 i0 83.7 18.8412162162162 98 16 99.3 0 2 295 303 400 WP_135698469.1 acetyl-CoA hydrolase/transferase family protein [Leptospira wolffii] diamond 5577 169 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira wolffii
19183920 19183920 PRJEB39643_P_NODE_76556_length_272_cov_1.547739_g76363_i0 PRJEB39643 76556 272 1.547739 4.20985008 Treponema sp. 166 Bacteria Bacteria 97.8 4.51e-23   NR MFC2330807.1 166 g76363 i0 91.1 0.496323529411765 45 4 49.6 0 271 137 159 203 MFC2330807.1 helix-turn-helix domain-containing protein [Treponema sp.] diamond 135 97.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
26589878 26589878 PRJEB39643_P_NODE_103961_length_259_cov_1.655914_g103768_i0 PRJEB39643 103961 259 1.655914 4.28881726 Treponema sp. 166 Bacteria Bacteria 176 9.4e-52   NR MFC2602884.1 166 g103768 i0 98.8 0.984555984555985 85 0 98.5 1 3 257 164 247 MFC2602884.1 hypothetical protein [Treponema sp.] diamond 255 176 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27539076 27539076 PRJEB39643_P_NODE_86444_length_268_cov_1.579487_g86251_i0 PRJEB39643 86444 268 1.579487 4.23302516 Treponema sp. 166 Bacteria Bacteria 154 1.1099999999999998e-41   NR MFC2330220.1 166 g86251 i0 85.1 0.973880597014925 87 13 97.4 0 264 4 565 651 MFC2330220.1 hypothetical protein [Treponema sp.] diamond 261 154 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27633751 27633751 PRJEB39643_P_NODE_120244_length_252_cov_1.720670_g120051_i0 PRJEB39643 120244 252 1.72067 4.3360884 Treponema vincentii 69710 Bacteria Bacteria 81.3 1.12e-15   NR WP_230974681.1 69710 g120051 i0 58 1.70238095238095 81 32 96.4 1 6 248 2 80 WP_230974681.1 tetratricopeptide repeat protein [Treponema vincentii] diamond 429 81.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
27854693 27854693 PRJEB39643_P_NODE_80105_length_271_cov_1.555556_g79912_i0 PRJEB39643 80105 271 1.555556 4.21555676 Treponema sp. 166 Bacteria Bacteria 114 6.429999999999999e-31   NR MBR1721258.1 166 g79912 i0 87.9 1.28413284132841 58 7 64.2 0 1 174 45 102 MBR1721258.1 DUF4406 domain-containing protein [Treponema sp.] diamond 348 114 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27917781 27917781 PRJEB39643_P_NODE_87385_length_267_cov_1.587629_g87192_i0 PRJEB39643 87385 267 1.587629 4.23896943 Treponema sp. 166 Bacteria Bacteria 67 1.52e-10   NR MFC2330454.1 166 g87192 i0 66.2 0.764044943820225 68 23 76.4 0 204 1 2175 2242 MFC2330454.1 beta strand repeat-containing protein [Treponema sp.] diamond 204 67 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28359752 28359752 PRJEB39643_P_NODE_81846_length_270_cov_1.563452_g81653_i0 PRJEB39643 81846 270 1.563452 4.2213204 Treponema sp. 166 Bacteria Bacteria 140 1.7699999999999998e-37   NR MFC2602919.1 166 g81653 i0 98.6 0.788888888888889 71 1 78.9 0 56 268 1 71 MFC2602919.1 MATE family efflux transporter [Treponema sp.] diamond 213 140 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28707330 28707330 PRJEB39643_P_NODE_62087_length_280_cov_1.487923_g61894_i0 PRJEB39643 62087 280 1.487923 4.1661844 Treponema sp. 166 Bacteria Bacteria 101 3.35e-25   NR MFC2603475.1 166 g61894 i0 96.3 1.14642857142857 54 2 57.9 0 278 117 78 131 MFC2603475.1 RNB domain-containing ribonuclease [Treponema sp.] diamond 321 101 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28770297 28770297 PRJEB39643_P_NODE_45427_length_289_cov_1.425926_g45234_i0 PRJEB39643 45427 289 1.425926 4.12092614 Treponema vincentii 69710 Bacteria Bacteria 154 1.7699999999999993e-41   NR WP_016518597.1 69710 g45234 i0 76 0.996539792387543 96 23 99.7 0 1 288 267 362 WP_016518597.1 methyl-accepting chemotaxis protein [Treponema vincentii] diamond 288 154 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
29963666 29963666 PRJEB39643_P_NODE_27771_length_348_cov_2.374545_g27578_i0 PRJEB39643 27771 348 2.374545 8.2634166 root 1 Root_unresolved Root_unresolved 46.6 0.00534   NR MCC5813355.1 178 g27578 i0 44.7 2.18965517241379 47 19 34.5 1 292 173 433 479 MCC5813355.1 tetratricopeptide repeat protein [Leptospira sp.] diamond 762 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
30507349 30507349 PRJEB39643_P_NODE_118753_length_253_cov_1.711111_g118560_i0 PRJEB39643 118753 253 1.711111 4.32911083 Treponema pedis 409322 Bacteria Bacteria 50.8 2.5e-5   NR WP_252723459.1 409322 g118560 i0 64.1 0.924901185770751 39 14 46.2 0 243 127 127 165 WP_252723459.1 ABC transporter permease subunit [Treponema pedis] diamond 234 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
30538929 30538929 PRJEB39643_P_NODE_69633_length_276_cov_1.517241_g69440_i0 PRJEB39643 69633 276 1.517241 4.18758516 Treponema sp. 166 Bacteria Bacteria 181 1.15e-53   NR MFC2603926.1 166 g69440 i0 98.9 1 92 1 100 0 1 276 194 285 MFC2603926.1 Crp/Fnr family transcriptional regulator [Treponema sp.] diamond 276 181 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30595340 30595340 PRJEB39643_P_NODE_111973_length_256_cov_1.683060_g111780_i0 PRJEB39643 111973 256 1.68306 4.3086336 Treponema 157 Bacteria Bacteria 89.7 1.9e-21   NR MEL3906254.1 166 g111780 i0 60.6 5.34375 66 25 77.3 1 204 7 1 65 MEL3906254.1 YdbC family protein [Treponema sp.] diamond 1368 90.1 0.995560488346282 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31132324 31132324 PRJEB39643_P_NODE_7875_length_724_cov_4.451613_g7706_i0 PRJEB39643 7875 724 4.451613 32.22967812 Pseudomonadati 3379134 Bacteria Bacteria 113 3.62e-25   NR PJE04544.1 178 g7706 i0 33.3 2.3328729281768 222 129 89.5 8 6 653 206 414 PJE04544.1 MAG: dehydrogenase [Leptospira sp.] diamond 1689 113 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
31518904 31518904 PRJEB39643_P_NODE_99736_length_261_cov_1.638298_g99543_i0 PRJEB39643 99736 261 1.638298 4.27595778 Treponema denticola 158 Bacteria Bacteria 97.4 1.75e-23   NR WP_253702924.1 158 g99543 i0 62.5 2.95402298850575 80 30 92 0 3 242 51 130 WP_253702924.1 Rpn family recombination-promoting nuclease/putative transposase [Treponema denticola] diamond 771 97.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
31613622 31613622 PRJEB39643_P_NODE_48656_length_287_cov_1.439252_g48463_i0 PRJEB39643 48656 287 1.439252 4.13065324 Treponema sp. 166 Bacteria Bacteria 68.2 1.51e-12   NR MEE0886998.1 166 g48463 i0 96.9 0.334494773519164 32 1 33.4 0 189 284 1 32 MEE0886998.1 virulence protein [Treponema sp.] diamond 96 68.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32024870 32024870 PRJEB39643_P_NODE_100198_length_261_cov_1.638298_g100005_i0 PRJEB39643 100198 261 1.638298 4.27595778 Treponema maltophilum 51160 Bacteria Bacteria 151 2.18e-40   NR WP_016525862.1 51160 g100005 i0 85.7 0.96551724137931 84 12 96.6 0 5 256 740 823 WP_016525862.1 bifunctional aspartate kinase/homoserine dehydrogenase I [Treponema maltophilum] diamond 252 151 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema maltophilum
32562976 32562976 PRJEB39643_P_NODE_124059_length_250_cov_1.740113_g123866_i0 PRJEB39643 124059 250 1.740113 4.3502825 Treponema 157 Bacteria Bacteria 127 5.23e-32   NR WP_002666949.1 157 g123866 i0 70.7 0.984 82 24 98.4 0 4 249 129 210 WP_002666949.1 MULTISPECIES: DNA topoisomerase (ATP-hydrolyzing) subunit B [Treponema] diamond 246 127 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema  
32619106 32619106 PRJEB39643_P_NODE_109040_length_257_cov_1.673913_g108847_i0 PRJEB39643 109040 257 1.673913 4.30195641 Treponema 157 Bacteria Bacteria 138 1.5e-38   NR WP_016522775.1 58231 g108847 i0 75.3 3.96887159533074 85 21 99.2 0 255 1 118 202 WP_016522775.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Treponema medium] diamond 1020 138 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
32751722 32751722 PRJEB39643_P_NODE_87460_length_267_cov_1.587629_g87267_i0 PRJEB39643 87460 267 1.587629 4.23896943 Treponema succinifaciens 167 Bacteria Bacteria 57 4.49e-7   NR WP_277300214.1 167 g87267 i0 32.2 2.93258426966292 87 59 97.8 0 265 5 237 323 WP_277300214.1 hypothetical protein [Treponema succinifaciens] diamond 783 57 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema succinifaciens

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