RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA641991", tax_kingdom = "Bacillati" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 19 ✖

tax_kingdom 1

  • Bacillati · 19 ✖

bioproject 1

  • PRJNA641991 · 19 ✖

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
2433554 2433554 PRJNA641991_S_NODE_7662_length_201_cov_1.000000_g7543_i0 PRJNA641991 7662 201 1 2.01 Brevibacillus 55080 Bacteria Bacteria 248 2.08e-61   NTclustered gi|507148245|ref|NR_103052.1| 1393 g7543 i0 90.476 1009.2039800995 189 16 94 2 1 188 769 956 Brevibacillus brevis strain 47 23S ribosomal RNA gene, complete sequence blastn 202850 248 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus brevis
8271055 8271055 PRJNA641991_S_NODE_4087_length_264_cov_1.186047_g3968_i0 PRJNA641991 4087 264 1.186047 3.13116408 Eubacteriales 186802 Bacteria Bacteria 126 6.35e-33   NR MBD8962269.1 2485925 g3968 i0 70 3.60227272727273 80 24 90.9 0 241 2 171 250 MBD8962269.1 aspartate--ammonia ligase [Oscillospiraceae bacterium] diamond 951 126 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
8811329 8811329 PRJNA641991_S_NODE_2527_length_330_cov_2.548043_g2408_i0 PRJNA641991 2527 330 2.548043 8.4085419 Streptococcus 1301 Bacteria Bacteria 610 4.09e-170   NTclustered gi|1782758915|gb|CP018189.1| 1304 g2408 i0 100 626.575757575758 330 0 100 0 1 330 17847 17518 Streptococcus salivarius strain ICDC3 chromosome, complete genome blastn 206770 610 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus salivarius
10821962 10821962 PRJNA641991_P_NODE_3549_length_165_cov_0.879310_g3508_i0 PRJNA641991 3549 165 0.87931 1.4508615 Staphylococcus haemolyticus 1283 Bacteria Bacteria 305 9.59e-79   NTclustered gi|2851146212|gb|CP085027.1| 1283 g3508 i0 100 41.6181818181818 165 0 100 0 1 165 1645411 1645247 Staphylococcus haemolyticus strain SLM-175 chromosome, complete genome blastn 6867 305 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus haemolyticus
16461198 16461198 PRJNA641991_S_NODE_14713_length_161_cov_0.910714_g14594_i0 PRJNA641991 14713 161 0.910714 1.46624954 Streptococcus 1301 Bacteria Bacteria 298 1.56e-76   NTclustered gi|1403302629|emb|LS483342.1| 1311 g14594 i0 100 100 161 0 100 0 1 161 656016 655856 Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1 blastn 16100 298 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
17736308 17736308 PRJNA641991_S_NODE_11574_length_169_cov_1.275000_g11455_i0 PRJNA641991 11574 169 1.275 2.15475 Streptococcus 1301 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|1403302629|emb|LS483342.1| 1311 g11455 i0 100 634 169 0 100 0 1 169 19715 19883 Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1 blastn 107146 313 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
18470018 18470018 PRJNA641991_S_NODE_2135_length_359_cov_1.645161_g2016_i0 PRJNA641991 2135 359 1.645161 5.90612799 Streptococcus porcinus 1340 Bacteria Bacteria 52.8 0.034   NTclustered gi|1988318085|gb|CP070236.1| 1340 g2016 i0 100 0.467966573816156 28 0 8 0 20 47 1207591 1207564 Streptococcus porcinus strain Colony573 chromosome blastn 168 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus porcinus
20284800 20284800 PRJNA641991_S_NODE_13816_length_163_cov_0.894737_g13697_i0 PRJNA641991 13816 163 0.894737 1.45842131 Streptococcus 1301 Bacteria Bacteria 302 1.22e-77   NTclustered gi|909815781|gb|CP011327.1| 1311 g13697 i0 100 126.134969325153 163 0 100 0 1 163 605322 605160 Streptococcus agalactiae strain GX064 genome blastn 20560 302 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
21020150 21020150 PRJNA641991_P_NODE_3737_length_164_cov_0.886957_g3696_i0 PRJNA641991 3737 164 0.886957 1.45460948 Clostridium 1485 Bacteria Bacteria 75.5 3.61e-14   NR MBQ6820692.1 1506 g3696 i0 82.1 7.13414634146341 39 7 71.3 0 162 46 562 600 MBQ6820692.1 beta-glucuronidase [Clostridium sp.] diamond 1170 75.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
25384773 25384773 PRJNA641991_S_NODE_12820_length_165_cov_1.181034_g12701_i0 PRJNA641991 12820 165 1.181034 1.9487061 Streptococcus 1301 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1403302629|emb|LS483342.1| 1311 g12701 i0 100 633.030303030303 165 0 100 0 1 165 19466 19302 Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1 blastn 104450 305 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
25384786 25384786 PRJNA641991_S_NODE_8840_length_189_cov_1.685714_g8721_i0 PRJNA641991 8840 189 1.685714 3.18599946 Streptococcus 1301 Bacteria Bacteria 313 6.74e-81   NTclustered gi|2746253929|gb|PP939747.1| 1306 g8721 i0 100 263.783068783069 169 0 89 0 21 189 191 23 Streptococcus sp. strain 1-4 16S ribosomal RNA gene, partial sequence blastn 49855 313 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp.
27175856 27175856 PRJNA641991_S_NODE_13022_length_165_cov_0.879310_g12903_i0 PRJNA641991 13022 165 0.87931 1.4508615 Clostridium botulinum 1491 Bacteria Bacteria 45.1 0.00194   NR WP_265210576.1 1491 g12903 i0 44.2 0.945454545454545 52 25 94.5 1 157 2 69 116 WP_265210576.1 CDP-glycerol glycerophosphotransferase family protein [Clostridium botulinum] diamond 156 45.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium botulinum
27302645 27302645 PRJNA641991_S_NODE_5083_length_238_cov_7.793651_g4964_i0 PRJNA641991 5083 238 7.793651 18.54888938 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 43.1 0.0248   NR MEA5061696.1 2049044 g4964 i0 33.8 0.857142857142857 68 38 79.4 2 3 191 183 248 MEA5061696.1 ComEC/Rec2 family competence protein [Erysipelotrichaceae bacterium] diamond 204 43.1 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
28104083 28104083 PRJNA641991_S_NODE_4245_length_259_cov_1.942857_g4126_i0 PRJNA641991 4245 259 1.942857 5.03199963 Bacillales 1385 Bacteria Bacteria 50.1 1.19e-4   NR WP_101967018.1 28031 g4126 i0 41.3 3.15057915057915 63 33 68.3 1 82 258 286 348 WP_101967018.1 S-layer homology domain-containing protein [Lysinibacillus fusiformis] diamond 816 50.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus fusiformis
28249682 28249682 PRJNA641991_S_NODE_7946_length_197_cov_44.581081_g7827_i0 PRJNA641991 7946 197 44.581081 87.82472957 Bacillus sp. MHSD17 3026937 Bacteria Bacteria 41.2 0.0421   NR MDD1371223.1 3026937 g7827 i0 54.5 0.50253807106599 33 15 50.3 0 102 4 119 151 MDD1371223.1 PH domain-containing protein [Bacillus sp. MHSD17] diamond 99 41.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. MHSD17
28281172 28281172 PRJNA641991_S_NODE_13406_length_164_cov_0.886957_g13287_i0 PRJNA641991 13406 164 0.886957 1.45460948 Clostridium sp. 1506 Bacteria Bacteria 42.4 0.0162   NR MEG0297248.1 1506 g13287 i0 51.1 2.14024390243902 45 20 78.7 1 142 14 23 67 MEG0297248.1 ATP-binding cassette domain-containing protein [Clostridium sp.] diamond 351 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
30713110 30713110 PRJNA641991_S_NODE_13034_length_165_cov_0.879310_g12915_i0 PRJNA641991 13034 165 0.87931 1.4508615 Cytobacillus citreus 2833586 Bacteria Bacteria 60.5 6.62e-9   NR WP_213103100.1 2833586 g12915 i0 70.7 0.745454545454545 41 11 74.5 1 146 24 309 348 WP_213103100.1 enoyl-CoA hydratase/isomerase family protein [Cytobacillus citreus] diamond 123 60.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Cytobacillus Cytobacillus citreus
30934444 30934444 PRJNA641991_S_NODE_8574_length_192_cov_0.930070_g8455_i0 PRJNA641991 8574 192 0.93007 1.7857344 Pseudoflavonifractor capillosus 106588 Bacteria Bacteria 41.2 0.0161   NR WP_204898878.1 106588 g8455 i0 33.3 0.984375 63 42 98.4 0 4 192 15 77 WP_204898878.1 hypothetical protein [Pseudoflavonifractor capillosus] diamond 189 41.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Pseudoflavonifractor Pseudoflavonifractor capillosus
32021837 32021837 PRJNA641991_S_NODE_10698_length_175_cov_0.960317_g10579_i0 PRJNA641991 10698 175 0.960317 1.68055475 Bacillati 1783272 Bacteria Bacteria 92 6.22e-20   NR MDI9461189.1 1879010 g10579 i0 73.2 13.3028571428571 56 15 96 0 173 6 425 480 MDI9461189.1 pyruvate, phosphate dikinase [Bacillota bacterium] diamond 2328 92 1 Bacteria   Bacillati Bacillota         Bacillota 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);;