RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1032461" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1032461 · 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
7819716 7819716 PRJNA1032461_S_NODE_17247_length_166_cov_0.888889_g17149_i0 PRJNA1032461 17247 166 0.888889 1.47555574 Irregularibacter muris 1796619 Bacteria Bacteria 116 1.74e-28   NR WP_257531642.1 1796619 g17149 i0 92.6 0.975903614457831 54 4 97.6 0 4 165 835 888 WP_257531642.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Irregularibacter muris] diamond 162 116 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Irregularibacter Irregularibacter muris
18018898 18018898 PRJNA1032461_S_NODE_20715_length_163_cov_0.912281_g20617_i0 PRJNA1032461 20715 163 0.912281 1.48701803 Enterococcus cecorum 44008 Bacteria Bacteria 110 2.71e-27   NR CAI3351331.1 44008 g20617 i0 98.1 1.98773006134969 54 1 99.4 0 163 2 181 234 CAI3351331.1 DEAD/DEAH box helicase family protein [Enterococcus cecorum] diamond 324 110 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus cecorum
26678720 26678720 PRJNA1032461_S_NODE_15101_length_168_cov_1.075630_g15003_i0 PRJNA1032461 15101 168 1.07563 1.8070584 Anoxybacillus 150247 Bacteria Bacteria 108 5.92e-26   NR WP_035064895.1 198467 g15003 i0 96.4 4.98214285714286 56 2 100 0 168 1 124 179 WP_035064895.1 cobyric acid synthase [Anoxybacillus gonensis] diamond 837 109 0.990825688073395 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacillus Anoxybacillus gonensis
26877183 26877183 PRJNA1032461_S_NODE_17421_length_166_cov_0.888889_g17323_i0 PRJNA1032461 17421 166 0.888889 1.47555574 Paenibacillus solanacearum 2048548 Bacteria Bacteria 118 1.55e-29   NR WP_246627527.1 2048548 g17323 i0 89.1 0.993975903614458 55 6 99.4 0 165 1 152 206 WP_246627527.1 arylsulfatase [Paenibacillus solanacearum] diamond 165 118 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus solanacearum
27035111 27035111 PRJNA1032461_S_NODE_16262_length_167_cov_0.881356_g16164_i0 PRJNA1032461 16262 167 0.881356 1.47186452 Clostridia bacterium 2044939 Bacteria Bacteria 82.4 1.22e-16   NR MBR5768794.1 2044939 g16164 i0 64.2 1.86826347305389 53 19 95.2 0 8 166 290 342 MBR5768794.1 zinc-ribbon domain-containing protein [Clostridia bacterium] diamond 312 82.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27035114 27035114 PRJNA1032461_S_NODE_22222_length_155_cov_2.594340_g22124_i0 PRJNA1032461 22222 155 2.59434 4.021227 Enterococcus faecalis 1351 Bacteria Bacteria 38.9 0.0447   NR MDU4017871.1 1351 g22124 i0 73.9 0.445161290322581 23 1 44.5 1 128 60 1 18 MDU4017871.1 hypothetical protein [Enterococcus faecalis] diamond 69 38.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
27153144 27153144 PRJNA1032461_S_NODE_14762_length_169_cov_0.866667_g14664_i0 PRJNA1032461 14762 169 0.866667 1.46466723 Oscillospiraceae 216572 Bacteria Bacteria 109 1.61e-26   NR WP_270752437.1 204475 g14664 i0 100 3.90532544378698 55 0 97.6 0 3 167 12 66 WP_270752437.1 MULTISPECIES: nickel-dependent lactate racemase [Gemmiger] diamond 660 109 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Gemmiger  
27753970 27753970 PRJNA1032461_S_NODE_14024_length_169_cov_1.300000_g13926_i0 PRJNA1032461 14024 169 1.3 2.197 Alkalihalobacillus 2675234 Bacteria Bacteria 80.5 2.66e-17   NR WP_048310440.1 157733 g13926 i0 67.9 2.82248520710059 53 17 94.1 0 6 164 33 85 WP_048310440.1 VOC family protein [Alkalihalobacillus macyae] diamond 477 80.9 0.995055624227441 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alkalihalobacillus Alkalihalobacillus macyae
28172113 28172113 PRJNA1032461_S_NODE_15186_length_168_cov_0.873950_g15088_i0 PRJNA1032461 15186 168 0.87395 1.468236 Staphylococcus epidermidis 1282 Bacteria Bacteria 42 0.00324   NR MDU1274902.1 1282 g15088 i0 94.4 0.321428571428571 18 1 32.1 0 168 115 2 19 MDU1274902.1 hypothetical protein [Staphylococcus epidermidis] diamond 54 42 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
28732604 28732604 PRJNA1032461_S_NODE_17347_length_166_cov_0.888889_g17249_i0 PRJNA1032461 17347 166 0.888889 1.47555574 Hominilimicola 3073565 Bacteria Bacteria 70.1 2.85e-12   NR RHP02498.1 2292889 g17249 i0 57.4 4.87951807228916 54 23 97.6 0 3 164 550 603 RHP02498.1 hypothetical protein DW004_10510 [Firmicutes bacterium AF36-3BH] diamond 810 70.1 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium AF36-3BH
29048411 29048411 PRJNA1032461_S_NODE_20348_length_163_cov_0.912281_g20250_i0 PRJNA1032461 20348 163 0.912281 1.48701803 Anaerococcus 165779 Bacteria Bacteria 102 8.26e-24   NR WP_316270273.1 33037 g20250 i0 96.3 2.98159509202454 54 2 99.4 0 1 162 116 169 WP_316270273.1 HAMP domain-containing sensor histidine kinase [Anaerococcus vaginalis] diamond 486 103 0.990291262135922 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus vaginalis
29308733 29308733 PRJNA1032461_S_NODE_21369_length_162_cov_0.920354_g21271_i0 PRJNA1032461 21369 162 0.920354 1.49097348 Ornithinibacillus contaminans 694055 Bacteria Bacteria 72.4 1.33e-13   NR WP_047981645.1 694055 g21271 i0 100 0.666666666666667 36 0 66.7 0 158 51 210 245 WP_047981645.1 TrmH family RNA methyltransferase [Ornithinibacillus contaminans] diamond 108 72.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Ornithinibacillus Ornithinibacillus contaminans
29877310 29877310 PRJNA1032461_S_NODE_10831_length_188_cov_1.683453_g10733_i0 PRJNA1032461 10831 188 1.683453 3.16489164 Clostridia bacterium 2044939 Bacteria Bacteria 41.6 0.0457   NR MBC7335180.1 2044939 g10733 i0 42.9 0.781914893617021 49 24 71.8 1 156 22 214 262 MBC7335180.1 NADH-quinone oxidoreductase subunit N [Clostridia bacterium] diamond 147 41.6 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30098215 30098215 PRJNA1032461_S_NODE_16712_length_167_cov_0.881356_g16614_i0 PRJNA1032461 16712 167 0.881356 1.47186452 Enterococcus sp. JM4C 1857217 Bacteria Bacteria 77.8 7.02e-16   NR WP_161842164.1 1857217 g16614 i0 68.5 0.970059880239521 54 17 97 0 166 5 23 76 WP_161842164.1 ATP-binding cassette domain-containing protein [Enterococcus sp. JM4C] diamond 162 77.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Candidatus Enterococcus huntleyi
30193016 30193016 PRJNA1032461_S_NODE_20472_length_163_cov_0.912281_g20374_i0 PRJNA1032461 20472 163 0.912281 1.48701803 Staphylococcus sp. RIT622 2510795 Bacteria Bacteria 100 1.63e-25   NR WP_129795339.1 2510795 g20374 i0 100 0.993865030674847 54 0 99.4 0 2 163 20 73 WP_129795339.1 hypothetical protein [Staphylococcus sp. RIT622] diamond 162 100 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus sp. RIT622
30540638 30540638 PRJNA1032461_S_NODE_4593_length_268_cov_1.625571_g4495_i0 PRJNA1032461 4593 268 1.625571 4.35653028 Staphylococcus sp. RIT622 2510795 Bacteria Bacteria 145 1.3e-41   NR WP_129795315.1 2510795 g4495 i0 100 0.817164179104478 73 0 81.7 0 2 220 159 231 WP_129795315.1 hypothetical protein [Staphylococcus sp. RIT622] diamond 219 145 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus sp. RIT622
31805084 31805084 PRJNA1032461_S_NODE_19857_length_163_cov_1.543860_g19759_i0 PRJNA1032461 19857 163 1.54386 2.5164918 Staphylococcus 1279 Bacteria Bacteria 101 5.25e-26   NR WP_002454393.1 1279 g19759 i0 100 0.957055214723926 52 0 95.7 0 162 7 82 133 WP_002454393.1 MULTISPECIES: YxeA family protein [Staphylococcus] diamond 156 101 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus  
32398429 32398429 PRJNA1032461_S_NODE_4599_length_268_cov_1.424658_g4501_i0 PRJNA1032461 4599 268 1.424658 3.81808344 Bacteria 2 Bacteria Bacteria 166 2.11e-45   NR MCG2544221.1 1282 g4501 i0 100 3.98507462686567 89 0 99.6 0 2 268 392 480 MCG2544221.1 hypothetical protein [Staphylococcus epidermidis] diamond 1068 166 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
32564771 32564771 PRJNA1032461_S_NODE_19299_length_164_cov_0.904348_g19201_i0 PRJNA1032461 19299 164 0.904348 1.48313072 Anaerococcus murdochii 411577 Bacteria Bacteria 107 3.04e-26   NR WP_223419470.1 411577 g19201 i0 96.3 0.98780487804878 54 2 98.8 0 164 3 19 72 WP_223419470.1 ABC transporter ATP-binding protein [Anaerococcus murdochii] diamond 162 107 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus murdochii
32658632 32658632 PRJNA1032461_S_NODE_19540_length_164_cov_0.904348_g19442_i0 PRJNA1032461 19540 164 0.904348 1.48313072 Niallia oryzisoli 1737571 Bacteria Bacteria 100 9.69e-25   NR WP_338451057.1 1737571 g19442 i0 83.3 1.97560975609756 54 9 98.8 0 162 1 35 88 WP_338451057.1 hypothetical protein [Niallia oryzisoli] diamond 324 100 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Niallia Niallia oryzisoli
32690306 32690306 PRJNA1032461_S_NODE_5360_length_250_cov_122.099502_g5262_i0 PRJNA1032461 5360 250 122.099502 305.248755 Staphylococcus pseudintermedius 283734 Bacteria Bacteria 118 1.4099999999999998e-32   NR WP_222114562.1 283734 g5262 i0 98.8 1.944 81 1 97.2 0 8 250 1 81 WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius] diamond 486 118 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus pseudintermedius
32839785 32839785 PRJNA1032461_S_NODE_21140_length_162_cov_0.920354_g21042_i0 PRJNA1032461 21140 162 0.920354 1.49097348 Bacillales 1385 Bacteria Bacteria 85.5 1.04e-17   NR WP_380145823.1 714067 g21042 i0 67.9 4.90740740740741 53 17 98.1 0 161 3 602 654 WP_380145823.1 SNF2 helicase associated domain-containing protein [Kroppenstedtia eburnea] diamond 795 85.9 0.9953434225844 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Kroppenstedtia Kroppenstedtia eburnea

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