RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA846086" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA846086 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
26896731 26896731 PRJNA846086_P_NODE_4881_length_244_cov_0.900585_g4815_i0 PRJNA846086 4881 244 0.900585 2.1974274 Treponema sp. 166 Bacteria Bacteria 144 7.12e-38   NR MEL3906984.1 166 g4815 i0 82.7 0.995901639344262 81 14 99.6 0 244 2 553 633 MEL3906984.1 leucine--tRNA ligase [Treponema sp.] diamond 243 144 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27086419 27086419 PRJNA846086_P_NODE_2662_length_261_cov_1.638298_g2596_i0 PRJNA846086 2662 261 1.638298 4.27595778 Treponema bryantii 163 Bacteria Bacteria 106 6.31e-25   NR MBE6360698.1 163 g2596 i0 79.7 0.67816091954023 59 12 67.8 0 178 2 301 359 MBE6360698.1 DNA methyltransferase [Treponema bryantii] diamond 177 106 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
27094773 27094773 PRJNA846086_P_NODE_4502_length_245_cov_0.895349_g4436_i0 PRJNA846086 4502 245 0.895349 2.19360505 Treponema 157 Bacteria Bacteria 149 9.729999999999999e-41   NR MEL3907198.1 166 g4436 i0 90.1 1.98367346938776 81 8 99.2 0 243 1 319 399 MEL3907198.1 DNA repair protein RadA [Treponema sp.] diamond 486 149 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27180974 27180974 PRJNA846086_P_NODE_3862_length_248_cov_0.880000_g3796_i0 PRJNA846086 3862 248 0.88 2.1824 Treponema maltophilum 51160 Bacteria Bacteria 151 4.41e-43   NR WP_040846112.1 51160 g3796 i0 98.8 0.991935483870968 82 1 99.2 0 248 3 36 117 WP_040846112.1 carbohydrate ABC transporter permease [Treponema maltophilum] diamond 246 151 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema maltophilum
27568603 27568603 PRJNA846086_P_NODE_5084_length_243_cov_0.905882_g5018_i0 PRJNA846086 5084 243 0.905882 2.20129326 Treponema 157 Bacteria Bacteria 158 8.709999999999999e-45   NR WP_187385418.1 2766702 g5018 i0 98.8 4.9382716049382704 80 1 98.8 0 241 2 273 352 WP_187385418.1 HD-GYP domain-containing protein [Treponema sp. Marseille-Q4130] diamond 1200 158 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4130
27875940 27875940 PRJNA846086_P_NODE_3905_length_248_cov_0.880000_g3839_i0 PRJNA846086 3905 248 0.88 2.1824 Treponema maltophilum 51160 Bacteria Bacteria 170 7.96e-48   NR WP_156827971.1 51160 g3839 i0 100 0.991935483870968 82 0 99.2 0 248 3 165 246 WP_156827971.1 sensor histidine kinase [Treponema maltophilum] diamond 246 170 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema maltophilum
28160384 28160384 PRJNA846086_P_NODE_5685_length_241_cov_0.863095_g5619_i0 PRJNA846086 5685 241 0.863095 2.08005895 uncultured Treponema sp. 162155 Bacteria Bacteria 45.8 5.4e-4   NR WP_296327245.1 162155 g5619 i0 53.1 0.398340248962656 32 15 39.8 0 220 125 61 92 WP_296327245.1 hypothetical protein [uncultured Treponema sp.] diamond 96 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
28570566 28570566 PRJNA846086_P_NODE_5047_length_243_cov_0.905882_g4981_i0 PRJNA846086 5047 243 0.905882 2.20129326 Treponema medium 58231 Bacteria Bacteria 112 3.23e-28   NR WP_016523716.1 58231 g4981 i0 86.9 0.753086419753086 61 8 75.3 0 183 1 1 61 WP_016523716.1 SPFH domain-containing protein [Treponema medium] diamond 183 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
28917731 28917731 PRJNA846086_P_NODE_3648_length_249_cov_0.875000_g3582_i0 PRJNA846086 3648 249 0.875 2.17875 Treponema sp. OMZ 838 1539298 Bacteria Bacteria 92 1.31e-19   NR WP_044015713.1 1539298 g3582 i0 71.7 1.44578313253012 60 17 72.3 0 68 247 1 60 WP_044015713.1 flagellar biosynthesis protein FlhF [Treponema sp. OMZ 838] diamond 360 92 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 838
29928545 29928545 PRJNA846086_P_NODE_3411_length_250_cov_0.870056_g3345_i0 PRJNA846086 3411 250 0.870056 2.17514 Treponema sp. Marseille-Q39 166 Bacteria Bacteria 163 3.769999999999999e-48   NR WP_370586908.1 2766703 g3345 i0 100 0.984 82 0 98.4 0 248 3 40 121 WP_370586908.1 IS3 family transposase [Treponema sp. Marseille-Q3903] diamond 246 163 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q3903
30244434 30244434 PRJNA846086_P_NODE_5052_length_243_cov_0.905882_g4986_i0 PRJNA846086 5052 243 0.905882 2.20129326 Candidatus Avitreponema avistercoris 2840705 Bacteria Bacteria 60.1 2.88e-8   NR MBO8450372.1 2840705 g4986 i0 38.8 1.91358024691358 80 49 98.8 0 4 243 301 380 MBO8450372.1 hypothetical protein [Candidatus Avitreponema avistercoris] diamond 465 60.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales   Candidatus Avitreponema Candidatus Avitreponema avistercoris
30979602 30979602 PRJNA846086_P_NODE_3574_length_249_cov_0.875000_g3508_i0 PRJNA846086 3574 249 0.875 2.17875 Treponema 157 Bacteria Bacteria 115 4.58e-29   NR WP_002667412.1 158 g3508 i0 73.8 1.56626506024096 65 17 78.3 0 197 3 9 73 WP_002667412.1 radical SAM protein [Treponema denticola] diamond 390 115 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
31350438 31350438 PRJNA846086_P_NODE_5076_length_243_cov_0.905882_g5010_i0 PRJNA846086 5076 243 0.905882 2.20129326 Treponema sp. 166 Bacteria Bacteria 157 1.22e-43   NR MFC2603297.1 166 g5010 i0 86.3 1.97530864197531 80 11 98.8 0 241 2 181 260 MFC2603297.1 hypothetical protein [Treponema sp.] diamond 480 157 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31382058 31382058 PRJNA846086_P_NODE_5596_length_241_cov_0.916667_g5530_i0 PRJNA846086 5596 241 0.916667 2.20916747 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 121 1.88e-33   NR MBQ7612595.1 1898206 g5530 i0 72.5 0.995850622406639 80 22 99.6 0 2 241 26 105 MBQ7612595.1 50S ribosomal protein L18 [Spirochaetaceae bacterium] diamond 240 121 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
31603434 31603434 PRJNA846086_P_NODE_3076_length_251_cov_0.865169_g3010_i0 PRJNA846086 3076 251 0.865169 2.17157419 Treponema sp. 166 Bacteria Bacteria 156 1.21e-44   NR MEL3907061.1 166 g3010 i0 95.1 0.9800796812749 82 4 98 0 5 250 41 122 MEL3907061.1 dihydroxyacetone kinase subunit DhaK [Treponema sp.] diamond 246 156 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31666510 31666510 PRJNA846086_P_NODE_2417_length_268_cov_1.538462_g2351_i0 PRJNA846086 2417 268 1.538462 4.12307816 Treponema sp. 166 Bacteria Bacteria 58.9 1.01e-7   NR MFC2330074.1 166 g2351 i0 38.6 0.92910447761194 83 51 92.9 0 268 20 389 471 MFC2330074.1 methyl-accepting chemotaxis protein [Treponema sp.] diamond 249 58.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32678236 32678236 PRJNA846086_P_NODE_3620_length_249_cov_0.875000_g3554_i0 PRJNA846086 3620 249 0.875 2.17875 Treponema phagedenis 162 Bacteria Bacteria 89 2.02e-18   NR WP_148889468.1 162 g3554 i0 62.7 0.807228915662651 67 25 80.7 0 6 206 461 527 WP_148889468.1 YifB family Mg chelatase-like AAA ATPase [Treponema phagedenis] diamond 201 89 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema phagedenis
32709902 32709902 PRJNA846086_P_NODE_2600_length_263_cov_1.278947_g2534_i0 PRJNA846086 2600 263 1.278947 3.36363061 Treponema sp. 166 Bacteria Bacteria 55.8 5.07e-7   NR HBG65861.1 166 g2534 i0 49.1 3.31939163498099 55 28 62.7 0 262 98 136 190 HBG65861.1 YigZ family protein [Treponema sp.] diamond 873 55.8 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);;