contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA641991" and tax_kingdom = "Bacillati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8271055 | 8271055 | PRJNA641991_S_NODE_4087_length_264_cov_1.186047_g3968_i0 | PRJNA641991 | 4087 | 264 | 1.186047 | 3.13116408 | Eubacteriales | 186802 | Bacteria | Bacteria | 126 | 6.35e-33 | NR | MBD8962269.1 | 2485925 | g3968 | i0 | 70 | 3.60227272727273 | 80 | 24 | 90.9 | 0 | 241 | 2 | 171 | 250 | MBD8962269.1 aspartate--ammonia ligase [Oscillospiraceae bacterium] | diamond | 951 | 126 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 21020150 | 21020150 | PRJNA641991_P_NODE_3737_length_164_cov_0.886957_g3696_i0 | PRJNA641991 | 3737 | 164 | 0.886957 | 1.45460948 | Clostridium | 1485 | Bacteria | Bacteria | 75.5 | 3.61e-14 | NR | MBQ6820692.1 | 1506 | g3696 | i0 | 82.1 | 7.13414634146341 | 39 | 7 | 71.3 | 0 | 162 | 46 | 562 | 600 | MBQ6820692.1 beta-glucuronidase [Clostridium sp.] | diamond | 1170 | 75.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium sp. | ||
| 27030262 | 27030262 | PRJNA641991_S_NODE_7542_length_202_cov_1.333333_g7423_i0 | PRJNA641991 | 7542 | 202 | 1.333333 | 2.69333266 | root | 1 | Root_unresolved | Root_unresolved | 116 | 1.93e-29 | NR | WP_029636754.1 | 1161 | g7423 | i0 | 80.3 | 23.5247524752475 | 66 | 13 | 98 | 0 | 200 | 3 | 159 | 224 | WP_029636754.1 MULTISPECIES: aldo/keto reductase [Nostocales] | diamond | 4752 | 117 | 0.991452991452991 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | ||||
| 27144043 | 27144043 | PRJNA641991_S_NODE_9362_length_185_cov_1.073529_g9243_i0 | PRJNA641991 | 9362 | 185 | 1.073529 | 1.98602865 | Collinsella sp. | 1965294 | Bacteria | Bacteria | 40 | 0.0342 | NR | MFR3450459.1 | 1965294 | g9243 | i0 | 37.3 | 0.827027027027027 | 51 | 31 | 82.7 | 1 | 3 | 155 | 9 | 58 | MFR3450459.1 hypothetical protein [Collinsella sp.] | diamond | 153 | 40 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriales | Coriobacteriaceae | Collinsella | Collinsella sp. | ||
| 27175856 | 27175856 | PRJNA641991_S_NODE_13022_length_165_cov_0.879310_g12903_i0 | PRJNA641991 | 13022 | 165 | 0.87931 | 1.4508615 | Clostridium botulinum | 1491 | Bacteria | Bacteria | 45.1 | 0.00194 | NR | WP_265210576.1 | 1491 | g12903 | i0 | 44.2 | 0.945454545454545 | 52 | 25 | 94.5 | 1 | 157 | 2 | 69 | 116 | WP_265210576.1 CDP-glycerol glycerophosphotransferase family protein [Clostridium botulinum] | diamond | 156 | 45.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium botulinum | ||
| 27302645 | 27302645 | PRJNA641991_S_NODE_5083_length_238_cov_7.793651_g4964_i0 | PRJNA641991 | 5083 | 238 | 7.793651 | 18.54888938 | Erysipelotrichaceae bacterium | 2049044 | Bacteria | Bacteria | 43.1 | 0.0248 | NR | MEA5061696.1 | 2049044 | g4964 | i0 | 33.8 | 0.857142857142857 | 68 | 38 | 79.4 | 2 | 3 | 191 | 183 | 248 | MEA5061696.1 ComEC/Rec2 family competence protein [Erysipelotrichaceae bacterium] | diamond | 204 | 43.1 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Erysipelotrichaceae bacterium | |||
| 27618469 | 27618469 | PRJNA641991_S_NODE_10624_length_175_cov_1.619048_g10505_i0 | PRJNA641991 | 10624 | 175 | 1.619048 | 2.833334 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 57.4 | 1.51e-8 | NR | HYI21055.1 | 2952938 | g10505 | i0 | 52.6 | 0.977142857142857 | 57 | 26 | 96 | 1 | 173 | 6 | 56 | 112 | HYI21055.1 hypothetical protein [Candidatus Limnocylindrales bacterium] | diamond | 171 | 57.4 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 27870822 | 27870822 | PRJNA641991_S_NODE_11825_length_167_cov_2.906780_g11706_i0 | PRJNA641991 | 11825 | 167 | 2.90678 | 4.8543226 | Aquihabitans sp. G128 | 2849779 | Bacteria | Bacteria | 43.5 | 0.00704 | NR | WP_216998947.1 | 2849779 | g11706 | i0 | 41.7 | 1.07784431137725 | 60 | 19 | 80.8 | 2 | 29 | 163 | 210 | 268 | WP_216998947.1 methionyl-tRNA formyltransferase [Aquihabitans sp. G128] | diamond | 180 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Iamiaceae | Aquihabitans | Aquihabitans sp. G128 | ||
| 28072596 | 28072596 | PRJNA641991_S_NODE_5065_length_239_cov_1.326316_g4946_i0 | PRJNA641991 | 5065 | 239 | 1.326316 | 3.16989524 | FCB group | 1783270 | Bacteria | Bacteria | 97.1 | 1.1e-23 | NR | WP_285918567.1 | 604315 | g4946 | i0 | 58.6 | 7.05439330543933 | 70 | 28 | 87.9 | 1 | 16 | 225 | 40 | 108 | WP_285918567.1 Mth938-like domain-containing protein [Actinomadura sp. OS1-43] | diamond | 1686 | 97.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Thermomonosporaceae | Actinomadura | Actinomadura sp. OS1-43 | ||
| 28104083 | 28104083 | PRJNA641991_S_NODE_4245_length_259_cov_1.942857_g4126_i0 | PRJNA641991 | 4245 | 259 | 1.942857 | 5.03199963 | Bacillales | 1385 | Bacteria | Bacteria | 50.1 | 1.19e-4 | NR | WP_101967018.1 | 28031 | g4126 | i0 | 41.3 | 3.15057915057915 | 63 | 33 | 68.3 | 1 | 82 | 258 | 286 | 348 | WP_101967018.1 S-layer homology domain-containing protein [Lysinibacillus fusiformis] | diamond | 816 | 50.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Lysinibacillus | Lysinibacillus fusiformis | ||
| 28167484 | 28167484 | PRJNA641991_S_NODE_14745_length_161_cov_0.910714_g14626_i0 | PRJNA641991 | 14745 | 161 | 0.910714 | 1.46624954 | Bacillati | 1783272 | Bacteria | Bacteria | 44.7 | 0.00255 | NR | MDQ2985888.1 | 2033014 | g14626 | i0 | 42.6 | 1.95652173913043 | 54 | 30 | 98.8 | 1 | 1 | 159 | 40 | 93 | MDQ2985888.1 elongation factor Tu [Armatimonadota bacterium] | diamond | 315 | 44.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28249682 | 28249682 | PRJNA641991_S_NODE_7946_length_197_cov_44.581081_g7827_i0 | PRJNA641991 | 7946 | 197 | 44.581081 | 87.82472957 | Bacillus sp. MHSD17 | 3026937 | Bacteria | Bacteria | 41.2 | 0.0421 | NR | MDD1371223.1 | 3026937 | g7827 | i0 | 54.5 | 0.50253807106599 | 33 | 15 | 50.3 | 0 | 102 | 4 | 119 | 151 | MDD1371223.1 PH domain-containing protein [Bacillus sp. MHSD17] | diamond | 99 | 41.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus sp. MHSD17 | ||
| 28281172 | 28281172 | PRJNA641991_S_NODE_13406_length_164_cov_0.886957_g13287_i0 | PRJNA641991 | 13406 | 164 | 0.886957 | 1.45460948 | Clostridium sp. | 1506 | Bacteria | Bacteria | 42.4 | 0.0162 | NR | MEG0297248.1 | 1506 | g13287 | i0 | 51.1 | 2.14024390243902 | 45 | 20 | 78.7 | 1 | 142 | 14 | 23 | 67 | MEG0297248.1 ATP-binding cassette domain-containing protein [Clostridium sp.] | diamond | 351 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium sp. | ||
| 28798669 | 28798669 | PRJNA641991_S_NODE_14847_length_161_cov_0.910714_g14728_i0 | PRJNA641991 | 14847 | 161 | 0.910714 | 1.46624954 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.00898 | NR | HEU5005883.1 | 2811413 | g14728 | i0 | 37.5 | 5.18012422360248 | 48 | 30 | 89.4 | 0 | 9 | 152 | 234 | 281 | HEU5005883.1 ATP-binding protein [Jatrophihabitantaceae bacterium] | diamond | 834 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Jatrophihabitantales | Jatrophihabitantaceae | Jatrophihabitantaceae bacterium | |||
| 28849541 | 28849541 | PRJNA641991_S_NODE_6188_length_220_cov_0.894737_g6069_i0 | PRJNA641991 | 6188 | 220 | 0.894737 | 1.9684214 | Nostoc sp. | 1180 | Bacteria | Bacteria | 122 | 7.23e-34 | NR | WP_334858291.1 | 1180 | g6069 | i0 | 80 | 1.89545454545455 | 70 | 14 | 95.5 | 0 | 220 | 11 | 76 | 145 | WP_334858291.1 coactosin family protein [Nostoc sp.] | diamond | 417 | 122 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nostocaceae | Nostoc | Nostoc sp. | |
| 29102439 | 29102439 | PRJNA641991_S_NODE_10368_length_177_cov_1.593750_g10249_i0 | PRJNA641991 | 10368 | 177 | 1.59375 | 2.8209375 | Kineosporiaceae bacterium | 2487580 | Bacteria | Bacteria | 60.5 | 7.92e-9 | NR | HVN12469.1 | 2487580 | g10249 | i0 | 57.1 | 3.64406779661017 | 56 | 23 | 94.9 | 1 | 3 | 170 | 300 | 354 | HVN12469.1 trypsin-like peptidase domain-containing protein [Kineosporiaceae bacterium] | diamond | 645 | 60.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kineosporiales | Kineosporiaceae | Kineosporiaceae bacterium | |||
| 30713110 | 30713110 | PRJNA641991_S_NODE_13034_length_165_cov_0.879310_g12915_i0 | PRJNA641991 | 13034 | 165 | 0.87931 | 1.4508615 | Cytobacillus citreus | 2833586 | Bacteria | Bacteria | 60.5 | 6.62e-9 | NR | WP_213103100.1 | 2833586 | g12915 | i0 | 70.7 | 0.745454545454545 | 41 | 11 | 74.5 | 1 | 146 | 24 | 309 | 348 | WP_213103100.1 enoyl-CoA hydratase/isomerase family protein [Cytobacillus citreus] | diamond | 123 | 60.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Cytobacillus | Cytobacillus citreus | ||
| 30851796 | 30851796 | PRJNA641991_S_NODE_6534_length_215_cov_1.228916_g6415_i0 | PRJNA641991 | 6534 | 215 | 1.228916 | 2.6421694 | Anaerolinea | 233189 | Bacteria | Bacteria | 97.1 | 1.9600000000000003e-21 | NR | WP_070105127.1 | 167964 | g6415 | i0 | 74.3 | 3.90697674418605 | 70 | 18 | 97.7 | 0 | 2 | 211 | 310 | 379 | WP_070105127.1 fasciclin domain-containing protein [Anaerolinea thermophila] | diamond | 840 | 97.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea thermophila | ||
| 30934444 | 30934444 | PRJNA641991_S_NODE_8574_length_192_cov_0.930070_g8455_i0 | PRJNA641991 | 8574 | 192 | 0.93007 | 1.7857344 | Pseudoflavonifractor capillosus | 106588 | Bacteria | Bacteria | 41.2 | 0.0161 | NR | WP_204898878.1 | 106588 | g8455 | i0 | 33.3 | 0.984375 | 63 | 42 | 98.4 | 0 | 4 | 192 | 15 | 77 | WP_204898878.1 hypothetical protein [Pseudoflavonifractor capillosus] | diamond | 189 | 41.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Pseudoflavonifractor | Pseudoflavonifractor capillosus | ||
| 31060960 | 31060960 | PRJNA641991_P_NODE_2895_length_178_cov_0.875969_g2854_i0 | PRJNA641991 | 2895 | 178 | 0.875969 | 1.55922482 | Actinokineospora sp. UTMC 2448 | 2268449 | Bacteria | Bacteria | 41.6 | 0.0403 | NR | UVS78122.1 | 2268449 | g2854 | i0 | 51.4 | 0.623595505617977 | 37 | 16 | 59 | 1 | 68 | 172 | 77 | 113 | UVS78122.1 hypothetical protein Actkin_01846 [Actinokineospora sp. UTMC 2448] | diamond | 111 | 41.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinokineospora | Actinokineospora sp. UTMC 2448 | ||
| 32021837 | 32021837 | PRJNA641991_S_NODE_10698_length_175_cov_0.960317_g10579_i0 | PRJNA641991 | 10698 | 175 | 0.960317 | 1.68055475 | Bacillati | 1783272 | Bacteria | Bacteria | 92 | 6.22e-20 | NR | MDI9461189.1 | 1879010 | g10579 | i0 | 73.2 | 13.3028571428571 | 56 | 15 | 96 | 0 | 173 | 6 | 425 | 480 | MDI9461189.1 pyruvate, phosphate dikinase [Bacillota bacterium] | diamond | 2328 | 92 | 1 | Bacteria | Bacillati | Bacillota | Bacillota bacterium | ||||||
| 32072791 | 32072791 | PRJNA641991_S_NODE_14158_length_162_cov_1.123894_g14039_i0 | PRJNA641991 | 14158 | 162 | 1.123894 | 1.82070828 | Streptomyces sp. NRRL F-5727 | 1463871 | Bacteria | Bacteria | 43.5 | 0.00684 | NR | WP_051716732.1 | 1463871 | g14039 | i0 | 45.1 | 1.88888888888889 | 51 | 26 | 94.4 | 1 | 4 | 156 | 322 | 370 | WP_051716732.1 MATE family efflux transporter [Streptomyces sp. NRRL F-5727] | diamond | 306 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NRRL F-5727 | ||
| 32389152 | 32389152 | PRJNA641991_P_NODE_3379_length_166_cov_0.871795_g3338_i0 | PRJNA641991 | 3379 | 166 | 0.871795 | 1.4471797 | Corynebacterium dentalis | 2014528 | Bacteria | Bacteria | 41.2 | 0.0465 | NR | WP_312097338.1 | 2014528 | g3338 | i0 | 73.9 | 0.41566265060241 | 23 | 6 | 41.6 | 0 | 70 | 2 | 1 | 23 | WP_312097338.1 esterase/lipase family protein [Corynebacterium dentalis] | diamond | 69 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium dentalis |
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);;