RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA893346", tax_phylum = "Bacillota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 32 ✖

tax_phylum 1

  • Bacillota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA893346 · 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
5971133 5971133 PRJNA893346_P_NODE_15065_length_401_cov_0.939024_g14577_i0 PRJNA893346 15065 401 0.939024 3.76548624 Gemella sanguinis 84135 Bacteria Bacteria 54.7 0.011   NTclustered gi|1780450472|gb|CP046313.1| 84135 g14577 i0 100 0.0723192019950125 29 0 7 0 170 198 560221 560249 Gemella sanguinis strain FDAARGOS_742 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella sanguinis
6347325 6347325 PRJNA893346_P_NODE_9725_length_506_cov_1.399538_g9241_i0 PRJNA893346 9725 506 1.399538 7.08166228 Lactobacillus 1578 Bacteria Bacteria 62.1 8.22e-5   NTclustered gi|1785991537|gb|CP039261.1| 33959 g9241 i0 89.796 1.52766798418972 49 4 9 1 286 333 1635908 1635860 Lactobacillus johnsonii strain DC22.2 chromosome, complete genome blastn 773 62.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus johnsonii
7246628 7246628 PRJNA893346_P_NODE_39946_length_241_cov_0.916667_g39456_i0 PRJNA893346 39946 241 0.916667 2.20916747 Enterococcus faecium 1352 Bacteria Bacteria 52.8 0.022   NTclustered gi|2890913812|gb|CP127427.1| 1352 g39456 i0 100 0.348547717842324 28 0 12 0 29 56 16368 16341 Enterococcus faecium strain ER05745.5 plasmid pER05745_5B.2, complete sequence blastn 84 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
12722764 12722764 PRJNA893346_P_NODE_34110_length_250_cov_0.870056_g33620_i0 PRJNA893346 34110 250 0.870056 2.17514 Staphylococcus 1279 Bacteria Bacteria 462 8.83e-126   NTclustered gi|1176884116|gb|CP020463.1| 1282 g33620 i0 100 100 250 0 100 0 1 250 2021575 2021824 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 25000 462 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
14896468 14896468 PRJNA893346_P_NODE_39012_length_242_cov_0.911243_g38522_i0 PRJNA893346 39012 242 0.911243 2.20520806 Candidatus Caccovivens 2840581 Bacteria Bacteria 120 1.08e-30   NR HHV95578.1 1898204 g38522 i0 79.7 10.7727272727273 79 16 97.9 0 240 4 162 240 HHV95578.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridiaceae bacterium] diamond 2607 120 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
17820804 17820804 PRJNA893346_P_NODE_3234_length_908_cov_3.742515_g2854_i0 PRJNA893346 3234 908 3.742515 33.9820362 root 1 Root_unresolved Root_unresolved 1677 0   NTclustered gi|1796975023|gb|CP033086.1| 1280 g2854 i0 100 58.0770925110132 908 0 100 0 1 908 2428193 2427286 Staphylococcus aureus strain WH9628 chromosome blastn 52734 1677 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
18719788 18719788 PRJNA893346_P_NODE_31715_length_260_cov_1.604278_g31225_i0 PRJNA893346 31715 260 1.604278 4.1711228 Anaerococcus nagyae 1755241 Bacteria Bacteria 453 5.5600000000000005e-123   NTclustered gi|2722731751|dbj|AP031484.1| 1755241 g31225 i0 100 327.261538461538 245 0 95 0 16 260 122130 121886 Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1 blastn 85088 453 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus nagyae
19994535 19994535 PRJNA893346_P_NODE_15076_length_400_cov_3.125382_g14588_i0 PRJNA893346 15076 400 3.125382 12.501528 Sutcliffiella horikoshii 79883 Bacteria Bacteria 63.9 1.77e-5   NTclustered gi|1198028747|gb|CP020880.1| 79883 g14588 i0 100 0.085 34 0 9 0 80 113 3029447 3029414 Sutcliffiella horikoshii strain 20a chromosome, complete genome blastn 34 63.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Sutcliffiella Sutcliffiella horikoshii
22920863 22920863 PRJNA893346_P_NODE_21778_length_329_cov_2.054688_g21289_i0 PRJNA893346 21778 329 2.054688 6.75992352 root 1 Root_unresolved Root_unresolved 575 1.4899999999999995e-159   NTclustered gi|1796975023|gb|CP033086.1| 1280 g21289 i0 98.765 29.4133738601824 324 3 98 1 1 324 2427005 2427327 Staphylococcus aureus strain WH9628 chromosome blastn 9677 575 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
25469986 25469986 PRJNA893346_P_NODE_31700_length_260_cov_1.647059_g31210_i0 PRJNA893346 31700 260 1.647059 4.2823534 Staphylococcus 1279 Bacteria Bacteria 481 2.55e-131   NTclustered gi|2894814215|gb|CP178526.1| 1292 g31210 i0 100 23.7269230769231 260 0 100 0 1 260 2186446 2186187 Staphylococcus warneri strain X5R13 chromosome, complete genome blastn 6169 481 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
26778672 26778672 PRJNA893346_P_NODE_4441_length_771_cov_2.085960_g1595_i1 PRJNA893346 4441 771 2.08596 16.0827516 root 1 Root_unresolved Root_unresolved 105 1.54e-21   NR WP_322364163.1 1396 g1595 i1 38.5 2.2568093385214 148 86 56 3 100 531 419 565 WP_322364163.1 FG-GAP repeat domain-containing protein [Bacillus cereus] diamond 1740 105 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
26992144 26992144 PRJNA893346_P_NODE_25322_length_302_cov_1.131004_g24832_i0 PRJNA893346 25322 302 1.131004 3.41563208 Eubacterium sp. 142586 Bacteria Bacteria 48.9 4.67e-4   NR MDE6469480.1 142586 g24832 i0 37.9 1.58940397350993 66 33 65.6 2 200 3 265 322 MDE6469480.1 glycoside hydrolase family 18 protein [Eubacterium sp.] diamond 480 48.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
27149979 27149979 PRJNA893346_P_NODE_14502_length_409_cov_1.369048_g14014_i0 PRJNA893346 14502 409 1.369048 5.59940632 Streptococcus dysgalactiae 1334 Bacteria Bacteria 80.9 1.03e-14   NR WP_204107570.1 1334 g14014 i0 50.6 0.579462102689487 79 39 57.9 0 1 237 433 511 WP_204107570.1 RNA-directed DNA polymerase, partial [Streptococcus dysgalactiae] diamond 237 80.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
27276975 27276975 PRJNA893346_P_NODE_14203_length_414_cov_1.008798_g13716_i0 PRJNA893346 14203 414 1.008798 4.17642372 Streptococcus dysgalactiae 1334 Bacteria Bacteria 137 2.6099999999999993e-34   NR MBM6549248.1 119602 g13716 i0 54.3 1 138 59 99.3 2 412 2 133 267 MBM6549248.1 DUF1759 domain-containing protein [Streptococcus dysgalactiae subsp. equisimilis] diamond 414 137 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
27442911 27442911 PRJNA893346_P_NODE_39683_length_241_cov_0.916667_g39193_i0 PRJNA893346 39683 241 0.916667 2.20916747 Streptococcus 1301 Bacteria Bacteria 50.4 6.95e-5   NR WP_239110322.1 1334 g39193 i0 53.7 1.34439834024896 54 25 67.2 0 2 163 485 538 WP_239110322.1 A17 family peptidase, partial [Streptococcus dysgalactiae] diamond 324 50.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
27908167 27908167 PRJNA893346_P_NODE_36425_length_246_cov_0.890173_g35935_i0 PRJNA893346 36425 246 0.890173 2.18982558 Streptococcus dysgalactiae 1334 Bacteria Bacteria 43.5 0.0207   NR MBM6549305.1 119602 g35935 i0 39.1 0.560975609756098 46 28 56.1 0 159 22 86 131 MBM6549305.1 hypothetical protein [Streptococcus dysgalactiae subsp. equisimilis] diamond 138 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
27947831 27947831 PRJNA893346_P_NODE_23325_length_317_cov_1.155738_g22835_i0 PRJNA893346 23325 317 1.155738 3.66368946 Bacillaceae 186817 Bacteria Bacteria 99.4 8.6e-23   NR WP_066108005.1 186817 g22835 i0 51.4 8.04416403785489 105 49 97.5 1 2 310 113 217 WP_066108005.1 MULTISPECIES: basic amino acid ABC transporter substrate-binding protein [Bacillaceae] diamond 2550 100 0.994 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae    
28042566 28042566 PRJNA893346_P_NODE_23625_length_314_cov_3.058091_g23135_i0 PRJNA893346 23625 314 3.058091 9.60240574 Bacteria 2 Bacteria Bacteria 84.3 2.09e-16   NR WP_322372238.1 1396 g23135 i0 40.2 4.90127388535032 102 59 95.5 1 300 1 393 494 WP_322372238.1 FG-GAP repeat domain-containing protein, partial [Bacillus cereus] diamond 1539 84.7 0.995277449822904 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
28255649 28255649 PRJNA893346_P_NODE_33946_length_250_cov_0.870056_g33456_i0 PRJNA893346 33946 250 0.870056 2.17514 Pseudobacteroides cellulosolvens 35825 Bacteria Bacteria 72.8 1.02e-12   NR WP_036935675.1 35825 g33456 i0 47.1 1.68 70 37 84 0 3 212 526 595 WP_036935675.1 phosphoenolpyruvate carboxykinase (GTP) [Pseudobacteroides cellulosolvens] diamond 420 72.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Pseudobacteroides Pseudobacteroides cellulosolvens
28823826 28823826 PRJNA893346_P_NODE_36208_length_247_cov_0.885057_g35718_i0 PRJNA893346 36208 247 0.885057 2.18609079 Acetoanaerobium noterae 745369 Bacteria Bacteria 96.3 4.57e-21   NR WP_313568436.1 745369 g35718 i0 63 4.90688259109312 81 28 98.4 2 246 4 288 366 WP_313568436.1 IMP dehydrogenase [Acetoanaerobium noterae] diamond 1212 96.3 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Filifactoraceae Acetoanaerobium Acetoanaerobium noterae
28918624 28918624 PRJNA893346_P_NODE_24568_length_307_cov_1.730769_g24078_i0 PRJNA893346 24568 307 1.730769 5.31346083 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 43.5 0.0397   NR MCQ2495786.1 1898203 g24078 i0 33 0.9185667752443 94 59 87.9 2 302 33 83 176 MCQ2495786.1 FHA domain-containing protein [Lachnospiraceae bacterium] diamond 282 43.5 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29297739 29297739 PRJNA893346_P_NODE_13689_length_422_cov_1.332378_g13203_i0 PRJNA893346 13689 422 1.332378 5.62263516 Clostridiales bacterium 1898207 Bacteria Bacteria 47 0.0057   NR NLC44074.1 1898207 g13203 i0 30.9 0.68957345971564 97 57 67.5 4 15 299 131 219 NLC44074.1 alpha/beta fold hydrolase [Clostridiales bacterium] diamond 291 47 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
29968619 29968619 PRJNA893346_P_NODE_38151_length_243_cov_1.382353_g37661_i0 PRJNA893346 38151 243 1.382353 3.35911779 Bacteria 2 Bacteria Bacteria 77.4 4.39e-15   NR WP_021285766.1 1054297 g37661 i0 75 6.51851851851852 48 12 59.3 0 83 226 38 85 WP_021285766.1 superoxide dismutase [Clostridium punense] diamond 1584 77.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium punense
29992460 29992460 PRJNA893346_P_NODE_20311_length_342_cov_1.137546_g19822_i0 PRJNA893346 20311 342 1.137546 3.89040732 Paenibacillus sp. yr247 1761880 Bacteria Bacteria 82.8 4.43e-16   NR WP_090827683.1 1761880 g19822 i0 45.5 0.868421052631579 99 54 86.8 0 320 24 229 327 WP_090827683.1 zinc-binding dehydrogenase [Paenibacillus sp. yr247] diamond 297 82.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. yr247
30181885 30181885 PRJNA893346_P_NODE_15792_length_391_cov_0.971698_g15304_i0 PRJNA893346 15792 391 0.971698 3.79933918 Staphylococcus aureus 1280 Bacteria Bacteria 88.6 4.25e-20   NR KMR26911.1 1280 g15304 i0 90.8 1.65728900255754 87 8 66.8 0 261 1 1 87 KMR26911.1 hypothetical protein EV30_14850, partial [Staphylococcus aureus] diamond 648 88.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31200384 31200384 PRJNA893346_P_NODE_21715_length_330_cov_1.186770_g21226_i0 PRJNA893346 21715 330 1.18677 3.916341 root 1 Root_unresolved Root_unresolved 62 1.53e-9   NR WP_072906887.1 182411 g21226 i0 45.3 6.94545454545455 64 35 58.2 0 3 194 4 67 WP_072906887.1 nucleoside-diphosphate kinase [Anaerobranca californiensis] diamond 2292 62.4 0.993589743589744 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Proteinivoracaceae Anaerobranca Anaerobranca californiensis
31414457 31414457 PRJNA893346_P_NODE_28236_length_283_cov_1.076190_g27746_i0 PRJNA893346 28236 283 1.07619 3.0456177 Geobacillus 129337 Bacteria Bacteria 46.2 0.00238   NR WP_033024398.1 129337 g27746 i0 33.3 0.954063604240283 90 45 82.7 3 15 248 8 94 WP_033024398.1 MULTISPECIES: phosphatase PAP2 family protein [Geobacillus] diamond 270 46.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus  
31541048 31541048 PRJNA893346_P_NODE_1716_length_1236_cov_2.129837_g1457_i0 PRJNA893346 1716 1236 2.129837 26.32478532 Weissella cibaria 137591 Bacteria Bacteria 47 0.0362   NR WP_196777253.1 137591 g1457 i0 42.6 0.313106796116505 129 58 31.3 5 520 906 44 156 WP_196777253.1 hypothetical protein, partial [Weissella cibaria] diamond 387 47 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella cibaria
31706870 31706870 PRJNA893346_P_NODE_39977_length_241_cov_0.916667_g39487_i0 PRJNA893346 39977 241 0.916667 2.20916747 Bacillati 1783272 Bacteria Bacteria 55.1 1.49e-7   NR WP_027089778.1 341225 g39487 i0 37.8 4.28215767634855 74 46 92.1 0 229 8 9 82 WP_027089778.1 rhodanese-like domain-containing protein [Thomasclavelia saccharogumia] diamond 1032 55.5 0.992792792792793 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Coprobacillaceae Thomasclavelia Thomasclavelia saccharogumia
31857159 31857159 PRJNA893346_P_NODE_35817_length_247_cov_0.885057_g35327_i0 PRJNA893346 35817 247 0.885057 2.18609079 Bacillus maqinnsis 3229854 Bacteria Bacteria 59.3 4.3e-8   NR WP_353855644.1 3229854 g35327 i0 44 0.910931174089069 75 37 89.9 2 11 232 1 71 WP_353855644.1 SDR family oxidoreductase [Bacillus maqinnsis] diamond 225 59.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus maqinnsis
32363734 32363734 PRJNA893346_P_NODE_32359_length_256_cov_1.666667_g31869_i0 PRJNA893346 32359 256 1.666667 4.26666752 Clostridia bacterium 2044939 Bacteria Bacteria 40 0.0417   NR MBZ4644956.1 2044939 g31869 i0 50 0.3984375 34 15 39.8 1 22 123 3 34 MBZ4644956.1 hypothetical protein [Clostridia bacterium] diamond 102 40 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32686986 32686986 PRJNA893346_P_NODE_13100_length_431_cov_1.583799_g12614_i0 PRJNA893346 13100 431 1.583799 6.82617369 Bacillati 1783272 Bacteria Bacteria 137 1.03e-35   NR HML36420.1 1879010 g12614 i0 48.6 8.71461716937355 140 69 96.1 2 18 431 2 140 HML36420.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Bacillota bacterium] diamond 3756 138 0.992753623188406 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);;