RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA784979 · 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
26958518 26958518 PRJNA784979_S_NODE_11962_length_164_cov_0.886957_g11920_i0 PRJNA784979 11962 164 0.886957 1.45460948 Clostridia bacterium 2044939 Bacteria Bacteria 41.2 0.0452   NR MFA5153464.1 2044939 g11920 i0 50 0.841463414634146 46 23 84.1 0 159 22 181 226 MFA5153464.1 hypothetical protein [Clostridia bacterium] diamond 138 41.2 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27031243 27031243 PRJNA784979_S_NODE_2802_length_276_cov_0.911894_g2760_i0 PRJNA784979 2802 276 0.911894 2.51682744 Bacillus 1386 Bacteria Bacteria 56.6 3.65e-8   NR WP_032677190.1 1423 g2760 i0 65 0.869565217391304 40 14 43.5 0 16 135 45 84 WP_032677190.1 hypothetical protein [Bacillus subtilis] diamond 240 56.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
27843177 27843177 PRJNA784979_S_NODE_6044_length_201_cov_1.111842_g6002_i0 PRJNA784979 6044 201 1.111842 2.23480242 Streptococcus pneumoniae 1313 Bacteria Bacteria 87.8 3.9300000000000005e-21   NR WP_230679251.1 1313 g6002 i0 95.7 0.701492537313433 47 2 70.1 0 143 3 1 47 WP_230679251.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 141 87.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28285158 28285158 PRJNA784979_S_NODE_12446_length_163_cov_0.894737_g12404_i0 PRJNA784979 12446 163 0.894737 1.45842131 Streptococcus pneumoniae 1313 Bacteria Bacteria 99.4 9.79e-26   NR WP_230684358.1 1313 g12404 i0 88.7 0.975460122699387 53 6 97.5 0 161 3 25 77 WP_230684358.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 159 99.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28727472 28727472 PRJNA784979_S_NODE_13287_length_161_cov_0.910714_g13245_i0 PRJNA784979 13287 161 0.910714 1.46624954 Peptoniphilus grossensis 1465756 Bacteria Bacteria 65.5 1.16e-10   NR WP_019125022.1 1465756 g13245 i0 67.9 1.97515527950311 53 17 98.8 0 160 2 369 421 WP_019125022.1 efflux RND transporter periplasmic adaptor subunit [Peptoniphilus grossensis] diamond 318 65.5 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus grossensis
29074957 29074957 PRJNA784979_S_NODE_10408_length_167_cov_0.864407_g10366_i0 PRJNA784979 10408 167 0.864407 1.44355969 Tepidibacillus sp. 2041576 Bacteria Bacteria 60.8 1.37e-9   NR MFT9488297.1 2041576 g10366 i0 49.1 1.90419161676647 53 27 95.2 0 165 7 87 139 MFT9488297.1 SLOG family protein [Tepidibacillus sp.] diamond 318 60.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Tepidibacillus Tepidibacillus sp.
29390624 29390624 PRJNA784979_S_NODE_13929_length_154_cov_3.133333_g13887_i0 PRJNA784979 13929 154 3.133333 4.82533282 Streptococcus pneumoniae 1313 Bacteria Bacteria 77.8 1.32e-17   NR CWF69157.1 1313 g13887 i0 100 1.4025974025974 34 0 66.2 0 153 52 15 48 CWF69157.1 Uncharacterised protein [Streptococcus pneumoniae] diamond 216 77.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
29864085 29864085 PRJNA784979_S_NODE_12191_length_163_cov_1.271930_g12149_i0 PRJNA784979 12191 163 1.27193 2.0732459 Heyndrickxia sporothermodurans 46224 Bacteria Bacteria 86.3 5.59e-18   NR WP_202734756.1 46224 g12149 i0 75.5 2.92638036809816 53 13 97.5 0 3 161 820 872 WP_202734756.1 DNA polymerase III subunit alpha [Heyndrickxia sporothermodurans] diamond 477 86.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Heyndrickxia Heyndrickxia sporothermodurans
30022227 30022227 PRJNA784979_S_NODE_5831_length_204_cov_0.909677_g5789_i0 PRJNA784979 5831 204 0.909677 1.85574108 Streptococcus pneumoniae 1313 Bacteria Bacteria 110 1.46e-29   NR WP_196299567.1 1313 g5789 i0 87.5 0.941176470588235 64 8 94.1 0 193 2 2 65 WP_196299567.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 192 110 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
30157461 30157461 PRJNA784979_S_NODE_11852_length_164_cov_0.886957_g11810_i0 PRJNA784979 11852 164 0.886957 1.45460948 Bacillati 1783272 Bacteria Bacteria 103 3.41e-25   NR HSK51973.1 2044939 g11810 i0 90.6 2.90853658536585 53 5 97 0 1 159 139 191 HSK51973.1 MBL fold metallo-hydrolase [Clostridia bacterium] diamond 477 103 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30338460 30338460 PRJNA784979_S_NODE_3152_length_261_cov_0.929245_g3110_i0 PRJNA784979 3152 261 0.929245 2.42532945 Streptococcus pneumoniae 1313 Bacteria Bacteria 114 2.6499999999999996e-31   NR WP_230679251.1 1313 g3110 i0 100 0.666666666666667 58 0 66.7 0 8 181 7 64 WP_230679251.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 174 114 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
30970066 30970066 PRJNA784979_S_NODE_4954_length_215_cov_3.831325_g4912_i0 PRJNA784979 4954 215 3.831325 8.23734875 Staphylococcus aureus 1280 Bacteria Bacteria 60.8 4.56e-10   NR MCS4580470.1 1280 g4912 i0 97.6 0.586046511627907 42 1 58.6 0 2 127 4 45 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 126 60.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30970067 30970067 PRJNA784979_S_NODE_6034_length_201_cov_1.309211_g5992_i0 PRJNA784979 6034 201 1.309211 2.63151411 Heyndrickxia sporothermodurans 46224 Bacteria Bacteria 42 0.0382   NR WP_202775311.1 46224 g5992 i0 80 0.373134328358209 25 5 37.3 0 26 100 263 287 WP_202775311.1 phosphoesterase [Heyndrickxia sporothermodurans] diamond 75 42 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Heyndrickxia Heyndrickxia sporothermodurans
31074064 31074064 PRJNA784979_S_NODE_13415_length_161_cov_0.910714_g13373_i0 PRJNA784979 13415 161 0.910714 1.46624954 FCB group 1783270 Bacteria Bacteria 41.6 0.0314   NR WP_246599323.1 205328 g13373 i0 54.8 1.71428571428571 31 14 57.8 0 64 156 34 64 WP_246599323.1 aliphatic sulfonate ABC transporter substrate-binding protein [Clostridium lacusfryxellense] diamond 276 42 0.990476190476191 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium lacusfryxellense
31285847 31285847 PRJNA784979_S_NODE_8655_length_177_cov_0.929688_g8613_i0 PRJNA784979 8655 177 0.929688 1.64554776 Streptococcus pseudopneumoniae 257758 Bacteria Bacteria 73.9 7.86e-16   NR MBF9666413.1 257758 g8613 i0 97.3 1.25423728813559 37 1 62.7 0 111 1 1 37 MBF9666413.1 hypothetical protein [Streptococcus pseudopneumoniae] diamond 222 73.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pseudopneumoniae
31791827 31791827 PRJNA784979_S_NODE_8257_length_180_cov_1.328244_g8215_i0 PRJNA784979 8257 180 1.328244 2.3908392 Robertmurraya sp. 2837525 Bacteria Bacteria 85.1 1.85e-17   NR WP_391557164.1 2837525 g8215 i0 67.8 3.93333333333333 59 18 98.3 1 178 2 587 644 WP_391557164.1 DNA polymerase [Robertmurraya sp.] diamond 708 85.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Robertmurraya Robertmurraya sp.
31950116 31950116 PRJNA784979_S_NODE_13877_length_155_cov_2.443396_g13835_i0 PRJNA784979 13877 155 2.443396 3.7872638 Paenibacillus sp. TRM 82003 2926908 Bacteria Bacteria 50.1 9.51e-6   NR MCI3922444.1 2926908 g13835 i0 43.1 0.987096774193548 51 28 96.8 1 154 5 72 122 MCI3922444.1 RusA family crossover junction endodeoxyribonuclease [Paenibacillus sp. TRM 82003] diamond 153 50.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. TRM 82003
32140129 32140129 PRJNA784979_S_NODE_11038_length_165_cov_1.879310_g10996_i0 PRJNA784979 11038 165 1.87931 3.1008615 Staphylococcus aureus 1280 Bacteria Bacteria 107 4.51e-29   NR HDG7340680.1 1280 g10996 i0 100 0.981818181818182 54 0 98.2 0 164 3 1 54 HDG7340680.1 hypothetical protein [Staphylococcus aureus] diamond 162 107 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32149443 32149443 PRJNA784979_S_NODE_5558_length_207_cov_1.253165_g5516_i0 PRJNA784979 5558 207 1.253165 2.59405155 Bacteria 2 Bacteria Bacteria 76.3 2.36e-16   NR MFK5283085.1 1597 g5516 i0 97.2 1.04347826086957 36 1 52.2 0 110 3 1 36 MFK5283085.1 hypothetical protein [Lacticaseibacillus paracasei] diamond 216 76.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
32456662 32456662 PRJNA784979_S_NODE_13039_length_162_cov_0.805310_g12997_i0 PRJNA784979 13039 162 0.80531 1.3046022 Streptococcus pneumoniae 1313 Bacteria Bacteria 84.7 5.57e-20   NR WP_196300570.1 1313 g12997 i0 95.3 0.796296296296296 43 2 79.6 0 162 34 35 77 WP_196300570.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 129 84.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32866259 32866259 PRJNA784979_S_NODE_12180_length_163_cov_1.307018_g12138_i0 PRJNA784979 12180 163 1.307018 2.13043934 Clostridia bacterium 2044939 Bacteria Bacteria 42.7 0.00865   NR MCK9575572.1 2044939 g12138 i0 51.7 0.533742331288344 29 14 53.4 0 153 67 136 164 MCK9575572.1 hypothetical protein [Clostridia bacterium] diamond 87 42.7 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia 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);;