RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA789095" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA789095 · 32 ✖

analysis 1

  • diamond · 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
16073453 16073453 PRJNA789095_P_NODE_51113_length_283_cov_1.638095_g49779_i0 PRJNA789095 51113 283 1.638095 4.63580885 Paucilactobacillus vaccinostercus 176291 Bacteria Bacteria 167 1.15e-48   NR WP_057777441.1 176291 g49779 i0 97.8 0.985865724381625 93 2 98.6 0 282 4 210 302 WP_057777441.1 ribose-phosphate diphosphokinase [Paucilactobacillus vaccinostercus] diamond 279 167 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Paucilactobacillus Paucilactobacillus vaccinostercus
26673540 26673540 PRJNA789095_P_NODE_64601_length_253_cov_2.538889_g63267_i0 PRJNA789095 64601 253 2.538889 6.42338917 Anaerococcus tetradius 33036 Bacteria Bacteria 137 2.2e-35   NR WP_276881443.1 33036 g63267 i0 89.2 1.96837944664032 83 9 98.4 0 3 251 2064 2146 WP_276881443.1 YPDG domain-containing protein [Anaerococcus tetradius] diamond 498 137 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus tetradius
26705294 26705294 PRJNA789095_P_NODE_46561_length_294_cov_5.221719_g45227_i0 PRJNA789095 46561 294 5.221719 15.35185386 Paenibacillus vini 1476024 Bacteria Bacteria 63.9 6.28e-11   NR WP_213656671.1 1476024 g45227 i0 67.4 0.438775510204082 43 14 43.9 0 136 8 6 48 WP_213656671.1 hypothetical protein [Paenibacillus vini] diamond 129 63.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus vini
27591026 27591026 PRJNA789095_P_NODE_49544_length_287_cov_1.079439_g48210_i0 PRJNA789095 49544 287 1.079439 3.09798993 Paenibacillus sp. FSL R7- 58172 Bacteria Bacteria 43.1 0.0431   NR WP_340965322.1 2921674 g48210 i0 31.6 0.59581881533101 57 33 53.3 2 115 267 8 64 WP_340965322.1 hypothetical protein [Paenibacillus sp. FSL R7-0198] diamond 171 43.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. FSL R7-0198
27726773 27726773 PRJNA789095_P_NODE_62724_length_257_cov_2.608696_g61390_i0 PRJNA789095 62724 257 2.608696 6.70434872 Bacteria 2 Bacteria Bacteria 176 9.399999999999999e-55   NR WP_243137692.1 29376 g61390 i0 100 1.98443579766537 85 0 99.2 0 3 257 3 87 WP_243137692.1 LysR substrate-binding domain-containing protein, partial [Desulfofundulus thermobenzoicus] diamond 510 176 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae Desulfofundulus Desulfofundulus thermobenzoicus
28064400 28064400 PRJNA789095_P_NODE_59425_length_265_cov_1.104167_g58091_i0 PRJNA789095 59425 265 1.104167 2.92604255 Halalkalibacter nanhaiisediminis 688079 Bacteria Bacteria 115 4.36e-30   NR WP_144448733.1 688079 g58091 i0 75.9 0.984905660377358 87 21 98.5 0 3 263 24 110 WP_144448733.1 hypothetical protein [Halalkalibacter nanhaiisediminis] diamond 261 115 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Halalkalibacter Halalkalibacter nanhaiisediminis
28452706 28452706 PRJNA789095_P_NODE_79486_length_226_cov_4.941176_g78152_i0 PRJNA789095 79486 226 4.941176 11.16705776 Aedoeadaptatus 2981628 Bacteria Bacteria 141 1.62e-38   NR WP_077074278.1 1871017 g78152 i0 96 2.98672566371681 75 3 99.6 0 1 225 203 277 WP_077074278.1 ABC transporter permease subunit [Aedoeadaptatus urinae] diamond 675 141 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Aedoeadaptatus Aedoeadaptatus urinae
29169679 29169679 PRJNA789095_P_NODE_47009_length_293_cov_2.622727_g45675_i0 PRJNA789095 47009 293 2.622727 7.68459011 Clostridioides difficile 1496 Bacteria Bacteria 67.8 1.08e-10   NR WP_256633438.1 1496 g45675 i0 73 1.67918088737201 37 10 37.9 0 274 164 470 506 WP_256633438.1 reverse transcriptase family protein [Clostridioides difficile] diamond 492 67.8 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
29232823 29232823 PRJNA789095_P_NODE_49949_length_286_cov_1.117371_g48615_i0 PRJNA789095 49949 286 1.117371 3.19568106 Dysosmobacter segnis 2763042 Bacteria Bacteria 46.2 0.00199   NR WP_187016454.1 2763042 g48615 i0 100 0.241258741258741 23 0 24.1 0 216 284 1 23 WP_187016454.1 hypothetical protein [Dysosmobacter segnis] diamond 69 46.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Dysosmobacter Dysosmobacter segnis
29264059 29264059 PRJNA789095_P_NODE_66289_length_251_cov_0.865169_g64955_i0 PRJNA789095 66289 251 0.865169 2.17157419 Lacrimispora sp. 2719234 Bacteria Bacteria 41.2 0.0463   NR WP_312426598.1 2719234 g64955 i0 42.2 0.537848605577689 45 26 53.8 0 54 188 24 68 WP_312426598.1 hypothetical protein [Lacrimispora sp.] diamond 135 41.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lacrimispora Lacrimispora sp.
29368239 29368239 PRJNA789095_P_NODE_51749_length_281_cov_4.591346_g50415_i0 PRJNA789095 51749 281 4.591346 12.90168226 FCB group 1783270 Bacteria Bacteria 50.8 8.47e-5   NR WP_256633438.1 1496 g50415 i0 46.3 1.644128113879 54 28 56.6 1 1 159 874 927 WP_256633438.1 reverse transcriptase family protein [Clostridioides difficile] diamond 462 51.2 0.9921875 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
29611268 29611268 PRJNA789095_P_NODE_81370_length_207_cov_4.962687_g80036_i0 PRJNA789095 81370 207 4.962687 10.27276209 Ezakiella sp. 1935205 Bacteria Bacteria 98.2 2.19e-22   NR MFR7835520.1 1935205 g80036 i0 86.8 0.985507246376812 68 9 98.6 0 205 2 172 239 MFR7835520.1 hypothetical protein [Ezakiella sp.] diamond 204 98.2 1 Bacteria   Bacillati Bacillota Tissierellia     Ezakiella Ezakiella sp.
29705845 29705845 PRJNA789095_P_NODE_67030_length_250_cov_0.870056_g65696_i0 PRJNA789095 67030 250 0.870056 2.17514 Dysosmobacter segnis 2763042 Bacteria Bacteria 96.3 3.21e-22   NR WP_187016406.1 2763042 g65696 i0 100 0.564 47 0 56.4 0 1 141 197 243 WP_187016406.1 hypothetical protein [Dysosmobacter segnis] diamond 141 96.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Dysosmobacter Dysosmobacter segnis
30179992 30179992 PRJNA789095_P_NODE_77112_length_236_cov_2.552147_g75778_i0 PRJNA789095 77112 236 2.552147 6.02306692 Peptoniphilus 162289 Bacteria Bacteria 154 5.239999999999999e-42   NR WP_023060064.1 162289 g75778 i0 96.1 0.966101694915254 76 3 96.6 0 3 230 141 216 WP_023060064.1 MULTISPECIES: excinuclease ABC subunit UvrC [Peptoniphilus] diamond 228 154 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus  
30243406 30243406 PRJNA789095_P_NODE_19392_length_559_cov_5.893004_g18068_i0 PRJNA789095 19392 559 5.893004 32.94189236 Clostridioides difficile 1496 Bacteria Bacteria 55.8 2.28e-5   NR WP_256633438.1 1496 g18068 i0 50 1.3309481216458 52 25 27.4 1 552 400 874 925 WP_256633438.1 reverse transcriptase family protein [Clostridioides difficile] diamond 744 55.8 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
30275169 30275169 PRJNA789095_P_NODE_72672_length_244_cov_0.900585_g71338_i0 PRJNA789095 72672 244 0.900585 2.1974274 Clostridia bacterium 2044939 Bacteria Bacteria 42.4 0.0294   NR MBQ8149526.1 2044939 g71338 i0 42.5 0.491803278688525 40 23 49.2 0 64 183 79 118 MBQ8149526.1 hypothetical protein [Clostridia bacterium] diamond 120 42.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30338546 30338546 PRJNA789095_P_NODE_72472_length_244_cov_1.596491_g71138_i0 PRJNA789095 72472 244 1.596491 3.89543804 Ruminococcus sp. 41978 Bacteria Bacteria 42.7 0.0358   NR WP_295092251.1 41978 g71138 i0 38.9 0.663934426229508 54 33 66.4 0 166 5 80 133 WP_295092251.1 hypothetical protein [Ruminococcus sp.] diamond 162 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
30401759 30401759 PRJNA789095_P_NODE_80753_length_214_cov_4.248227_g79419_i0 PRJNA789095 80753 214 4.248227 9.09120578 Sporosarcina sp. PTS23 49982 Bacteria Bacteria 122 2.3e-30   NR WP_114923530.1 2283194 g79419 i0 88.6 0.981308411214953 70 8 98.1 0 212 3 433 502 WP_114923530.1 dynamin family protein [Sporosarcina sp. PTS2304] diamond 210 122 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Sporosarcina Sporosarcina sp. PTS2304
30410848 30410848 PRJNA789095_P_NODE_77853_length_233_cov_3.262500_g76519_i0 PRJNA789095 77853 233 3.2625 7.601625 Bacillati 1783272 Bacteria Bacteria 128 7.530000000000001e-33   NR NLM09636.1 1898204 g76519 i0 79.2 13.8798283261803 77 16 99.1 0 3 233 330 406 NLM09636.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPB [Clostridiaceae bacterium] diamond 3234 128 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
30559028 30559028 PRJNA789095_P_NODE_63193_length_256_cov_2.666667_g61859_i0 PRJNA789095 63193 256 2.666667 6.82666752 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 42.7 0.0402   NR MCR5321216.1 1898203 g61859 i0 40.4 0.609375 52 27 57.4 2 57 203 164 214 MCR5321216.1 acyltransferase [Lachnospiraceae bacterium] diamond 156 42.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30685489 30685489 PRJNA789095_P_NODE_27933_length_411_cov_1.298817_g26601_i0 PRJNA789095 27933 411 1.298817 5.33813787 Dysosmobacter segnis 2763042 Bacteria Bacteria 107 5.66e-28   NR WP_187016484.1 2763042 g26601 i0 100 0.401459854014599 55 0 40.1 0 115 279 1 55 WP_187016484.1 hypothetical protein [Dysosmobacter segnis] diamond 165 107 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Dysosmobacter Dysosmobacter segnis
30780402 30780402 PRJNA789095_P_NODE_56274_length_271_cov_3.782828_g54940_i0 PRJNA789095 56274 271 3.782828 10.25146388 Neobacillus drentensis 220684 Bacteria Bacteria 42.4 0.0327   NR WP_066248496.1 220684 g54940 i0 29.9 0.74169741697417 67 47 74.2 0 21 221 32 98 WP_066248496.1 hypothetical protein [Neobacillus drentensis] diamond 201 42.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus drentensis
31074078 31074078 PRJNA789095_P_NODE_64515_length_253_cov_3.483333_g63181_i0 PRJNA789095 64515 253 3.483333 8.81283249 Bacillales 1385 Bacteria Bacteria 47 1.4e-4   NR WP_407819668.1 1280 g63181 i0 84.4 0.758893280632411 32 5 37.9 0 103 8 14 45 WP_407819668.1 hypothetical protein [Staphylococcus aureus] diamond 192 47 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31096286 31096286 PRJNA789095_P_NODE_56895_length_270_cov_2.187817_g55561_i0 PRJNA789095 56895 270 2.187817 5.9071059 Clostridioides difficile 1496 Bacteria Bacteria 55.1 2.15e-6   NR WP_256628284.1 1496 g55561 i0 45.8 1.06666666666667 48 26 53.3 0 268 125 278 325 WP_256628284.1 reverse transcriptase domain-containing protein, partial [Clostridioides difficile] diamond 288 55.1 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
31507639 31507639 PRJNA789095_P_NODE_74636_length_242_cov_0.911243_g73302_i0 PRJNA789095 74636 242 0.911243 2.20520806 Bacillota bacterium 1879010 Bacteria Bacteria 42.7 0.0358   NR NLN83124.1 1879010 g73302 i0 41.9 0.533057851239669 43 25 53.3 0 41 169 231 273 NLN83124.1 DUF1576 domain-containing protein [Bacillota bacterium] diamond 129 42.7 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
31516868 31516868 PRJNA789095_P_NODE_70836_length_246_cov_0.890173_g69502_i0 PRJNA789095 70836 246 0.890173 2.18982558 PVC group 1783257 Bacteria Bacteria 82.4 2.29e-16   NR WP_256628284.1 1496 g69502 i0 45.3 4.75609756097561 75 41 91.5 0 13 237 251 325 WP_256628284.1 reverse transcriptase domain-containing protein, partial [Clostridioides difficile] diamond 1170 82.8 0.995169082125604 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
31633893 31633893 PRJNA789095_P_NODE_73296_length_243_cov_2.429412_g71962_i0 PRJNA789095 73296 243 2.429412 5.90347116 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 86.7 5.53e-20   NR MBQ5561215.1 1898203 g71962 i0 43 0.975308641975309 79 45 97.5 0 239 3 16 94 MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium] diamond 237 86.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
31855303 31855303 PRJNA789095_P_NODE_54717_length_275_cov_1.514851_g53383_i0 PRJNA789095 54717 275 1.514851 4.16584025 Peptoniphilus sp. BV3AC2 1111133 Bacteria Bacteria 167 3.75e-47   NR WP_023058958.1 1111133 g53383 i0 95.6 0.992727272727273 91 4 99.3 0 3 275 342 432 WP_023058958.1 sensor histidine kinase [Peptoniphilus sp. BV3AC2] diamond 273 167 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus sp. BV3AC2
31886939 31886939 PRJNA789095_P_NODE_17257_length_621_cov_9.605839_g15948_i0 PRJNA789095 17257 621 9.605839 59.65226019 Clostridioides difficile 1496 Bacteria Bacteria 54.3 1.14e-4   NR WP_256628275.1 1496 g15948 i0 50 0.502415458937198 52 25 24.6 1 8 160 788 839 WP_256628275.1 reverse transcriptase family protein, partial [Clostridioides difficile] diamond 312 54.3 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
31981831 31981831 PRJNA789095_P_NODE_58858_length_266_cov_1.414508_g57524_i0 PRJNA789095 58858 266 1.414508 3.76259128 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 43.1 0.036   NR MBQ7433913.1 1898203 g57524 i0 34.5 0.620300751879699 55 34 62 1 195 31 241 293 MBQ7433913.1 PAS domain S-box protein [Lachnospiraceae bacterium] diamond 165 43.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32424942 32424942 PRJNA789095_P_NODE_26119_length_433_cov_2.100000_g24787_i0 PRJNA789095 26119 433 2.1 9.093 Staphylococcus aureus 1280 Bacteria Bacteria 148 2.48e-40   NR RBL73497.1 1280 g24787 i0 88.6 6.09699769053118 88 10 61 0 3 266 260 347 RBL73497.1 elongation factor 1-alpha, partial [Staphylococcus aureus] diamond 2640 149 0.993288590604027 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32424946 32424946 PRJNA789095_P_NODE_48159_length_290_cov_1.313364_g46825_i0 PRJNA789095 48159 290 1.313364 3.8087556 Dysosmobacter segnis 2763042 Bacteria Bacteria 65.9 1.13e-10   NR WP_187016499.1 2763042 g46825 i0 100 0.320689655172414 31 0 32.1 0 197 289 1 31 WP_187016499.1 ribose-phosphate pyrophosphokinase-like domain-containing protein, partial [Dysosmobacter segnis] diamond 93 65.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Dysosmobacter Dysosmobacter segnis

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