contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA825466" and tax_phylum = "Actinomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4648798 | 4648798 | PRJNA825466_P_NODE_17644_length_250_cov_0.870056_g17543_i0 | PRJNA825466 | 17644 | 250 | 0.870056 | 2.17514 | Brevibacterium mcbrellneri | 53363 | Bacteria | Bacteria | 173 | 4.53e-51 | NR | WP_005882029.1 | 53363 | g17543 | i0 | 100 | 0.996 | 83 | 0 | 99.6 | 0 | 250 | 2 | 65 | 147 | WP_005882029.1 succinyl-diaminopimelate desuccinylase [Brevibacterium mcbrellneri] | diamond | 249 | 173 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Brevibacteriaceae | Brevibacterium | Brevibacterium mcbrellneri | ||
| 4648842 | 4648842 | PRJNA825466_P_NODE_29024_length_241_cov_0.916667_g28923_i0 | PRJNA825466 | 29024 | 241 | 0.916667 | 2.20916747 | Yimella lutea | 587872 | Bacteria | Bacteria | 172 | 6.68e-50 | NR | WP_141927259.1 | 587872 | g28923 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 2 | 241 | 359 | 438 | WP_141927259.1 PIG-L family deacetylase [Yimella lutea] | diamond | 240 | 172 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermacoccaceae | Yimella | Yimella lutea | ||
| 11024126 | 11024126 | PRJNA825466_P_NODE_17289_length_250_cov_1.740113_g17188_i0 | PRJNA825466 | 17289 | 250 | 1.740113 | 4.3502825 | Iamia | 467975 | Bacteria | Bacteria | 115 | 1.54e-28 | NR | HEU5149848.1 | 2722710 | g17188 | i0 | 63.9 | 1.992 | 83 | 30 | 99.6 | 0 | 2 | 250 | 122 | 204 | HEU5149848.1 geranylgeranyl reductase family protein [Iamia sp.] | diamond | 498 | 115 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Iamiaceae | Iamia | Iamia sp. | ||
| 13573947 | 13573947 | PRJNA825466_P_NODE_13011_length_269_cov_1.571429_g12910_i0 | PRJNA825466 | 13011 | 269 | 1.571429 | 4.22714401 | Enemella evansiae | 2016499 | Bacteria | Bacteria | 172 | 1.05e-50 | NR | WP_094404689.1 | 2016499 | g12910 | i0 | 100 | 0.992565055762082 | 89 | 0 | 99.3 | 0 | 269 | 3 | 2 | 90 | WP_094404689.1 membrane protein insertase YidC [Enemella evansiae] | diamond | 267 | 172 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Enemella | Enemella evansiae | ||
| 27339057 | 27339057 | PRJNA825466_P_NODE_3963_length_382_cov_1.304207_g3862_i0 | PRJNA825466 | 3963 | 382 | 1.304207 | 4.98207074 | Micromonosporaceae bacterium | 1873464 | Bacteria | Bacteria | 57 | 1.79e-6 | NR | MDT5026064.1 | 1873464 | g3862 | i0 | 35 | 0.965968586387435 | 123 | 64 | 96.6 | 4 | 374 | 6 | 566 | 672 | MDT5026064.1 hypothetical protein [Micromonosporaceae bacterium] | diamond | 369 | 57 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonosporaceae bacterium | |||
| 27370847 | 27370847 | PRJNA825466_P_NODE_12543_length_272_cov_1.221106_g12442_i0 | PRJNA825466 | 12543 | 272 | 1.221106 | 3.32140832 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 89.4 | 7.55e-19 | NR | MDQ3895293.1 | 2900548 | g12442 | i0 | 86.7 | 2.94485294117647 | 45 | 6 | 49.6 | 0 | 137 | 271 | 3 | 47 | MDQ3895293.1 sugar phosphate isomerase/epimerase [Actinomycetota bacterium] | diamond | 801 | 89.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 27591767 | 27591767 | PRJNA825466_P_NODE_23104_length_246_cov_0.890173_g23003_i0 | PRJNA825466 | 23104 | 246 | 0.890173 | 2.18982558 | Corynebacterium parakroppenstedtii | 2828363 | Bacteria | Bacteria | 42.4 | 0.0116 | NR | WP_236882086.1 | 2828363 | g23003 | i0 | 44.7 | 0.573170731707317 | 47 | 26 | 57.3 | 0 | 231 | 91 | 47 | 93 | WP_236882086.1 hypothetical protein, partial [Corynebacterium parakroppenstedtii] | diamond | 141 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium parakroppenstedtii | ||
| 27812818 | 27812818 | PRJNA825466_P_NODE_12864_length_270_cov_1.553299_g12763_i0 | PRJNA825466 | 12864 | 270 | 1.553299 | 4.1939073 | Streptosporangiaceae bacterium | 2339230 | Bacteria | Bacteria | 55.1 | 2.06e-6 | NR | MBV9445290.1 | 2339230 | g12763 | i0 | 46.3 | 2.12222222222222 | 67 | 33 | 72.2 | 2 | 195 | 1 | 201 | 266 | MBV9445290.1 hypothetical protein [Streptosporangiaceae bacterium] | diamond | 573 | 55.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Streptosporangiaceae bacterium | |||
| 27875647 | 27875647 | PRJNA825466_P_NODE_5965_length_335_cov_0.858779_g5864_i0 | PRJNA825466 | 5965 | 335 | 0.858779 | 2.87690965 | Actinomadura nitritigenes | 134602 | Bacteria | Bacteria | 44.3 | 0.0295 | NR | WP_208265424.1 | 134602 | g5864 | i0 | 39.2 | 0.707462686567164 | 79 | 39 | 69 | 3 | 55 | 285 | 273 | 344 | WP_208265424.1 PrsW family glutamic-type intramembrane protease [Actinomadura nitritigenes] | diamond | 237 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Thermomonosporaceae | Actinomadura | Actinomadura nitritigenes | ||
| 28073725 | 28073725 | PRJNA825466_P_NODE_10545_length_284_cov_1.459716_g10444_i0 | PRJNA825466 | 10545 | 284 | 1.459716 | 4.14559344 | Corynebacterium | 1716 | Bacteria | Bacteria | 85.9 | 3.9e-17 | NR | WP_071057432.1 | 38289 | g10444 | i0 | 82.1 | 2.95774647887324 | 56 | 10 | 59.2 | 0 | 189 | 22 | 1 | 56 | WP_071057432.1 hypothetical protein [Corynebacterium jeikeium] | diamond | 840 | 85.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium jeikeium | ||
| 28547698 | 28547698 | PRJNA825466_P_NODE_13047_length_269_cov_1.357143_g12946_i0 | PRJNA825466 | 13047 | 269 | 1.357143 | 3.65071467 | Bacteria | 2 | Bacteria | Bacteria | 111 | 2.32e-27 | NR | WP_101386122.1 | 1938858 | g12946 | i0 | 62.8 | 4.817843866171 | 86 | 32 | 95.9 | 0 | 11 | 268 | 151 | 236 | WP_101386122.1 carbamate kinase [Streptomyces sp. TLI_146] | diamond | 1296 | 112 | 0.991071428571429 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. TLI_146 | ||
| 28696863 | 28696863 | PRJNA825466_P_NODE_27567_length_242_cov_0.911243_g27466_i0 | PRJNA825466 | 27567 | 242 | 0.911243 | 2.20520806 | Corynebacterium jeikeium | 38289 | Bacteria | Bacteria | 80.1 | 2.57e-15 | NR | WP_034985158.1 | 38289 | g27466 | i0 | 60.5 | 0.942148760330578 | 76 | 18 | 94.2 | 2 | 228 | 1 | 50 | 113 | WP_034985158.1 membrane protein [Corynebacterium jeikeium] | diamond | 228 | 80.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium jeikeium | ||
| 28854357 | 28854357 | PRJNA825466_P_NODE_26388_length_243_cov_0.905882_g26287_i0 | PRJNA825466 | 26388 | 243 | 0.905882 | 2.20129326 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 42.7 | 0.016 | NR | WP_329707424.1 | 35761 | g26287 | i0 | 35.3 | 0.62962962962963 | 51 | 33 | 63 | 0 | 219 | 67 | 2 | 52 | WP_329707424.1 SRPBCC family protein [Nocardioides sp.] | diamond | 153 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 29170406 | 29170406 | PRJNA825466_P_NODE_20809_length_247_cov_13.701149_g20708_i0 | PRJNA825466 | 20809 | 247 | 13.701149 | 33.84183803 | Corynebacterium parakroppenstedtii | 2828363 | Bacteria | Bacteria | 47.4 | 1.31e-4 | NR | WP_236882086.1 | 2828363 | g20708 | i0 | 47.8 | 0.558704453441296 | 46 | 24 | 55.9 | 0 | 232 | 95 | 47 | 92 | WP_236882086.1 hypothetical protein, partial [Corynebacterium parakroppenstedtii] | diamond | 138 | 47.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium parakroppenstedtii | ||
| 29833313 | 29833313 | PRJNA825466_P_NODE_26711_length_243_cov_0.905882_g26610_i0 | PRJNA825466 | 26711 | 243 | 0.905882 | 2.20129326 | Rhodococcus sp. NPDC | 3346536 | Bacteria | Bacteria | 79 | 6.75e-15 | NR | WP_378578527.1 | 3346536 | g26610 | i0 | 53.7 | 1.01234567901235 | 82 | 36 | 100 | 2 | 243 | 1 | 110 | 190 | WP_378578527.1 prolyl oligopeptidase family serine peptidase [Rhodococcus sp. NPDC058521] | diamond | 246 | 79 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus sp. NPDC058521 | ||
| 30023043 | 30023043 | PRJNA825466_P_NODE_22851_length_246_cov_0.890173_g22750_i0 | PRJNA825466 | 22851 | 246 | 0.890173 | 2.18982558 | Corynebacterium parakroppenstedtii | 2828363 | Bacteria | Bacteria | 50.4 | 8.22e-6 | NR | WP_236882086.1 | 2828363 | g22750 | i0 | 54.8 | 0.51219512195122 | 42 | 19 | 51.2 | 0 | 216 | 91 | 52 | 93 | WP_236882086.1 hypothetical protein, partial [Corynebacterium parakroppenstedtii] | diamond | 126 | 50.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium parakroppenstedtii | ||
| 30663401 | 30663401 | PRJNA825466_P_NODE_20553_length_248_cov_0.880000_g20452_i0 | PRJNA825466 | 20553 | 248 | 0.88 | 2.1824 | Bacillati | 1783272 | Bacteria | Bacteria | 86.3 | 1.02e-17 | NR | MCB0864022.1 | 1909295 | g20452 | i0 | 54.3 | 4.63306451612903 | 81 | 36 | 98 | 1 | 6 | 248 | 115 | 194 | MCB0864022.1 intradiol ring-cleavage dioxygenase [Solirubrobacterales bacterium] | diamond | 1149 | 86.3 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacterales bacterium | ||||
| 30686214 | 30686214 | PRJNA825466_P_NODE_10293_length_286_cov_1.361502_g10192_i0 | PRJNA825466 | 10293 | 286 | 1.361502 | 3.89389572 | Candidatus Yaniella excrementavium | 2838771 | Bacteria | Bacteria | 191 | 1.0999999999999998e-56 | NR | HIY86692.1 | 2838771 | g10192 | i0 | 98.9 | 0.996503496503496 | 95 | 1 | 99.7 | 0 | 286 | 2 | 20 | 114 | HIY86692.1 YdiU family protein [Candidatus Yaniella excrementavium] | diamond | 285 | 191 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Yaniella | Candidatus Yaniella excrementavium | ||
| 30970844 | 30970844 | PRJNA825466_P_NODE_22414_length_246_cov_0.890173_g22313_i0 | PRJNA825466 | 22414 | 246 | 0.890173 | 2.18982558 | Promicromonospora umidemergens | 629679 | Bacteria | Bacteria | 152 | 4.29e-41 | NR | WP_253871511.1 | 629679 | g22313 | i0 | 84 | 1.97560975609756 | 81 | 13 | 98.8 | 0 | 244 | 2 | 327 | 407 | WP_253871511.1 calcineurin-like phosphoesterase C-terminal domain-containing protein [Promicromonospora umidemergens] | diamond | 486 | 152 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Promicromonosporaceae | Promicromonospora | Promicromonospora umidemergens | ||
| 31381792 | 31381792 | PRJNA825466_P_NODE_28096_length_241_cov_1.702381_g27995_i0 | PRJNA825466 | 28096 | 241 | 1.702381 | 4.10273821 | Arachnia sp. | 2801846 | Bacteria | Bacteria | 43.1 | 0.0265 | NR | HOA25975.1 | 2801846 | g27995 | i0 | 53.2 | 0.5850622406639 | 47 | 21 | 58.5 | 1 | 57 | 197 | 599 | 644 | HOA25975.1 hypothetical protein [Arachnia sp.] | diamond | 141 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Arachnia | Arachnia sp. | ||
| 31444932 | 31444932 | PRJNA825466_P_NODE_23236_length_245_cov_2.546512_g23135_i0 | PRJNA825466 | 23236 | 245 | 2.546512 | 6.2389544 | Allokutzneria oryzae | 1378989 | Bacteria | Bacteria | 70.9 | 1.25e-12 | NR | WP_377859761.1 | 1378989 | g23135 | i0 | 49.4 | 7.60408163265306 | 83 | 36 | 94.3 | 2 | 244 | 14 | 126 | 208 | WP_377859761.1 glycoside hydrolase family 75 protein [Allokutzneria oryzae] | diamond | 1863 | 70.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Allokutzneria | Allokutzneria oryzae | ||
| 31444934 | 31444934 | PRJNA825466_S_NODE_2036_length_241_cov_0.916667_g2030_i0 | PRJNA825466 | 2036 | 241 | 0.916667 | 2.20916747 | Micromonospora zhanjiangensis | 1522057 | Bacteria | Bacteria | 90.9 | 6.85e-20 | NR | MFD0823276.1 | 1522057 | g2030 | i0 | 51.3 | 0.946058091286307 | 76 | 37 | 94.6 | 0 | 11 | 238 | 1 | 76 | MFD0823276.1 replication initiation factor domain-containing protein [Micromonospora zhanjiangensis] | diamond | 228 | 90.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora zhanjiangensis | ||
| 31919396 | 31919396 | PRJNA825466_P_NODE_19937_length_248_cov_0.880000_g19836_i0 | PRJNA825466 | 19937 | 248 | 0.88 | 2.1824 | Amycolatopsis sp. VS83 | 37632 | Bacteria | Bacteria | 52.4 | 4.62e-6 | NR | WP_409186722.1 | 2652442 | g19836 | i0 | 44.9 | 0.834677419354839 | 69 | 30 | 78.6 | 4 | 195 | 1 | 56 | 120 | WP_409186722.1 HNH endonuclease signature motif containing protein [Amycolatopsis sp. VS8301801F10] | diamond | 207 | 52.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Amycolatopsis | Amycolatopsis sp. VS8301801F10 | ||
| 32331069 | 32331069 | PRJNA825466_P_NODE_27739_length_242_cov_0.911243_g27638_i0 | PRJNA825466 | 27739 | 242 | 0.911243 | 2.20520806 | Cutibacterium acnes | 1747 | Bacteria | Bacteria | 40.4 | 0.0417 | NR | MES6266278.1 | 1747 | g27638 | i0 | 76.2 | 0.260330578512397 | 21 | 5 | 26 | 0 | 63 | 1 | 13 | 33 | MES6266278.1 hypothetical protein [Cutibacterium acnes] | diamond | 63 | 40.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 32741324 | 32741324 | PRJNA825466_P_NODE_15440_length_255_cov_2.258242_g15339_i0 | PRJNA825466 | 15440 | 255 | 2.258242 | 5.7585171 | Pseudoclavibacter sp. | 1915061 | Bacteria | Bacteria | 43.5 | 0.0192 | NR | MFT8636664.1 | 1915061 | g15339 | i0 | 39.1 | 0.811764705882353 | 69 | 35 | 80 | 2 | 208 | 5 | 92 | 154 | MFT8636664.1 type 1 glutamine amidotransferase [Pseudoclavibacter sp.] | diamond | 207 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Pseudoclavibacter | Pseudoclavibacter 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);;