contig_metadata
21 rows where bioproject = "PRJNA832865", tax_phylum = "Actinomycetota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 822129 | 822129 | PRJNA832865_S_NODE_102501_length_246_cov_0.890173_g97415_i0 | PRJNA832865 | 102501 | 246 | 0.890173 | 2.18982558 | Schaalia sp. HMT-877 | 3059029 | Bacteria | Bacteria | 117 | 7.77e-22 | NTclustered | gi|2557565758|gb|CP130059.1| | 3059029 | g97415 | i0 | 85.088 | 0.463414634146341 | 114 | 17 | 46 | 0 | 133 | 246 | 327598 | 327711 | Schaalia sp. HMT-877 strain F0543 chromosome, complete genome | blastn | 114 | 117 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Schaalia | Schaalia sp. HMT-877 | ||
| 822149 | 822149 | PRJNA832865_S_NODE_104401_length_245_cov_0.895349_g99315_i0 | PRJNA832865 | 104401 | 245 | 0.895349 | 2.19360505 | Corynebacterium accolens | 38284 | Bacteria | Bacteria | 305 | 1.54e-78 | NTclustered | gi|2550484788|gb|CP100380.1| | 38284 | g99315 | i0 | 89.431 | 25.0530612244898 | 246 | 21 | 99 | 4 | 1 | 243 | 1386880 | 1387123 | Corynebacterium accolens strain CA3 chromosome | blastn | 6138 | 305 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium accolens | ||
| 4652331 | 4652331 | PRJNA832865_S_NODE_94564_length_251_cov_0.865169_g89478_i0 | PRJNA832865 | 94564 | 251 | 0.865169 | 2.17157419 | Actinomycetes | 1760 | Bacteria | Bacteria | 113 | 7.030000000000001e-27 | NR | WP_218026015.1 | 282684 | g89478 | i0 | 70.2 | 38.4262948207171 | 84 | 24 | 99.2 | 1 | 1 | 249 | 1895 | 1978 | WP_218026015.1 SDR family NAD(P)-dependent oxidoreductase [Nocardia miyunensis] | diamond | 9645 | 113 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia miyunensis | ||
| 8475058 | 8475058 | PRJNA832865_S_NODE_110607_length_241_cov_0.916667_g105521_i0 | PRJNA832865 | 110607 | 241 | 0.916667 | 2.20916747 | Mycobacteroides salmoniphilum | 404941 | Bacteria | Bacteria | 390 | 4.05e-104 | NTclustered | gi|1626698579|gb|CP024633.1| | 404941 | g105521 | i0 | 95.851 | 14.7966804979253 | 241 | 10 | 100 | 0 | 1 | 241 | 3054817 | 3055057 | Mycobacteroides salmoniphilum strain DSM 43276 chromosome | blastn | 3566 | 390 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacteroides | Mycobacteroides salmoniphilum | ||
| 12302466 | 12302466 | PRJNA832865_S_NODE_50090_length_358_cov_2.712281_g45004_i0 | PRJNA832865 | 50090 | 358 | 2.712281 | 9.70996598 | Rothia dentocariosa | 2047 | Bacteria | Bacteria | 52.8 | 0.034 | NTclustered | gi|2894503601|gb|CP178332.1| | 2047 | g45004 | i0 | 96.875 | 0.0893854748603352 | 32 | 0 | 9 | 1 | 125 | 156 | 1169337 | 1169367 | Rothia dentocariosa strain SOSUI018 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia dentocariosa | ||
| 12708234 | 12708234 | PRJNA832865_S_NODE_111010_length_241_cov_0.916667_g105924_i0 | PRJNA832865 | 111010 | 241 | 0.916667 | 2.20916747 | Cutibacterium | 1912216 | Bacteria | Bacteria | 446 | 8.519999999999999e-121 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g105924 | i0 | 100 | 56.7344398340249 | 241 | 0 | 100 | 0 | 1 | 241 | 1553996 | 1554236 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 13673 | 446 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 12708242 | 12708242 | PRJNA832865_S_NODE_36010_length_457_cov_1.375000_g30926_i0 | PRJNA832865 | 36010 | 457 | 1.375 | 6.28375 | Gardnerella | 2701 | Bacteria | Bacteria | 52.8 | 0.044 | NTclustered | gi|2769796964|gb|CP160093.1| | 2702 | g30926 | i0 | 100 | 0.12253829321663 | 28 | 0 | 6 | 0 | 159 | 186 | 1116982 | 1116955 | Gardnerella vaginalis strain 1683_1263_1_CBA4 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Bifidobacteriales | Bifidobacteriaceae | Gardnerella | Gardnerella vaginalis | ||
| 25455199 | 25455199 | PRJNA832865_S_NODE_102300_length_246_cov_0.890173_g97214_i0 | PRJNA832865 | 102300 | 246 | 0.890173 | 2.18982558 | Cutibacterium | 1912216 | Bacteria | Bacteria | 427 | 3.16e-115 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g97214 | i0 | 97.967 | 146.024390243902 | 246 | 5 | 100 | 0 | 1 | 246 | 1982906 | 1983151 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 35922 | 427 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 26928053 | 26928053 | PRJNA832865_S_NODE_92242_length_254_cov_0.961326_g87156_i0 | PRJNA832865 | 92242 | 254 | 0.961326 | 2.44176804 | Micromonosporaceae bacterium | 1873464 | Bacteria | Bacteria | 48.5 | 3.64e-4 | NR | MBX6355373.1 | 1873464 | g87156 | i0 | 45 | 0.708661417322835 | 60 | 31 | 70.9 | 2 | 219 | 40 | 86 | 143 | MBX6355373.1 nitroreductase family protein [Micromonosporaceae bacterium] | diamond | 180 | 48.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonosporaceae bacterium | |||
| 27094741 | 27094741 | PRJNA832865_S_NODE_102502_length_246_cov_0.890173_g97416_i0 | PRJNA832865 | 102502 | 246 | 0.890173 | 2.18982558 | Streptomyces | 1883 | Bacteria | Bacteria | 42.7 | 0.0166 | NR | WP_127828415.1 | 1883 | g97416 | i0 | 52.3 | 4.32926829268293 | 44 | 19 | 51.2 | 1 | 34 | 159 | 48 | 91 | WP_127828415.1 MULTISPECIES: DUF742 domain-containing protein [Streptomyces] | diamond | 1065 | 43.1 | 0.990719257540603 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | |||
| 27844129 | 27844129 | PRJNA832865_S_NODE_83824_length_267_cov_1.922680_g78738_i0 | PRJNA832865 | 83824 | 267 | 1.92268 | 5.1335556 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 42.7 | 0.0454 | NR | WP_386889645.1 | 3347064 | g78738 | i0 | 32.5 | 0.865168539325843 | 77 | 49 | 83.1 | 1 | 8 | 229 | 185 | 261 | WP_386889645.1 winged helix-turn-helix transcriptional regulator [Streptomyces sp. NPDC060184] | diamond | 231 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC060184 | ||
| 29107355 | 29107355 | PRJNA832865_S_NODE_54268_length_341_cov_1.059701_g49182_i0 | PRJNA832865 | 54268 | 341 | 1.059701 | 3.61358041 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 46.2 | 0.00581 | NR | HZO36794.1 | 2586742 | g49182 | i0 | 37.3 | 1.63636363636364 | 75 | 41 | 60.7 | 1 | 24 | 230 | 5 | 79 | HZO36794.1 DsbA family oxidoreductase [Solirubrobacteraceae bacterium] | diamond | 558 | 46.2 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 29485905 | 29485905 | PRJNA832865_S_NODE_60710_length_319_cov_1.678862_g55624_i0 | PRJNA832865 | 60710 | 319 | 1.678862 | 5.35556978 | Kutzneria chonburiensis | 1483604 | Bacteria | Bacteria | 76.6 | 1.4e-14 | NR | WP_273938474.1 | 1483604 | g55624 | i0 | 48.8 | 1.5141065830721 | 80 | 41 | 75.2 | 0 | 42 | 281 | 103 | 182 | WP_273938474.1 ATP-dependent Clp protease proteolytic subunit [Kutzneria chonburiensis] | diamond | 483 | 76.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Kutzneria | Kutzneria chonburiensis | ||
| 30023179 | 30023179 | PRJNA832865_S_NODE_37471_length_441_cov_5.377717_g32386_i0 | PRJNA832865 | 37471 | 441 | 5.377717 | 23.71573197 | Rubrobacter sp. | 2036010 | Bacteria | Bacteria | 101 | 2.9e-24 | NR | HET7270448.1 | 2036010 | g32386 | i0 | 43.8 | 3.73469387755102 | 121 | 68 | 82.3 | 0 | 363 | 1 | 26 | 146 | HET7270448.1 Hsp20/alpha crystallin family protein [Rubrobacter sp.] | diamond | 1647 | 101 | 1 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacter | Rubrobacter sp. | ||
| 30031593 | 30031593 | PRJNA832865_S_NODE_97731_length_249_cov_0.875000_g92645_i0 | PRJNA832865 | 97731 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 155 | 1.8299999999999998e-47 | NR | CKY27918.1 | 1773 | g92645 | i0 | 98.8 | 2.96385542168675 | 82 | 1 | 98.8 | 0 | 2 | 247 | 11 | 92 | CKY27918.1 acetyl-CoA acetyltransferase [Mycobacterium tuberculosis] | diamond | 738 | 155 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium tuberculosis | ||
| 30086099 | 30086099 | PRJNA832865_S_NODE_30272_length_530_cov_6.126915_g25218_i0 | PRJNA832865 | 30272 | 530 | 6.126915 | 32.4726495 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 101 | 1.69e-23 | NR | HEX3946098.1 | 2201156 | g25218 | i0 | 33.3 | 1.83396226415094 | 162 | 102 | 91.1 | 3 | 486 | 4 | 6 | 162 | HEX3946098.1 hemerythrin domain-containing protein [Acidimicrobiales bacterium] | diamond | 972 | 101 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 30212438 | 30212438 | PRJNA832865_S_NODE_87232_length_261_cov_2.829787_g82146_i0 | PRJNA832865 | 87232 | 261 | 2.829787 | 7.38574407 | Mycobacterium simulans | 627089 | Bacteria | Bacteria | 42.7 | 0.0472 | NR | WP_191496213.1 | 627089 | g82146 | i0 | 31.6 | 0.873563218390805 | 76 | 51 | 87.4 | 1 | 229 | 2 | 761 | 835 | WP_191496213.1 type VII secretion protein EccCa [Mycobacterium simulans] | diamond | 228 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium simulans | ||
| 30307862 | 30307862 | PRJNA832865_S_NODE_39872_length_420_cov_3.213256_g34787_i0 | PRJNA832865 | 39872 | 420 | 3.213256 | 13.4956752 | Streptomyces sporangiiformans | 2315329 | Bacteria | Bacteria | 45.8 | 0.0219 | NR | WP_244951198.1 | 2315329 | g34787 | i0 | 29.9 | 1.52857142857143 | 107 | 74 | 75.7 | 1 | 372 | 55 | 1657 | 1763 | WP_244951198.1 type I polyketide synthase, partial [Streptomyces sporangiiformans] | diamond | 642 | 45.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sporangiiformans | ||
| 31445091 | 31445091 | PRJNA832865_S_NODE_98376_length_248_cov_1.760000_g93290_i0 | PRJNA832865 | 98376 | 248 | 1.76 | 4.3648 | Nonomuraea spiralis | 46182 | Bacteria | Bacteria | 43.1 | 0.0273 | NR | WP_189649627.1 | 46182 | g93290 | i0 | 42.9 | 0.508064516129032 | 42 | 23 | 50.8 | 1 | 87 | 212 | 23 | 63 | WP_189649627.1 aldo/keto reductase [Nonomuraea spiralis] | diamond | 126 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Nonomuraea | Nonomuraea spiralis | ||
| 31887816 | 31887816 | PRJNA832865_S_NODE_85817_length_264_cov_1.251309_g80731_i0 | PRJNA832865 | 85817 | 264 | 1.251309 | 3.30345576 | Cutibacterium sp. | 1912221 | Bacteria | Bacteria | 77.4 | 2.75e-14 | NR | MCA3774187.1 | 1912221 | g80731 | i0 | 43.6 | 10.2272727272727 | 78 | 44 | 88.6 | 0 | 21 | 254 | 288 | 365 | MCA3774187.1 hypothetical protein [Cutibacterium sp.] | diamond | 2700 | 77.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium sp. | ||
| 32236274 | 32236274 | PRJNA832865_S_NODE_56778_length_332_cov_1.189189_g51692_i0 | PRJNA832865 | 56778 | 332 | 1.189189 | 3.94810748 | Blastococcus sp. Marseille-P5729 | 2086582 | Bacteria | Bacteria | 47.8 | 0.00145 | NR | WP_106850528.1 | 2086582 | g51692 | i0 | 36.4 | 0.596385542168675 | 66 | 40 | 57.8 | 1 | 279 | 88 | 124 | 189 | WP_106850528.1 respiratory nitrate reductase subunit gamma [Blastococcus sp. Marseille-P5729] | diamond | 198 | 47.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Blastococcus | Blastococcus sp. Marseille-P5729 |
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);;