contig_metadata
24 rows where bioproject = "PRJNA645397" and tax_phylum = "Bacillota"
This data as json, CSV (advanced)
| 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 | |||
| 2434338 | 2434338 | PRJNA645397_P_NODE_7322_length_191_cov_1.084507_g7249_i0 | PRJNA645397 | 7322 | 191 | 1.084507 | 2.07140837 | Staphylococcus | 1279 | Bacteria | Bacteria | 292 | 8.89e-75 | NTclustered | gi|1835046049|gb|CP051643.1| | 29380 | g7249 | i0 | 97.661 | 513.251308900524 | 171 | 3 | 90 | 1 | 21 | 191 | 62417 | 62248 | Staphylococcus caprae strain SY333 chromosome, complete genome | blastn | 98031 | 294 | 0.993197278911565 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus caprae | ||
| 4447360 | 4447360 | PRJNA645397_P_NODE_9544_length_168_cov_0.873950_g9471_i0 | PRJNA645397 | 9544 | 168 | 0.87395 | 1.468236 | Salinicoccus halodurans | 407035 | Bacteria | Bacteria | 254 | 3.6e-63 | NTclustered | gi|820755876|gb|CP011366.1| | 407035 | g9471 | i0 | 98.601 | 1.18452380952381 | 143 | 2 | 85 | 0 | 26 | 168 | 362630 | 362772 | Salinicoccus halodurans strain H3B36, complete genome | blastn | 199 | 254 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Salinicoccus | Salinicoccus halodurans | ||
| 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 | ||
| 7537069 | 7537069 | PRJNA645397_P_NODE_9446_length_168_cov_0.873950_g9373_i0 | PRJNA645397 | 9446 | 168 | 0.87395 | 1.468236 | Bacillus | 1386 | Bacteria | Bacteria | 305 | 9.81e-79 | NTclustered | gi|2212750716|gb|CP063975.1| | 1396 | g9373 | i0 | 99.405 | 100 | 168 | 1 | 100 | 0 | 1 | 168 | 180963 | 180796 | Bacillus cereus strain N435-1 chromosome, complete genome | blastn | 16800 | 305 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus cereus | ||
| 8272868 | 8272868 | PRJNA645397_S_NODE_927_length_193_cov_1.048611_g925_i0 | PRJNA645397 | 927 | 193 | 1.048611 | 2.02381923 | Ruoffia tabacinasalis | 87458 | Bacteria | Bacteria | 324 | 3.19e-84 | NTclustered | gi|2686201366|gb|CP144682.1| | 87458 | g925 | i0 | 96.891 | 5.22279792746114 | 193 | 6 | 100 | 0 | 1 | 193 | 2242587 | 2242395 | Ruoffia tabacinasalis strain jzb001 chromosome, complete genome | blastn | 1008 | 324 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Aerococcaceae | Ruoffia | Ruoffia tabacinasalis | ||
| 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 | ||
| 21022025 | 21022025 | PRJNA645397_P_NODE_8277_length_179_cov_0.984615_g8204_i0 | PRJNA645397 | 8277 | 179 | 0.984615 | 1.76246085 | Salinicoccus halodurans | 407035 | Bacteria | Bacteria | 268 | 1.3799999999999999e-67 | NTclustered | gi|820755876|gb|CP011366.1| | 407035 | g8204 | i0 | 97.468 | 0.88268156424581 | 158 | 2 | 88 | 2 | 22 | 179 | 1086101 | 1086256 | Salinicoccus halodurans strain H3B36, complete genome | blastn | 158 | 268 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Salinicoccus | Salinicoccus halodurans | ||
| 21022034 | 21022034 | PRJNA645397_P_NODE_9937_length_166_cov_0.888889_g9864_i0 | PRJNA645397 | 9937 | 166 | 0.888889 | 1.47555574 | Clostridioides difficile | 1496 | Bacteria | Bacteria | 263 | 5.9e-66 | NTclustered | gi|2062474862|gb|CP072118.1| | 1496 | g9864 | i0 | 95.181 | 70.789156626506 | 166 | 8 | 100 | 0 | 1 | 166 | 4058394 | 4058229 | Clostridioides difficile isolate MAR286 chromosome, complete genome | blastn | 11751 | 263 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Peptostreptococcaceae | Clostridioides | Clostridioides difficile | ||
| 24111063 | 24111063 | PRJNA645397_P_NODE_11119_length_162_cov_0.876106_g11046_i0 | PRJNA645397 | 11119 | 162 | 0.876106 | 1.41929172 | Bacillus | 1386 | Bacteria | Bacteria | 294 | 2.03e-75 | NTclustered | gi|2582827010|gb|CP135060.1| | 1396 | g11046 | i0 | 99.383 | 101 | 162 | 1 | 100 | 0 | 1 | 162 | 2094077 | 2093916 | Bacillus cereus strain B126_1 chromosome, complete genome | blastn | 16362 | 294 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus cereus | ||
| 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
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);;