RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA492406 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
8105744 8105744 PRJNA492406_P_NODE_28407_length_248_cov_0.880000_g28108_i0 PRJNA492406 28407 248 0.88 2.1824 Bacilli bacterium 1903720 Bacteria Bacteria 84.7 3.35e-19   NR MCR5349097.1 1903720 g28108 i0 59.7 2.35887096774194 62 25 75 0 54 239 2 63 MCR5349097.1 thioredoxin [Bacilli bacterium] diamond 585 84.7 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
10656206 10656206 PRJNA492406_P_NODE_23229_length_267_cov_1.927835_g22930_i0 PRJNA492406 23229 267 1.927835 5.14731945 Bacillota 1239 Bacteria Bacteria 127 2.29e-35   NR WP_077720530.1 1471761 g22930 i0 68.5 8.98876404494382 89 28 100 0 1 267 10 98 WP_077720530.1 nucleoside-diphosphate kinase [Novibacillus thermophilus] diamond 2400 128 0.9921875 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Novibacillus Novibacillus thermophilus
23404723 23404723 PRJNA492406_P_NODE_18939_length_288_cov_1.437209_g18640_i0 PRJNA492406 18939 288 1.437209 4.13916192 Bacillaceae 186817 Bacteria Bacteria 171 2.85e-50   NR WP_053431525.1 86665 g18640 i0 89.5 110.833333333333 95 10 99 0 286 2 144 238 WP_053431525.1 PhoH family protein [Halalkalibacterium halodurans] diamond 31920 172 0.994186046511628 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Halalkalibacterium (ex Joshi et al. 2022) Halalkalibacterium halodurans
26981477 26981477 PRJNA492406_P_NODE_9302_length_402_cov_1.756839_g9003_i0 PRJNA492406 9302 402 1.756839 7.06249278 Bacilli bacterium 1903720 Bacteria Bacteria 49.7 8.66e-4   NR MBQ3475494.1 1903720 g9003 i0 26.1 1 134 95 100 2 1 402 2375 2504 MBQ3475494.1 InlB B-repeat-containing protein [Bacilli bacterium] diamond 402 49.7 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
27487215 27487215 PRJNA492406_P_NODE_21903_length_274_cov_1.472637_g21604_i0 PRJNA492406 21903 274 1.472637 4.03502538 Cohnella herbarum 2728023 Bacteria Bacteria 52.4 2.04e-5   NR WP_169283505.1 2728023 g21604 i0 41.3 0.875912408759124 80 45 87.6 1 30 269 11 88 WP_169283505.1 pyridoxal phosphate-dependent aminotransferase [Cohnella herbarum] diamond 240 52.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella herbarum
27708662 27708662 PRJNA492406_P_NODE_18504_length_290_cov_1.322581_g18205_i0 PRJNA492406 18504 290 1.322581 3.8354849 Clostridia bacterium 2044939 Bacteria Bacteria 42.7 0.0438   NR MBQ7948540.1 2044939 g18205 i0 52.2 0.475862068965517 46 19 47.6 1 26 163 13 55 MBQ7948540.1 leucine-rich repeat domain-containing protein [Clostridia bacterium] diamond 138 42.7 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28213145 28213145 PRJNA492406_P_NODE_24026_length_263_cov_1.600000_g23727_i0 PRJNA492406 24026 263 1.6 4.208 Paenibacillus sp. PK3_47 2072642 Bacteria Bacteria 44.3 0.014   NR UQZ34316.1 2072642 g23727 i0 37.8 2.70342205323194 74 42 84.4 2 33 254 95 164 UQZ34316.1 hypothetical protein C2I18_12790 [Paenibacillus sp. PK3_47] diamond 711 44.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. PK3_47
28213146 28213146 PRJNA492406_P_NODE_24246_length_262_cov_1.587302_g23947_i0 PRJNA492406 24246 262 1.587302 4.15873124 Hydrogenibacillus schlegelii 1484 Bacteria Bacteria 120 1.89e-30   NR WP_066202316.1 1484 g23947 i0 64.7 2.86259541984733 85 30 97.3 0 3 257 217 301 WP_066202316.1 NAD(P)/FAD-dependent oxidoreductase [Hydrogenibacillus schlegelii] diamond 750 120 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Hydrogenibacillus Hydrogenibacillus schlegelii
28244808 28244808 PRJNA492406_P_NODE_32486_length_235_cov_2.635802_g32187_i0 PRJNA492406 32486 235 2.635802 6.1941347 Scopulibacillus daqui 1469162 Bacteria Bacteria 85.9 6.6e-19   NR WP_205003290.1 1469162 g32187 i0 54.2 1.83829787234043 72 33 91.9 0 2 217 97 168 WP_205003290.1 thiol-disulfide oxidoreductase ResA [Scopulibacillus daqui] diamond 432 85.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Scopulibacillus Scopulibacillus daqui
28308222 28308222 PRJNA492406_P_NODE_18826_length_289_cov_1.041667_g18527_i0 PRJNA492406 18826 289 1.041667 3.01041763 Staphylococcus borealis 2742203 Bacteria Bacteria 110 7.09e-29   NR WP_415427217.1 2742203 g18527 i0 66.2 0.799307958477509 77 26 79.9 0 235 5 1 77 WP_415427217.1 hypothetical protein, partial [Staphylococcus borealis] diamond 231 110 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus borealis
28466184 28466184 PRJNA492406_P_NODE_9286_length_402_cov_2.340426_g8987_i0 PRJNA492406 9286 402 2.340426 9.40851252 Paenibacillus naphthalenovorans 162209 Bacteria Bacteria 67.4 5.4e-10   NR WP_062410505.1 162209 g8987 i0 37.9 1.04477611940298 140 74 94.8 5 401 21 78 217 WP_062410505.1 S-layer homology domain-containing protein [Paenibacillus naphthalenovorans] diamond 420 67.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus naphthalenovorans
28497718 28497718 PRJNA492406_P_NODE_19947_length_284_cov_1.094787_g19648_i0 PRJNA492406 19947 284 1.094787 3.10919508 Dysosmobacter segnis 2763042 Bacteria Bacteria 194 9.46e-60   NR WP_187016437.1 2763042 g19648 i0 100 0.992957746478873 94 0 99.3 0 284 3 107 200 WP_187016437.1 hypothetical protein [Dysosmobacter segnis] diamond 282 194 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Dysosmobacter Dysosmobacter segnis
29633840 29633840 PRJNA492406_P_NODE_23250_length_267_cov_1.587629_g22951_i0 PRJNA492406 23250 267 1.587629 4.23896943 Clostridium 1485 Bacteria Bacteria 52.8 1.15e-5   NR WP_011721126.1 1485 g22951 i0 40 1.4494382022471901 65 39 73 0 267 73 139 203 WP_011721126.1 MULTISPECIES: metal ABC transporter ATP-binding protein [Clostridium] diamond 387 52.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium  
30392835 30392835 PRJNA492406_P_NODE_4413_length_569_cov_1.679435_g4118_i0 PRJNA492406 4413 569 1.679435 9.55598515 Priestia megaterium 1404 Bacteria Bacteria 126 7.439999999999999e-30   NR WP_375345368.1 1404 g4118 i0 36.6 6.27416520210896 202 112 98.6 3 568 8 1075 1275 WP_375345368.1 DEAD/DEAH box helicase [Priestia megaterium] diamond 3570 126 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia megaterium
30739905 30739905 PRJNA492406_P_NODE_18494_length_290_cov_1.368664_g18195_i0 PRJNA492406 18494 290 1.368664 3.9691256 Anaerovoracaceae bacterium 3030912 Bacteria Bacteria 57 4.62e-8   NR HVI43160.1 3030912 g18195 i0 45 0.620689655172414 60 33 62.1 0 288 109 14 73 HVI43160.1 hypothetical protein [Anaerovoracaceae bacterium] diamond 180 57 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   Anaerovoracaceae bacterium
30992768 30992768 PRJNA492406_P_NODE_27034_length_250_cov_1.305085_g26735_i0 PRJNA492406 27034 250 1.305085 3.2627125 Dysosmobacter segnis 2763042 Bacteria Bacteria 145 4.89e-42   NR WP_187016443.1 2763042 g26735 i0 100 0.852 71 0 85.2 0 2 214 135 205 WP_187016443.1 hypothetical protein [Dysosmobacter segnis] diamond 213 145 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Dysosmobacter Dysosmobacter segnis
31040563 31040563 PRJNA492406_P_NODE_16895_length_304_cov_2.142857_g16596_i0 PRJNA492406 16895 304 2.142857 6.51428528 Bacteria 2 Bacteria Bacteria 62.8 6.19e-9   NR HBB72400.1 41978 g16596 i0 38 1.66776315789474 100 57 98.7 1 302 3 201 295 HBB72400.1 GTPase [Ruminococcus sp.] diamond 507 63.2 0.993670886075949 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
31514779 31514779 PRJNA492406_P_NODE_6536_length_471_cov_1.354271_g6237_i0 PRJNA492406 6536 471 1.354271 6.37861641 Zhenhengia 2944196 Bacteria Bacteria 102 7.83e-22   NR WP_320651479.1 2763666 g6237 i0 47.1 9.68152866242038 104 52 66.2 1 334 23 160 260 WP_320651479.1 ATP-dependent metallopeptidase FtsH/Yme1/Tma family protein [Zhenhengia yiwuensis] diamond 4560 102 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Zhenhengia Zhenhengia yiwuensis
31862254 31862254 PRJNA492406_P_NODE_22377_length_272_cov_1.155779_g22078_i0 PRJNA492406 22377 272 1.155779 3.14371888 Bacteria 2 Bacteria Bacteria 65.9 3.76e-10   NR MBX6395197.1 2782694 g22078 i0 47.5 4.51102941176471 61 32 67.3 0 2 184 403 463 MBX6395197.1 leucyl aminopeptidase [Alicyclobacillaceae bacterium] diamond 1227 65.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae   Alicyclobacillaceae bacterium
32052294 32052294 PRJNA492406_P_NODE_7898_length_432_cov_1.440111_g7599_i0 PRJNA492406 7898 432 1.440111 6.22127952 FCB group 1783270 Bacteria Bacteria 50.1 8.15e-4   NR MCI8671821.1 1903720 g7599 i0 33.9 4.59722222222222 59 39 41 0 178 2 1556 1614 MCI8671821.1 hypothetical protein [Bacilli bacterium] diamond 1986 50.1 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
32605630 32605630 PRJNA492406_P_NODE_7260_length_448_cov_4.037333_g6961_i0 PRJNA492406 7260 448 4.037333 18.08725184 Bacillus cereus group 86661 Bacteria Bacteria 49.7 8.37e-4   NR WP_128267372.1 86661 g6961 i0 27.8 0.602678571428571 90 64 60.3 1 127 396 46 134 WP_128267372.1 MULTISPECIES: hypothetical protein [Bacillus cereus group] diamond 270 49.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus  
32668523 32668523 PRJNA492406_P_NODE_19500_length_286_cov_1.126761_g19201_i0 PRJNA492406 19500 286 1.126761 3.22253646 Sutcliffiella horikoshii 79883 Bacteria Bacteria 73.9 1.56e-13   NR WP_331254646.1 79883 g19201 i0 60.4 0.555944055944056 53 21 55.6 0 2 160 177 229 WP_331254646.1 TIGR02206 family membrane protein [Sutcliffiella horikoshii] diamond 159 73.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Sutcliffiella Sutcliffiella horikoshii

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