contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA509429" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26697215 | 26697215 | PRJNA509429_P_NODE_30841_length_220_cov_1.135135_g30013_i0 | PRJNA509429 | 30841 | 220 | 1.135135 | 2.497297 | unclassified Streptomyces | 2593676 | Bacteria | Bacteria | 42 | 0.0276 | NR | WP_141712220.1 | 2593676 | g30013 | i0 | 41.2 | 0.695454545454545 | 51 | 20 | 69.5 | 1 | 25 | 177 | 92 | 132 | WP_141712220.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces] | diamond | 153 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | |||
| 27013814 | 27013814 | PRJNA509429_P_NODE_30262_length_223_cov_1.313830_g29434_i0 | PRJNA509429 | 30262 | 223 | 1.31383 | 2.9298409 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 42.7 | 0.0278 | NR | MEE8376588.1 | 2080302 | g29434 | i0 | 37.1 | 0.834080717488789 | 62 | 39 | 83.4 | 0 | 2 | 187 | 210 | 271 | MEE8376588.1 hypothetical protein [Acidimicrobiia bacterium] | diamond | 186 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 27298453 | 27298453 | PRJNA509429_P_NODE_11383_length_426_cov_20.672634_g10565_i0 | PRJNA509429 | 11383 | 426 | 20.672634 | 88.06542084 | Fructilactobacillus sanfranciscensis | 1625 | Bacteria | Bacteria | 82.4 | 5.05e-17 | NR | POH17992.1 | 1625 | g10565 | i0 | 78.6 | 0.492957746478873 | 70 | 15 | 49.3 | 0 | 1 | 210 | 62 | 131 | POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] | diamond | 210 | 82.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Fructilactobacillus | Fructilactobacillus sanfranciscensis | ||
| 27298454 | 27298454 | PRJNA509429_P_NODE_31843_length_214_cov_4.865922_g31015_i0 | PRJNA509429 | 31843 | 214 | 4.865922 | 10.41307308 | Staphylococcus aureus | 1280 | Bacteria | Bacteria | 65.5 | 6.9e-12 | NR | MCS4580470.1 | 1280 | g31015 | i0 | 100 | 0.602803738317757 | 43 | 0 | 60.3 | 0 | 4 | 132 | 1 | 43 | MCS4580470.1 hypothetical protein [Staphylococcus aureus] | diamond | 129 | 65.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus aureus | ||
| 27393373 | 27393373 | PRJNA509429_P_NODE_34563_length_202_cov_1.179641_g33735_i0 | PRJNA509429 | 34563 | 202 | 1.179641 | 2.38287482 | Arthrobacter globiformis NBRC 12137 | 1077972 | Bacteria | Bacteria | 42 | 0.0416 | NR | GAB15080.1 | 1077972 | g33735 | i0 | 45 | 0.891089108910891 | 60 | 30 | 89.1 | 1 | 1 | 180 | 319 | 375 | GAB15080.1 hypothetical protein ARGLB_080_01455 [Arthrobacter globiformis NBRC 12137] | diamond | 180 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter globiformis | ||
| 27614412 | 27614412 | PRJNA509429_P_NODE_28804_length_232_cov_1.086294_g27976_i0 | PRJNA509429 | 28804 | 232 | 1.086294 | 2.52020208 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 44.3 | 0.00317 | NR | WP_324396383.1 | 1785 | g27976 | i0 | 45.8 | 0.620689655172414 | 48 | 20 | 59.5 | 2 | 61 | 198 | 42 | 85 | WP_324396383.1 hypothetical protein [Mycobacterium sp.] | diamond | 144 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 27772344 | 27772344 | PRJNA509429_P_NODE_47884_length_159_cov_0.959677_g47056_i0 | PRJNA509429 | 47884 | 159 | 0.959677 | 1.52588643 | Dactylosporangium thailandense | 47849 | Bacteria | Bacteria | 41.2 | 0.0364 | NR | BFE59973.1 | 47849 | g47056 | i0 | 60.6 | 0.622641509433962 | 33 | 13 | 62.3 | 0 | 59 | 157 | 5 | 37 | BFE59973.1 hypothetical protein GCM10020063_044990 [Dactylosporangium thailandense] | diamond | 99 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Dactylosporangium | Dactylosporangium thailandense | ||
| 28119364 | 28119364 | PRJNA509429_P_NODE_28605_length_233_cov_1.237374_g27777_i0 | PRJNA509429 | 28605 | 233 | 1.237374 | 2.88308142 | Priestia megaterium | 1404 | Bacteria | Bacteria | 41.2 | 0.017 | NR | QDZ82736.1 | 1404 | g27777 | i0 | 52.2 | 0.592274678111588 | 46 | 18 | 56.7 | 3 | 225 | 94 | 20 | 63 | QDZ82736.1 hypothetical protein D0440_26115 [Priestia megaterium] | diamond | 138 | 41.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Priestia | Priestia megaterium | ||
| 28403594 | 28403594 | PRJNA509429_P_NODE_46246_length_163_cov_1.000000_g45418_i0 | PRJNA509429 | 46246 | 163 | 1 | 1.63 | Humibacter sp. | 1940291 | Bacteria | Bacteria | 41.6 | 0.017 | NR | HWU47418.1 | 1940291 | g45418 | i0 | 42.5 | 1.34355828220859 | 40 | 18 | 73.6 | 1 | 163 | 44 | 19 | 53 | HWU47418.1 hypothetical protein [Humibacter sp.] | diamond | 219 | 41.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Humibacter | Humibacter sp. | ||
| 28719408 | 28719408 | PRJNA509429_P_NODE_34487_length_202_cov_1.886228_g33659_i0 | PRJNA509429 | 34487 | 202 | 1.886228 | 3.81018056 | Streptomyces albospinus | 285515 | Bacteria | Bacteria | 41.2 | 0.0151 | NR | WP_189308268.1 | 285515 | g33659 | i0 | 40.4 | 0.698019801980198 | 47 | 24 | 69.8 | 1 | 142 | 2 | 3 | 45 | WP_189308268.1 hypothetical protein [Streptomyces albospinus] | diamond | 141 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces albospinus | ||
| 29476804 | 29476804 | PRJNA509429_P_NODE_42410_length_173_cov_3.217391_g41582_i0 | PRJNA509429 | 42410 | 173 | 3.217391 | 5.56608643 | Streptomyces melanogenes | 67326 | Bacteria | Bacteria | 39.3 | 0.0298 | NR | WP_190088150.1 | 67326 | g41582 | i0 | 53.1 | 0.554913294797688 | 32 | 12 | 50.3 | 1 | 84 | 170 | 4 | 35 | WP_190088150.1 hypothetical protein [Streptomyces melanogenes] | diamond | 96 | 39.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces melanogenes | ||
| 29697701 | 29697701 | PRJNA509429_P_NODE_17930_length_324_cov_7.982699_g17102_i0 | PRJNA509429 | 17930 | 324 | 7.982699 | 25.86394476 | uncultured Microbacterium sp. | 191216 | Bacteria | Bacteria | 43.9 | 0.036 | NR | WP_295840303.1 | 191216 | g17102 | i0 | 32.6 | 0.824074074074074 | 89 | 48 | 81.5 | 3 | 19 | 282 | 4 | 81 | WP_295840303.1 flavin monoamine oxidase family protein [uncultured Microbacterium sp.] | diamond | 267 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | uncultured Microbacterium sp. | ||
| 29761152 | 29761152 | PRJNA509429_P_NODE_31671_length_215_cov_5.150000_g30843_i0 | PRJNA509429 | 31671 | 215 | 5.15 | 11.0725 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 40.8 | 0.047 | NR | MEZ4667052.1 | 2052143 | g30843 | i0 | 38.3 | 0.837209302325581 | 60 | 36 | 83.7 | 1 | 26 | 205 | 34 | 92 | MEZ4667052.1 hypothetical protein [Anaerolineae bacterium] | diamond | 180 | 40.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29761153 | 29761153 | PRJNA509429_P_NODE_37811_length_189_cov_1.103896_g36983_i0 | PRJNA509429 | 37811 | 189 | 1.103896 | 2.08636344 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 43.1 | 0.0123 | NR | HEY8759750.1 | 2052315 | g36983 | i0 | 50 | 0.476190476190476 | 30 | 15 | 47.6 | 0 | 175 | 86 | 77 | 106 | HEY8759750.1 FAD:protein FMN transferase [Candidatus Dormiibacterota bacterium] | diamond | 90 | 43.1 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29982362 | 29982362 | PRJNA509429_P_NODE_9891_length_462_cov_4.711944_g5835_i2 | PRJNA509429 | 9891 | 462 | 4.711944 | 21.76918128 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 42.7 | 0.0475 | NR | WP_362953358.1 | 3155267 | g5835 | i2 | 48.1 | 0.350649350649351 | 54 | 23 | 31.8 | 2 | 156 | 302 | 22 | 75 | WP_362953358.1 hypothetical protein [Streptomyces sp. NPDC048669] | diamond | 162 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC048669 | ||
| 30456667 | 30456667 | PRJNA509429_P_NODE_42653_length_173_cov_1.021739_g41825_i0 | PRJNA509429 | 42653 | 173 | 1.021739 | 1.76760847 | Desulfosporosinus sp. | 157907 | Bacteria | Bacteria | 48.9 | 9.93e-6 | NR | MDR3540328.1 | 157907 | g41825 | i0 | 92.6 | 0.468208092485549 | 27 | 2 | 46.8 | 0 | 160 | 80 | 2 | 28 | MDR3540328.1 hypothetical protein [Desulfosporosinus sp.] | diamond | 81 | 48.9 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Desulfitobacteriaceae | Desulfosporosinus | Desulfosporosinus sp. | ||
| 30866980 | 30866980 | PRJNA509429_P_NODE_31154_length_218_cov_2.000000_g30326_i0 | PRJNA509429 | 31154 | 218 | 2 | 4.36 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42 | 0.045 | NR | TMD25539.1 | 2026724 | g30326 | i0 | 42.9 | 0.674311926605505 | 49 | 28 | 67.4 | 0 | 185 | 39 | 184 | 232 | TMD25539.1 MAG: DUF2029 domain-containing protein [Chloroflexota bacterium] | diamond | 147 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31246214 | 31246214 | PRJNA509429_P_NODE_43935_length_169_cov_1.246269_g43107_i0 | PRJNA509429 | 43935 | 169 | 1.246269 | 2.10619461 | Corynebacterium efficiens YS-314 | 196164 | Bacteria | Bacteria | 50.1 | 3.05e-5 | NR | BAC18353.1 | 196164 | g43107 | i0 | 50 | 1.75739644970414 | 50 | 25 | 88.8 | 0 | 18 | 167 | 110 | 159 | BAC18353.1 conserved hypothetical protein [Corynebacterium efficiens YS-314] | diamond | 297 | 50.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium efficiens | ||
| 31341135 | 31341135 | PRJNA509429_P_NODE_29576_length_227_cov_2.250000_g28748_i0 | PRJNA509429 | 29576 | 227 | 2.25 | 5.1075 | Bacillus sp. SRB_28 | 1969378 | Bacteria | Bacteria | 40.8 | 0.0239 | NR | RAN86401.1 | 1969378 | g28748 | i0 | 71.4 | 0.370044052863436 | 28 | 7 | 37 | 1 | 2 | 85 | 1 | 27 | RAN86401.1 hypothetical protein B5P41_29460 [Bacillus sp. SRB_28] | diamond | 84 | 40.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus sp. SRB_28 | ||
| 31910471 | 31910471 | PRJNA509429_P_NODE_23877_length_266_cov_1.670996_g23049_i0 | PRJNA509429 | 23877 | 266 | 1.670996 | 4.44484936 | Carboxydothermus islandicus | 661089 | Bacteria | Bacteria | 51.2 | 5.28e-6 | NR | GAV26061.1 | 661089 | g23049 | i0 | 48.3 | 0.676691729323308 | 60 | 31 | 67.7 | 0 | 67 | 246 | 36 | 95 | GAV26061.1 putative uncharacterized protein, partial [Carboxydothermus islandicus] | diamond | 180 | 51.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Thermoanaerobacterales | Thermoanaerobacteraceae | Carboxydothermus | Carboxydothermus islandicus | ||
| 31910472 | 31910472 | PRJNA509429_P_NODE_38897_length_185_cov_1.066667_g38069_i0 | PRJNA509429 | 38897 | 185 | 1.066667 | 1.97333395 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 60.1 | 1.16e-8 | NR | MCL6509819.1 | 2052143 | g38069 | i0 | 71.4 | 0.681081081081081 | 42 | 12 | 68.1 | 0 | 185 | 60 | 280 | 321 | MCL6509819.1 P-type conjugative transfer ATPase TrbB [Anaerolineae bacterium] | diamond | 126 | 60.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32195249 | 32195249 | PRJNA509429_P_NODE_33938_length_204_cov_8.644970_g33110_i0 | PRJNA509429 | 33938 | 204 | 8.64497 | 17.6357388 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 47 | 7.1e-4 | NR | HEX4539557.1 | 2201156 | g33110 | i0 | 39.7 | 1.07352941176471 | 73 | 31 | 97.1 | 2 | 5 | 202 | 169 | 235 | HEX4539557.1 hypothetical protein [Acidimicrobiales bacterium] | diamond | 219 | 47 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 32385096 | 32385096 | PRJNA509429_P_NODE_28619_length_232_cov_23.258883_g27791_i0 | PRJNA509429 | 28619 | 232 | 23.258883 | 53.96060856 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 42.4 | 0.043 | NR | WP_383302644.1 | 3346067 | g27791 | i0 | 34.4 | 0.827586206896552 | 64 | 40 | 82.8 | 1 | 28 | 219 | 163 | 224 | WP_383302644.1 sigma-70 family RNA polymerase sigma factor [Streptomyces sp. NPDC057249] | diamond | 192 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC057249 | ||
| 32385098 | 32385098 | PRJNA509429_P_NODE_42579_length_173_cov_1.384058_g41751_i0 | PRJNA509429 | 42579 | 173 | 1.384058 | 2.39442034 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 40.4 | 0.0146 | NR | MBA2615054.1 | 2900548 | g41751 | i0 | 47.4 | 0.658959537572254 | 38 | 20 | 65.9 | 0 | 39 | 152 | 2 | 39 | MBA2615054.1 hypothetical protein [Actinomycetota bacterium] | diamond | 114 | 40.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 32763759 | 32763759 | PRJNA509429_P_NODE_15980_length_349_cov_25.754777_g15152_i0 | PRJNA509429 | 15980 | 349 | 25.754777 | 89.88417173 | Fructilactobacillus sanfranciscensis | 1625 | Bacteria | Bacteria | 121 | 1.0799999999999999e-32 | NR | POH17992.1 | 1625 | g15152 | i0 | 65.2 | 0.988538681948424 | 115 | 40 | 98.9 | 0 | 2 | 346 | 3 | 117 | POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] | diamond | 345 | 121 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Fructilactobacillus | Fructilactobacillus sanfranciscensis |
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);;