RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 34 ✖

tax_kingdom 1

bioproject 1

  • PRJNA642647 · 34 ✖

analysis 1

  • diamond · 34 ✖

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
12097444 12097444 PRJNA642647_P_NODE_6370_length_152_cov_0.991304_g6320_i0 PRJNA642647 6370 152 0.991304 1.50678208 Bacillales 1385 Bacteria Bacteria 89.7 2.4e-19   NR WP_197201438.1 1399 g6320 i0 91.1 20.8223684210526 45 4 88.8 0 149 15 365 409 WP_197201438.1 DEAD/DEAH box helicase [Cytobacillus firmus] diamond 3165 90.5 0.991160220994475 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Cytobacillus Cytobacillus firmus
26701257 26701257 PRJNA642647_P_NODE_5461_length_163_cov_0.896825_g5411_i0 PRJNA642647 5461 163 0.896825 1.46182475 Lactococcus petauri 1940789 Bacteria Bacteria 65.9 1.37e-12   NR WP_263946547.1 1940789 g5411 i0 94.4 0.662576687116564 36 2 66.3 0 108 1 1 36 WP_263946547.1 hypothetical protein, partial [Lactococcus petauri] diamond 108 65.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Lactococcus Lactococcus petauri
27017968 27017968 PRJNA642647_P_NODE_6602_length_151_cov_0.973684_g6552_i0 PRJNA642647 6602 151 0.973684 1.47026284 Streptococcus pseudopneumoniae 257758 Bacteria Bacteria 62 6.19e-11   NR WP_196313157.1 257758 g6552 i0 75 0.794701986754967 40 10 79.5 0 29 148 3 42 WP_196313157.1 hypothetical protein, partial [Streptococcus pseudopneumoniae] diamond 120 62 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pseudopneumoniae
27997384 27997384 PRJNA642647_P_NODE_5645_length_160_cov_1.878049_g5595_i0 PRJNA642647 5645 160 1.878049 3.0048784 Streptococcus pneumoniae 1313 Bacteria Bacteria 104 7.91e-28   NR WP_411982903.1 1313 g5595 i0 96.2 0.975 52 2 97.5 0 158 3 26 77 WP_411982903.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 156 104 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28186438 28186438 PRJNA642647_P_NODE_6346_length_152_cov_1.304348_g6296_i0 PRJNA642647 6346 152 1.304348 1.98260896 Lacticaseibacillus paracasei 1597 Bacteria Bacteria 99 1.37e-25   NR MFK5281060.1 1597 g6296 i0 98 0.967105263157895 49 1 96.7 0 149 3 10 58 MFK5281060.1 hypothetical protein [Lacticaseibacillus paracasei] diamond 147 99 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
28356731 28356731 PRJNA642647_P_NODE_4686_length_168_cov_3.778626_g4636_i0 PRJNA642647 4686 168 3.778626 6.34809168 Bacteria 2 Bacteria Bacteria 42 0.014   NR MBQ4324642.1 2044939 g4636 i0 82.6 1.60714285714286 23 4 41.1 0 95 27 120 142 MBQ4324642.1 ribonuclease HI [Clostridia bacterium] diamond 270 42 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28881206 28881206 PRJNA642647_P_NODE_5028_length_166_cov_2.937984_g4978_i0 PRJNA642647 5028 166 2.937984 4.87705344 Salinicoccus halitifaciens 1073415 Bacteria Bacteria 55.8 2.53e-7   NR WP_230821462.1 1073415 g4978 i0 100 0.451807228915663 25 0 45.2 0 91 165 202 226 WP_230821462.1 GNAT family N-acetyltransferase [Salinicoccus halitifaciens] diamond 75 55.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Salinicoccus Salinicoccus halitifaciens
28944755 28944755 PRJNA642647_P_NODE_3268_length_195_cov_1.132911_g3218_i0 PRJNA642647 3268 195 1.132911 2.20917645 Streptococcus pneumoniae 1313 Bacteria Bacteria 95.5 3.669999999999999e-24   NR WP_223716956.1 1313 g3218 i0 74.6 0.907692307692308 59 15 90.8 0 2 178 10 68 WP_223716956.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 177 95.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
29197196 29197196 PRJNA642647_P_NODE_3909_length_181_cov_4.347222_g3859_i0 PRJNA642647 3909 181 4.347222 7.86847182 Ileibacterium valens 1862668 Bacteria Bacteria 45.4 0.00184   NR WP_075820664.1 1862668 g3859 i0 40.4 0.94475138121547 57 30 89.5 2 169 8 410 465 WP_075820664.1 GH25 family lysozyme [Ileibacterium valens] diamond 171 45.4 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Ileibacterium Ileibacterium valens
29355039 29355039 PRJNA642647_P_NODE_5729_length_159_cov_2.204918_g5679_i0 PRJNA642647 5729 159 2.204918 3.50581962 Clostridioides difficile 1496 Bacteria Bacteria 114 9.02e-31   NR WP_330584562.1 1496 g5679 i0 98 0.962264150943396 51 1 96.2 0 2 154 13 63 WP_330584562.1 SNF2-related protein, partial [Clostridioides difficile] diamond 153 114 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
29512637 29512637 PRJNA642647_P_NODE_3950_length_181_cov_1.062500_g3900_i0 PRJNA642647 3950 181 1.0625 1.923125 Faecalicatena contorta 39482 Bacteria Bacteria 113 3.11e-30   NR WP_205148937.1 39482 g3900 i0 96.6 0.961325966850829 58 2 96.1 0 3 176 69 126 WP_205148937.1 hypothetical protein, partial [Faecalicatena contorta] diamond 174 113 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Faecalicatena Faecalicatena contorta
29638740 29638740 PRJNA642647_P_NODE_2670_length_212_cov_2.245714_g2620_i0 PRJNA642647 2670 212 2.245714 4.76091368 Listeria monocytogenes 1639 Bacteria Bacteria 108 6.78e-29   NR WP_333724692.1 1639 g2620 i0 100 0.735849056603774 52 0 73.6 0 56 211 1 52 WP_333724692.1 hypothetical protein, partial [Listeria monocytogenes] diamond 156 108 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29701869 29701869 PRJNA642647_P_NODE_950_length_362_cov_2.320000_g900_i0 PRJNA642647 950 362 2.32 8.3984 Listeria monocytogenes 1639 Bacteria Bacteria 52.8 2.61e-6   NR WP_333733330.1 1639 g900 i0 41.3 0.522099447513812 63 37 52.2 0 62 250 1 63 WP_333733330.1 hypothetical protein, partial [Listeria monocytogenes] diamond 189 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29765235 29765235 PRJNA642647_P_NODE_231_length_721_cov_20.624269_g195_i0 PRJNA642647 231 721 20.624269 148.70097949 Staphylococcus aureus 1280 Bacteria Bacteria 48.9 0.00145   NR WP_178137632.1 1280 g195 i0 47.9 1.02773925104022 96 37 36.6 5 458 721 7 97 WP_178137632.1 hypothetical protein, partial [Staphylococcus aureus] diamond 741 48.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
29860068 29860068 PRJNA642647_P_NODE_4271_length_175_cov_1.666667_g4221_i0 PRJNA642647 4271 175 1.666667 2.91666725 Streptococcus pneumoniae 1313 Bacteria Bacteria 129 2.17e-37   NR WP_223688121.1 1313 g4221 i0 100 0.994285714285714 58 0 99.4 0 2 175 20 77 WP_223688121.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 174 129 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
30175933 30175933 PRJNA642647_P_NODE_1712_length_265_cov_2.416667_g1662_i0 PRJNA642647 1712 265 2.416667 6.40416755 Paenibacillus paeoniae 2292705 Bacteria Bacteria 42.7 0.0365   NR WP_116043422.1 2292705 g1662 i0 43.2 0.49811320754717 44 25 49.8 0 58 189 131 174 WP_116043422.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Paenibacillus paeoniae] diamond 132 42.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus paeoniae
30346834 30346834 PRJNA642647_P_NODE_5912_length_157_cov_1.058333_g5862_i0 PRJNA642647 5912 157 1.058333 1.66158281 root 1 Root_unresolved Root_unresolved 77.8 4.14e-15   NR MCG0276765.1 2885163 g5862 i0 70.6 3.05732484076433 51 14 95.5 1 5 154 105 155 MCG0276765.1 initiator NS1 family protein [Thermosediminibacteraceae bacterium] diamond 480 77.8 1 Bacteria   Bacillati Bacillota Clostridia Thermosediminibacterales Thermosediminibacteraceae   Thermosediminibacteraceae bacterium
30441244 30441244 PRJNA642647_P_NODE_2093_length_238_cov_2.527363_g2043_i0 PRJNA642647 2093 238 2.527363 6.01512394 Lactobacillales 186826 Bacteria Bacteria 98.6 3.41e-22   NR WP_303766030.1 46125 g2043 i0 61 1.92857142857143 77 30 97.1 0 2 232 311 387 WP_303766030.1 DEAD/DEAH box helicase [Abiotrophia defectiva] diamond 459 98.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Abiotrophia Abiotrophia defectiva
30630524 30630524 PRJNA642647_P_NODE_1973_length_247_cov_1.623810_g1923_i0 PRJNA642647 1973 247 1.62381 4.0108107 Megasphaera 906 Bacteria Bacteria 85.9 2.59e-17   NR WP_091647527.1 349095 g1923 i0 51.3 1.94331983805668 80 36 97.2 1 5 244 258 334 WP_091647527.1 virulence-associated E family protein [Megasphaera paucivorans] diamond 480 86.3 0.995365005793743 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Megasphaera Megasphaera paucivorans
30757062 30757062 PRJNA642647_P_NODE_6514_length_151_cov_2.912281_g6464_i0 PRJNA642647 6514 151 2.912281 4.39754431 Ruminococcus 1263 Bacteria Bacteria 43.1 0.00735   NR WP_147330081.1 40519 g6464 i0 29.6 3.89403973509934 98 18 93.4 1 143 3 59 156 WP_147330081.1 hypothetical protein [Ruminococcus callidus] diamond 588 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus callidus
31029378 31029378 PRJNA642647_P_NODE_2095_length_238_cov_2.378109_g2045_i0 PRJNA642647 2095 238 2.378109 5.65989942 Listeria monocytogenes 1639 Bacteria Bacteria 94.4 3.36e-23   NR WP_333724649.1 1639 g2045 i0 100 0.617647058823529 49 0 61.8 0 237 91 21 69 WP_333724649.1 SU10 major capsid protein, partial [Listeria monocytogenes] diamond 147 94.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
31092302 31092302 PRJNA642647_P_NODE_2595_length_214_cov_4.689266_g2545_i0 PRJNA642647 2595 214 4.689266 10.03502924 Sporolactobacillus terrae 269673 Bacteria Bacteria 75.1 6.13e-14   NR WP_152080095.1 269673 g2545 i0 49.3 0.967289719626168 69 35 96.7 0 209 3 226 294 WP_152080095.1 hypothetical protein [Sporolactobacillus terrae] diamond 207 75.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Sporolactobacillus Sporolactobacillus terrae
31313571 31313571 PRJNA642647_P_NODE_2515_length_218_cov_2.088398_g2465_i0 PRJNA642647 2515 218 2.088398 4.55270764 Streptococcus pneumoniae 1313 Bacteria Bacteria 119 1.56e-33   NR WP_230687861.1 1313 g2465 i0 96.6 0.798165137614679 58 2 79.8 0 176 3 1 58 WP_230687861.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 174 119 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31661341 31661341 PRJNA642647_P_NODE_1477_length_286_cov_3.381526_g1427_i0 PRJNA642647 1477 286 3.381526 9.67116436 Streptococcus pneumoniae 1313 Bacteria Bacteria 142 5.639999999999999e-42   NR WP_230685354.1 1313 g1427 i0 86.1 0.828671328671329 79 9 82.9 1 239 3 1 77 WP_230685354.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 237 142 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31882838 31882838 PRJNA642647_P_NODE_2697_length_211_cov_2.609195_g2647_i0 PRJNA642647 2697 211 2.609195 5.50540145 Listeria monocytogenes 1639 Bacteria Bacteria 137 2.61e-40   NR WP_333728245.1 1639 g2647 i0 100 0.995260663507109 70 0 99.5 0 1 210 12 81 WP_333728245.1 hypothetical protein, partial [Listeria monocytogenes] diamond 210 137 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32104394 32104394 PRJNA642647_P_NODE_2798_length_208_cov_1.321637_g2748_i0 PRJNA642647 2798 208 1.321637 2.74900496 Listeria monocytogenes 1639 Bacteria Bacteria 129 3.949999999999999e-37   NR WP_333733332.1 1639 g2748 i0 94 0.966346153846154 67 4 96.6 0 6 206 12 78 WP_333733332.1 hypothetical protein, partial [Listeria monocytogenes] diamond 201 129 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32116831 32116831 PRJNA642647_P_NODE_5638_length_160_cov_2.195122_g5588_i0 PRJNA642647 5638 160 2.195122 3.5121952 root 1 Root_unresolved Root_unresolved 39.3 0.0335   NR WP_237453410.1 1280 g5588 i0 67.9 1.25625 28 9 52.5 0 66 149 3 30 WP_237453410.1 hypothetical protein, partial [Staphylococcus aureus] diamond 201 39.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32199409 32199409 PRJNA642647_P_NODE_2318_length_226_cov_1.735450_g2268_i0 PRJNA642647 2318 226 1.73545 3.922117 Enterococcus gallinarum 1353 Bacteria Bacteria 55.5 8.42e-7   NR WP_123837247.1 1353 g2268 i0 54.5 0.584070796460177 44 20 58.4 0 95 226 1 44 WP_123837247.1 hypothetical protein [Enterococcus gallinarum] diamond 132 55.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus gallinarum
32357824 32357824 PRJNA642647_P_NODE_4879_length_166_cov_3.558140_g4829_i0 PRJNA642647 4879 166 3.55814 5.9065124 Bacillus cereus 1396 Bacteria Bacteria 57.4 3.21e-9   NR WP_368971011.1 1396 g4829 i0 100 0.451807228915663 25 0 45.2 0 91 165 17 41 WP_368971011.1 hypothetical protein, partial [Bacillus cereus] diamond 75 57.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
32389179 32389179 PRJNA642647_P_NODE_5579_length_161_cov_1.758065_g5529_i0 PRJNA642647 5579 161 1.758065 2.83048465 Enterococcus faecalis 1351 Bacteria Bacteria 65.1 1.52e-10   NR HGS8738438.1 1351 g5529 i0 67.3 0.968944099378882 52 17 96.9 0 156 1 5 56 HGS8738438.1 MobA/MobL family protein [Enterococcus faecalis] diamond 156 65.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
32516016 32516016 PRJNA642647_P_NODE_5439_length_163_cov_1.722222_g5389_i0 PRJNA642647 5439 163 1.722222 2.80722186 Listeria monocytogenes 1639 Bacteria Bacteria 100 3.23e-26   NR WP_333725025.1 1639 g5389 i0 98 0.901840490797546 49 1 90.2 0 14 160 1 49 WP_333725025.1 hypothetical protein, partial [Listeria monocytogenes] diamond 147 100 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32579172 32579172 PRJNA642647_P_NODE_3119_length_199_cov_1.734568_g3069_i0 PRJNA642647 3119 199 1.734568 3.45179032 Streptococcus pneumoniae 1313 Bacteria Bacteria 115 9.199999999999999e-32   NR WP_155458505.1 1313 g3069 i0 98.2 0.844221105527638 56 1 84.4 0 195 28 26 81 WP_155458505.1 DUF2800 domain-containing protein, partial [Streptococcus pneumoniae] diamond 168 115 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32610465 32610465 PRJNA642647_P_NODE_5280_length_165_cov_2.960938_g5230_i0 PRJNA642647 5280 165 2.960938 4.8855477 Desulfosporosinus sp. 157907 Bacteria Bacteria 41.6 0.00689   NR MDR3540328.1 157907 g5230 i0 56 0.909090909090909 50 18 90.9 2 165 16 6 51 MDR3540328.1 hypothetical protein [Desulfosporosinus sp.] diamond 150 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Desulfosporosinus sp.
32893700 32893700 PRJNA642647_P_NODE_5820_length_158_cov_1.702479_g5770_i0 PRJNA642647 5820 158 1.702479 2.68991682 Loigolactobacillus coryniformis 1610 Bacteria Bacteria 96.7 1.2999999999999998e-24   NR WP_249567929.1 1610 g5770 i0 98.1 0.987341772151899 52 1 98.7 0 2 157 19 70 WP_249567929.1 hypothetical protein, partial [Loigolactobacillus coryniformis] diamond 156 96.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Loigolactobacillus Loigolactobacillus coryniformis

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