RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA870096" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 29 ✖

tax_kingdom 1

bioproject 1

  • PRJNA870096 · 29 ✖

analysis 1

  • diamond · 29 ✖

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
18701253 18701253 PRJNA870096_S_NODE_19335_length_412_cov_11.577236_g17680_i0 PRJNA870096 19335 412 11.577236 47.69821232 Veillonella sp. 1926307 Bacteria Bacteria 167 6.31e-51   NR WP_366512514.1 1926307 g17680 i0 74.3 1.52912621359223 105 27 76.5 0 384 70 1 105 WP_366512514.1 hypothetical protein [Veillonella sp.] diamond 630 167 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp.
25076031 25076031 PRJNA870096_S_NODE_23620_length_371_cov_4.274390_g21957_i0 PRJNA870096 23620 371 4.27439 15.8579869 FCB group 1783270 Bacteria Bacteria 213 1.63e-64   NR WP_132015865.1 1082276 g21957 i0 79.5 6.92991913746631 122 25 98.7 0 367 2 350 471 WP_132015865.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Hydrogenispora ethanolica] diamond 2571 213 1 Bacteria   Bacillati Bacillota       Hydrogenispora Hydrogenispora ethanolica
27213039 27213039 PRJNA870096_S_NODE_113742_length_166_cov_19.178862_g112078_i0 PRJNA870096 113742 166 19.178862 31.83691092 Staphylococcus aureus 1280 Bacteria Bacteria 41.2 0.0123   NR MCS4580470.1 1280 g112078 i0 96.8 0.560240963855422 31 1 56 0 165 73 3 33 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 93 41.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27276558 27276558 PRJNA870096_S_NODE_74083_length_203_cov_3.300000_g72419_i0 PRJNA870096 74083 203 3.3 6.699 Eubacteriaceae bacterium 2049045 Bacteria Bacteria 67.8 1.23e-11   NR MBR6801013.1 2049045 g72419 i0 56.1 0.842364532019704 57 25 84.2 0 31 201 14 70 MBR6801013.1 glycerophosphodiester phosphodiesterase [Eubacteriaceae bacterium] diamond 171 67.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae   Eubacteriaceae bacterium
27339821 27339821 PRJNA870096_S_NODE_53963_length_239_cov_1.979592_g52299_i0 PRJNA870096 53963 239 1.979592 4.73122488 Dolosigranulum pigrum 29394 Bacteria Bacteria 52.8 1.01e-5   NR WP_208967450.1 29394 g52299 i0 50 0.677824267782427 54 26 67.8 1 3 164 284 336 WP_208967450.1 GTPase ObgE [Dolosigranulum pigrum] diamond 162 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Dolosigranulum Dolosigranulum pigrum
27939707 27939707 PRJNA870096_S_NODE_145485_length_150_cov_1.280374_g143821_i0 PRJNA870096 145485 150 1.280374 1.920561 Clostridiales bacterium 1898207 Bacteria Bacteria 42.4 0.0101   NR MBE5820911.1 1898207 g143821 i0 44.9 0.98 49 25 94 1 150 10 97 145 MBE5820911.1 GNAT family N-acetyltransferase [Clostridiales bacterium] diamond 147 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28073879 28073879 PRJNA870096_S_NODE_140525_length_152_cov_0.880734_g138861_i0 PRJNA870096 140525 152 0.880734 1.33871568 root 1 Root_unresolved Root_unresolved 47.8 3.96e-5   NR MFP9035373.1 1351 g138861 i0 75.9 15.6118421052632 29 7 57.2 0 14 100 26 54 MFP9035373.1 DUF1725 domain-containing protein [Enterococcus faecalis] diamond 2373 47.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
28191959 28191959 PRJNA870096_S_NODE_143586_length_151_cov_0.888889_g141922_i0 PRJNA870096 143586 151 0.888889 1.34222239 Cohnella sp. CFH 77786 2662265 Bacteria Bacteria 65.5 5.28e-12   NR WP_219638946.1 2662265 g141922 i0 60.4 0.95364238410596 48 19 95.4 0 3 146 67 114 WP_219638946.1 DUF1304 domain-containing protein [Cohnella sp. CFH 77786] diamond 144 65.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella sp. CFH 77786
28231579 28231579 PRJNA870096_S_NODE_79106_length_197_cov_1.558442_g77442_i0 PRJNA870096 79106 197 1.558442 3.07013074 PVC group 1783257 Bacteria Bacteria 72.8 1.78e-13   NR HPF20685.1 2053627 g77442 i0 60 2.96954314720812 65 25 99 1 197 3 189 252 HPF20685.1 SDR family NAD(P)-dependent oxidoreductase [Syntrophomonas sp.] diamond 585 72.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Syntrophomonadaceae Syntrophomonas Syntrophomonas sp.
28350044 28350044 PRJNA870096_S_NODE_35546_length_299_cov_2.199219_g33882_i0 PRJNA870096 35546 299 2.199219 6.57566481 Lactobacillales bacterium 1993866 Bacteria Bacteria 43.5 0.0194   NR MBE6159497.1 1993866 g33882 i0 28.7 0.94314381270903 94 54 81.3 2 297 55 49 142 MBE6159497.1 hypothetical protein [Lactobacillales bacterium] diamond 282 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales     Lactobacillales bacterium
28516105 28516105 PRJNA870096_S_NODE_49947_length_249_cov_1.864078_g48283_i0 PRJNA870096 49947 249 1.864078 4.64155422 Bacteria 2 Bacteria Bacteria 45.1 0.00559   NR WP_019189703.1 938289 g48283 i0 34.8 1.6144578313253 69 44 83.1 1 12 218 222 289 WP_019189703.1 alpha/beta hydrolase [Levyella massiliensis] diamond 402 45.4 0.993392070484582 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Levyella Levyella massiliensis
28855094 28855094 PRJNA870096_S_NODE_9908_length_586_cov_4.362799_g8359_i0 PRJNA870096 9908 586 4.362799 25.56600214 Bacilli bacterium 1903720 Bacteria Bacteria 46.6 0.0388   NR MBQ4030179.1 1903720 g8359 i0 29.7 0.378839590443686 74 52 37.9 0 582 361 750 823 MBQ4030179.1 hypothetical protein [Bacilli bacterium] diamond 222 46.6 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
28886720 28886720 PRJNA870096_S_NODE_129708_length_157_cov_0.622807_g128044_i0 PRJNA870096 129708 157 0.622807 0.97780699 Veillonella parvula 29466 Bacteria Bacteria 47.4 5.85e-5   NR WP_325306650.1 29466 g128044 i0 77.3 0.420382165605096 22 5 42 0 66 1 1 22 WP_325306650.1 hypothetical protein [Veillonella parvula] diamond 66 47.4 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella parvula
28886722 28886722 PRJNA870096_S_NODE_54428_length_238_cov_1.800000_g52764_i0 PRJNA870096 54428 238 1.8 4.284 Paenibacillus cremeus 2163881 Bacteria Bacteria 62.4 4.08e-9   NR WP_144845662.1 2163881 g52764 i0 51.1 2.55882352941176 45 22 56.7 0 229 95 400 444 WP_144845662.1 Fe-Mn family superoxide dismutase [Paenibacillus cremeus] diamond 609 62.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus cremeus
28950194 28950194 PRJNA870096_S_NODE_139988_length_152_cov_0.880734_g138324_i0 PRJNA870096 139988 152 0.880734 1.33871568 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 72 6.88e-15   NR WP_252130203.1 1590 g138324 i0 100 0.690789473684211 35 0 69.1 0 107 3 1 35 WP_252130203.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 105 72 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29021568 29021568 PRJNA870096_S_NODE_39688_length_282_cov_1.803347_g38024_i0 PRJNA870096 39688 282 1.803347 5.08543854 Bacillaceae 186817 Bacteria Bacteria 47 9.35e-4   NR WP_172249008.1 1510468 g38024 i0 55.6 1.14893617021277 36 16 38.3 0 3 110 98 133 WP_172249008.1 ankyrin repeat domain-containing protein [Bacillus haikouensis] diamond 324 47 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus haikouensis
29202706 29202706 PRJNA870096_S_NODE_134849_length_154_cov_1.108108_g133185_i0 PRJNA870096 134849 154 1.108108 1.70648632 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 100 1.54e-25   NR WP_252130017.1 1590 g133185 i0 96.1 2.96103896103896 51 2 99.4 0 1 153 17 67 WP_252130017.1 30S ribosomal protein S30e, partial [Lactiplantibacillus plantarum] diamond 456 101 0.99009900990099 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29431439 29431439 PRJNA870096_S_NODE_49949_length_249_cov_1.864078_g48285_i0 PRJNA870096 49949 249 1.864078 4.64155422 Bacillota 1239 Bacteria Bacteria 44.3 0.00418   NR WP_169735827.1 319475 g48285 i0 36.8 3.09638554216867 68 30 79.5 2 233 36 45 101 WP_169735827.1 rhodanese-like domain-containing protein [Clostridium lundense] diamond 771 44.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium lundense
29707303 29707303 PRJNA870096_S_NODE_140610_length_152_cov_0.880734_g138946_i0 PRJNA870096 140610 152 0.880734 1.33871568 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 54.7 4.51e-7   NR MBQ9165384.1 2485925 g138946 i0 80.6 6.57236842105263 31 6 61.2 0 7 99 199 229 MBQ9165384.1 YggS family pyridoxal phosphate-dependent enzyme [Oscillospiraceae bacterium] diamond 999 54.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
29802405 29802405 PRJNA870096_S_NODE_100711_length_176_cov_1.443609_g99047_i0 PRJNA870096 100711 176 1.443609 2.54075184 Alkalihalobacterium chitinilyticum 2980103 Bacteria Bacteria 71.2 1.31e-12   NR WP_275119149.1 2980103 g99047 i0 90.5 0.715909090909091 42 4 71.6 0 49 174 1 42 WP_275119149.1 MFS transporter [Alkalihalobacterium chitinilyticum] diamond 126 71.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alkalihalobacterium Alkalihalobacterium chitinilyticum
29960380 29960380 PRJNA870096_S_NODE_27131_length_345_cov_117.847682_g25467_i0 PRJNA870096 27131 345 117.847682 406.5745029 Criibacterium bergeronii 1871336 Bacteria Bacteria 133 8.499999999999999e-38   NR RDY20310.1 1871336 g25467 i0 98 1.85217391304348 101 2 87.8 0 8 310 1 101 RDY20310.1 hypothetical protein BBG48_010870, partial [Criibacterium bergeronii] diamond 639 133 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Filifactoraceae Criibacterium Criibacterium bergeronii
30371578 30371578 PRJNA870096_S_NODE_16792_length_445_cov_37.796020_g15145_i0 PRJNA870096 16792 445 37.79602 168.192289 Bacillus thuringiensis 1428 Bacteria Bacteria 95.1 1.91e-22   NR WP_050232139.1 1428 g15145 i0 98.9 0.586516853932584 87 1 58.7 0 147 407 1 87 WP_050232139.1 hypothetical protein [Bacillus thuringiensis] diamond 261 95.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
30403182 30403182 PRJNA870096_S_NODE_56953_length_232_cov_8.862434_g55289_i0 PRJNA870096 56953 232 8.862434 20.56084688 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 42.4 0.0448   NR MEA5061696.1 2049044 g55289 i0 36.1 0.788793103448276 61 37 78.9 1 228 46 190 248 MEA5061696.1 ComEC/Rec2 family competence protein [Erysipelotrichaceae bacterium] diamond 183 42.4 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
30686975 30686975 PRJNA870096_S_NODE_122893_length_161_cov_0.983051_g121229_i0 PRJNA870096 122893 161 0.983051 1.58271211 Streptococcus agalactiae 1311 Bacteria Bacteria 101 2.1699999999999998e-23   NR MFS5904746.1 1311 g121229 i0 90 0.93167701863354 50 5 93.2 0 152 3 660 709 MFS5904746.1 pol polyprotein [Streptococcus agalactiae] diamond 150 101 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
30718618 30718618 PRJNA870096_S_NODE_49394_length_250_cov_227.661836_g47730_i0 PRJNA870096 49394 250 227.661836 569.15459 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 69.7 2.12e-13   NR WP_252130143.1 1590 g47730 i0 78.6 5.052 42 9 50.4 0 247 122 48 89 WP_252130143.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 1263 69.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30971596 30971596 PRJNA870096_S_NODE_52194_length_243_cov_5.185000_g50530_i0 PRJNA870096 52194 243 5.185 12.59955 Butyrivibrio sp. VCD2 28121 Bacteria Bacteria 42.7 0.0369   NR WP_035773553.1 1280664 g50530 i0 39.5 0.530864197530864 43 26 53.1 0 223 95 440 482 WP_035773553.1 ATP-dependent DNA helicase RecG [Butyrivibrio sp. VCD2006] diamond 129 42.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Butyrivibrio Butyrivibrio sp. VCD2006
31224053 31224053 PRJNA870096_S_NODE_48175_length_254_cov_1.819905_g46511_i0 PRJNA870096 48175 254 1.819905 4.6225587 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 90.1 1.51e-21   NR MBE6714843.1 2485925 g46511 i0 53.2 0.933070866141732 79 37 93.3 0 239 3 1 79 MBE6714843.1 hypothetical protein [Oscillospiraceae bacterium] diamond 237 90.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32300168 32300168 PRJNA870096_S_NODE_106619_length_172_cov_0.930233_g104955_i0 PRJNA870096 106619 172 0.930233 1.60000076 Clostridiales bacterium 1898207 Bacteria Bacteria 44.7 0.00291   NR MDR2091423.1 1898207 g104955 i0 41.5 0.924418604651163 53 31 92.4 0 9 167 400 452 MDR2091423.1 extracellular solute-binding protein [Clostridiales bacterium] diamond 159 44.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
32804822 32804822 PRJNA870096_S_NODE_108540_length_170_cov_1.511811_g106876_i0 PRJNA870096 108540 170 1.511811 2.5700787 Clostridia bacterium 2044939 Bacteria Bacteria 48.5 8.72e-5   NR MBQ8174634.1 2044939 g106876 i0 73.3 3.84705882352941 30 8 52.9 0 1 90 11 40 MBQ8174634.1 J domain-containing protein [Clostridia bacterium] diamond 654 48.5 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);;