RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA641707" 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

  • PRJNA641707 · 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
8266306 8266306 PRJNA641707_P_NODE_197787_length_197_cov_27.418919_g195124_i0 PRJNA641707 197787 197 27.418919 54.01527043 Bacteria 2 Bacteria Bacteria 61.2 5.9e-9   NR MFO8044093.1 2024959 g195124 i0 87.5 4.17258883248731 32 4 48.7 0 98 3 362 393 MFO8044093.1 Zn-dependent hydrolase [Alkalispirochaeta sp.] diamond 822 61.6 0.993506493506494 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Alkalispirochaeta Alkalispirochaeta sp.
27366001 27366001 PRJNA641707_P_NODE_73063_length_247_cov_3.969697_g70400_i0 PRJNA641707 73063 247 3.969697 9.80515159 Leptonema illini DSM 21528 929563 Bacteria Bacteria 45.4 0.00127   NR EHQ05108.1 929563 g70400 i0 59.4 8.55060728744939 32 13 38.9 0 4 99 90 121 EHQ05108.1 Cell wall-associated hydrolase [Leptonema illini DSM 21528] diamond 2112 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema Leptonema illini
27681751 27681751 PRJNA641707_P_NODE_31264_length_387_cov_7.215976_g28651_i0 PRJNA641707 31264 387 7.215976 27.92582712 Treponema sp. 166 Bacteria Bacteria 72.8 5.66e-12   NR MCL2411901.1 166 g28651 i0 50 5.35658914728682 72 36 55.8 0 111 326 138 209 MCL2411901.1 M60 family metallopeptidase [Treponema sp.] diamond 2073 72.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28155101 28155101 PRJNA641707_P_NODE_121245_length_245_cov_6.683673_g118582_i0 PRJNA641707 121245 245 6.683673 16.37499885 Leptospiraceae bacterium 2026757 Bacteria Bacteria 55.8 8.68e-7   NR MDX1960271.1 2026757 g118582 i0 78.1 0.391836734693878 32 5 39.2 1 6 101 276 305 MDX1960271.1 AAA family ATPase [Leptospiraceae bacterium] diamond 96 55.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28439208 28439208 PRJNA641707_P_NODE_122486_length_245_cov_5.719388_g119823_i0 PRJNA641707 122486 245 5.719388 14.0125006 Treponema 157 Bacteria Bacteria 98.6 1.84e-24   NR WP_002670000.1 157 g119823 i0 62 0.96734693877551 79 21 96.7 1 6 242 24 93 WP_002670000.1 MULTISPECIES: 50S ribosomal protein L22 [Treponema] diamond 237 98.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema  
28723311 28723311 PRJNA641707_P_NODE_142127_length_241_cov_5.760417_g139464_i0 PRJNA641707 142127 241 5.760417 13.88260497 Spirochaetota bacterium 2202144 Bacteria Bacteria 60.1 1.78e-8   NR MBP7736528.1 2202144 g139464 i0 84.4 0.398340248962656 32 5 39.8 0 240 145 179 210 MBP7736528.1 peroxiredoxin [Spirochaetota bacterium] diamond 96 60.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28975934 28975934 PRJNA641707_P_NODE_133468_length_243_cov_8.283505_g130805_i0 PRJNA641707 133468 243 8.283505 20.12891715 Treponema sp. Marseille-Q39 166 Bacteria Bacteria 64.3 8.38e-10   NR WP_187381355.1 2766703 g130805 i0 100 0.407407407407407 33 0 40.7 0 143 241 329 361 WP_187381355.1 flagellar motor switch protein FliG [Treponema sp. Marseille-Q3903] diamond 99 64.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q3903
28976088 28976088 PRJNA641707_P_NODE_53828_length_292_cov_6.946502_g51167_i0 PRJNA641707 53828 292 6.946502 20.28378584 Spirochaetia bacterium 2053615 Bacteria Bacteria 85.9 1.67e-17   NR MCI5607849.1 2053615 g51167 i0 59.4 0.657534246575342 64 26 65.8 0 263 72 262 325 MCI5607849.1 2-hydroxyacid dehydrogenase [Spirochaetia bacterium] diamond 192 85.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29354911 29354911 PRJNA641707_P_NODE_259689_length_178_cov_5.635659_g257026_i0 PRJNA641707 259689 178 5.635659 10.03147302 Leptospiraceae bacterium 2026757 Bacteria Bacteria 77.4 4.33e-17   NR MBK8395743.1 2026757 g257026 i0 80.4 1.55056179775281 46 9 77.5 0 140 3 1 46 MBK8395743.1 hypothetical protein [Leptospiraceae bacterium] diamond 276 77.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29733366 29733366 PRJNA641707_P_NODE_141490_length_241_cov_7.260417_g138827_i0 PRJNA641707 141490 241 7.260417 17.49760497 Spirochaetia bacterium 2053615 Bacteria Bacteria 51.2 3.64e-5   NR MBL8993573.1 2053615 g138827 i0 66.7 0.784232365145228 33 11 41.1 0 143 241 103 135 MBL8993573.1 asparagine--tRNA ligase [Spirochaetia bacterium] diamond 189 51.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30460691 30460691 PRJNA641707_P_NODE_230533_length_190_cov_3.907801_g227870_i0 PRJNA641707 230533 190 3.907801 7.4248219 Spirochaetia bacterium 2053615 Bacteria Bacteria 66.2 5.8e-11   NR MDY3939617.1 2053615 g227870 i0 56.6 0.836842105263158 53 23 83.7 0 185 27 130 182 MDY3939617.1 RNA polymerase sigma factor RpoD/SigA [Spirochaetia bacterium] diamond 159 66.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30788616 30788616 PRJNA641707_P_NODE_232714_length_189_cov_5.450000_g230051_i0 PRJNA641707 232714 189 5.45 10.3005 Bacteria 2 Bacteria Bacteria 107 1.83e-25   NR NLC93316.1 166 g230051 i0 79 28.3333333333333 62 13 98.4 0 4 189 274 335 NLC93316.1 mannitol dehydrogenase family protein [Treponema sp.] diamond 5355 108 0.990740740740741 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31041717 31041717 PRJNA641707_P_NODE_73075_length_247_cov_3.924242_g70412_i0 PRJNA641707 73075 247 3.924242 9.69287774 Pseudomonadati 3379134 Bacteria Bacteria 73.2 7.58e-13   NR WP_246845549.1 172 g70412 i0 100 27.0607287449393 33 0 40.1 0 149 247 516 548 WP_246845549.1 fatty acid desaturase [Leptospira biflexa] diamond 6684 73.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira biflexa
31060906 31060906 PRJNA641707_P_NODE_337855_length_151_cov_5.833333_g335192_i0 PRJNA641707 337855 151 5.833333 8.80833283 Spirochaetia bacterium 2053615 Bacteria Bacteria 68.2 3.54e-12   NR MDY3939693.1 2053615 g335192 i0 86.5 0.735099337748344 37 5 73.5 0 116 6 18 54 MDY3939693.1 hypothetical protein [Spirochaetia bacterium] diamond 111 68.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31198871 31198871 PRJNA641707_P_NODE_145535_length_240_cov_5.068063_g142872_i0 PRJNA641707 145535 240 5.068063 12.1633512 Pseudomonadati 3379134 Bacteria Bacteria 57.4 2.38e-7   NR WP_319562943.1 2038653 g142872 i0 71.9 2.3875 32 9 40 0 97 2 261 292 WP_319562943.1 sucrose phosphorylase [Marispirochaeta sp.] diamond 573 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Marispirochaeta Marispirochaeta sp.
32167848 32167848 PRJNA641707_P_NODE_336618_length_152_cov_2.922330_g333955_i0 PRJNA641707 336618 152 2.92233 4.4419416 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 76.6 1.36e-15   NR MBQ1197710.1 1898206 g333955 i0 97.2 1.42105263157895 36 1 71.1 0 148 41 165 200 MBQ1197710.1 nucleotide exchange factor GrpE [Spirochaetaceae bacterium] diamond 216 76.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32231106 32231106 PRJNA641707_P_NODE_28778_length_404_cov_3.464789_g26177_i0 PRJNA641707 28778 404 3.464789 13.99774756 Spirochaetota bacterium 2202144 Bacteria Bacteria 155 1.09e-40   NR TXH11062.1 2202144 g26177 i0 56.6 1.00990099009901 136 57 99.5 1 404 3 711 846 TXH11062.1 MAG: hypothetical protein E6R04_03340 [Spirochaetota bacterium] diamond 408 155 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32326144 32326144 PRJNA641707_P_NODE_238439_length_187_cov_3.760870_g235776_i0 PRJNA641707 238439 187 3.76087 7.0328269 Brachyspira intermedia 84377 Bacteria Bacteria 80.5 8.89e-16   NR WP_335791729.1 84377 g235776 i0 59.6 1.82887700534759 57 23 91.4 0 171 1 736 792 WP_335791729.1 WavE lipopolysaccharide synthesis family protein, partial [Brachyspira intermedia] diamond 342 80.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira intermedia
32420812 32420812 PRJNA641707_P_NODE_288679_length_167_cov_6.466102_g286016_i0 PRJNA641707 288679 167 6.466102 10.79839034 Treponema lecithinolyticum 53418 Bacteria Bacteria 107 3.03e-25   NR WP_021686177.1 53418 g286016 i0 92.5 0.952095808383233 53 4 95.2 0 161 3 106 158 WP_021686177.1 glycyl radical protein [Treponema lecithinolyticum] diamond 159 107 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema lecithinolyticum
32767782 32767782 PRJNA641707_P_NODE_74820_length_246_cov_15.248731_g72157_i0 PRJNA641707 74820 246 15.248731 37.51187826 Spirochaetota bacterium 2202144 Bacteria Bacteria 44.7 0.00272   NR HOR94661.1 2202144 g72157 i0 75 1.6219512195122 24 6 29.3 0 72 1 5 28 HOR94661.1 carbamoyl-phosphate synthase domain-containing protein [Spirochaetota bacterium] diamond 399 44.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32799068 32799068 PRJNA641707_P_NODE_255300_length_180_cov_3.778626_g252637_i0 PRJNA641707 255300 180 3.778626 6.8015268 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 113 1.82e-27   NR WP_187419143.1 2766701 g252637 i0 84.5 0.966666666666667 58 9 96.7 0 6 179 57 114 WP_187419143.1 hypothetical protein [Treponema sp. Marseille-Q4132] diamond 174 113 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
32862180 32862180 PRJNA641707_P_NODE_224740_length_192_cov_3.328671_g222077_i0 PRJNA641707 224740 192 3.328671 6.39104832 Spirochaetota bacterium 2202144 Bacteria Bacteria 58.5 5.02e-8   NR TXH11062.1 2202144 g222077 i0 42.6 0.953125 61 33 92.2 1 182 6 202 262 TXH11062.1 MAG: hypothetical protein E6R04_03340 [Spirochaetota bacterium] diamond 183 58.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota 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);;