RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJNA851399" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 35 ✖

tax_kingdom 1

bioproject 1

  • PRJNA851399 · 35 ✖

analysis 1

  • diamond · 35 ✖

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
17417823 17417823 PRJNA851399_P_NODE_9014_length_271_cov_1.009009_g8561_i0 PRJNA851399 9014 271 1.009009 2.73441439 Bacillus halotolerans 260554 Bacteria Bacteria 165 2.2e-50   NR MBL6010772.1 260554 g8561 i0 97.8 0.996309963099631 90 2 99.6 0 1 270 59 148 MBL6010772.1 magnesium transporter CorA [Bacillus halotolerans] diamond 270 165 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus halotolerans
19965757 19965757 PRJNA851399_P_NODE_24056_length_169_cov_1.116667_g23603_i0 PRJNA851399 24056 169 1.116667 1.88716723 Listeria monocytogenes 1639 Bacteria Bacteria 110 1.6799999999999999e-29   NR HCA4016380.1 1639 g23603 i0 100 0.994082840236686 56 0 99.4 0 168 1 45 100 HCA4016380.1 hypothetical protein [Listeria monocytogenes] diamond 168 110 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
26810105 26810105 PRJNA851399_P_NODE_39341_length_161_cov_1.821429_g38888_i0 PRJNA851399 39341 161 1.821429 2.93250069 Bacillati 1783272 Bacteria Bacteria 101 3.3e-26   NR NFV91291.1 1280 g38888 i0 100 1.97515527950311 53 0 98.8 0 3 161 32 84 NFV91291.1 DUF349 domain-containing protein [Staphylococcus aureus] diamond 318 101 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
26896963 26896963 PRJNA851399_P_NODE_41221_length_161_cov_0.910714_g40768_i0 PRJNA851399 41221 161 0.910714 1.46624954 Clostridia bacterium 2044939 Bacteria Bacteria 103 7.77e-26   NR MEI3392042.1 2044939 g40768 i0 90.6 1.97515527950311 53 5 98.8 0 160 2 39 91 MEI3392042.1 spore cortex-lytic enzyme [Clostridia bacterium] diamond 318 103 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27434443 27434443 PRJNA851399_P_NODE_4803_length_463_cov_61.340580_g4355_i0 PRJNA851399 4803 463 61.34058 284.0068854 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 65.5 2.87e-11   NR KZU89800.1 1590 g4355 i0 82.1 0.252699784017279 39 7 25.3 0 416 300 2 40 KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum] diamond 117 65.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
27687183 27687183 PRJNA851399_P_NODE_10644_length_239_cov_1.715789_g10191_i0 PRJNA851399 10644 239 1.715789 4.10073571 Bacillus cereus 1396 Bacteria Bacteria 167 1.6e-51   NR MDF9502072.1 1396 g10191 i0 98.7 1.98326359832636 79 1 99.2 0 3 239 3 81 MDF9502072.1 hypothetical protein [Bacillus cereus] diamond 474 167 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
27781658 27781658 PRJNA851399_P_NODE_6004_length_393_cov_8.186047_g5552_i0 PRJNA851399 6004 393 8.186047 32.17116471 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 66.6 5.27e-12   NR KZU89800.1 1590 g5552 i0 79.5 0.297709923664122 39 8 29.8 0 349 233 2 40 KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum] diamond 117 66.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
27939521 27939521 PRJNA851399_P_NODE_14065_length_201_cov_1.342105_g13612_i0 PRJNA851399 14065 201 1.342105 2.69763105 Bacillus cereus 1396 Bacteria Bacteria 69.7 1.18e-13   NR WP_323656232.1 1396 g13612 i0 59.3 1.74626865671642 54 22 80.6 0 163 2 2 55 WP_323656232.1 hypothetical protein, partial [Bacillus cereus] diamond 351 69.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
27970920 27970920 PRJNA851399_P_NODE_12885_length_211_cov_3.067901_g12432_i0 PRJNA851399 12885 211 3.067901 6.47327111 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 68.9 7.93e-14   NR KZU89800.1 1590 g12432 i0 84.6 0.554502369668246 39 6 55.5 0 44 160 2 40 KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum] diamond 117 68.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
28452982 28452982 PRJNA851399_P_NODE_32326_length_164_cov_0.886957_g31873_i0 PRJNA851399 32326 164 0.886957 1.45460948 FCB group 1783270 Bacteria Bacteria 112 1.11e-28   NR MEE1100610.1 2021311 g31873 i0 94.4 1.97560975609756 54 3 98.8 0 163 2 185 238 MEE1100610.1 radical SAM protein [Agathobacter sp.] diamond 324 112 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Agathobacter Agathobacter sp.
28570795 28570795 PRJNA851399_P_NODE_19167_length_179_cov_6.307692_g18714_i0 PRJNA851399 19167 179 6.307692 11.29076868 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 72.4 2.15e-15   NR KZU89800.1 1590 g18714 i0 94.9 0.653631284916201 39 2 65.4 0 125 9 2 40 KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum] diamond 117 72.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
28610718 28610718 PRJNA851399_P_NODE_28527_length_166_cov_0.871795_g28074_i0 PRJNA851399 28527 166 0.871795 1.4471797 Bacillati 1783272 Bacteria Bacteria 117 3.25e-32   NR PTI99531.1 1286 g28074 i0 100 1.95180722891566 54 0 97.6 0 3 164 59 112 PTI99531.1 hypothetical protein BU047_13120, partial [Staphylococcus simulans] diamond 324 117 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus simulans
28634267 28634267 PRJNA851399_P_NODE_25607_length_167_cov_0.864407_g25154_i0 PRJNA851399 25607 167 0.864407 1.44355969 uncultured Acetatifactor sp. 1671927 Bacteria Bacteria 125 2.36e-32   NR WP_300817698.1 1671927 g25154 i0 100 0.988023952095808 55 0 98.8 0 1 165 336 390 WP_300817698.1 hypothetical protein [uncultured Acetatifactor sp.] diamond 165 125 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Acetatifactor uncultured Acetatifactor sp.
28697360 28697360 PRJNA851399_P_NODE_42147_length_155_cov_2.500000_g41694_i0 PRJNA851399 42147 155 2.5 3.875 Anaerococcus provencensis 938293 Bacteria Bacteria 82.8 7.9e-17   NR WP_044565160.1 938293 g41694 i0 84.3 0.987096774193548 51 8 98.7 0 155 3 321 371 WP_044565160.1 cysteine--tRNA ligase [Anaerococcus provencensis] diamond 153 82.8 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus provencensis
28854877 28854877 PRJNA851399_P_NODE_6348_length_374_cov_3.027692_g5896_i0 PRJNA851399 6348 374 3.027692 11.32356808 Bacillus velezensis 492670 Bacteria Bacteria 147 1.2099999999999999e-40   NR WP_415448747.1 492670 g5896 i0 54.8 8.94385026737968 124 56 99.5 0 374 3 146 269 WP_415448747.1 glycoside hydrolase family 113 [Bacillus velezensis] diamond 3345 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus velezensis
29076234 29076234 PRJNA851399_P_NODE_21988_length_173_cov_1.459677_g21535_i0 PRJNA851399 21988 173 1.459677 2.52524121 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 38.5 0.0497   NR KZU46937.1 1590 g21535 i0 51.4 0.606936416184971 35 17 60.7 0 150 46 1 35 KZU46937.1 hypothetical protein Nizo2766_1002 [Lactiplantibacillus plantarum] diamond 105 38.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29147832 29147832 PRJNA851399_P_NODE_29929_length_165_cov_0.965517_g29476_i0 PRJNA851399 29929 165 0.965517 1.59310305 root 1 Root_unresolved Root_unresolved 82.4 5.16e-17   NR WP_323655933.1 1396 g29476 i0 71.7 12.5272727272727 53 15 96.4 0 2 160 124 176 WP_323655933.1 reverse transcriptase domain-containing protein, partial [Bacillus cereus] diamond 2067 83.2 0.990384615384615 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
29202487 29202487 PRJNA851399_P_NODE_1429_length_973_cov_84.038961_g1192_i0 PRJNA851399 1429 973 84.038961 817.69909053 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 70.1 9.11e-12   NR KZU89800.1 1590 g1192 i0 87.2 0.120246659815005 39 5 12 0 10 126 2 40 KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum] diamond 117 70.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29234032 29234032 PRJNA851399_P_NODE_8929_length_272_cov_3.201794_g8476_i0 PRJNA851399 8929 272 3.201794 8.70887968 Listeria monocytogenes 1639 Bacteria Bacteria 48.1 4.49e-5   NR WP_109246538.1 1639 g8476 i0 100 0.242647058823529 22 0 24.3 0 271 206 43 64 WP_109246538.1 FmdB family zinc ribbon protein [Listeria monocytogenes] diamond 66 48.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29360293 29360293 PRJNA851399_P_NODE_37469_length_162_cov_0.902655_g37016_i0 PRJNA851399 37469 162 0.902655 1.4623011 uncultured Peptostreptococcus sp. 169971 Bacteria Bacteria 98.6 9.99e-23   NR WP_297395007.1 169971 g37016 i0 90.7 2 54 5 100 0 162 1 92 145 WP_297395007.1 putative isocaproyl-CoA dehydrogenase AcdB [uncultured Peptostreptococcus sp.] diamond 324 98.6 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Peptostreptococcus uncultured Peptostreptococcus sp.
29391924 29391924 PRJNA851399_P_NODE_13849_length_203_cov_0.993506_g13396_i0 PRJNA851399 13849 203 0.993506 2.01681718 Streptococcus pyogenes 1314 Bacteria Bacteria 137 7.71e-39   NR HGC6553668.1 1314 g13396 i0 100 0.990147783251232 67 0 99 0 2 202 123 189 HGC6553668.1 hypothetical protein [Streptococcus pyogenes] diamond 201 137 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pyogenes
29644012 29644012 PRJNA851399_P_NODE_35510_length_163_cov_0.894737_g35057_i0 PRJNA851399 35510 163 0.894737 1.45842131 Streptococcus sp. 263_SSPC 1579343 Bacteria Bacteria 105 1.39e-25   NR WP_048782893.1 1579343 g35057 i0 100 2.96319018404908 54 0 99.4 0 2 163 42 95 WP_048782893.1 DNA/RNA non-specific endonuclease [Streptococcus sp. 263_SSPC] diamond 483 105 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp. 263_SSPC
29652264 29652264 PRJNA851399_P_NODE_18130_length_182_cov_2.300752_g17677_i0 PRJNA851399 18130 182 2.300752 4.18736864 Bacillati 1783272 Bacteria Bacteria 134 4.14e-39   NR MDF9565246.1 1396 g17677 i0 100 1.97802197802198 60 0 98.9 0 2 181 53 112 MDF9565246.1 rhodanese-like domain-containing protein [Bacillus cereus] diamond 360 134 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
30212826 30212826 PRJNA851399_P_NODE_5592_length_413_cov_98.197802_g5140_i0 PRJNA851399 5592 413 98.197802 405.55692226 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 78.6 2.49e-16   NR WP_222836994.1 1590 g5140 i0 95 0.290556900726392 40 2 29.1 0 137 256 1 40 WP_222836994.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 120 78.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30348081 30348081 PRJNA851399_P_NODE_15572_length_190_cov_1.907801_g15119_i0 PRJNA851399 15572 190 1.907801 3.6248219 Enterococcus 1350 Bacteria Bacteria 127 1.67e-34   NR WP_010739149.1 1350 g15119 i0 100 1.98947368421053 63 0 99.5 0 190 2 102 164 WP_010739149.1 MULTISPECIES: ankyrin repeat domain-containing protein [Enterococcus] diamond 378 127 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus  
30560266 30560266 PRJNA851399_P_NODE_20933_length_175_cov_1.873016_g20480_i0 PRJNA851399 20933 175 1.873016 3.277778 Aedoeadaptatus coxii 755172 Bacteria Bacteria 112 4.45e-27   NR WP_322631531.1 755172 g20480 i0 98.3 0.994285714285714 58 1 99.4 0 1 174 1734 1791 WP_322631531.1 InlB B-repeat-containing protein, partial [Aedoeadaptatus coxii] diamond 174 112 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Aedoeadaptatus Aedoeadaptatus coxii
30939826 30939826 PRJNA851399_P_NODE_16094_length_189_cov_1.085714_g15641_i0 PRJNA851399 16094 189 1.085714 2.05199946 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 61.6 4.56e-11   NR KZU89800.1 1590 g15641 i0 72.5 1.22222222222222 40 11 63.5 0 128 9 1 40 KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum] diamond 231 61.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31066286 31066286 PRJNA851399_P_NODE_33575_length_164_cov_0.886957_g33122_i0 PRJNA851399 33575 164 0.886957 1.45460948 uncultured Anaerococcus sp. 293428 Bacteria Bacteria 96.3 1.7700000000000003e-21   NR WP_297280977.1 293428 g33122 i0 87 2.96341463414634 54 7 98.8 0 163 2 250 303 WP_297280977.1 endonuclease MutS2 [uncultured Anaerococcus sp.] diamond 486 96.3 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
31255658 31255658 PRJNA851399_P_NODE_4215_length_511_cov_81.183983_g3776_i0 PRJNA851399 4215 511 81.183983 414.85015313 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 72 2.34e-13   NR WP_222836994.1 1590 g3776 i0 87.5 0.234833659491194 40 5 23.5 0 47 166 1 40 WP_222836994.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 120 72 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31413861 31413861 PRJNA851399_P_NODE_9676_length_256_cov_3.101449_g9223_i0 PRJNA851399 9676 256 3.101449 7.93970944 unclassified Leuconostoc 2685106 Bacteria Bacteria 97.1 3.53e-21   NR WP_233610746.1 2685106 g9223 i0 54.1 1.9921875 85 39 99.6 0 256 2 388 472 WP_233610746.1 MULTISPECIES: phage distal tail protein domain-containing protein [unclassified Leuconostoc] diamond 510 97.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Leuconostoc  
31730034 31730034 PRJNA851399_P_NODE_40157_length_161_cov_0.910714_g39704_i0 PRJNA851399 40157 161 0.910714 1.46624954 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 57 1.13e-7   NR MBR3366232.1 1898203 g39704 i0 46.6 1.08074534161491 58 26 98.8 2 3 161 324 381 MBR3366232.1 hypothetical protein [Lachnospiraceae bacterium] diamond 174 57 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
31888177 31888177 PRJNA851399_P_NODE_18957_length_180_cov_1.557252_g18504_i0 PRJNA851399 18957 180 1.557252 2.8030536 Listeria monocytogenes 1639 Bacteria Bacteria 83.2 1.99e-19   NR WP_109246538.1 1639 g18504 i0 100 0.566666666666667 34 0 56.7 0 104 3 1 34 WP_109246538.1 FmdB family zinc ribbon protein [Listeria monocytogenes] diamond 102 83.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32741875 32741875 PRJNA851399_P_NODE_29280_length_166_cov_0.871795_g28827_i0 PRJNA851399 29280 166 0.871795 1.4471797 uncultured Blautia sp. 765821 Bacteria Bacteria 112 3.91e-29   NR WP_295281588.1 765821 g28827 i0 98.2 1.98795180722892 55 1 99.4 0 1 165 67 121 WP_295281588.1 RnfABCDGE type electron transport complex subunit B, partial [uncultured Blautia sp.] diamond 330 112 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia uncultured Blautia sp.
32773093 32773093 PRJNA851399_P_NODE_19580_length_178_cov_2.643411_g19127_i0 PRJNA851399 19580 178 2.643411 4.70527158 Bacillus cereus 1396 Bacteria Bacteria 51.6 1.11e-5   NR WP_323655933.1 1396 g19127 i0 51.7 2.02247191011236 60 28 99.4 1 177 1 76 135 WP_323655933.1 reverse transcriptase domain-containing protein, partial [Bacillus cereus] diamond 360 51.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
32867593 32867593 PRJNA851399_P_NODE_13540_length_205_cov_1.634615_g13087_i0 PRJNA851399 13540 205 1.634615 3.35096075 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 58.5 9.22e-10   NR KZU89800.1 1590 g13087 i0 74.4 1.71219512195122 39 10 57.1 0 140 24 2 40 KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum] diamond 351 58.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum

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