RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA608894" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA608894 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
585912 585912 PRJNA608894_P_NODE_8461_length_914_cov_2.862069_g8043_i0 PRJNA608894 8461 914 2.862069 26.15931066 root 1 Root_unresolved Root_unresolved 315 3.95e-102   NR QHG77622.1 1280 g8043 i0 69 80.4617067833698 216 67 70.9 0 6 653 58 273 QHG77622.1 30S ribosomal protein S5 [Staphylococcus aureus] diamond 73542 317 0.993690851735016 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
9513904 9513904 PRJNA608894_P_NODE_39248_length_286_cov_1.338028_g38749_i0 PRJNA608894 39248 286 1.338028 3.82676008 Paenibacillus chitinolyticus 79263 Bacteria Bacteria 84.7 7.63e-18   NR WP_387540500.1 79263 g38749 i0 55.1 3.38811188811189 78 34 81.8 1 8 241 90 166 WP_387540500.1 ERF family protein [Paenibacillus chitinolyticus] diamond 969 84.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus chitinolyticus
19712005 19712005 PRJNA608894_P_NODE_36496_length_298_cov_1.284444_g35997_i0 PRJNA608894 36496 298 1.284444 3.82764312 Bacteria 2 Bacteria Bacteria 140 3.18e-38   NR MBQ8908951.1 2044939 g35997 i0 78.7 44.9295302013423 94 20 94.6 0 2 283 170 263 MBQ8908951.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridia bacterium] diamond 13389 140 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
26649908 26649908 PRJNA608894_P_NODE_39021_length_287_cov_1.079439_g38522_i0 PRJNA608894 39021 287 1.079439 3.09798993 Propionispora 112902 Bacteria Bacteria 43.1 0.0466   NR WP_054258607.1 1677858 g38522 i0 33.9 1.29616724738676 62 41 64.8 0 227 42 246 307 WP_054258607.1 preprotein translocase subunit SecA [Propionispora sp. 2/2-37] diamond 372 43.5 0.990804597701149 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Sporomusaceae Propionispora Propionispora sp. 2/2-37
26921942 26921942 PRJNA608894_P_NODE_49542_length_252_cov_1.122905_g49043_i0 PRJNA608894 49542 252 1.122905 2.8297206 Bacilli bacterium 1903720 Bacteria Bacteria 82 4.36e-16   NR MCI8498067.1 1903720 g49043 i0 46.4 1 84 44 100 1 252 1 208 290 MCI8498067.1 rhomboid family intramembrane serine protease [Bacilli bacterium] diamond 252 82 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
27364894 27364894 PRJNA608894_P_NODE_25043_length_382_cov_1.355987_g24546_i0 PRJNA608894 25043 382 1.355987 5.17987034 Staphylococcus warneri 1292 Bacteria Bacteria 72 4.76e-14   NR MDU1260150.1 1292 g24546 i0 100 0.235602094240838 30 0 23.6 0 318 229 1 30 MDU1260150.1 hypothetical protein [Staphylococcus warneri] diamond 90 72 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
27459472 27459472 PRJNA608894_P_NODE_35083_length_305_cov_1.715517_g34584_i0 PRJNA608894 35083 305 1.715517 5.23232685 Bacillota bacterium 1879010 Bacteria Bacteria 44.3 0.00252   NR MBR1735723.1 1879010 g34584 i0 63 0.265573770491803 27 10 26.6 0 305 225 13 39 MBR1735723.1 hypothetical protein [Bacillota bacterium] diamond 81 44.3 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
27756899 27756899 PRJNA608894_P_NODE_21304_length_433_cov_10.630556_g20808_i0 PRJNA608894 21304 433 10.630556 46.03030748 Paenibacillus 44249 Bacteria Bacteria 145 5.6499999999999996e-42   NR WP_377607390.1 306542 g20808 i0 61.1 3.1662817551963 113 44 78.3 0 381 43 4 116 WP_377607390.1 group I truncated hemoglobin [Paenibacillus gansuensis] diamond 1371 145 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus gansuensis
28122379 28122379 PRJNA608894_P_NODE_53185_length_248_cov_0.880000_g52686_i0 PRJNA608894 53185 248 0.88 2.1824 Marinococcus luteus 1122204 Bacteria Bacteria 105 5.14e-27   NR SDW09900.1 1122204 g52686 i0 89.4 0.798387096774194 66 7 79.8 0 50 247 23 88 SDW09900.1 hypothetical protein SAMN05421781_0440 [Marinococcus luteus] diamond 198 105 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Marinococcus Marinococcus luteus
28135654 28135654 PRJNA608894_P_NODE_20925_length_440_cov_4.337875_g20429_i0 PRJNA608894 20925 440 4.337875 19.08665 Bacillales 1385 Bacteria Bacteria 142 1e-40   NR WP_029100328.1 33942 g20429 i0 56.9 14.3045454545455 116 50 79.1 0 44 391 1 116 WP_029100328.1 group I truncated hemoglobin [Brevibacillus thermoruber] diamond 6294 143 0.993006993006993 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus thermoruber
28690930 28690930 PRJNA608894_P_NODE_31847_length_322_cov_1.642570_g31348_i0 PRJNA608894 31847 322 1.64257 5.2890754 Enterococcus faecalis 1351 Bacteria Bacteria 42 0.0144   NR MDU4017877.1 1351 g31348 i0 94.4 0.167701863354037 18 1 16.8 0 287 234 1 18 MDU4017877.1 hypothetical protein [Enterococcus faecalis] diamond 54 42 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
28722414 28722414 PRJNA608894_P_NODE_62327_length_205_cov_2.166667_g61828_i0 PRJNA608894 62327 205 2.166667 4.44166735 Clostridium butyricum 1492 Bacteria Bacteria 57 8.63e-9   NR MDU1007372.1 1492 g61828 i0 68.3 0.6 41 11 58.5 2 154 35 1 40 MDU1007372.1 hypothetical protein [Clostridium butyricum] diamond 123 57 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium butyricum
29448232 29448232 PRJNA608894_P_NODE_30210_length_334_cov_1.356322_g29711_i0 PRJNA608894 30210 334 1.356322 4.53011548 Clostridia bacterium 2044939 Bacteria Bacteria 51.2 1.09e-4   NR MDO4381436.1 2044939 g29711 i0 31.5 3.20658682634731 111 57 95.2 5 17 334 331 427 MDO4381436.1 hypothetical protein [Clostridia bacterium] diamond 1071 51.2 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29637564 29637564 PRJNA608894_P_NODE_37410_length_293_cov_2.318182_g36911_i0 PRJNA608894 37410 293 2.318182 6.79227326 Listeria monocytogenes 1639 Bacteria Bacteria 53.5 6.63e-7   NR WP_333731483.1 1639 g36911 i0 60.5 0.389078498293515 38 15 38.9 0 288 175 43 80 WP_333731483.1 hypothetical protein, partial [Listeria monocytogenes] diamond 114 53.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29985377 29985377 PRJNA608894_P_NODE_30651_length_330_cov_2.957198_g30152_i0 PRJNA608894 30651 330 2.957198 9.7587534 Eubacterium sp. 142586 Bacteria Bacteria 44.3 0.0274   NR MBS4868228.1 142586 g30152 i0 23.5 0.890909090909091 98 73 87.3 1 42 329 347 444 MBS4868228.1 GldG family protein [Eubacterium sp.] diamond 294 44.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
30648588 30648588 PRJNA608894_P_NODE_48073_length_256_cov_1.371585_g47574_i0 PRJNA608894 48073 256 1.371585 3.5112576 Clostridium perfringens 1502 Bacteria Bacteria 77 1.24e-14   NR EJT5919229.1 1502 g47574 i0 54.2 0.84375 72 33 84.4 0 218 3 3 74 EJT5919229.1 glycosyltransferase family 2 protein [Clostridium perfringens] diamond 216 77 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
30775364 30775364 PRJNA608894_P_NODE_27754_length_354_cov_6.558719_g27255_i0 PRJNA608894 27754 354 6.558719 23.21786526 Streptococcus pneumoniae 1313 Bacteria Bacteria 84 1.7e-18   NR MDG7606462.1 1313 g27255 i0 95 0.338983050847458 40 2 33.9 0 31 150 1 40 MDG7606462.1 hypothetical protein [Streptococcus pneumoniae] diamond 120 84 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
30775365 30775365 PRJNA608894_P_NODE_29634_length_338_cov_2.958491_g29135_i0 PRJNA608894 29634 338 2.958491 9.99969958 Clostridia bacterium 2044939 Bacteria Bacteria 65.9 9.26e-10   NR MBP3801826.1 2044939 g29135 i0 43.8 0.64792899408284 73 38 64.8 2 5 223 3163 3232 MBP3801826.1 hypothetical protein [Clostridia bacterium] diamond 219 65.9 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31198645 31198645 PRJNA608894_P_NODE_23575_length_400_cov_3.605505_g23078_i0 PRJNA608894 23575 400 3.605505 14.42202 FCB group 1783270 Bacteria Bacteria 120 4.59e-32   NR WP_002845271.1 1257 g23078 i0 53.6 11.0625 112 50 84 1 398 63 12 121 WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus] diamond 4425 121 0.991735537190083 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Peptostreptococcus  
31217169 31217169 PRJNA608894_P_NODE_56855_length_244_cov_0.900585_g56356_i0 PRJNA608894 56855 244 0.900585 2.1974274 Bacillota bacterium 1879010 Bacteria Bacteria 91.7 3.46e-20   NR HJH62421.1 1879010 g56356 i0 61 3.78688524590164 77 30 94.7 0 232 2 54 130 HJH62421.1 3-hydroxybutyryl-CoA dehydrogenase [Bacillota bacterium] diamond 924 91.7 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
31375832 31375832 PRJNA608894_P_NODE_54576_length_246_cov_1.618497_g54077_i0 PRJNA608894 54576 246 1.618497 3.98150262 Polycladomyces subterraneus 1016997 Bacteria Bacteria 44.3 0.0105   NR WP_301238520.1 1016997 g54077 i0 33.8 2.36585365853659 68 44 82.9 1 229 26 234 300 WP_301238520.1 thermonuclease family protein [Polycladomyces subterraneus] diamond 582 44.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Polycladomyces Polycladomyces subterraneus
31818445 31818445 PRJNA608894_P_NODE_47577_length_257_cov_2.152174_g47078_i0 PRJNA608894 47577 257 2.152174 5.53108718 Clostridium butyricum 1492 Bacteria Bacteria 49.3 1.25e-5   NR MDU1007400.1 1492 g47078 i0 66.7 0.315175097276265 27 9 31.5 0 252 172 34 60 MDU1007400.1 hypothetical protein [Clostridium butyricum] diamond 81 49.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium butyricum
31926504 31926504 PRJNA608894_P_NODE_38857_length_287_cov_1.705607_g38358_i0 PRJNA608894 38857 287 1.705607 4.89509209 Lactobacillales 186826 Bacteria Bacteria 44.7 0.00401   NR WP_214494867.1 1336 g38358 i0 89.5 0.386759581881533 19 2 19.9 0 283 227 4 22 WP_214494867.1 hypothetical protein [Streptococcus equi] diamond 111 44.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus equi
31989792 31989792 PRJNA608894_P_NODE_50058_length_251_cov_0.865169_g49559_i0 PRJNA608894 50058 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 65.1 5.31e-10   NR WP_373713600.1 1306 g49559 i0 93.8 9.2390438247012 32 2 38.2 0 2 97 263 294 WP_373713600.1 6-phospho-alpha-glucosidase [Streptococcus sp.] diamond 2319 65.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp.
32103239 32103239 PRJNA608894_P_NODE_54198_length_247_cov_0.885057_g53699_i0 PRJNA608894 54198 247 0.885057 2.18609079 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 48.5 3.42e-4   NR MBP0974611.1 2485925 g53699 i0 34.7 1.7246963562753 75 45 91.1 2 230 6 8 78 MBP0974611.1 leucine-rich repeat protein [Oscillospiraceae bacterium] diamond 426 48.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32230068 32230068 PRJNA608894_P_NODE_60258_length_241_cov_0.916667_g59759_i0 PRJNA608894 60258 241 0.916667 2.20916747 Fredinandcohnia sp. 179-A 1 2837515 Bacteria Bacteria 52 1.16e-5   NR WP_412966627.1 3235176 g59759 i0 40.3 1.64315352697095 72 39 89.6 2 227 12 100 167 WP_412966627.1 hypothetical protein [Fredinandcohnia sp. 179-A 10B2 NHS] diamond 396 52 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Fredinandcohnia Fredinandcohnia sp. 179-A 10B2 NHS

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