RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA645397" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA645397 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
1895772 1895772 PRJNA645397_P_NODE_1162_length_466_cov_1.736211_g1098_i0 PRJNA645397 1162 466 1.736211 8.09074326 Clostridia 186801 Bacteria Bacteria 272 4.44e-88   NR MCX4342178.1 1898203 g1098 i0 89 1.87982832618026 146 16 94 0 27 464 60 205 MCX4342178.1 transposase [Lachnospiraceae bacterium] diamond 876 272 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
5723087 5723087 PRJNA645397_P_NODE_9165_length_169_cov_0.866667_g9092_i0 PRJNA645397 9165 169 0.866667 1.46466723 Butyrivibrio 830 Bacteria Bacteria 82.8 3.27e-17   NR MCM1561387.1 28121 g9092 i0 86.4 6.24852071005917 44 6 78.1 0 37 168 196 239 MCM1561387.1 MBL fold metallo-hydrolase [Butyrivibrio sp.] diamond 1056 82.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Butyrivibrio Butyrivibrio sp.
6998207 6998207 PRJNA645397_P_NODE_9266_length_169_cov_0.866667_g9193_i0 PRJNA645397 9266 169 0.866667 1.46466723 Aerococcus agrisoli 2487350 Bacteria Bacteria 95.5 3.18e-21   NR WP_123779439.1 2487350 g9193 i0 87.5 1.70414201183432 48 6 85.2 0 144 1 425 472 WP_123779439.1 VWA-like domain-containing protein [Aerococcus agrisoli] diamond 288 95.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Aerococcus Aerococcus agrisoli
14648532 14648532 PRJNA645397_P_NODE_9612_length_167_cov_1.262712_g9539_i0 PRJNA645397 9612 167 1.262712 2.10872904 Alteribacillus persepolensis 568899 Bacteria Bacteria 57 1.01e-7   NR WP_091274967.1 568899 g9539 i0 56 1.79640718562874 50 22 89.8 0 152 3 33 82 WP_091274967.1 flagellar hook-basal body protein [Alteribacillus persepolensis] diamond 300 57 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alteribacillus Alteribacillus persepolensis
14648534 14648534 PRJNA645397_P_NODE_9992_length_166_cov_0.888889_g9919_i0 PRJNA645397 9992 166 0.888889 1.47555574 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 75.9 2.76e-14   NR MDE7324497.1 1898203 g9919 i0 93.3 0.813253012048193 45 3 81.3 0 165 31 257 301 MDE7324497.1 hypothetical protein [Lachnospiraceae bacterium] diamond 135 75.9 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
18471880 18471880 PRJNA645397_P_NODE_10515_length_164_cov_0.904348_g10442_i0 PRJNA645397 10515 164 0.904348 1.48313072 Roseburia 841 Bacteria Bacteria 59.7 1.32e-8   NR WP_281854119.1 360807 g10442 i0 62.8 3.09146341463415 43 16 78.7 0 137 9 486 528 WP_281854119.1 AAA family ATPase [Roseburia inulinivorans] diamond 507 59.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Roseburia Roseburia inulinivorans
19746448 19746448 PRJNA645397_P_NODE_9276_length_169_cov_0.866667_g9203_i0 PRJNA645397 9276 169 0.866667 1.46466723 Anoxybacteroides tepidamans 265948 Bacteria Bacteria 79.7 2.67e-16   NR WP_183256394.1 265948 g9203 i0 83 0.834319526627219 47 8 83.4 0 143 3 151 197 WP_183256394.1 yteA family sporulation protein [Anoxybacteroides tepidamans] diamond 141 79.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacteroides Anoxybacteroides tepidamans
27302694 27302694 PRJNA645397_P_NODE_9783_length_167_cov_0.881356_g9710_i0 PRJNA645397 9783 167 0.881356 1.47186452 Erysipelothrix sp. 38403 Bacteria Bacteria 73.2 4.13e-14   NR NLC41629.1 38403 g9710 i0 63.6 0.988023952095808 55 20 98.8 0 3 167 62 116 NLC41629.1 hypothetical protein [Erysipelothrix sp.] diamond 165 73.2 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Erysipelothrix Erysipelothrix sp.
27492171 27492171 PRJNA645397_P_NODE_10243_length_165_cov_0.896552_g10170_i0 PRJNA645397 10243 165 0.896552 1.4793108 Niallia taxi 2499688 Bacteria Bacteria 111 9.9e-27   NR WP_328041167.1 2499688 g10170 i0 100 1 55 0 100 0 1 165 537 591 WP_328041167.1 heavy metal translocating P-type ATPase [Niallia taxi] diamond 165 111 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Niallia Niallia taxi
27965653 27965653 PRJNA645397_P_NODE_6605_length_202_cov_0.830065_g6532_i0 PRJNA645397 6605 202 0.830065 1.6767313 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 117 3.2e-30   NR MDE7478212.1 1898203 g6532 i0 98.2 5.92574257425743 57 1 84.7 0 202 32 223 279 MDE7478212.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Lachnospiraceae bacterium] diamond 1197 117 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
28376074 28376074 PRJNA645397_P_NODE_3346_length_296_cov_0.744939_g3273_i0 PRJNA645397 3346 296 0.744939 2.20501944 Listeria monocytogenes 1639 Bacteria Bacteria 47.8 9.62e-5   NR WP_206745231.1 1639 g3273 i0 57.1 0.35472972972973 35 15 35.5 0 57 161 37 71 WP_206745231.1 hypothetical protein, partial [Listeria monocytogenes] diamond 105 47.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29197244 29197244 PRJNA645397_P_NODE_4349_length_255_cov_1.383495_g4276_i0 PRJNA645397 4349 255 1.383495 3.52791225 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 46.6 1.9e-4   NR MCI8943684.1 2485925 g4276 i0 84.6 0.8 26 4 30.6 0 160 83 50 75 MCI8943684.1 hypothetical protein [Oscillospiraceae bacterium] diamond 204 46.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
29417973 29417973 PRJNA645397_P_NODE_10189_length_165_cov_0.896552_g10116_i0 PRJNA645397 10189 165 0.896552 1.4793108 Niallia taxi 2499688 Bacteria Bacteria 107 2.83e-26   NR WP_182104611.1 2499688 g10116 i0 98.2 2 55 1 100 0 165 1 171 225 WP_182104611.1 aminopeptidase, partial [Niallia taxi] diamond 330 107 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Niallia Niallia taxi
29714170 29714170 PRJNA645397_P_NODE_7890_length_184_cov_1.059259_g7817_i0 PRJNA645397 7890 184 1.059259 1.94903656 Bacteria 2 Bacteria Bacteria 72.4 9.55e-15   NR WP_275233503.1 1280 g7817 i0 100 2.93478260869565 36 0 58.7 0 75 182 1 36 WP_275233503.1 hypothetical protein [Staphylococcus aureus] diamond 540 72.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32167947 32167947 PRJNA645397_P_NODE_7038_length_194_cov_1.613793_g6965_i0 PRJNA645397 7038 194 1.613793 3.13075842 Butyrivibrio sp. MB2 28121 Bacteria Bacteria 43.5 0.0106   NR WP_026524841.1 1280678 g6965 i0 44.7 0.587628865979381 38 21 58.8 0 150 37 706 743 WP_026524841.1 hypothetical protein [Butyrivibrio sp. MB2005] diamond 114 43.5 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Butyrivibrio Butyrivibrio sp. MB2005
32326327 32326327 PRJNA645397_P_NODE_10579_length_164_cov_0.904348_g10506_i0 PRJNA645397 10579 164 0.904348 1.48313072 Listeria monocytogenes 1639 Bacteria Bacteria 50.8 1.22e-6   NR WP_206745231.1 1639 g10506 i0 54.7 0.969512195121951 53 22 97 2 163 5 12 62 WP_206745231.1 hypothetical protein, partial [Listeria monocytogenes] diamond 159 50.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32799221 32799221 PRJNA645397_P_NODE_8540_length_176_cov_1.015748_g8467_i0 PRJNA645397 8540 176 1.015748 1.78771648 Lawsonibacter sp. 2185275 Bacteria Bacteria 50.1 3.36e-5   NR MEA4932380.1 2185275 g8467 i0 50 0.954545454545455 56 23 90.3 2 159 1 89 142 MEA4932380.1 M23 family metallopeptidase [Lawsonibacter sp.] diamond 168 50.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Lawsonibacter Lawsonibacter sp.

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