RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA940501" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA940501 · 20 ✖

analysis 1

  • diamond · 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
26803570 26803570 PRJNA940501_S_NODE_264981_length_175_cov_1.424242_g264163_i0 PRJNA940501 264981 175 1.424242 2.4924235 Spirochaetia bacterium 2053615 Bacteria Bacteria 117 4.06e-29   NR MCI6316349.1 2053615 g264163 i0 100 0.977142857142857 57 0 97.7 0 3 173 397 453 MCI6316349.1 pallilysin-related adhesin [Spirochaetia bacterium] diamond 171 117 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
27341419 27341419 PRJNA940501_S_NODE_213583_length_189_cov_0.965753_g212765_i0 PRJNA940501 213583 189 0.965753 1.82527317 Leptospira borgpetersenii 174 Bacteria Bacteria 45.1 0.00122   NR WP_228029286.1 174 g212765 i0 43.2 0.698412698412698 44 25 69.8 0 187 56 99 142 WP_228029286.1 hypothetical protein, partial [Leptospira borgpetersenii] diamond 132 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira borgpetersenii
27720677 27720677 PRJNA940501_S_NODE_211784_length_189_cov_1.931507_g210966_i0 PRJNA940501 211784 189 1.931507 3.65054823 Treponema vincentii 69710 Bacteria Bacteria 45.1 0.00284   NR WP_016519616.1 69710 g210966 i0 39.1 1.01587301587302 64 33 98.4 2 189 4 61 120 WP_016519616.1 lipopolysaccharide biosynthesis protein [Treponema vincentii] diamond 192 45.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
28004603 28004603 PRJNA940501_S_NODE_183505_length_198_cov_2.393548_g182687_i0 PRJNA940501 183505 198 2.393548 4.73922504 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 43.1 0.0151   NR MCY4378190.1 1898206 g182687 i0 41.9 1.83333333333333 43 25 65.2 0 70 198 69 111 MCY4378190.1 Gfo/Idh/MocA family oxidoreductase [Spirochaetaceae bacterium] diamond 363 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28193627 28193627 PRJNA940501_S_NODE_261546_length_176_cov_1.097744_g260728_i0 PRJNA940501 261546 176 1.097744 1.93202944 Treponema sp. 166 Bacteria Bacteria 108 7.3e-26   NR MBR0545917.1 166 g260728 i0 98.3 0.988636363636364 58 1 98.9 0 174 1 134 191 MBR0545917.1 heavy metal translocating P-type ATPase [Treponema sp.] diamond 174 108 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28225137 28225137 PRJNA940501_S_NODE_148786_length_212_cov_1.390533_g147968_i0 PRJNA940501 148786 212 1.390533 2.94792996 Treponema sp. 166 Bacteria Bacteria 92 7.379999999999999e-23   NR WP_318695208.1 166 g147968 i0 94 0.707547169811321 50 3 70.8 0 1 150 4 53 WP_318695208.1 hypothetical protein [Treponema sp.] diamond 150 92 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28320040 28320040 PRJNA940501_S_NODE_144666_length_214_cov_1.251462_g143848_i0 PRJNA940501 144666 214 1.251462 2.67812868 Treponema bryantii 163 Bacteria Bacteria 73.2 4.09e-13   NR WP_338368548.1 163 g143848 i0 53.5 0.995327102803738 71 33 99.5 0 214 2 168 238 WP_338368548.1 ankyrin repeat domain-containing protein [Treponema bryantii] diamond 213 73.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
28572635 28572635 PRJNA940501_S_NODE_101527_length_237_cov_1.453608_g100709_i0 PRJNA940501 101527 237 1.453608 3.44505096 Spirochaetia bacterium 2053615 Bacteria Bacteria 157 3.0199999999999996e-45   NR MCI7036282.1 2053615 g100709 i0 100 1.9746835443038 78 0 98.7 0 3 236 26 103 MCI7036282.1 acetate kinase [Spirochaetia bacterium] diamond 468 157 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
28730643 28730643 PRJNA940501_S_NODE_62487_length_269_cov_2.269912_g61669_i0 PRJNA940501 62487 269 2.269912 6.10606328 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 42.7 0.0338   NR MDR1096389.1 1898206 g61669 i0 36.4 0.613382899628253 55 31 58 2 84 239 107 160 MDR1096389.1 YkgJ family cysteine cluster protein [Spirochaetaceae bacterium] diamond 165 42.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29109617 29109617 PRJNA940501_S_NODE_58108_length_274_cov_2.670996_g57290_i0 PRJNA940501 58108 274 2.670996 7.31852904 Rectinemataceae bacterium 3064674 Bacteria Bacteria 43.1 0.0381   NR HUX39726.1 3064674 g57290 i0 39.6 0.58029197080292 53 27 55.8 2 5 157 260 309 HUX39726.1 hypothetical protein [Rectinemataceae bacterium] diamond 159 43.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
29393697 29393697 PRJNA940501_S_NODE_204689_length_191_cov_2.452703_g203871_i0 PRJNA940501 204689 191 2.452703 4.68466273 Treponema sp. 166 Bacteria Bacteria 130 1.46e-33   NR MEE1167355.1 166 g203871 i0 100 0.989528795811518 63 0 99 0 190 2 166 228 MEE1167355.1 EAL domain-containing protein [Treponema sp.] diamond 189 130 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
29835623 29835623 PRJNA940501_S_NODE_357711_length_156_cov_1.451327_g356893_i0 PRJNA940501 357711 156 1.451327 2.26407012 Alkalispirochaeta sp. 2024959 Bacteria Bacteria 41.6 0.0301   NR MFO8043336.1 2024959 g356893 i0 36.4 0.846153846153846 44 26 80.8 1 135 10 190 233 MFO8043336.1 serine hydrolase domain-containing protein [Alkalispirochaeta sp.] diamond 132 41.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Alkalispirochaeta Alkalispirochaeta sp.
30025373 30025373 PRJNA940501_S_NODE_269171_length_174_cov_1.435115_g268353_i0 PRJNA940501 269171 174 1.435115 2.4971001 Leptospiraceae bacterium 2026757 Bacteria Bacteria 81.3 2.71e-16   NR HMV45331.1 2026757 g268353 i0 65.5 2 58 20 100 0 174 1 45 102 HMV45331.1 SpoIID/LytB domain-containing protein [Leptospiraceae bacterium] diamond 348 81.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30278325 30278325 PRJNA940501_S_NODE_185052_length_198_cov_1.212903_g184234_i0 PRJNA940501 185052 198 1.212903 2.40154794 Borreliella garinii 29519 Bacteria Bacteria 43.9 0.00206   NR WP_234932126.1 29519 g184234 i0 31.3 1.95454545454545 64 44 97 0 197 6 33 96 WP_234932126.1 hypothetical protein, partial [Borreliella garinii] diamond 387 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii
30530631 30530631 PRJNA940501_S_NODE_295933_length_168_cov_1.504000_g295115_i0 PRJNA940501 295933 168 1.504 2.52672 Leptospira sp. GIMC2 178 Bacteria Bacteria 71.6 7.43e-13   NR WP_272532568.1 1513297 g295115 i0 63.6 0.982142857142857 55 20 98.2 0 3 167 47 101 WP_272532568.1 tetraacyldisaccharide 4'-kinase [Leptospira sp. GIMC2001] diamond 165 71.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp. GIMC2001
30758814 30758814 PRJNA940501_S_NODE_188694_length_197_cov_0.915584_g187876_i0 PRJNA940501 188694 197 0.915584 1.80370048 Treponema 157 Bacteria Bacteria 123 4.44e-33   NR MCR4900662.1 166 g187876 i0 92.3 10.8883248730964 65 5 99 0 2 196 147 211 MCR4900662.1 AAA family ATPase [Treponema sp.] diamond 2145 124 0.991935483870968 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31169274 31169274 PRJNA940501_S_NODE_373475_length_153_cov_1.709091_g372657_i0 PRJNA940501 373475 153 1.709091 2.61490923 root 1 Root_unresolved Root_unresolved 112 8.39e-29   NR MBQ1629163.1 166 g372657 i0 100 6 51 0 100 0 1 153 174 224 MBQ1629163.1 winged helix DNA-binding domain-containing protein [Treponema sp.] diamond 918 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31636978 31636978 PRJNA940501_S_NODE_312316_length_165_cov_1.155738_g311498_i0 PRJNA940501 312316 165 1.155738 1.9069677 Spirochaetia bacterium 2053615 Bacteria Bacteria 59.7 1.31e-8   NR NBU99293.1 2053615 g311498 i0 56.6 0.963636363636364 53 23 96.4 0 163 5 345 397 NBU99293.1 hypothetical protein [Spirochaetia bacterium] diamond 159 59.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32079890 32079890 PRJNA940501_S_NODE_353938_length_157_cov_1.236842_g353120_i0 PRJNA940501 353938 157 1.236842 1.94184194 Treponema sp. 166 Bacteria Bacteria 102 6.92e-24   NR MBQ5907057.1 166 g353120 i0 94.1 0.974522292993631 51 3 97.5 0 155 3 208 258 MBQ5907057.1 hypothetical protein [Treponema sp.] diamond 153 102 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32743681 32743681 PRJNA940501_S_NODE_390800_length_151_cov_0.870370_g389982_i0 PRJNA940501 390800 151 0.87037 1.3142587 Spirochaetia bacterium 2053615 Bacteria Bacteria 106 9.31e-26   NR MCI7440436.1 2053615 g389982 i0 98 0.993377483443709 50 1 99.3 0 150 1 130 179 MCI7440436.1 endonuclease/exonuclease/phosphatase family protein [Spirochaetia bacterium] diamond 150 106 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium

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