contig_metadata
29 rows where bioproject = "PRJNA929522", tax_phylum = "Bacillota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9833221 | 9833221 | PRJNA929522_S_NODE_3728_length_349_cov_1.778986_g3658_i0 | PRJNA929522 | 3728 | 349 | 1.778986 | 6.20866114 | Candidatus Enterococcus mangumiae | 2230878 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|2707316588|gb|CP147250.1| | 2230878 | g3658 | i0 | 100 | 0.0802292263610315 | 28 | 0 | 8 | 0 | 266 | 293 | 2257289 | 2257262 | Candidatus Enterococcus mangumiae strain DIV1094 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Candidatus Enterococcus mangumiae | ||
| 10182064 | 10182064 | PRJNA929522_S_NODE_1848_length_488_cov_1.773494_g1778_i0 | PRJNA929522 | 1848 | 488 | 1.773494 | 8.65465072 | Heyndrickxia ginsengihumi | 363870 | Bacteria | Bacteria | 72 | 1.47e-11 | NR | WP_251406586.1 | 363870 | g1778 | i0 | 48.4 | 2.45286885245902 | 93 | 38 | 54.1 | 4 | 273 | 10 | 24 | 111 | WP_251406586.1 S8 family peptidase [Heyndrickxia ginsengihumi] | diamond | 1197 | 72 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Heyndrickxia | Heyndrickxia ginsengihumi | ||
| 12732858 | 12732858 | PRJNA929522_S_NODE_6090_length_287_cov_1.719626_g6020_i0 | PRJNA929522 | 6090 | 287 | 1.719626 | 4.93532662 | root | 1 | Root_unresolved | Root_unresolved | 531 | 2.799999999999999e-146 | NTclustered | gi|1796975023|gb|CP033086.1| | 1280 | g6020 | i0 | 100 | 98.801393728223 | 287 | 0 | 100 | 0 | 1 | 287 | 2463321 | 2463607 | Staphylococcus aureus strain WH9628 chromosome | blastn | 28356 | 531 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus aureus | ||
| 13658999 | 13658999 | PRJNA929522_S_NODE_6371_length_282_cov_1.473684_g6301_i0 | PRJNA929522 | 6371 | 282 | 1.473684 | 4.15578888 | Bacillus paranthracis | 2026186 | Bacteria | Bacteria | 150 | 8.97e-32 | NTclustered | gi|2168785877|gb|CP089743.1| | 2026186 | g6301 | i0 | 80.928 | 87.9929078014184 | 194 | 33 | 68 | 4 | 91 | 282 | 2904482 | 2904291 | Bacillus paranthracis strain SHOU-BC01 chromosome, complete genome | blastn | 24814 | 150 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus paranthracis | ||
| 16208258 | 16208258 | PRJNA929522_S_NODE_1433_length_549_cov_2.909664_g1363_i0 | PRJNA929522 | 1433 | 549 | 2.909664 | 15.97405536 | Bacteria | 2 | Bacteria | Bacteria | 99.4 | 1.68e-20 | NR | EEG31940.1 | 537013 | g1363 | i0 | 44.3 | 8.78688524590164 | 106 | 59 | 57.9 | 0 | 548 | 231 | 392 | 497 | EEG31940.1 chaperone protein DnaK [[Clostridium] methylpentosum DSM 5476] | diamond | 4824 | 99.8 | 0.995991983967936 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | [Clostridium] methylpentosum | |||
| 16208314 | 16208314 | PRJNA929522_S_NODE_8253_length_253_cov_2.822222_g8183_i0 | PRJNA929522 | 8253 | 253 | 2.822222 | 7.14022166 | Trichococcus flocculiformis | 82803 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2621701196|emb|OY759718.1| | 82803 | g8183 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 130 | 157 | 1191779 | 1191752 | MAG: Trichococcus flocculiformis isolate 659e37ff-3402-4023-a990-0c9469b16b9d genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Carnobacteriaceae | Trichococcus | Trichococcus flocculiformis | ||
| 26739552 | 26739552 | PRJNA929522_S_NODE_2781_length_400_cov_2.018349_g2711_i0 | PRJNA929522 | 2781 | 400 | 2.018349 | 8.073396 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 77.4 | 1.51e-13 | NR | MBP3802252.1 | 2044939 | g2711 | i0 | 48.4 | 1.17 | 64 | 31 | 48 | 1 | 256 | 65 | 314 | 375 | MBP3802252.1 hypothetical protein [Clostridia bacterium] | diamond | 468 | 77.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 26866889 | 26866889 | PRJNA929522_S_NODE_8461_length_251_cov_1.084270_g8391_i0 | PRJNA929522 | 8461 | 251 | 1.08427 | 2.7215177 | Bacilli bacterium | 1903720 | Bacteria | Bacteria | 131 | 4.89e-34 | NR | MBQ3001054.1 | 1903720 | g8391 | i0 | 75.6 | 3.9203187250996 | 82 | 20 | 98 | 0 | 1 | 246 | 324 | 405 | MBQ3001054.1 asparagine--tRNA ligase [Bacilli bacterium] | diamond | 984 | 131 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacilli bacterium | |||||
| 26961410 | 26961410 | PRJNA929522_S_NODE_1542_length_529_cov_2.190789_g1472_i0 | PRJNA929522 | 1542 | 529 | 2.190789 | 11.58927381 | Paenibacillus sp. SYP-B4298 | 2996034 | Bacteria | Bacteria | 96.3 | 1.83e-19 | NR | WP_270170223.1 | 2996034 | g1472 | i0 | 35.1 | 3.90737240075614 | 205 | 90 | 93.6 | 7 | 2 | 496 | 269 | 470 | WP_270170223.1 Ig-like domain-containing protein [Paenibacillus sp. SYP-B4298] | diamond | 2067 | 96.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus sp. SYP-B4298 | ||
| 26961412 | 26961412 | PRJNA929522_S_NODE_2122_length_456_cov_3.033943_g2052_i0 | PRJNA929522 | 2122 | 456 | 3.033943 | 13.83478008 | Ammoniphilus oxalaticus | 66863 | Bacteria | Bacteria | 196 | 2.33e-61 | NR | WP_120188376.1 | 66863 | g2052 | i0 | 69.9 | 17.4342105263158 | 133 | 40 | 87.5 | 0 | 442 | 44 | 1 | 133 | WP_120188376.1 nucleoside-diphosphate kinase [Ammoniphilus oxalaticus] | diamond | 7950 | 196 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Ammoniphilus | Ammoniphilus oxalaticus | ||
| 27663989 | 27663989 | PRJNA929522_S_NODE_8804_length_249_cov_0.875000_g8734_i0 | PRJNA929522 | 8804 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 87.8 | 4.55e-18 | NR | MBR2138771.1 | 1903720 | g8734 | i0 | 55.3 | 8.90361445783133 | 76 | 31 | 91.6 | 1 | 236 | 9 | 80 | 152 | MBR2138771.1 asparagine--tRNA ligase [Bacilli bacterium] | diamond | 2217 | 87.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacilli bacterium | |||||
| 27783209 | 27783209 | PRJNA929522_S_NODE_6044_length_288_cov_1.530233_g5974_i0 | PRJNA929522 | 6044 | 288 | 1.530233 | 4.40707104 | Clostridiaceae bacterium | 1898204 | Bacteria | Bacteria | 72.4 | 1.19e-12 | NR | NLM50675.1 | 1898204 | g5974 | i0 | 37.2 | 3.64583333333333 | 94 | 58 | 97.9 | 1 | 283 | 2 | 128 | 220 | NLM50675.1 S8 family serine peptidase [Clostridiaceae bacterium] | diamond | 1050 | 72.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridiaceae bacterium | |||
| 28169039 | 28169039 | PRJNA929522_S_NODE_5645_length_296_cov_1.367713_g5575_i0 | PRJNA929522 | 5645 | 296 | 1.367713 | 4.04843048 | PVC group | 1783257 | Bacteria | Bacteria | 48.1 | 8.85e-4 | NR | MBO8127033.1 | 1879010 | g5575 | i0 | 34.1 | 1.77364864864865 | 91 | 52 | 88.2 | 4 | 287 | 27 | 240 | 326 | MBO8127033.1 sodium-translocating pyrophosphatase [Bacillota bacterium] | diamond | 525 | 48.5 | 0.991752577319588 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 28509286 | 28509286 | PRJNA929522_S_NODE_9487_length_245_cov_0.895349_g9417_i0 | PRJNA929522 | 9487 | 245 | 0.895349 | 2.19360505 | Clostridiaceae bacterium | 1898204 | Bacteria | Bacteria | 43.1 | 0.0273 | NR | NLD49844.1 | 1898204 | g9417 | i0 | 37.3 | 0.624489795918367 | 51 | 31 | 61.2 | 1 | 212 | 63 | 393 | 443 | NLD49844.1 radical SAM protein [Clostridiaceae bacterium] | diamond | 153 | 43.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridiaceae bacterium | |||
| 28674251 | 28674251 | PRJNA929522_S_NODE_2167_length_451_cov_1.886243_g2097_i0 | PRJNA929522 | 2167 | 451 | 1.886243 | 8.50695593 | FCB group | 1783270 | Bacteria | Bacteria | 200 | 3.1100000000000007e-59 | NR | WP_325394107.1 | 49981 | g2097 | i0 | 60.5 | 22.5166297117517 | 147 | 58 | 97.8 | 0 | 9 | 449 | 104 | 250 | WP_325394107.1 aldehyde dehydrogenase [Desulfitobacterium sp.] | diamond | 10155 | 202 | 0.99009900990099 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Desulfitobacteriaceae | Desulfitobacterium | Desulfitobacterium sp. | ||
| 29077719 | 29077719 | PRJNA929522_S_NODE_6748_length_276_cov_0.945813_g6678_i0 | PRJNA929522 | 6748 | 276 | 0.945813 | 2.61044388 | Acidaminobacter sp. JC | 1872102 | Bacteria | Bacteria | 81.3 | 7.85e-16 | NR | WP_240840040.1 | 2530199 | g6678 | i0 | 50 | 1.40217391304348 | 64 | 32 | 69.6 | 0 | 205 | 14 | 56 | 119 | WP_240840040.1 fatty acid desaturase [Acidaminobacter sp. JC074] | diamond | 387 | 81.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Acidaminobacteraceae | Acidaminobacter | Acidaminobacter sp. JC074 | ||
| 29361780 | 29361780 | PRJNA929522_S_NODE_2269_length_442_cov_2.051491_g2199_i0 | PRJNA929522 | 2269 | 442 | 2.051491 | 9.06759022 | Clostridiales Family XIII bacterium | 3107375 | Bacteria | Bacteria | 87 | 1.11e-16 | NR | MDR0596872.1 | 2137877 | g2199 | i0 | 36 | 5.83710407239819 | 139 | 80 | 94.3 | 3 | 420 | 4 | 46 | 175 | MDR0596872.1 Ig-like domain-containing protein [Eubacteriales Family XIII. Incertae Sedis bacterium] | diamond | 2580 | 87 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales Family XIII. Incertae Sedis | Clostridiales Family XIII bacterium | |||
| 29361788 | 29361788 | PRJNA929522_S_NODE_8469_length_251_cov_0.921348_g8399_i0 | PRJNA929522 | 8469 | 251 | 0.921348 | 2.31258348 | Paenibacillus paridis | 2583376 | Bacteria | Bacteria | 43.5 | 0.0215 | NR | WP_139993458.1 | 2583376 | g8399 | i0 | 38.6 | 0.681274900398406 | 57 | 34 | 66.9 | 1 | 171 | 4 | 303 | 359 | WP_139993458.1 hypothetical protein [Paenibacillus paridis] | diamond | 171 | 43.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus paridis | ||
| 29772012 | 29772012 | PRJNA929522_S_NODE_2131_length_455_cov_2.306283_g2061_i0 | PRJNA929522 | 2131 | 455 | 2.306283 | 10.49358765 | Candidatus Allofournierella merdigallinarum | 2838594 | Bacteria | Bacteria | 92 | 1.95e-18 | NR | HJA25952.1 | 2838594 | g2061 | i0 | 38.3 | 1.97802197802198 | 149 | 84 | 94.3 | 3 | 439 | 11 | 290 | 436 | HJA25952.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Allofournierella merdigallinarum] | diamond | 900 | 92 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Allofournierella | Candidatus Allofournierella merdigallinarum | ||
| 29866988 | 29866988 | PRJNA929522_S_NODE_7871_length_259_cov_1.123656_g7801_i0 | PRJNA929522 | 7871 | 259 | 1.123656 | 2.91026904 | Vallitalea pronyensis | 1348613 | Bacteria | Bacteria | 99 | 5.02e-22 | NR | WP_212694071.1 | 1348613 | g7801 | i0 | 54.2 | 1.94594594594595 | 83 | 33 | 96.1 | 1 | 252 | 4 | 293 | 370 | WP_212694071.1 aldehyde dehydrogenase [Vallitalea pronyensis] | diamond | 504 | 99 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Vallitaleaceae | Vallitalea | Vallitalea pronyensis | ||
| 30309749 | 30309749 | PRJNA929522_S_NODE_7792_length_260_cov_0.919786_g7722_i0 | PRJNA929522 | 7792 | 260 | 0.919786 | 2.3914436 | Paenibacillus graminis | 189425 | Bacteria | Bacteria | 77.4 | 2.96e-14 | NR | WP_052415696.1 | 189425 | g7722 | i0 | 51.3 | 0.923076923076923 | 80 | 39 | 92.3 | 0 | 1 | 240 | 886 | 965 | WP_052415696.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Paenibacillus graminis] | diamond | 240 | 77.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus graminis | ||
| 30688265 | 30688265 | PRJNA929522_S_NODE_8293_length_253_cov_1.283333_g8223_i0 | PRJNA929522 | 8293 | 253 | 1.283333 | 3.24683249 | Staphylococcus pseudintermedius | 283734 | Bacteria | Bacteria | 49.3 | 1.83e-4 | NR | WP_323695889.1 | 283734 | g8223 | i0 | 37.2 | 0.924901185770751 | 78 | 45 | 91.3 | 2 | 20 | 250 | 71 | 145 | WP_323695889.1 class I SAM-dependent methyltransferase [Staphylococcus pseudintermedius] | diamond | 234 | 49.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus pseudintermedius | ||
| 31067719 | 31067719 | PRJNA929522_S_NODE_4255_length_332_cov_0.942085_g4185_i0 | PRJNA929522 | 4255 | 332 | 0.942085 | 3.1277222 | Chengkuizengella sediminis | 1885917 | Bacteria | Bacteria | 85.9 | 7.96e-17 | NR | WP_162036560.1 | 1885917 | g4185 | i0 | 41.9 | 3.84036144578313 | 105 | 60 | 94.9 | 1 | 1 | 315 | 737 | 840 | WP_162036560.1 S-layer homology domain-containing protein [Chengkuizengella sediminis] | diamond | 1275 | 85.9 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Chengkuizengella | Chengkuizengella sediminis | ||
| 31415329 | 31415329 | PRJNA929522_S_NODE_8656_length_250_cov_0.870056_g8586_i0 | PRJNA929522 | 8656 | 250 | 0.870056 | 2.17514 | Virgibacillus necropolis | 163877 | Bacteria | Bacteria | 65.5 | 3.72e-10 | NR | WP_089533605.1 | 163877 | g8586 | i0 | 53.2 | 0.744 | 62 | 29 | 74.4 | 0 | 248 | 63 | 364 | 425 | WP_089533605.1 MFS transporter [Virgibacillus necropolis] | diamond | 186 | 65.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Virgibacillus | Virgibacillus necropolis | ||
| 31573660 | 31573660 | PRJNA929522_S_NODE_5736_length_294_cov_2.217195_g5666_i0 | PRJNA929522 | 5736 | 294 | 2.217195 | 6.5185533 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 77.8 | 3.09e-14 | NR | MBP3802252.1 | 2044939 | g5666 | i0 | 57.4 | 0.551020408163265 | 54 | 21 | 55.1 | 1 | 131 | 292 | 314 | 365 | MBP3802252.1 hypothetical protein [Clostridia bacterium] | diamond | 162 | 77.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 32048032 | 32048032 | PRJNA929522_S_NODE_9278_length_246_cov_0.890173_g9208_i0 | PRJNA929522 | 9278 | 246 | 0.890173 | 2.18982558 | Streptococcus pseudopneumoniae | 257758 | Bacteria | Bacteria | 40.8 | 0.0247 | NR | WP_196310494.1 | 257758 | g9208 | i0 | 40.7 | 0.658536585365854 | 54 | 28 | 62.2 | 2 | 194 | 42 | 3 | 55 | WP_196310494.1 hypothetical protein, partial [Streptococcus pseudopneumoniae] | diamond | 162 | 40.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus pseudopneumoniae | ||
| 32269649 | 32269649 | PRJNA929522_S_NODE_8138_length_255_cov_1.263736_g8068_i0 | PRJNA929522 | 8138 | 255 | 1.263736 | 3.2225268 | Aneurinibacillus | 55079 | Bacteria | Bacteria | 42.4 | 0.0459 | NR | WP_057899844.1 | 55079 | g8068 | i0 | 65.6 | 0.376470588235294 | 32 | 11 | 37.6 | 0 | 188 | 93 | 119 | 150 | WP_057899844.1 MULTISPECIES: LysE family translocator [Aneurinibacillus] | diamond | 96 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Aneurinibacillus | |||
| 32554576 | 32554576 | PRJNA929522_S_NODE_9599_length_244_cov_0.900585_g9529_i0 | PRJNA929522 | 9599 | 244 | 0.900585 | 2.1974274 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 66.6 | 9.4e-11 | NR | MBQ3149921.1 | 2044939 | g9529 | i0 | 43.4 | 0.934426229508197 | 76 | 41 | 93.4 | 1 | 233 | 6 | 81 | 154 | MBQ3149921.1 polysaccharide deacetylase family protein [Clostridia bacterium] | diamond | 228 | 66.6 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 32907651 | 32907651 | PRJNA929522_S_NODE_2260_length_443_cov_1.248649_g2190_i0 | PRJNA929522 | 2260 | 443 | 1.248649 | 5.53151507 | Bacillati | 1783272 | Bacteria | Bacteria | 98.2 | 1.45e-20 | NR | WP_044355812.1 | 1458845 | g2190 | i0 | 45.5 | 1.84875846501129 | 132 | 60 | 81.9 | 4 | 401 | 39 | 538 | 668 | WP_044355812.1 S-layer homology domain-containing protein [Paenibacillus sp. E194] | diamond | 819 | 98.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus sp. E194 |
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);;