RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA588137" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA588137 · 17 ✖

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
3689935 3689935 PRJNA588137_S_NODE_5703_length_261_cov_1.175532_g5670_i0 PRJNA588137 5703 261 1.175532 3.06813852 Staphylococcus 1279 Bacteria Bacteria 472 1.54e-128   NTclustered gi|2669659999|gb|CP090011.1| 1290 g5670 i0 99.234 485.210727969349 261 2 100 0 1 261 762175 762435 Staphylococcus hominis strain acrlg chromosome, complete genome blastn 126640 472 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus hominis
6242154 6242154 PRJNA588137_S_NODE_8445_length_247_cov_0.862069_g8412_i0 PRJNA588137 8445 247 0.862069 2.12931043 root 1 Root_unresolved Root_unresolved 52.8 0.022   NTclustered gi|2717163682|gb|CP133007.1| 201828 g8412 i0 100 0.251012145748988 28 0 11 0 174 201 5259 5286 Staphylococcus casei strain SCK7 plasmid unnamed1, complete sequence blastn 62 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus casei
9493229 9493229 PRJNA588137_S_NODE_9368_length_245_cov_0.860465_g9335_i0 PRJNA588137 9368 245 0.860465 2.10813925 Gemella morbillorum 29391 Bacteria Bacteria 387 5.34e-103   NTclustered gi|1403530627|emb|LS483440.1| 29391 g9335 i0 95.102 3 245 12 100 0 1 245 419599 419843 Gemella morbillorum strain NCTC11323 genome assembly, chromosome: 1 blastn 735 387 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella morbillorum
10769075 10769075 PRJNA588137_S_NODE_8069_length_247_cov_1.017241_g8036_i0 PRJNA588137 8069 247 1.017241 2.51258527 Anaerococcus sp. WGS1529 3366812 Bacteria Bacteria 429 8.83e-116   NTclustered gi|2831325273|gb|CP171112.1| 3366812 g8036 i0 97.976 61.7125506072874 247 5 100 0 1 247 665245 665491 Anaerococcus sp. WGS1529 chromosome, complete genome blastn 15243 429 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus sp. WGS1529
11341802 11341802 PRJNA588137_S_NODE_3389_length_309_cov_1.338983_g3356_i0 PRJNA588137 3389 309 1.338983 4.13745747 Bacillus 1386 Bacteria Bacteria 566 8.33e-157   NTclustered gi|2575657259|gb|CP133703.1| 1423 g3356 i0 99.676 952.938511326861 309 1 100 0 1 309 1063619 1063311 Bacillus subtilis strain CP35 chromosome, complete genome blastn 294458 566 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
11341867 11341867 PRJNA588137_S_NODE_9709_length_244_cov_0.900585_g9676_i0 PRJNA588137 9709 244 0.900585 2.1974274 Staphylococcus 1279 Bacteria Bacteria 451 1.86e-122   NTclustered gi|1821208350|gb|CP043783.1| 1282 g9676 i0 100 62.2008196721311 244 0 100 0 1 244 2874 2631 Staphylococcus epidermidis strain SESURV_p1_0563 plasmid unnamed2 blastn 15177 451 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
14593594 14593594 PRJNA588137_S_NODE_6372_length_251_cov_0.865169_g6339_i0 PRJNA588137 6372 251 0.865169 2.17157419 Streptococcus gordonii 1302 Bacteria Bacteria 448 2.48e-121   NTclustered gi|1403375826|emb|LS483375.1| 1302 g6339 i0 98.805 14.6932270916335 251 3 100 0 1 251 470235 469985 Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1 blastn 3688 448 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus gordonii
16441166 16441166 PRJNA588137_S_NODE_2593_length_335_cov_2.091603_g2560_i0 PRJNA588137 2593 335 2.091603 7.00687005 Anoxybacillus 150247 Bacteria Bacteria 619 6.91e-173   NTclustered gi|1207877705|gb|CP021838.1| 33934 g2560 i0 100 840.217910447761 335 0 100 0 1 335 1490659 1490325 Anoxybacillus flavithermus strain 52-1A chromosome, complete genome blastn 281473 619 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacillus Anoxybacillus flavithermus
18416572 18416572 PRJNA588137_S_NODE_10655_length_242_cov_0.911243_g10622_i0 PRJNA588137 10655 242 0.911243 2.20520806 Veillonella atypica 39777 Bacteria Bacteria 385 1.89e-102   NTclustered gi|2592626561|gb|CP103397.1| 39777 g10622 i0 95.436 41.7231404958678 241 11 99 0 2 242 1560473 1560233 Veillonella atypica strain G765s_culture10 chromosome, complete genome blastn 10097 385 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella atypica
18416645 18416645 PRJNA588137_S_NODE_7755_length_248_cov_0.880000_g7722_i0 PRJNA588137 7755 248 0.88 2.1824 Streptococcus gordonii 1302 Bacteria Bacteria 453 5.2600000000000005e-123   NTclustered gi|1403375826|emb|LS483375.1| 1302 g7722 i0 99.597 18.366935483871 248 1 100 0 1 248 390344 390591 Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1 blastn 4555 453 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus gordonii
28564061 28564061 PRJNA588137_S_NODE_5287_length_268_cov_1.446154_g5254_i0 PRJNA588137 5287 268 1.446154 3.87569272 Listeria monocytogenes 1639 Bacteria Bacteria 127 2.31e-32   NR HCA4015454.1 1639 g5254 i0 97 0.738805970149254 66 2 73.9 0 59 256 1 66 HCA4015454.1 hypothetical protein [Listeria monocytogenes] diamond 198 127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
28829930 28829930 PRJNA588137_S_NODE_7348_length_249_cov_0.875000_g7315_i0 PRJNA588137 7348 249 0.875 2.17875 root 1 Root_unresolved Root_unresolved 86.7 5.2e-19   NR WP_069142025.1 1313 g7315 i0 47.6 11.8313253012048 82 43 98.8 0 247 2 30 111 WP_069142025.1 LexA family protein, partial [Streptococcus pneumoniae] diamond 2946 86.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28847981 28847981 PRJNA588137_S_NODE_7948_length_248_cov_0.880000_g7915_i0 PRJNA588137 7948 248 0.88 2.1824 Bacilli bacterium 1903720 Bacteria Bacteria 120 2.18e-32   NR MEG0407245.1 1903720 g7915 i0 74.4 1.98387096774194 82 21 99.2 0 248 3 10 91 MEG0407245.1 phage protein [Bacilli bacterium] diamond 492 120 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
29132477 29132477 PRJNA588137_S_NODE_6349_length_251_cov_1.157303_g6316_i0 PRJNA588137 6349 251 1.157303 2.90483053 Carnobacteriaceae bacterium 52-44 3142729 Bacteria Bacteria 48.9 6.53e-5   NR MEY8292856.1 3142729 g6316 i0 75.9 0.346613545816733 29 7 34.7 0 91 5 1 29 MEY8292856.1 Rid family detoxifying hydrolase [Carnobacteriaceae bacterium 52-44] diamond 87 48.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae   Carnobacteriaceae bacterium 52-44
29542694 29542694 PRJNA588137_S_NODE_3930_length_296_cov_1.035874_g3897_i0 PRJNA588137 3930 296 1.035874 3.06618704 Listeria monocytogenes 1639 Bacteria Bacteria 109 1.12e-25   NR HCA4015454.1 1639 g3897 i0 98.1 0.537162162162162 53 1 53.7 0 2 160 432 484 HCA4015454.1 hypothetical protein [Listeria monocytogenes] diamond 159 109 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
30237672 30237672 PRJNA588137_S_NODE_9972_length_243_cov_0.905882_g9939_i0 PRJNA588137 9972 243 0.905882 2.20129326 Thermicanus aegyptius 94009 Bacteria Bacteria 114 1.55e-29   NR WP_028987004.1 94009 g9939 i0 98.4 1.53086419753086 62 1 76.5 0 243 58 143 204 WP_028987004.1 SpoIIIAH-like family protein [Thermicanus aegyptius] diamond 372 114 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
30283125 30283125 PRJNA588137_S_NODE_5692_length_261_cov_1.228723_g5659_i0 PRJNA588137 5692 261 1.228723 3.20696703 Bacillaceae 186817 Bacteria Bacteria 102 4.66e-26   NR WP_229725710.1 373054 g5659 i0 57.6 3.91954022988506 85 36 97.7 0 259 5 30 114 WP_229725710.1 group I truncated hemoglobin [Calditerricola satsumensis] diamond 1023 103 0.990291262135922 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Calditerricola Calditerricola satsumensis

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