RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA299585" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA299585 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
375053 375053 PRJNA299585_S_NODE_15981_length_150_cov_3.636364_g15751_i0 PRJNA299585 15981 150 3.636364 5.454546 Bacteria 2 Bacteria Bacteria 101 1.49e-26   NR MET2744022.1 29380 g15751 i0 100 2 50 0 100 0 1 150 8 57 MET2744022.1 biotin--[acetyl-CoA-carboxylase] ligase [Staphylococcus caprae] diamond 300 101 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus caprae
4202244 4202244 PRJNA299585_S_NODE_13244_length_171_cov_2.436620_g13014_i0 PRJNA299585 13244 171 2.43662 4.1666202 Clostridium botulinum 1491 Bacteria Bacteria 107 5.7e-28   NR MBY7057768.1 1491 g13014 i0 100 1.96491228070175 56 0 98.2 0 3 170 81 136 MBY7057768.1 dipeptide ABC transporter permease DppC [Clostridium botulinum] diamond 336 107 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium botulinum
8028604 8028604 PRJNA299585_S_NODE_9267_length_225_cov_4.591837_g9037_i0 PRJNA299585 9267 225 4.591837 10.33163325 Staphylococcus borealis 2742203 Bacteria Bacteria 103 5.56e-27   NR WP_415427280.1 2742203 g9037 i0 100 1.36 51 0 68 0 72 224 1 51 WP_415427280.1 LysE family transporter, partial [Staphylococcus borealis] diamond 306 103 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus borealis
9303303 9303303 PRJNA299585_S_NODE_5248_length_353_cov_6.345679_g5018_i0 PRJNA299585 5248 353 6.345679 22.40024687 Streptococcus pneumoniae 1313 Bacteria Bacteria 133 2.68e-38   NR WP_205012627.1 1313 g5018 i0 100 0.611898016997167 72 0 61.2 0 272 57 1 72 WP_205012627.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 216 133 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
16952567 16952567 PRJNA299585_S_NODE_4034_length_426_cov_5.078086_g3804_i0 PRJNA299585 4034 426 5.078086 21.63264636 Bacteria 2 Bacteria Bacteria 249 6.73e-83   NR WP_415410978.1 985762 g3804 i0 100 3.74647887323944 133 0 93.7 0 26 424 1 133 WP_415410978.1 POTRA domain-containing protein, partial [Staphylococcus agnetis] diamond 1596 249 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus agnetis
20776750 20776750 PRJNA299585_S_NODE_5957_length_322_cov_4.709898_g5727_i0 PRJNA299585 5957 322 4.709898 15.16587156 Bacteria 2 Bacteria Bacteria 174 2.9499999999999995e-54   NR WP_415411044.1 985762 g5727 i0 98.8 1.58385093167702 85 1 79.2 0 256 2 1 85 WP_415411044.1 metallophosphoesterase, partial [Staphylococcus agnetis] diamond 510 174 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus agnetis
21463456 21463456 PRJNA299585_S_NODE_10837_length_199_cov_6.047059_g10607_i0 PRJNA299585 10837 199 6.047059 12.03364741 Staphylococcus borealis 2742203 Bacteria Bacteria 132 2.84e-38   NR WP_415430289.1 2742203 g10607 i0 100 0.979899497487437 65 0 98 0 197 3 7 71 WP_415430289.1 protein kinase domain-containing protein, partial [Staphylococcus borealis] diamond 195 132 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus borealis
27912856 27912856 PRJNA299585_S_NODE_12925_length_174_cov_2.572414_g12695_i0 PRJNA299585 12925 174 2.572414 4.47600036 Bacteria 2 Bacteria Bacteria 104 1.02e-27   NR WP_392418865.1 1307 g12695 i0 100 2.74137931034483 53 0 91.4 0 160 2 1 53 WP_392418865.1 hypothetical protein, partial [Streptococcus suis] diamond 477 104 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
27958630 27958630 PRJNA299585_S_NODE_13965_length_165_cov_2.007353_g13735_i0 PRJNA299585 13965 165 2.007353 3.31213245 Staphylococcus borealis 2742203 Bacteria Bacteria 115 4.95e-32   NR WP_415427226.1 2742203 g13735 i0 100 2 55 0 100 0 1 165 4 58 WP_415427226.1 hypothetical protein, partial [Staphylococcus borealis] diamond 330 115 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus borealis
28432278 28432278 PRJNA299585_S_NODE_6106_length_315_cov_5.339161_g5876_i0 PRJNA299585 6106 315 5.339161 16.81835715 Bacillus mycoides 1405 Bacteria Bacteria 142 1.0899999999999998e-41   NR OOR48540.1 1405 g5876 i0 100 2.66666666666667 70 0 66.7 0 211 2 1 70 OOR48540.1 hypothetical protein BGP34_31730, partial [Bacillus mycoides] diamond 840 142 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus mycoides
29176202 29176202 PRJNA299585_S_NODE_10509_length_204_cov_2.165714_g10279_i0 PRJNA299585 10509 204 2.165714 4.41805656 Bacteria 2 Bacteria Bacteria 129 8.36e-37   NR WP_187172042.1 1352 g10279 i0 100 3.94117647058824 67 0 98.5 0 2 202 45 111 WP_187172042.1 NAD-dependent epimerase/dehydratase family protein, partial [Enterococcus faecium] diamond 804 129 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
29554735 29554735 PRJNA299585_S_NODE_10650_length_202_cov_2.057803_g10420_i0 PRJNA299585 10650 202 2.057803 4.15676206 Bacteria 2 Bacteria Bacteria 133 1.98e-38   NR WP_213385948.1 1423 g10420 i0 100 1.99009900990099 67 0 99.5 0 1 201 55 121 WP_213385948.1 DUF4115 domain-containing protein, partial [Bacillus subtilis] diamond 402 133 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
29965526 29965526 PRJNA299585_S_NODE_12991_length_173_cov_5.423611_g12761_i0 PRJNA299585 12991 173 5.423611 9.38284703 Bacteria 2 Bacteria Bacteria 111 1.53e-30   NR WP_204323072.1 1313 g12761 i0 98.2 3.95375722543353 57 1 98.8 0 2 172 16 72 WP_204323072.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 684 111 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
30281802 30281802 PRJNA299585_S_NODE_10272_length_207_cov_4.022472_g10042_i0 PRJNA299585 10272 207 4.022472 8.32651704 Bacteria 2 Bacteria Bacteria 106 1.08e-28   NR RNF77525.1 1280 g10042 i0 100 4.34782608695652 50 0 72.5 0 206 57 4 53 RNF77525.1 EAL domain-containing protein, partial [Staphylococcus aureus] diamond 900 106 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31622796 31622796 PRJNA299585_S_NODE_9996_length_211_cov_5.258242_g9766_i0 PRJNA299585 9996 211 5.258242 11.09489062 Brevibacillus sp. MCWH 2508871 Bacteria Bacteria 148 2.65e-44   NR NNV04833.1 2508871 g9766 i0 100 0.995260663507109 70 0 99.5 0 211 2 23 92 NNV04833.1 NADP-dependent oxidoreductase [Brevibacillus sp. MCWH] diamond 210 148 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus sp. MCWH
31893460 31893460 PRJNA299585_S_NODE_14537_length_160_cov_3.778626_g14307_i0 PRJNA299585 14537 160 3.778626 6.0458016 Bacteria 2 Bacteria Bacteria 100 4.6e-26   NR WP_214975276.1 74706 g14307 i0 100 1.9875 53 0 99.4 0 2 160 43 95 WP_214975276.1 hypothetical protein, partial [Staphylococcus coagulans] diamond 318 100 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus coagulans
31893465 31893465 PRJNA299585_S_NODE_6837_length_289_cov_2.973077_g6607_i0 PRJNA299585 6837 289 2.973077 8.59219253 Bacteria 2 Bacteria Bacteria 116 1.36e-31   NR WP_415410974.1 985762 g6607 i0 100 1.32871972318339 64 0 66.4 0 3 194 27 90 WP_415410974.1 hypothetical protein, partial [Staphylococcus agnetis] diamond 384 116 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus agnetis
32083273 32083273 PRJNA299585_S_NODE_15498_length_153_cov_3.556452_g15268_i0 PRJNA299585 15498 153 3.556452 5.44137156 Bacteria 2 Bacteria Bacteria 103 2.3e-27   NR MEN3967531.1 1296 g15268 i0 100 3 51 0 100 0 153 1 30 80 MEN3967531.1 hypothetical protein [Mammaliicoccus sciuri] diamond 459 103 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Mammaliicoccus Mammaliicoccus sciuri
32273390 32273390 PRJNA299585_S_NODE_12798_length_175_cov_3.952055_g12568_i0 PRJNA299585 12798 175 3.952055 6.91609625 Bacteria 2 Bacteria Bacteria 82 7.9e-19   NR WP_204321394.1 1313 g12568 i0 100 1.33714285714286 39 0 66.9 0 7 123 40 78 WP_204321394.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 234 82 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32603483 32603483 PRJNA299585_S_NODE_13800_length_166_cov_4.072993_g13570_i0 PRJNA299585 13800 166 4.072993 6.76116838 Staphylococcus borealis 2742203 Bacteria Bacteria 102 2.23e-26   NR WP_415427165.1 2742203 g13570 i0 100 0.921686746987952 51 0 92.2 0 155 3 11 61 WP_415427165.1 hypothetical protein, partial [Staphylococcus borealis] diamond 153 102 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus borealis

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