contig_metadata
25 rows where bioproject = "PRJNA352610", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1668535 | 1668535 | PRJNA352610_P_NODE_2502_length_622_cov_4.562842_g2443_i0 | PRJNA352610 | 2502 | 622 | 4.562842 | 28.38087724 | Clostridium perfringens | 1502 | Bacteria | Bacteria | 254 | 6.99e-83 | NR | MDJ8942385.1 | 1502 | g2443 | i0 | 80.5 | 0.742765273311897 | 154 | 30 | 74.3 | 0 | 487 | 26 | 42 | 195 | MDJ8942385.1 hypothetical protein [Clostridium perfringens] | diamond | 462 | 254 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium perfringens | ||
| 6771674 | 6771674 | PRJNA352610_P_NODE_5806_length_452_cov_4.567282_g5745_i0 | PRJNA352610 | 5806 | 452 | 4.567282 | 20.64411464 | root | 1 | Root_unresolved | Root_unresolved | 187 | 3.07e-58 | NR | MRC56835.1 | 1428 | g5745 | i0 | 80 | 17.9601769911504 | 115 | 22 | 76.3 | 1 | 423 | 79 | 10 | 123 | MRC56835.1 50S ribosomal protein L30e [Bacillus thuringiensis] | diamond | 8118 | 187 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus thuringiensis | ||
| 16971296 | 16971296 | PRJNA352610_P_NODE_27994_length_247_cov_0.885057_g27933_i0 | PRJNA352610 | 27994 | 247 | 0.885057 | 2.18609079 | Streptococcus sp. Marseille-Q6470 | 2972784 | Bacteria | Bacteria | 374 | 4.189999999999998e-99 | NTclustered | gi|2306632708|emb|OX336385.1| | 2972784 | g27933 | i0 | 93.927 | 2.98785425101215 | 247 | 15 | 100 | 0 | 1 | 247 | 231626 | 231380 | Streptococcus sp. Marseille-Q6470 genome assembly, chromosome: contig00001 | blastn | 738 | 374 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus sp. Marseille-Q6470 | ||
| 22747411 | 22747411 | PRJNA352610_P_NODE_11558_length_349_cov_1.054348_g11497_i0 | PRJNA352610 | 11558 | 349 | 1.054348 | 3.67967452 | Bacteria | 2 | Bacteria | Bacteria | 617 | 2.59e-172 | NTclustered | gi|1214725545|gb|CP022247.1| | 1282 | g11497 | i0 | 98.567 | 476.054441260745 | 349 | 5 | 100 | 0 | 1 | 349 | 1787665 | 1787317 | Staphylococcus epidermidis strain AMT chromosome, complete genome | blastn | 166143 | 617 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus epidermidis | ||
| 23345735 | 23345735 | PRJNA352610_P_NODE_239_length_1368_cov_2.465637_g226_i0 | PRJNA352610 | 239 | 1368 | 2.465637 | 33.72991416 | Clostridium perfringens | 1502 | Bacteria | Bacteria | 210 | 5.61e-61 | NR | MDJ8942383.1 | 1502 | g226 | i0 | 70.2 | 0.449561403508772 | 205 | 59 | 45 | 1 | 1051 | 437 | 74 | 276 | MDJ8942383.1 hypothetical protein [Clostridium perfringens] | diamond | 615 | 210 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium perfringens | ||
| 26599659 | 26599659 | PRJNA352610_P_NODE_23261_length_261_cov_1.117021_g23200_i0 | PRJNA352610 | 23261 | 261 | 1.117021 | 2.91542481 | Parasporobacterium sp. | 2740533 | Bacteria | Bacteria | 85.9 | 1.44e-17 | NR | MCF0230466.1 | 2740533 | g23200 | i0 | 56.3 | 0.816091954022989 | 71 | 31 | 81.6 | 0 | 48 | 260 | 29 | 99 | MCF0230466.1 asparaginase [Parasporobacterium sp.] | diamond | 213 | 85.9 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Parasporobacterium | Parasporobacterium sp. | ||
| 27707006 | 27707006 | PRJNA352610_P_NODE_14564_length_320_cov_0.931174_g14503_i0 | PRJNA352610 | 14564 | 320 | 0.931174 | 2.9797568 | Ligilactobacillus sp. WC1T17 | 3158786 | Bacteria | Bacteria | 44.3 | 0.0187 | NR | WP_225355186.1 | 3158786 | g14503 | i0 | 31 | 0.54375 | 58 | 40 | 54.4 | 0 | 205 | 32 | 19 | 76 | WP_225355186.1 hypothetical protein [Ligilactobacillus sp. WC1T17] | diamond | 174 | 44.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Ligilactobacillus | Ligilactobacillus sp. WC1T17 | ||
| 28116964 | 28116964 | PRJNA352610_P_NODE_29285_length_245_cov_0.895349_g29224_i0 | PRJNA352610 | 29285 | 245 | 0.895349 | 2.19360505 | Paenibacillus oceani | 2772510 | Bacteria | Bacteria | 43.1 | 0.0269 | NR | WP_190926862.1 | 2772510 | g29224 | i0 | 40.7 | 0.722448979591837 | 59 | 28 | 67.3 | 2 | 31 | 195 | 239 | 294 | WP_190926862.1 ROK family transcriptional regulator [Paenibacillus oceani] | diamond | 177 | 43.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus oceani | ||
| 28260340 | 28260340 | PRJNA352610_P_NODE_10806_length_358_cov_1.350877_g10745_i0 | PRJNA352610 | 10806 | 358 | 1.350877 | 4.83613966 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 1.1e-9 | NR | MRA76214.1 | 1428 | g10745 | i0 | 66 | 0.837988826815642 | 50 | 14 | 40.2 | 2 | 2 | 145 | 12 | 60 | MRA76214.1 hypothetical protein [Bacillus thuringiensis] | diamond | 300 | 61.2 | 0.993464052287582 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus thuringiensis | ||
| 28748511 | 28748511 | PRJNA352610_P_NODE_207_length_1414_cov_7.827740_g195_i0 | PRJNA352610 | 207 | 1414 | 7.82774 | 110.6842436 | Methylomusa anaerophila | 1930071 | Bacteria | Bacteria | 127 | 4.24e-28 | NR | WP_126308322.1 | 1930071 | g195 | i0 | 27.6 | 1.71004243281471 | 380 | 254 | 78.3 | 7 | 1234 | 128 | 40 | 409 | WP_126308322.1 ammonium transporter [Methylomusa anaerophila] | diamond | 2418 | 127 | 1 | Bacteria | Bacillati | Bacillota | Negativicutes | Selenomonadales | Sporomusaceae | Methylomusa | Methylomusa anaerophila | ||
| 28969620 | 28969620 | PRJNA352610_P_NODE_3148_length_570_cov_1.096579_g3087_i0 | PRJNA352610 | 3148 | 570 | 1.096579 | 6.2505003 | [Eubacterium] hominis | 2764325 | Bacteria | Bacteria | 47 | 0.0165 | NR | WP_187426296.1 | 2764325 | g3087 | i0 | 41.2 | 0.357894736842105 | 68 | 32 | 35.8 | 1 | 324 | 121 | 4 | 63 | WP_187426296.1 Cof-type HAD-IIB family hydrolase [[Eubacterium] hominis] | diamond | 204 | 47 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Amedibacillus | [Eubacterium] hominis | ||
| 29316888 | 29316888 | PRJNA352610_P_NODE_7309_length_416_cov_0.877551_g7248_i0 | PRJNA352610 | 7309 | 416 | 0.877551 | 3.65061216 | Candidatus Mediterraneibacter quadrami | 2838684 | Bacteria | Bacteria | 44.7 | 0.0393 | NR | HJD42471.1 | 2838684 | g7248 | i0 | 22.1 | 1.07451923076923 | 149 | 93 | 90.9 | 3 | 1 | 378 | 102 | 250 | HJD42471.1 site-specific integrase [Candidatus Mediterraneibacter quadrami] | diamond | 447 | 44.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Mediterraneibacter | Candidatus Mediterraneibacter quadrami | ||
| 29902533 | 29902533 | PRJNA352610_P_NODE_7371_length_414_cov_2.563050_g7310_i0 | PRJNA352610 | 7371 | 414 | 2.56305 | 10.611027 | root | 1 | Root_unresolved | Root_unresolved | 205 | 5.41e-63 | NR | MRB67411.1 | 1428 | g7310 | i0 | 78.5 | 34.1884057971015 | 121 | 26 | 87.7 | 0 | 52 | 414 | 11 | 131 | MRB67411.1 30S ribosomal protein S2 [Bacillus thuringiensis] | diamond | 14154 | 206 | 0.995145631067961 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus thuringiensis | ||
| 30232739 | 30232739 | PRJNA352610_P_NODE_21792_length_270_cov_0.923858_g21731_i0 | PRJNA352610 | 21792 | 270 | 0.923858 | 2.4944166 | Sporofaciens musculi | 2681861 | Bacteria | Bacteria | 42.7 | 0.0495 | NR | WP_159750977.1 | 2681861 | g21731 | i0 | 50 | 0.511111111111111 | 46 | 23 | 51.1 | 0 | 187 | 50 | 169 | 214 | WP_159750977.1 MATE family efflux transporter [Sporofaciens musculi] | diamond | 138 | 42.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Sporofaciens | Sporofaciens musculi | ||
| 30264676 | 30264676 | PRJNA352610_P_NODE_28432_length_246_cov_0.890173_g28371_i0 | PRJNA352610 | 28432 | 246 | 0.890173 | 2.18982558 | Halanaerobiales bacterium | 2094029 | Bacteria | Bacteria | 63.5 | 1.86e-9 | NR | MBS3812162.1 | 2094029 | g28371 | i0 | 50 | 0.585365853658537 | 48 | 24 | 58.5 | 0 | 70 | 213 | 1 | 48 | MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] | diamond | 144 | 63.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiales bacterium | ||||
| 31275430 | 31275430 | PRJNA352610_P_NODE_23895_length_257_cov_1.255435_g23834_i0 | PRJNA352610 | 23895 | 257 | 1.255435 | 3.22646795 | Enterococcus faecium | 1352 | Bacteria | Bacteria | 49.3 | 2.15e-4 | NR | WP_334412465.1 | 1352 | g23834 | i0 | 61 | 0.957198443579767 | 82 | 32 | 95.7 | 0 | 3 | 248 | 14 | 95 | WP_334412465.1 hypothetical protein, partial [Enterococcus faecium] | diamond | 246 | 49.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Enterococcus faecium | ||
| 31450934 | 31450934 | PRJNA352610_P_NODE_23256_length_261_cov_1.148936_g23195_i0 | PRJNA352610 | 23256 | 261 | 1.148936 | 2.99872296 | Bacillales | 1385 | Bacteria | Bacteria | 108 | 1.02e-25 | NR | WP_069325903.1 | 44249 | g23195 | i0 | 64.7 | 10.7931034482759 | 85 | 27 | 94.3 | 1 | 248 | 3 | 118 | 202 | WP_069325903.1 MULTISPECIES: NADH-dependent flavin oxidoreductase [Paenibacillus] | diamond | 2817 | 109 | 0.990825688073395 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | |||
| 31545878 | 31545878 | PRJNA352610_P_NODE_996_length_864_cov_1.902655_g952_i0 | PRJNA352610 | 996 | 864 | 1.902655 | 16.4389392 | Bacillota | 1239 | Bacteria | Bacteria | 95.9 | 2.01e-18 | NR | WP_007062230.1 | 217159 | g952 | i0 | 28.4 | 5.80555555555556 | 261 | 164 | 85.8 | 8 | 758 | 18 | 7 | 258 | WP_007062230.1 ammonium transporter [Clostridium carboxidivorans] | diamond | 5016 | 95.9 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium carboxidivorans | ||
| 31767041 | 31767041 | PRJNA352610_P_NODE_27077_length_248_cov_0.880000_g27016_i0 | PRJNA352610 | 27077 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 96.3 | 5.97e-21 | NR | WP_093230995.1 | 46223 | g27016 | i0 | 55.7 | 20.1411290322581 | 79 | 34 | 95.6 | 1 | 10 | 246 | 1024 | 1101 | WP_093230995.1 non-ribosomal peptide synthetase [Thermoflavimicrobium dichotomicum] | diamond | 4995 | 96.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Thermoactinomycetaceae | Thermoflavimicrobium | Thermoflavimicrobium dichotomicum | ||
| 31988490 | 31988490 | PRJNA352610_P_NODE_9758_length_372_cov_1.571906_g9697_i0 | PRJNA352610 | 9758 | 372 | 1.571906 | 5.84749032 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.0262 | NR | WP_185358167.1 | 1640 | g9697 | i0 | 38.5 | 2.00806451612903 | 65 | 36 | 49.2 | 1 | 341 | 159 | 46 | 110 | WP_185358167.1 ATP-binding cassette domain-containing protein [Listeria seeligeri] | diamond | 747 | 44.7 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Listeriaceae | Listeria | Listeria seeligeri | ||
| 32066208 | 32066208 | PRJNA352610_P_NODE_20698_length_276_cov_1.512315_g20637_i0 | PRJNA352610 | 20698 | 276 | 1.512315 | 4.1739894 | Halanaerobiales bacterium | 2094029 | Bacteria | Bacteria | 71.6 | 3.79e-12 | NR | MBS3812162.1 | 2094029 | g20637 | i0 | 50 | 0.91304347826087 | 84 | 41 | 90.2 | 1 | 24 | 272 | 765 | 848 | MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] | diamond | 252 | 71.6 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiales bacterium | ||||
| 32382730 | 32382730 | PRJNA352610_P_NODE_6299_length_439_cov_0.964481_g6238_i0 | PRJNA352610 | 6299 | 439 | 0.964481 | 4.23407159 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 45.4 | 0.0114 | NR | MCI8714955.1 | 2485925 | g6238 | i0 | 32.1 | 0.533029612756264 | 78 | 51 | 53.3 | 1 | 32 | 265 | 2 | 77 | MCI8714955.1 GNAT family N-acetyltransferase [Oscillospiraceae bacterium] | diamond | 234 | 45.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 32541169 | 32541169 | PRJNA352610_P_NODE_28499_length_246_cov_0.890173_g28438_i0 | PRJNA352610 | 28499 | 246 | 0.890173 | 2.18982558 | Bacillota bacterium | 1879010 | Bacteria | Bacteria | 112 | 8.470000000000001e-27 | NR | MDP4145640.1 | 1879010 | g28438 | i0 | 77.6 | 2.42682926829268 | 67 | 15 | 81.7 | 0 | 245 | 45 | 119 | 185 | MDP4145640.1 portal protein [Bacillota bacterium] | diamond | 597 | 112 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 32761411 | 32761411 | PRJNA352610_P_NODE_21240_length_273_cov_1.240000_g21179_i0 | PRJNA352610 | 21240 | 273 | 1.24 | 3.3852 | Neobacillus cucumis | 1740721 | Bacteria | Bacteria | 147 | 4.98e-41 | NR | WP_378575475.1 | 1740721 | g21179 | i0 | 76.4 | 1.96703296703297 | 89 | 21 | 97.8 | 0 | 271 | 5 | 184 | 272 | WP_378575475.1 elongation of very long chain fatty acids protein, partial [Neobacillus cucumis] | diamond | 537 | 147 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Neobacillus | Neobacillus cucumis | ||
| 32824447 | 32824447 | PRJNA352610_P_NODE_29860_length_244_cov_0.900585_g29799_i0 | PRJNA352610 | 29860 | 244 | 0.900585 | 2.1974274 | Halanaerobiales bacterium | 2094029 | Bacteria | Bacteria | 124 | 7.6799999999999996e-31 | NR | MBS3812162.1 | 2094029 | g29799 | i0 | 70.9 | 0.971311475409836 | 79 | 23 | 97.1 | 0 | 237 | 1 | 299 | 377 | MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] | diamond | 237 | 124 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiales bacterium |
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);;