RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1001940" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1001940 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
2697187 2697187 PRJNA1001940_S_NODE_20123_length_436_cov_3.442748_g19085_i0 PRJNA1001940 20123 436 3.442748 15.01038128 Agathobacter sp. 2021311 Bacteria Bacteria 294 3.07e-98   NR MEE1008982.1 2021311 g19085 i0 100 0.997706422018349 145 0 99.8 0 2 436 121 265 MEE1008982.1 sugar ABC transporter permease [Agathobacter sp.] diamond 435 294 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Agathobacter Agathobacter sp.
24371527 24371527 PRJNA1001940_S_NODE_109240_length_207_cov_3.121951_g108186_i0 PRJNA1001940 109240 207 3.121951 6.46243857 Bacteria 2 Bacteria Bacteria 109 1.11e-26   NR MEG0328659.1 38403 g108186 i0 70.6 3.91304347826087 68 20 98.6 0 206 3 168 235 MEG0328659.1 Fic/DOC family N-terminal domain-containing protein [Erysipelothrix sp.] diamond 810 110 0.990909090909091 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Erysipelothrix Erysipelothrix sp.
26749055 26749055 PRJNA1001940_S_NODE_113181_length_204_cov_1.192547_g112127_i0 PRJNA1001940 113181 204 1.192547 2.43279588 Clostridiales bacterium 1898207 Bacteria Bacteria 62.4 2.49e-9   NR NLL33689.1 1898207 g112127 i0 51.6 0.911764705882353 62 29 91.2 1 190 5 310 370 NLL33689.1 DUF2812 domain-containing protein [Clostridiales bacterium] diamond 186 62.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
26970956 26970956 PRJNA1001940_S_NODE_165962_length_169_cov_0.912698_g164908_i0 PRJNA1001940 165962 169 0.912698 1.54245962 Lactobacillus crispatus 47770 Bacteria Bacteria 62 5.27e-11   NR WP_205758276.1 47770 g164908 i0 64.6 0.85207100591716 48 15 81.7 1 30 167 1 48 WP_205758276.1 hypothetical protein, partial [Lactobacillus crispatus] diamond 144 62 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
27034337 27034337 PRJNA1001940_S_NODE_203622_length_152_cov_3.082569_g202568_i0 PRJNA1001940 203622 152 3.082569 4.68550488 Salinicoccus roseus 45670 Bacteria Bacteria 87 3.71e-19   NR WP_094907001.1 45670 g202568 i0 95 0.789473684210526 40 2 78.9 0 3 122 217 256 WP_094907001.1 putative hydro-lyase [Salinicoccus roseus] diamond 120 87 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Salinicoccus Salinicoccus roseus
27097527 27097527 PRJNA1001940_S_NODE_153582_length_175_cov_2.181818_g152528_i0 PRJNA1001940 153582 175 2.181818 3.8181815 Neobacillus vireti 220686 Bacteria Bacteria 57.4 4.49e-8   NR WP_335556765.1 220686 g152528 i0 51.1 0.805714285714286 47 23 80.6 0 173 33 123 169 WP_335556765.1 hypothetical protein [Neobacillus vireti] diamond 141 57.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus vireti
27855618 27855618 PRJNA1001940_S_NODE_194205_length_155_cov_2.142857_g193151_i0 PRJNA1001940 194205 155 2.142857 3.32142835 Peptococcaceae bacterium 2052179 Bacteria Bacteria 102 1.03e-25   NR MBQ2014405.1 2052179 g193151 i0 100 1.9741935483871 51 0 98.7 0 1 153 90 140 MBQ2014405.1 IMP dehydrogenase [Peptococcaceae bacterium] diamond 306 102 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae   Peptococcaceae bacterium
28202764 28202764 PRJNA1001940_S_NODE_46506_length_315_cov_2.941176_g45452_i0 PRJNA1001940 46506 315 2.941176 9.2647044 Streptococcus suis 1307 Bacteria Bacteria 42 0.0178   NR WP_319443996.1 1307 g45452 i0 63.6 0.314285714285714 33 11 30.5 1 97 2 8 40 WP_319443996.1 hypothetical protein, partial [Streptococcus suis] diamond 99 42 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
28385018 28385018 PRJNA1001940_S_NODE_41766_length_330_cov_6.188153_g40712_i0 PRJNA1001940 41766 330 6.188153 20.4209049 Atopostipes 292480 Bacteria Bacteria 202 6.520000000000001e-58   NR WP_073298408.1 180295 g40712 i0 91.7 1.98181818181818 109 9 99.1 0 329 3 45 153 WP_073298408.1 ABC transporter ATP-binding protein/permease [Atopostipes suicloacalis] diamond 654 203 0.995073891625616 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Atopostipes Atopostipes suicloacalis
29244978 29244978 PRJNA1001940_S_NODE_96029_length_221_cov_2.426966_g94975_i0 PRJNA1001940 96029 221 2.426966 5.36359486 Soehngenia saccharolytica 253256 Bacteria Bacteria 57.8 3.75e-8   NR TJX51369.1 253256 g94975 i0 96 0.339366515837104 25 1 33.9 0 220 146 146 170 TJX51369.1 plastocyanin [Soehngenia saccharolytica] diamond 75 57.8 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Tissierellaceae Soehngenia Soehngenia saccharolytica
29434054 29434054 PRJNA1001940_S_NODE_166450_length_168_cov_1.920000_g165396_i0 PRJNA1001940 166450 168 1.92 3.2256 Gemella haemolysans 1379 Bacteria Bacteria 100 1.1399999999999999e-24   NR WP_003147762.1 1379 g165396 i0 87.3 0.982142857142857 55 7 98.2 0 3 167 14 68 WP_003147762.1 C39 family peptidase [Gemella haemolysans] diamond 165 100 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
29623317 29623317 PRJNA1001940_S_NODE_130610_length_190_cov_1.306122_g129556_i0 PRJNA1001940 130610 190 1.306122 2.4816318 [Clostridium] innocuum 1522 Bacteria Bacteria 92 5.0600000000000005e-22   NR WP_044909216.1 1522 g129556 i0 91.7 0.757894736842105 48 4 75.8 0 165 22 37 84 WP_044909216.1 hypothetical protein, partial [[Clostridium] innocuum] diamond 144 92 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium [Clostridium] innocuum
29813157 29813157 PRJNA1001940_S_NODE_39111_length_340_cov_2.909091_g38057_i0 PRJNA1001940 39111 340 2.909091 9.8909094 Halalkalibacter alkalisediminis 935616 Bacteria Bacteria 160 1.4200000000000001e-44   NR WP_273842555.1 935616 g38057 i0 69.4 0.979411764705882 111 34 97.9 0 3 335 352 462 WP_273842555.1 glycoside hydrolase family 32 protein [Halalkalibacter alkalisediminis] diamond 333 160 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Halalkalibacter Halalkalibacter alkalisediminis
30319297 30319297 PRJNA1001940_S_NODE_89352_length_230_cov_1.283422_g88298_i0 PRJNA1001940 89352 230 1.283422 2.9518706 Bacillus pseudomycoides 64104 Bacteria Bacteria 40 0.041   NR WP_212667653.1 64104 g88298 i0 62.1 0.378260869565217 29 11 37.8 0 87 1 20 48 WP_212667653.1 hypothetical protein, partial [Bacillus pseudomycoides] diamond 87 40 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus pseudomycoides
30350867 30350867 PRJNA1001940_S_NODE_27212_length_392_cov_3.696275_g26164_i0 PRJNA1001940 27212 392 3.696275 14.489398 Atopostipes sp. 1872652 Bacteria Bacteria 209 1.13e-63   NR HLR88187.1 1872652 g26164 i0 79.2 0.994897959183674 130 27 99.5 0 390 1 68 197 HLR88187.1 hypothetical protein [Atopostipes sp.] diamond 390 209 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Atopostipes Atopostipes sp.
30350871 30350871 PRJNA1001940_S_NODE_83752_length_237_cov_2.969072_g82698_i0 PRJNA1001940 83752 237 2.969072 7.03670064 [Clostridium] innocuum 1522 Bacteria Bacteria 113 1.35e-30   NR WP_044908698.1 1522 g82698 i0 74.3 0.936708860759494 74 18 93.7 1 223 2 1 73 WP_044908698.1 hypothetical protein [[Clostridium] innocuum] diamond 222 113 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium [Clostridium] innocuum
30761173 30761173 PRJNA1001940_S_NODE_146814_length_179_cov_2.117647_g145760_i0 PRJNA1001940 146814 179 2.117647 3.79058813 [Clostridium] innocuum 1522 Bacteria Bacteria 127 8.76e-36   NR WP_197054051.1 1522 g145760 i0 93.2 0.988826815642458 59 4 98.9 0 1 177 51 109 WP_197054051.1 reverse transcriptase family protein, partial [[Clostridium] innocuum] diamond 177 127 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium [Clostridium] innocuum
31456574 31456574 PRJNA1001940_S_NODE_91596_length_227_cov_1.304348_g90542_i0 PRJNA1001940 91596 227 1.304348 2.96086996 Paludifilum halophilum 1642702 Bacteria Bacteria 44.3 0.00136   NR WP_169713838.1 1642702 g90542 i0 48.7 0.515418502202643 39 20 51.5 0 109 225 2 40 WP_169713838.1 hypothetical protein, partial [Paludifilum halophilum] diamond 117 44.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Paludifilum Paludifilum halophilum
32120909 32120909 PRJNA1001940_S_NODE_31278_length_372_cov_4.258359_g30227_i0 PRJNA1001940 31278 372 4.258359 15.84109548 Anaerococcus 165779 Bacteria Bacteria 239 6.389999999999998e-74   NR WP_115595220.1 165779 g30227 i0 100 0.991935483870968 123 0 99.2 0 2 370 269 391 WP_115595220.1 MULTISPECIES: DNA primase [Anaerococcus] diamond 369 239 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus  
32310927 32310927 PRJNA1001940_S_NODE_9479_length_553_cov_12.219608_g8533_i0 PRJNA1001940 9479 553 12.219608 67.57443224 Soehngenia saccharolytica 253256 Bacteria Bacteria 212 1.3999999999999999e-67   NR TJX50879.1 253256 g8533 i0 89.2 0.650994575045208 120 12 65.1 1 3 362 15 133 TJX50879.1 hypothetical protein E8P77_26860 [Soehngenia saccharolytica] diamond 360 212 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Tissierellaceae Soehngenia Soehngenia saccharolytica
32689591 32689591 PRJNA1001940_S_NODE_63000_length_273_cov_3.130435_g61946_i0 PRJNA1001940 63000 273 3.130435 8.54608755 Bacillus sp. FJAT-4535 2011014 Bacteria Bacteria 77 4.71e-14   NR WP_096202707.1 2011014 g61946 i0 83.3 0.461538461538462 42 7 46.2 0 1 126 543 584 WP_096202707.1 pyruvate kinase [Bacillus sp. FJAT-45350] diamond 126 77 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. FJAT-45350

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