RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1159911" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1159911 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
1582955 1582955 PRJNA1159911_P_NODE_68922_length_286_cov_1.516432_g68380_i0 PRJNA1159911 68922 286 1.516432 4.33699552 Staphylococcus aureus 1280 Bacteria Bacteria 189 6.2e-60   NR KIT90241.1 1280 g68380 i0 100 0.996503496503496 95 0 99.7 0 286 2 36 130 KIT90241.1 hypothetical protein QT22_00385, partial [Staphylococcus aureus] diamond 285 189 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
2859506 2859506 PRJNA1159911_P_NODE_85803_length_252_cov_2.452514_g85261_i0 PRJNA1159911 85803 252 2.452514 6.18033528 Staphylococcus aureus 1280 Bacteria Bacteria 109 1.56e-28   NR WP_044121081.1 1280 g85261 i0 98.1 0.642857142857143 54 1 64.3 0 2 163 79 132 WP_044121081.1 NAD(+) diphosphatase, partial [Staphylococcus aureus] diamond 162 109 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
11785747 11785747 PRJNA1159911_P_NODE_101270_length_241_cov_0.916667_g100728_i0 PRJNA1159911 101270 241 0.916667 2.20916747 Bacillota bacterium 1879010 Bacteria Bacteria 127 4.62e-33   NR MDO4754639.1 1879010 g100728 i0 83.5 0.983402489626556 79 13 98.3 0 239 3 214 292 MDO4754639.1 sodium ion-translocating decarboxylase subunit beta [Bacillota bacterium] diamond 237 127 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
11786541 11786541 PRJNA1159911_P_NODE_48650_length_353_cov_1.757143_g48108_i0 PRJNA1159911 48650 353 1.757143 6.20271479 Staphylococcus aureus 1280 Bacteria Bacteria 167 5.19e-51   NR KIU01105.1 1280 g48108 i0 97.9 0.815864022662889 96 2 81.6 0 353 66 21 116 KIU01105.1 hypothetical protein QU38_02630, partial [Staphylococcus aureus] diamond 288 167 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
16340446 16340446 PRJNA1159911_P_NODE_51993_length_339_cov_1.804511_g51451_i0 PRJNA1159911 51993 339 1.804511 6.11729229 Staphylococcus aureus 1280 Bacteria Bacteria 155 1.79e-46   NR KIU01704.1 1280 g51451 i0 100 0.752212389380531 85 0 75.2 0 338 84 45 129 KIU01704.1 hypothetical protein QU38_00255, partial [Staphylococcus aureus] diamond 255 155 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
23260398 23260398 PRJNA1159911_P_NODE_65039_length_296_cov_1.215247_g64497_i0 PRJNA1159911 65039 296 1.215247 3.59713112 Bacteria 2 Bacteria Bacteria 190 4.81e-60   NR KIU01448.1 1280 g64497 i0 99 1.98648648648649 98 1 99.3 0 1 294 44 141 KIU01448.1 hypothetical protein QU38_01575, partial [Staphylococcus aureus] diamond 588 190 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
26818994 26818994 PRJNA1159911_P_NODE_75301_length_272_cov_1.356784_g74759_i0 PRJNA1159911 75301 272 1.356784 3.69045248 Caenibacillus caldisaponilyticus 1674942 Bacteria Bacteria 188 3.419999999999999e-54   NR WP_077614236.1 1674942 g74759 i0 100 0.992647058823529 90 0 99.3 0 1 270 540 629 WP_077614236.1 cytochrome aa3 quinol oxidase subunit I [Caenibacillus caldisaponilyticus] diamond 270 188 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Caenibacillus Caenibacillus caldisaponilyticus
26819004 26819004 PRJNA1159911_P_NODE_88761_length_250_cov_0.870056_g88219_i0 PRJNA1159911 88761 250 0.870056 2.17514 Bacillales bacterium 1904864 Bacteria Bacteria 79.3 2.46e-15   NR HET7579365.1 1904864 g88219 i0 94.7 1.824 38 2 45.6 0 115 2 1 38 HET7579365.1 4-hydroxy-3-methylbut-2-enyl diphosphate reductase [Bacillales bacterium] diamond 456 79.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales     Bacillales bacterium
27040413 27040413 PRJNA1159911_P_NODE_71982_length_279_cov_1.456311_g71440_i0 PRJNA1159911 71982 279 1.456311 4.06310769 Staphylococcus aureus 1280 Bacteria Bacteria 192 6.059999999999999e-60   NR WP_200888818.1 1280 g71440 i0 100 2 93 0 100 0 279 1 7 99 WP_200888818.1 putative porin, partial [Staphylococcus aureus] diamond 558 192 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27609187 27609187 PRJNA1159911_P_NODE_52544_length_337_cov_1.458333_g52002_i0 PRJNA1159911 52544 337 1.458333 4.91458221 Pseudoramibacter sp. 2034862 Bacteria Bacteria 43.9 0.0412   NR WP_296424645.1 2034862 g52002 i0 36.2 0.614243323442137 69 37 60.5 3 124 327 326 388 WP_296424645.1 IS1182 family transposase [Pseudoramibacter sp.] diamond 207 43.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Pseudoramibacter Pseudoramibacter sp.
27609190 27609190 PRJNA1159911_P_NODE_61884_length_305_cov_1.258621_g61342_i0 PRJNA1159911 61884 305 1.258621 3.83879405 Clostridioides difficile 1496 Bacteria Bacteria 121 4.93e-33   NR WP_198104585.1 1496 g61342 i0 96.7 0.590163934426229 60 2 59 0 2 181 65 124 WP_198104585.1 IS66 family transposase, partial [Clostridioides difficile] diamond 180 121 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
27861542 27861542 PRJNA1159911_P_NODE_65265_length_295_cov_1.792793_g64723_i0 PRJNA1159911 65265 295 1.792793 5.28873935 Streptococcus pneumoniae 1313 Bacteria Bacteria 80.5 1.58e-17   NR WP_216969834.1 1313 g64723 i0 100 0.416949152542373 41 0 41.7 0 3 125 40 80 WP_216969834.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 123 80.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
27924830 27924830 PRJNA1159911_P_NODE_53425_length_333_cov_1.992308_g52883_i0 PRJNA1159911 53425 333 1.992308 6.63438564 Alteribacillus sp. JSM 1 1872481 Bacteria Bacteria 43.9 0.0381   NR WP_375008661.1 1562101 g52883 i0 28.8 0.531531531531532 59 42 53.2 0 17 193 159 217 WP_375008661.1 TRAP transporter large permease [Alteribacillus sp. JSM 102045] diamond 177 43.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alteribacillus Alteribacillus sp. JSM 102045
28544270 28544270 PRJNA1159911_P_NODE_65827_length_294_cov_1.045249_g65285_i0 PRJNA1159911 65827 294 1.045249 3.07303206 Bacillati 1783272 Bacteria Bacteria 214 3.77e-70   NR MCL7548339.1 1280 g65285 i0 100 1.97959183673469 97 0 99 0 3 293 6 102 MCL7548339.1 rhodanese-like domain-containing protein [Staphylococcus aureus] diamond 582 214 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
28891166 28891166 PRJNA1159911_P_NODE_71088_length_281_cov_1.394231_g70546_i0 PRJNA1159911 71088 281 1.394231 3.91778911 Bacteria 2 Bacteria Bacteria 179 1.2399999999999998e-55   NR WP_160273991.1 1280 g70546 i0 97.8 2.97864768683274 93 2 99.3 0 3 281 18 110 WP_160273991.1 hypothetical protein, partial [Staphylococcus aureus] diamond 837 179 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
28998671 28998671 PRJNA1159911_P_NODE_16328_length_751_cov_22.780236_g15835_i0 PRJNA1159911 16328 751 22.780236 171.07957236 Staphylococcus aureus 1280 Bacteria Bacteria 299 9.419999999999999e-98   NR RBL73497.1 1280 g15835 i0 98.1 1.23035952063915 154 3 61.5 0 1 462 194 347 RBL73497.1 elongation factor 1-alpha, partial [Staphylococcus aureus] diamond 924 299 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
29049339 29049339 PRJNA1159911_P_NODE_85328_length_253_cov_1.927778_g84786_i0 PRJNA1159911 85328 253 1.927778 4.87727834 Bacteria 2 Bacteria Bacteria 112 1.31e-30   NR WP_164176839.1 1313 g84786 i0 100 1.32806324110672 56 0 66.4 0 86 253 1 56 WP_164176839.1 glycosyltransferase, partial [Streptococcus pneumoniae] diamond 336 112 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
29806902 29806902 PRJNA1159911_P_NODE_88591_length_250_cov_0.870056_g88049_i0 PRJNA1159911 88591 250 0.870056 2.17514 Anaerococcus 165779 Bacteria Bacteria 152 6.7e-42   NR WP_297281545.1 293428 g88049 i0 85.5 1.992 83 12 99.6 0 250 2 354 436 WP_297281545.1 4-alpha-glucanotransferase [uncultured Anaerococcus sp.] diamond 498 152 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
29850954 29850954 PRJNA1159911_P_NODE_69351_length_285_cov_1.646226_g68809_i0 PRJNA1159911 69351 285 1.646226 4.6917441 Vallitalea sp. AN17-1 3074434 Bacteria Bacteria 43.9 0.0211   NR GMQ58476.1 3074434 g68809 i0 41.2 0.536842105263158 51 28 53.7 1 245 93 146 194 GMQ58476.1 carbohydrate-binding protein [Vallitalea sp. AN17-1] diamond 153 43.9 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Vallitaleaceae Vallitalea Vallitalea sediminicola
29882642 29882642 PRJNA1159911_P_NODE_86011_length_252_cov_1.720670_g85469_i0 PRJNA1159911 86011 252 1.72067 4.3360884 Heyndrickxia sporothermodurans 46224 Bacteria Bacteria 51.6 2.97e-5   NR WP_107981750.1 46224 g85469 i0 48.1 2.94047619047619 52 27 61.9 0 68 223 80 131 WP_107981750.1 SPRY domain-containing protein [Heyndrickxia sporothermodurans] diamond 741 51.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Heyndrickxia Heyndrickxia sporothermodurans
30040388 30040388 PRJNA1159911_P_NODE_93971_length_246_cov_0.890173_g93429_i0 PRJNA1159911 93971 246 0.890173 2.18982558 Streptococcus suis 1307 Bacteria Bacteria 154 3.9599999999999996e-47   NR WP_392462772.1 1307 g93429 i0 100 0.975609756097561 80 0 97.6 0 245 6 8 87 WP_392462772.1 CHASE3 domain-containing protein, partial [Streptococcus suis] diamond 240 154 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
30134837 30134837 PRJNA1159911_P_NODE_65012_length_296_cov_1.313901_g64470_i0 PRJNA1159911 65012 296 1.313901 3.88914696 Candidatus Allocopromorpha excrementigallinarum 2840742 Bacteria Bacteria 62.8 2.2e-9   NR HIU25553.1 2840742 g64470 i0 40.2 0.932432432432432 92 38 89.2 2 13 276 91 169 HIU25553.1 YigZ family protein [Candidatus Allocopromorpha excrementigallinarum] diamond 276 62.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Candidatus Allocopromorpha Candidatus Allocopromorpha excrementigallinarum
30261796 30261796 PRJNA1159911_P_NODE_47072_length_361_cov_1.048611_g46530_i0 PRJNA1159911 47072 361 1.048611 3.78548571 Staphylococcus aureus 1280 Bacteria Bacteria 129 7.53e-36   NR KIU01440.1 1280 g46530 i0 100 1.72853185595568 66 0 54.8 0 2 199 62 127 KIU01440.1 hypothetical protein QU38_01615, partial [Staphylococcus aureus] diamond 624 129 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30767092 30767092 PRJNA1159911_P_NODE_46114_length_366_cov_1.020478_g45572_i0 PRJNA1159911 46114 366 1.020478 3.73494948 Exiguobacterium mexicanum 340146 Bacteria Bacteria 167 2.79e-50   NR MFN3367734.1 340146 g45572 i0 97.8 0.762295081967213 93 2 76.2 0 1 279 80 172 MFN3367734.1 hypothetical protein [Exiguobacterium mexicanum] diamond 279 167 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium mexicanum
31323566 31323566 PRJNA1159911_P_NODE_62775_length_302_cov_1.681223_g62233_i0 PRJNA1159911 62775 302 1.681223 5.07729346 Bacteria 2 Bacteria Bacteria 198 2.32e-63   NR WP_393960373.1 1404 g62233 i0 100 1.98675496688742 100 0 99.3 0 1 300 9 108 WP_393960373.1 hypothetical protein, partial [Priestia megaterium] diamond 600 198 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia megaterium
31450284 31450284 PRJNA1159911_P_NODE_97256_length_243_cov_2.988235_g96714_i0 PRJNA1159911 97256 243 2.988235 7.26141105 root 1 Root_unresolved Root_unresolved 89.7 1.2600000000000002e-21   NR PWS22639.1 1352 g96714 i0 100 22.2345679012346 40 0 49.4 0 123 242 1 40 PWS22639.1 hypothetical protein DKP78_17330, partial [Enterococcus faecium] diamond 5403 89.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
31620577 31620577 PRJNA1159911_P_NODE_96616_length_244_cov_0.900585_g96074_i0 PRJNA1159911 96616 244 0.900585 2.1974274 Streptococcus salivarius 1304 Bacteria Bacteria 148 1.3399999999999996e-42   NR MDU0882193.1 1304 g96074 i0 100 1.99180327868852 81 0 99.6 0 1 243 1 81 MDU0882193.1 FtsX-like permease family protein [Streptococcus salivarius] diamond 486 148 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus salivarius
31829550 31829550 PRJNA1159911_P_NODE_89317_length_249_cov_1.715909_g88775_i0 PRJNA1159911 89317 249 1.715909 4.27261341 Clostridium 1485 Bacteria Bacteria 67 1.06e-10   NR WP_070109829.1 76489 g88775 i0 41.5 4.34939759036145 82 46 98.8 2 248 3 223 302 WP_070109829.1 GGDEF domain-containing protein [Clostridium acetireducens] diamond 1083 67.4 0.99406528189911 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium acetireducens
31841834 31841834 PRJNA1159911_P_NODE_93457_length_246_cov_1.508671_g92915_i0 PRJNA1159911 93457 246 1.508671 3.71133066 Staphylococcus aureus 1280 Bacteria Bacteria 88.2 4.25e-21   NR WP_159314292.1 1280 g92915 i0 100 0.621951219512195 51 0 62.2 0 245 93 7 57 WP_159314292.1 hypothetical protein [Staphylococcus aureus] diamond 153 88.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32190127 32190127 PRJNA1159911_P_NODE_72018_length_279_cov_1.330097_g71476_i0 PRJNA1159911 72018 279 1.330097 3.71097063 Staphylococcus aureus 1280 Bacteria Bacteria 83.6 6.97e-19   NR WP_160273964.1 1280 g71476 i0 100 0.408602150537634 38 0 40.9 0 3 116 38 75 WP_160273964.1 TonB-dependent receptor, partial [Staphylococcus aureus] diamond 114 83.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32348487 32348487 PRJNA1159911_P_NODE_24279_length_569_cov_3.417339_g23744_i0 PRJNA1159911 24279 569 3.417339 19.44465891 Virgibacillus sp. 19R1-5 2834410 Bacteria Bacteria 199 1.36e-60   NR WP_213406776.1 2834410 g23744 i0 67.1 2.49384885764499 158 51 83.3 1 1 474 3 159 WP_213406776.1 hypothetical protein, partial [Virgibacillus sp. 19R1-5] diamond 1419 199 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Virgibacillus Virgibacillus sp. 19R1-5
32538318 32538318 PRJNA1159911_P_NODE_93739_length_246_cov_0.890173_g93197_i0 PRJNA1159911 93739 246 0.890173 2.18982558 Clostridium perfringens 1502 Bacteria Bacteria 72.8 1.3e-14   NR WP_395251605.1 1502 g93197 i0 47.3 0.902439024390244 74 39 90.2 0 223 2 5 78 WP_395251605.1 hypothetical protein, partial [Clostridium perfringens] diamond 222 72.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens

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