RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA796975" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 33 ✖

tax_kingdom 1

bioproject 1

  • PRJNA796975 · 33 ✖

analysis 1

  • diamond · 33 ✖

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
3332225 3332225 PRJNA796975_S_NODE_11283_length_165_cov_0.879310_g11206_i0 PRJNA796975 11283 165 0.87931 1.4508615 uncultured Anaerococcus sp. 293428 Bacteria Bacteria 95.1 2.17e-22   NR WP_297281150.1 293428 g11206 i0 88.7 0.963636363636364 53 6 96.4 0 163 5 85 137 WP_297281150.1 response regulator [uncultured Anaerococcus sp.] diamond 159 95.1 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
3332262 3332262 PRJNA796975_S_NODE_15423_length_161_cov_0.910714_g15346_i0 PRJNA796975 15423 161 0.910714 1.46624954 Oliverpabstia intestinalis 2606633 Bacteria Bacteria 100 4.65e-23   NR WP_106492515.1 2606633 g15346 i0 100 0.857142857142857 46 0 85.7 0 14 151 1 46 WP_106492515.1 acetyl-CoA decarbonylase/synthase complex subunit gamma [Oliverpabstia intestinalis] diamond 138 100 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Oliverpabstia Oliverpabstia intestinalis
5884691 5884691 PRJNA796975_S_NODE_13365_length_163_cov_0.894737_g13288_i0 PRJNA796975 13365 163 0.894737 1.45842131 Staphylococcus gallinarum 1293 Bacteria Bacteria 102 1.13e-23   NR WP_107512082.1 1293 g13288 i0 100 0.865030674846626 47 0 86.5 0 142 2 1 47 WP_107512082.1 terminase large subunit [Staphylococcus gallinarum] diamond 141 102 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus gallinarum
13534822 13534822 PRJNA796975_S_NODE_10671_length_166_cov_0.871795_g10594_i0 PRJNA796975 10671 166 0.871795 1.4471797 Clostridiales bacterium 1898207 Bacteria Bacteria 96.7 6.469999999999999e-23   NR MBF0987889.1 1898207 g10594 i0 94.2 0.939759036144578 52 3 94 0 9 164 126 177 MBF0987889.1 MIP family channel protein [Clostridiales bacterium] diamond 156 96.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
26673702 26673702 PRJNA796975_S_NODE_11241_length_165_cov_0.879310_g11164_i0 PRJNA796975 11241 165 0.87931 1.4508615 Anaerococcus prevotii 33034 Bacteria Bacteria 99 1.49e-23   NR WP_004834384.1 33034 g11164 i0 98.1 0.945454545454545 52 1 94.5 0 164 9 23 74 WP_004834384.1 hypothetical protein [Anaerococcus prevotii] diamond 156 99 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus prevotii
26873440 26873440 PRJNA796975_S_NODE_12261_length_164_cov_0.886957_g12184_i0 PRJNA796975 12261 164 0.886957 1.45460948 Staphylococcus 1279 Bacteria Bacteria 87.8 8.14e-19   NR MDH8781464.1 1282 g12184 i0 97.4 2.14024390243902 39 1 71.3 0 2 118 320 358 MDH8781464.1 hypothetical protein [Staphylococcus epidermidis] diamond 351 87.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
27686063 27686063 PRJNA796975_S_NODE_9784_length_167_cov_0.864407_g9707_i0 PRJNA796975 9784 167 0.864407 1.44355969 Dialister sp. 1955814 Bacteria Bacteria 113 7.61e-29   NR MDU5309550.1 1955814 g9707 i0 100 2.96407185628743 55 0 98.8 0 1 165 154 208 MDU5309550.1 glycosyltransferase family 2 protein [Dialister sp.] diamond 495 113 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Dialister Dialister sp.
27947468 27947468 PRJNA796975_S_NODE_11385_length_165_cov_0.879310_g11308_i0 PRJNA796975 11385 165 0.87931 1.4508615 Anaerococcus 165779 Bacteria Bacteria 93.6 1.57e-20   NR WP_004827237.1 33032 g11308 i0 88.9 2.94545454545455 54 6 98.2 0 164 3 429 482 WP_004827237.1 DNA gyrase subunit A [Anaerococcus lactolyticus] diamond 486 93.6 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus lactolyticus
28033177 28033177 PRJNA796975_S_NODE_11205_length_165_cov_0.879310_g11128_i0 PRJNA796975 11205 165 0.87931 1.4508615 Oribacterium sp. oral taxon 1969407 Bacteria Bacteria 74.3 9.24e-14   NR WP_021775068.1 652706 g11128 i0 74.1 1.96363636363636 54 14 98.2 0 3 164 558 611 WP_021775068.1 efflux RND transporter permease subunit [Oribacterium sp. oral taxon 078] diamond 324 74.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Oribacterium Oribacterium sp. oral taxon 078
28159539 28159539 PRJNA796975_S_NODE_13145_length_163_cov_0.894737_g13068_i0 PRJNA796975 13145 163 0.894737 1.45842131 Staphylococcus hominis 1290 Bacteria Bacteria 42 0.00388   NR WP_119626173.1 1290 g13068 i0 94.4 0.331288343558282 18 1 33.1 0 54 1 1 18 WP_119626173.1 XRE family transcriptional regulator [Staphylococcus hominis] diamond 54 42 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus hominis
28317248 28317248 PRJNA796975_S_NODE_9606_length_167_cov_0.864407_g9529_i0 PRJNA796975 9606 167 0.864407 1.44355969 Halalkalibacterium halodurans 86665 Bacteria Bacteria 113 1.53e-27   NR WP_053431736.1 86665 g9529 i0 98.2 1.97604790419162 55 1 98.8 0 3 167 991 1045 WP_053431736.1 transglycosylase SLT domain-containing protein [Halalkalibacterium halodurans] diamond 330 113 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Halalkalibacterium (ex Joshi et al. 2022) Halalkalibacterium halodurans
28475108 28475108 PRJNA796975_S_NODE_12566_length_164_cov_0.886957_g12489_i0 PRJNA796975 12566 164 0.886957 1.45460948 Salinicoccus roseus 45670 Bacteria Bacteria 119 3.04e-32   NR WP_040105937.1 45670 g12489 i0 98.1 0.98780487804878 54 1 98.8 0 162 1 90 143 WP_040105937.1 single-stranded DNA-binding protein [Salinicoccus roseus] diamond 162 119 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Salinicoccus Salinicoccus roseus
28633156 28633156 PRJNA796975_S_NODE_12307_length_164_cov_0.886957_g12230_i0 PRJNA796975 12307 164 0.886957 1.45460948 uncultured Blautia sp. 765821 Bacteria Bacteria 90.9 1.01e-19   NR WP_302232399.1 765821 g12230 i0 97.8 0.841463414634146 46 1 84.1 0 163 26 390 435 WP_302232399.1 TRAP transporter large permease [uncultured Blautia sp.] diamond 138 90.9 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia uncultured Blautia sp.
28822081 28822081 PRJNA796975_S_NODE_13388_length_163_cov_0.894737_g13311_i0 PRJNA796975 13388 163 0.894737 1.45842131 Staphylococcus agnetis 985762 Bacteria Bacteria 44.3 0.00366   NR WP_252566037.1 985762 g13311 i0 40.7 0.993865030674847 54 31 99.4 1 2 163 241 293 WP_252566037.1 DEAD/DEAH box helicase family protein [Staphylococcus agnetis] diamond 162 44.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus agnetis
29147595 29147595 PRJNA796975_S_NODE_5369_length_204_cov_0.987097_g5292_i0 PRJNA796975 5369 204 0.987097 2.01367788 Bacillales 1385 Bacteria Bacteria 134 5.669999999999999e-38   NR REJ13780.1 301148 g5292 i0 100 5.91176470588235 67 0 98.5 0 202 2 102 168 REJ13780.1 MAG: hypothetical protein C6W57_15750, partial [Caldibacillus debilis] diamond 1206 134 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Caldibacillus Caldibacillus debilis
29169855 29169855 PRJNA796975_S_NODE_3289_length_243_cov_1.335052_g3212_i0 PRJNA796975 3289 243 1.335052 3.24417636 Blautia luti 89014 Bacteria Bacteria 159 3.889999999999999e-43   NR WP_173771196.1 89014 g3212 i0 100 0.950617283950617 77 0 95.1 0 2 232 992 1068 WP_173771196.1 SpaA isopeptide-forming pilin-related protein [Blautia luti] diamond 231 159 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia luti
29273316 29273316 PRJNA796975_S_NODE_10549_length_166_cov_0.871795_g10472_i0 PRJNA796975 10549 166 0.871795 1.4471797 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 71.6 5.38e-13   NR WP_014553333.1 2331 g10472 i0 72.9 11.2228915662651 48 13 86.7 0 2 145 118 165 WP_014553333.1 DUF4268 domain-containing protein [Halanaerobium praevalens] diamond 1863 71.6 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halanaerobiaceae Halanaerobium Halanaerobium praevalens
29579878 29579878 PRJNA796975_S_NODE_12610_length_164_cov_0.886957_g12533_i0 PRJNA796975 12610 164 0.886957 1.45460948 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 77.4 5.51e-15   NR MDE6209795.1 1898203 g12533 i0 63.3 4.17073170731707 60 16 98.8 1 3 164 219 278 MDE6209795.1 response regulator [Lachnospiraceae bacterium] diamond 684 77.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29642983 29642983 PRJNA796975_S_NODE_3670_length_233_cov_1.108696_g3593_i0 PRJNA796975 3670 233 1.108696 2.58326168 Bacillota 1239 Bacteria Bacteria 172 2.44e-51   NR WP_234756848.1 1239 g3593 i0 100 0.991416309012876 77 0 99.1 0 232 2 204 280 WP_234756848.1 MULTISPECIES: small ribosomal subunit Rsm22 family protein [Bacillota] diamond 231 172 1 Bacteria   Bacillati Bacillota          
29832744 29832744 PRJNA796975_S_NODE_11331_length_165_cov_0.879310_g11254_i0 PRJNA796975 11331 165 0.87931 1.4508615 Eubacterium sp. 142586 Bacteria Bacteria 97.4 6.84e-22   NR MBO5152742.1 142586 g11254 i0 83 2.89090909090909 53 9 96.4 0 161 3 288 340 MBO5152742.1 AAA family ATPase [Eubacterium sp.] diamond 477 97.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
29896055 29896055 PRJNA796975_S_NODE_12371_length_164_cov_0.886957_g12294_i0 PRJNA796975 12371 164 0.886957 1.45460948 uncultured Blautia sp. 765821 Bacteria Bacteria 107 4.34e-26   NR WP_288938607.1 765821 g12294 i0 96.3 0.98780487804878 54 2 98.8 0 164 3 254 307 WP_288938607.1 3-dehydroquinate synthase [uncultured Blautia sp.] diamond 162 107 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia uncultured Blautia sp.
30094434 30094434 PRJNA796975_S_NODE_11532_length_165_cov_0.879310_g11455_i0 PRJNA796975 11532 165 0.87931 1.4508615 Bacillota 1239 Bacteria Bacteria 100 6.04e-24   NR WP_316498230.1 261299 g11455 i0 94.4 1.96363636363636 54 3 98.2 0 163 2 187 240 WP_316498230.1 N-acetylmuramoyl-L-alanine amidase [Intestinibacter bartlettii] diamond 324 100 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Intestinibacter Intestinibacter bartlettii
30243576 30243576 PRJNA796975_S_NODE_10912_length_166_cov_0.871795_g10835_i0 PRJNA796975 10912 166 0.871795 1.4471797 uncultured Mediterraneibacter sp. 2316024 Bacteria Bacteria 97.8 3.94e-22   NR WP_296957807.1 2316024 g10835 i0 94.4 1.96987951807229 54 3 97.6 0 1 162 287 340 WP_296957807.1 MFS transporter [uncultured Mediterraneibacter sp.] diamond 327 97.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Mediterraneibacter uncultured Mediterraneibacter sp.
30590936 30590936 PRJNA796975_S_NODE_12273_length_164_cov_0.886957_g12196_i0 PRJNA796975 12273 164 0.886957 1.45460948 Ruminococcus sp. 41978 Bacteria Bacteria 83.6 5.17e-17   NR MCI6651887.1 41978 g12196 i0 100 0.731707317073171 40 0 73.2 0 163 44 501 540 MCI6651887.1 starch-binding protein [Ruminococcus sp.] diamond 120 83.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
30685670 30685670 PRJNA796975_S_NODE_12033_length_164_cov_0.886957_g11956_i0 PRJNA796975 12033 164 0.886957 1.45460948 Streptococcus sp. 1306 Bacteria Bacteria 103 6.17e-24   NR WP_316714425.1 1306 g11956 i0 100 0.98780487804878 54 0 98.8 0 1 162 288 341 WP_316714425.1 putative cross-wall-targeting lipoprotein signal domain-containing proteiin [Streptococcus sp.] diamond 162 103 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp.
31254531 31254531 PRJNA796975_S_NODE_11795_length_165_cov_0.879310_g11718_i0 PRJNA796975 11795 165 0.87931 1.4508615 Anaerococcus tetradius 33036 Bacteria Bacteria 73.2 1.54e-13   NR WP_060928850.1 33036 g11718 i0 74.1 0.981818181818182 54 14 98.2 0 163 2 56 109 WP_060928850.1 molybdopterin-binding protein [Anaerococcus tetradius] diamond 162 73.2 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus tetradius
31349583 31349583 PRJNA796975_S_NODE_7336_length_183_cov_1.141791_g7259_i0 PRJNA796975 7336 183 1.141791 2.08947753 Paenibacillus taichungensis 484184 Bacteria Bacteria 76.3 1.2e-16   NR WP_310855027.1 484184 g7259 i0 77.8 2.21311475409836 45 10 73.8 0 180 46 19 63 WP_310855027.1 hypothetical protein, partial [Paenibacillus taichungensis] diamond 405 76.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus taichungensis
31665662 31665662 PRJNA796975_S_NODE_14577_length_162_cov_0.893805_g14500_i0 PRJNA796975 14577 162 0.893805 1.4479641 Clostridiales bacterium S5-A14a 1230734 Bacteria Bacteria 110 1.98e-26   NR KGF09053.1 1230734 g14500 i0 98 0.944444444444444 51 1 94.4 0 155 3 374 424 KGF09053.1 prolyl-tRNA synthetase [Clostridiales bacterium S5-A14a] diamond 153 110 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   Clostridiales bacterium S5-A14a
31801188 31801188 PRJNA796975_S_NODE_10677_length_166_cov_0.871795_g10600_i0 PRJNA796975 10677 166 0.871795 1.4471797 Clostridia 186801 Bacteria Bacteria 113 1.43e-28   NR WP_243121806.1 89014 g10600 i0 98.2 2.98192771084337 55 1 99.4 0 165 1 72 126 WP_243121806.1 LacI family DNA-binding transcriptional regulator [Blautia luti] diamond 495 113 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia luti
31950359 31950359 PRJNA796975_S_NODE_10897_length_166_cov_0.871795_g10820_i0 PRJNA796975 10897 166 0.871795 1.4471797 Anaerococcus nagyae 1755241 Bacteria Bacteria 98.2 4.59e-25   NR WP_394271626.1 1755241 g10820 i0 95.5 0.795180722891566 44 2 79.5 0 164 33 55 98 WP_394271626.1 hypothetical protein [Anaerococcus nagyae] diamond 132 98.2 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus nagyae
32013762 32013762 PRJNA796975_S_NODE_12278_length_164_cov_0.886957_g12201_i0 PRJNA796975 12278 164 0.886957 1.45460948 Staphylococcus warneri 1292 Bacteria Bacteria 73.2 7.27e-14   NR MDU6255077.1 1292 g12201 i0 93 0.786585365853659 43 3 78.7 0 131 3 1 43 MDU6255077.1 DNA/RNA non-specific endonuclease [Staphylococcus warneri] diamond 129 73.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
32298877 32298877 PRJNA796975_S_NODE_11539_length_165_cov_0.879310_g11462_i0 PRJNA796975 11539 165 0.87931 1.4508615 Lacicoccus qingdaonensis 576118 Bacteria Bacteria 112 5.34e-29   NR WP_092987668.1 576118 g11462 i0 98.2 1 55 1 100 0 165 1 3 57 WP_092987668.1 hypothetical protein [Lacicoccus qingdaonensis] diamond 165 112 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Salinicoccaceae Lacicoccus Lacicoccus qingdaonensis
32393468 32393468 PRJNA796975_S_NODE_12519_length_164_cov_0.886957_g12442_i0 PRJNA796975 12519 164 0.886957 1.45460948 Ruminococcus sp. SR1/5 657323 Bacteria Bacteria 74.7 1.31e-15   NR CBL19725.1 657323 g12442 i0 97.3 1.35365853658537 37 1 67.7 0 163 53 77 113 CBL19725.1 Flp pilus assembly protein, ATPase CpaF [Ruminococcus sp. SR1/5] diamond 222 74.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp. SR1/5

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