RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJEB55250" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJEB55250 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
2671963 2671963 PRJEB55250_P_NODE_7143_length_283_cov_1.414286_g7019_i0 PRJEB55250 7143 283 1.414286 4.00242938 Eubacteriales bacterium 2831996 Bacteria Bacteria 107 1.04e-24   NR MDY5042262.1 2831996 g7019 i0 58.1 1.99293286219081 93 38 98.6 1 2 280 161 252 MDY5042262.1 DNA methyltransferase [Eubacteriales bacterium] diamond 564 107 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
2672004 2672004 PRJEB55250_P_NODE_883_length_704_cov_1.093502_g769_i0 PRJEB55250 883 704 1.093502 7.69825408 Listeria monocytogenes 1639 Bacteria Bacteria 181 6.349999999999998e-55   NR HCA4016369.1 1639 g769 i0 96.7 0.383522727272727 90 3 38.4 0 64 333 1 90 HCA4016369.1 DUF1364 family protein [Listeria monocytogenes] diamond 270 181 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
26653434 26653434 PRJEB55250_P_NODE_6721_length_286_cov_1.680751_g6597_i0 PRJEB55250 6721 286 1.680751 4.80694786 Streptococcus sp. 1306 Bacteria Bacteria 44.7 0.0123   NR MCC8991193.1 1306 g6597 i0 38.4 1.03846153846154 99 56 98.6 3 3 284 323 421 MCC8991193.1 hypothetical protein [Streptococcus sp.] diamond 297 44.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp.
26685246 26685246 PRJEB55250_P_NODE_15341_length_243_cov_1.788235_g15217_i0 PRJEB55250 15341 243 1.788235 4.34541105 Tissierellia bacterium KA 2049431 Bacteria Bacteria 149 7.059999999999998e-42   NR KXB48002.1 1588751 g15217 i0 97.5 0.987654320987654 80 2 98.8 0 242 3 103 182 KXB48002.1 transcription repressor HrcA [Tissierellia bacterium KA00581] diamond 240 149 1 Bacteria   Bacillati Bacillota Tissierellia       Tissierellia bacterium KA00581
26875651 26875651 PRJEB55250_P_NODE_15921_length_242_cov_0.911243_g15797_i0 PRJEB55250 15921 242 0.911243 2.20520806 Clostridium paraputrificum 29363 Bacteria Bacteria 62.8 3.24e-9   NR WP_394896490.1 29363 g15797 i0 48.6 1.73553719008264 70 33 86.8 2 217 8 1004 1070 WP_394896490.1 hypothetical protein, partial [Clostridium paraputrificum] diamond 420 62.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium paraputrificum
26875660 26875660 PRJEB55250_P_NODE_7421_length_281_cov_1.235577_g7297_i0 PRJEB55250 7421 281 1.235577 3.47197137 Priestia aryabhattai 412384 Bacteria Bacteria 56.6 7.51e-7   NR WP_328264160.1 412384 g7297 i0 41.7 0.896797153024911 84 42 84.3 2 271 35 317 398 WP_328264160.1 distal tail protein Dit [Priestia aryabhattai] diamond 252 56.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia aryabhattai
26907046 26907046 PRJEB55250_P_NODE_12662_length_249_cov_0.875000_g12538_i0 PRJEB55250 12662 249 0.875 2.17875 Bacillus licheniformis 1402 Bacteria Bacteria 90.9 4.27e-19   NR WP_145616212.1 1402 g12538 i0 75.9 1.30120481927711 54 13 65.1 0 162 1 1 54 WP_145616212.1 phage portal protein [Bacillus licheniformis] diamond 324 90.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus licheniformis
27507739 27507739 PRJEB55250_P_NODE_14343_length_245_cov_1.732558_g14219_i0 PRJEB55250 14343 245 1.732558 4.2447671 Robertmurraya 2837507 Bacteria Bacteria 145 1.49e-38   NR WP_340905793.1 2837507 g14219 i0 96.3 0.991836734693878 81 3 99.2 0 243 1 70 150 WP_340905793.1 MULTISPECIES: polysaccharide biosynthesis protein [Robertmurraya] diamond 243 145 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Robertmurraya  
28006212 28006212 PRJEB55250_P_NODE_14805_length_244_cov_1.801170_g14681_i0 PRJEB55250 14805 244 1.80117 4.3948548 root 1 Root_unresolved Root_unresolved 124 3.12e-34   NR MEG2306956.1 2049044 g14681 i0 71.3 1.9672131147541 80 23 98.4 0 2 241 69 148 MEG2306956.1 NADAR family protein [Erysipelotrichaceae bacterium] diamond 480 124 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
28201982 28201982 PRJEB55250_P_NODE_7926_length_277_cov_1.411765_g7802_i0 PRJEB55250 7926 277 1.411765 3.91058905 Listeria monocytogenes 1639 Bacteria Bacteria 150 3.61e-45   NR HCA4016359.1 1639 g7802 i0 98.6 0.8014440433213 74 1 80.1 0 224 3 1 74 HCA4016359.1 hypothetical protein [Listeria monocytogenes] diamond 222 150 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
28960213 28960213 PRJEB55250_P_NODE_14188_length_246_cov_0.890173_g14064_i0 PRJEB55250 14188 246 0.890173 2.18982558 Clostridium estertheticum 238834 Bacteria Bacteria 92 3.9e-20   NR WP_216194074.1 238834 g14064 i0 50.6 0.963414634146341 79 35 91.5 1 232 8 31 109 WP_216194074.1 hypothetical protein [Clostridium estertheticum] diamond 237 92 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium estertheticum
28991853 28991853 PRJEB55250_P_NODE_14848_length_244_cov_1.660819_g14724_i0 PRJEB55250 14848 244 1.660819 4.05239836 Peribacillus alkalitolerans 1550385 Bacteria Bacteria 149 1.22e-39   NR WP_163101678.1 1550385 g14724 i0 95 0.983606557377049 80 4 98.4 0 3 242 119 198 WP_163101678.1 YhgE/Pip domain-containing protein [Peribacillus alkalitolerans] diamond 240 149 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Peribacillus Peribacillus alkalitolerans
29023484 29023484 PRJEB55250_P_NODE_6488_length_288_cov_1.432558_g6364_i0 PRJEB55250 6488 288 1.432558 4.12576704 Bacilli bacterium 1903720 Bacteria Bacteria 89.7 1.99e-18   NR MEG0407372.1 1903720 g6364 i0 70.2 1.22916666666667 57 17 59.4 0 171 1 3 59 MEG0407372.1 DNA polymerase [Bacilli bacterium] diamond 354 89.7 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
29149817 29149817 PRJEB55250_P_NODE_12849_length_248_cov_1.760000_g12725_i0 PRJEB55250 12849 248 1.76 4.3648 Peribacillus frigoritolerans 450367 Bacteria Bacteria 120 6.76e-33   NR MCK2000460.1 450367 g12725 i0 61 0.991935483870968 82 32 99.2 0 246 1 35 116 MCK2000460.1 hypothetical protein [Peribacillus frigoritolerans] diamond 246 120 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Peribacillus Peribacillus frigoritolerans
29212737 29212737 PRJEB55250_P_NODE_12489_length_249_cov_0.875000_g12365_i0 PRJEB55250 12489 249 0.875 2.17875 Clostridia bacterium 2044939 Bacteria Bacteria 42.7 0.0386   NR MBP3437167.1 2044939 g12365 i0 30.9 0.819277108433735 68 46 80.7 1 215 15 149 216 MBP3437167.1 diaminopimelate decarboxylase [Clostridia bacterium] diamond 204 42.7 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29275548 29275548 PRJEB55250_P_NODE_15249_length_243_cov_3.076471_g15125_i0 PRJEB55250 15249 243 3.076471 7.47582453 Staphylococcus chromogenes 46126 Bacteria Bacteria 45.4 0.00276   NR WP_311541869.1 46126 g15125 i0 40.5 1.03703703703704 84 46 98.8 3 243 4 7 90 WP_311541869.1 SANT/Myb-like DNA-binding domain-containing protein [Staphylococcus chromogenes] diamond 252 45.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus chromogenes
29433266 29433266 PRJEB55250_P_NODE_4750_length_322_cov_1.008032_g4626_i0 PRJEB55250 4750 322 1.008032 3.24586304 Listeria monocytogenes 1639 Bacteria Bacteria 115 2e-30   NR HCA4016380.1 1639 g4626 i0 57.9 0.996894409937888 107 45 99.7 0 322 2 4 110 HCA4016380.1 hypothetical protein [Listeria monocytogenes] diamond 321 115 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29615943 29615943 PRJEB55250_P_NODE_1330_length_561_cov_3.799180_g1209_i0 PRJEB55250 1330 561 3.79918 21.3133998 Bacilli 91061 Bacteria Bacteria 45.4 0.0097   NR WP_289900952.1 1352 g1209 i0 62.5 0.342245989304813 32 12 17.1 0 514 419 71 102 WP_289900952.1 hypothetical protein [Enterococcus faecium] diamond 192 45.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
29685825 29685825 PRJEB55250_P_NODE_10890_length_255_cov_1.082418_g10766_i0 PRJEB55250 10890 255 1.082418 2.7601659 Enterococcus faecalis 1351 Bacteria Bacteria 57 1.42e-8   NR WP_411400860.1 1351 g10766 i0 53.8 0.611764705882353 52 23 61.2 1 20 175 20 70 WP_411400860.1 hypothetical protein, partial [Enterococcus faecalis] diamond 156 57 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
29780853 29780853 PRJEB55250_P_NODE_7111_length_283_cov_1.466667_g6987_i0 PRJEB55250 7111 283 1.466667 4.15066761 Bacilli bacterium 1903720 Bacteria Bacteria 63.2 1.1e-10   NR MEG0407308.1 1903720 g6987 i0 45.1 1.47349823321555 71 38 74.2 1 72 281 9 79 MEG0407308.1 SH3 beta-barrel fold-containing protein [Bacilli bacterium] diamond 417 63.2 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
29875703 29875703 PRJEB55250_P_NODE_3631_length_355_cov_2.184397_g3507_i0 PRJEB55250 3631 355 2.184397 7.75460935 Bacillus velezensis 492670 Bacteria Bacteria 117 8.309999999999999e-31   NR WP_196616486.1 492670 g3507 i0 71.4 0.650704225352113 77 22 65.1 0 353 123 80 156 WP_196616486.1 nucleoside 2-deoxyribosyltransferase [Bacillus velezensis] diamond 231 117 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus velezensis
29907347 29907347 PRJEB55250_P_NODE_2151_length_444_cov_1.245283_g2028_i0 PRJEB55250 2151 444 1.245283 5.52905652 Listeria monocytogenes 1639 Bacteria Bacteria 240 1.99e-73   NR HCA4015451.1 1639 g2028 i0 92.2 0.864864864864865 128 10 86.5 0 59 442 14 141 HCA4015451.1 hypothetical protein [Listeria monocytogenes] diamond 384 240 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29907351 29907351 PRJEB55250_P_NODE_4431_length_330_cov_1.112840_g4307_i0 PRJEB55250 4431 330 1.11284 3.672372 Listeria monocytogenes 1639 Bacteria Bacteria 202 5.35e-59   NR HCA4015448.1 1639 g4307 i0 100 0.990909090909091 109 0 99.1 0 3 329 4 112 HCA4015448.1 tape measure protein [Listeria monocytogenes] diamond 327 202 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
30350092 30350092 PRJEB55250_P_NODE_8712_length_271_cov_1.333333_g8588_i0 PRJEB55250 8712 271 1.333333 3.61333243 Listeria monocytogenes 1639 Bacteria Bacteria 175 8.03e-52   NR HCA4016208.1 1639 g8588 i0 96.7 0.996309963099631 90 3 99.6 0 271 2 244 333 HCA4016208.1 DUF3383 family protein [Listeria monocytogenes] diamond 270 175 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
31170768 31170768 PRJEB55250_P_NODE_10195_length_260_cov_1.395722_g10071_i0 PRJEB55250 10195 260 1.395722 3.6288772 Bacillus toyonensis 155322 Bacteria Bacteria 48.5 6.98e-5   NR WP_098087806.1 155322 g10071 i0 54.3 0.530769230769231 46 21 53.1 0 248 111 60 105 WP_098087806.1 TM2 domain-containing protein [Bacillus toyonensis] diamond 138 48.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus toyonensis
31297461 31297461 PRJEB55250_P_NODE_4695_length_323_cov_1.232000_g4571_i0 PRJEB55250 4695 323 1.232 3.97936 Paenibacillus hemerocallicola 1172614 Bacteria Bacteria 69.3 4.39e-11   NR WP_139607502.1 1172614 g4571 i0 38.3 0.993808049535604 107 60 99.4 2 2 322 150 250 WP_139607502.1 glycosyl hydrolase family 28-related protein [Paenibacillus hemerocallicola] diamond 321 69.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus hemerocallicola
31740156 31740156 PRJEB55250_P_NODE_14097_length_246_cov_0.890173_g13973_i0 PRJEB55250 14097 246 0.890173 2.18982558 Enterococcus faecalis 1351 Bacteria Bacteria 67 1.44e-12   NR WP_411400860.1 1351 g13973 i0 65.3 0.597560975609756 49 17 59.8 0 244 98 22 70 WP_411400860.1 hypothetical protein, partial [Enterococcus faecalis] diamond 147 67 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
32088310 32088310 PRJEB55250_P_NODE_9478_length_265_cov_1.541667_g9354_i0 PRJEB55250 9478 265 1.541667 4.08541755 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 121 7.78e-34   NR WP_340470256.1 1590 g9354 i0 65.9 0.99622641509434 88 28 97.4 1 259 2 1 88 WP_340470256.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 264 121 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
32214972 32214972 PRJEB55250_P_NODE_12198_length_250_cov_0.870056_g12074_i0 PRJEB55250 12198 250 0.870056 2.17514 Bacillota bacterium 1879010 Bacteria Bacteria 68.9 2.33e-11   NR HHV08423.1 1879010 g12074 i0 48.1 0.972 81 40 97.2 1 5 247 11 89 HHV08423.1 signal recognition particle protein [Bacillota bacterium] diamond 243 68.9 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32563190 32563190 PRJEB55250_P_NODE_16539_length_241_cov_0.916667_g16415_i0 PRJEB55250 16539 241 0.916667 2.20916747 Listeria monocytogenes 1639 Bacteria Bacteria 145 5.659999999999999e-43   NR HCA4015798.1 1639 g16415 i0 93.7 0.983402489626556 79 5 98.3 0 239 3 38 116 HCA4015798.1 hypothetical protein [Listeria monocytogenes] diamond 237 145 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes

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