contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA289590" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26599026 | 26599026 | PRJNA289590_P_NODE_30041_length_164_cov_0.878261_g29817_i0 | PRJNA289590 | 30041 | 164 | 0.878261 | 1.44034804 | Pseudokineococcus marinus | 351215 | Bacteria | Bacteria | 92 | 4.67e-20 | NR | WP_171203999.1 | 351215 | g29817 | i0 | 81.5 | 0.98780487804878 | 54 | 10 | 98.8 | 0 | 163 | 2 | 339 | 392 | WP_171203999.1 catalase [Pseudokineococcus marinus] | diamond | 162 | 92 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kineosporiales | Kineosporiaceae | Pseudokineococcus | Pseudokineococcus marinus | ||
| 26965193 | 26965193 | PRJNA289590_P_NODE_23262_length_182_cov_1.556391_g23038_i0 | PRJNA289590 | 23262 | 182 | 1.556391 | 2.83263162 | Actinomycetota | 201174 | Bacteria | Bacteria | 65.9 | 1.16e-10 | NR | MEA2314811.1 | 2586742 | g23038 | i0 | 59.7 | 3.04945054945055 | 62 | 23 | 98.9 | 2 | 3 | 182 | 504 | 565 | MEA2314811.1 hypothetical protein [Solirubrobacteraceae bacterium] | diamond | 555 | 65.9 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 27028557 | 27028557 | PRJNA289590_P_NODE_14542_length_237_cov_1.648936_g14318_i0 | PRJNA289590 | 14542 | 237 | 1.648936 | 3.90797832 | Actinomycetes | 1760 | Bacteria | Bacteria | 95.1 | 1.28e-20 | NR | WP_073893777.1 | 2071 | g14318 | i0 | 66.2 | 6.59493670886076 | 74 | 25 | 93.7 | 0 | 15 | 236 | 5597 | 5670 | WP_073893777.1 MULTISPECIES: non-ribosomal peptide synthetase [Saccharothrix] | diamond | 1563 | 95.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharothrix | |||
| 27453592 | 27453592 | PRJNA289590_P_NODE_13243_length_250_cov_2.069652_g13019_i0 | PRJNA289590 | 13243 | 250 | 2.069652 | 5.17413 | Mycolicibacterium sp. | 2320850 | Bacteria | Bacteria | 119 | 6.45e-29 | NR | WP_372943725.1 | 2320850 | g13019 | i0 | 71.1 | 1.992 | 83 | 24 | 99.6 | 0 | 250 | 2 | 217 | 299 | WP_372943725.1 phage tail tape measure protein [Mycolicibacterium sp.] | diamond | 498 | 119 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium sp. | ||
| 28179350 | 28179350 | PRJNA289590_P_NODE_27566_length_167_cov_0.881356_g27342_i0 | PRJNA289590 | 27566 | 167 | 0.881356 | 1.47186452 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 44.7 | 0.00278 | NR | MDQ1601302.1 | 2900548 | g27342 | i0 | 42.6 | 1.68862275449102 | 47 | 26 | 82.6 | 1 | 24 | 161 | 165 | 211 | MDQ1601302.1 hypothetical protein [Actinomycetota bacterium] | diamond | 282 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 28228528 | 28228528 | PRJNA289590_P_NODE_15126_length_232_cov_1.590164_g14902_i0 | PRJNA289590 | 15126 | 232 | 1.590164 | 3.68918048 | Bacteria | 2 | Bacteria | Bacteria | 114 | 1.14e-29 | NR | MES9394400.1 | 1747 | g14902 | i0 | 73.7 | 8.8448275862069 | 76 | 20 | 98.3 | 0 | 230 | 3 | 57 | 132 | MES9394400.1 arginine--tRNA ligase [Cutibacterium acnes] | diamond | 2052 | 115 | 0.991304347826087 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 28368956 | 28368956 | PRJNA289590_P_NODE_29266_length_165_cov_0.896552_g29042_i0 | PRJNA289590 | 29266 | 165 | 0.896552 | 1.4793108 | Actinomycetes bacterium | 1883427 | Bacteria | Bacteria | 108 | 1.14e-25 | NR | MCG9477778.1 | 1883427 | g29042 | i0 | 98.1 | 0.963636363636364 | 53 | 1 | 96.4 | 0 | 6 | 164 | 579 | 631 | MCG9477778.1 phosphoribosylformylglycinamidine synthase subunit PurL [Actinomycetes bacterium] | diamond | 159 | 108 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes bacterium | |||||
| 28621759 | 28621759 | PRJNA289590_P_NODE_24147_length_177_cov_2.437500_g23923_i0 | PRJNA289590 | 24147 | 177 | 2.4375 | 4.314375 | Catellatospora sp. NPDC | 54104 | Bacteria | Bacteria | 65.9 | 8.71e-11 | NR | WP_360541395.1 | 3155271 | g23923 | i0 | 66.7 | 0.813559322033898 | 48 | 16 | 81.4 | 0 | 30 | 173 | 85 | 132 | WP_360541395.1 hypothetical protein [Catellatospora sp. NPDC049111] | diamond | 144 | 65.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Catellatospora | Catellatospora sp. NPDC049111 | ||
| 28653250 | 28653250 | PRJNA289590_P_NODE_1587_length_1019_cov_14.557732_g1404_i0 | PRJNA289590 | 1587 | 1019 | 14.557732 | 148.34328908 | Nonomuraea angiospora | 46172 | Bacteria | Bacteria | 45.4 | 0.0151 | NR | WP_319716170.1 | 46172 | g1404 | i0 | 52.3 | 0.129538763493621 | 44 | 21 | 13 | 0 | 767 | 636 | 9 | 52 | WP_319716170.1 hypothetical protein, partial [Nonomuraea angiospora] | diamond | 132 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Nonomuraea | Nonomuraea angiospora | ||
| 29252864 | 29252864 | PRJNA289590_P_NODE_27369_length_167_cov_0.881356_g27145_i0 | PRJNA289590 | 27369 | 167 | 0.881356 | 1.47186452 | Geodermatophilaceae bacterium | 1882271 | Bacteria | Bacteria | 41.2 | 0.0475 | NR | MBA3419366.1 | 1882271 | g27145 | i0 | 44.4 | 0.808383233532934 | 45 | 25 | 80.8 | 0 | 30 | 164 | 586 | 630 | MBA3419366.1 hypothetical protein [Geodermatophilaceae bacterium] | diamond | 135 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Geodermatophilaceae bacterium | |||
| 30390561 | 30390561 | PRJNA289590_P_NODE_31353_length_162_cov_0.920354_g31129_i0 | PRJNA289590 | 31353 | 162 | 0.920354 | 1.49097348 | Nocardioides sp. CN2-186 | 3156607 | Bacteria | Bacteria | 89.7 | 3.17e-19 | NR | WP_348870305.1 | 3156607 | g31129 | i0 | 86.8 | 0.981481481481482 | 53 | 7 | 98.1 | 0 | 161 | 3 | 100 | 152 | WP_348870305.1 class I adenylate-forming enzyme family protein [Nocardioides sp. CN2-186] | diamond | 159 | 89.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides tweenelious | ||
| 30895804 | 30895804 | PRJNA289590_P_NODE_19054_length_205_cov_1.000000_g18830_i0 | PRJNA289590 | 19054 | 205 | 1 | 2.05 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 42 | 0.0427 | NR | TML42851.1 | 2900548 | g18830 | i0 | 56.4 | 0.570731707317073 | 39 | 11 | 55.6 | 2 | 89 | 202 | 30 | 63 | TML42851.1 MAG: ABC transporter ATP-binding protein [Actinomycetota bacterium] | diamond | 117 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30990580 | 30990580 | PRJNA289590_P_NODE_1594_length_1015_cov_14.966874_g1411_i0 | PRJNA289590 | 1594 | 1015 | 14.966874 | 151.9137711 | Nonomuraea angiospora | 46172 | Bacteria | Bacteria | 45.4 | 0.015 | NR | WP_319716170.1 | 46172 | g1411 | i0 | 52.3 | 0.130049261083744 | 44 | 21 | 13 | 0 | 763 | 632 | 9 | 52 | WP_319716170.1 hypothetical protein, partial [Nonomuraea angiospora] | diamond | 132 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Nonomuraea | Nonomuraea angiospora | ||
| 31022061 | 31022061 | PRJNA289590_P_NODE_19715_length_201_cov_1.269737_g19491_i0 | PRJNA289590 | 19715 | 201 | 1.269737 | 2.55217137 | Streptomyces pactum | 68249 | Bacteria | Bacteria | 62.4 | 1.23e-9 | NR | WP_197987272.1 | 68249 | g19491 | i0 | 54.5 | 0.82089552238806 | 55 | 25 | 82.1 | 0 | 200 | 36 | 183 | 237 | WP_197987272.1 flavin reductase family protein [Streptomyces pactum] | diamond | 165 | 62.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces pactum | ||
| 32319119 | 32319119 | PRJNA289590_P_NODE_10199_length_289_cov_2.062500_g9975_i0 | PRJNA289590 | 10199 | 289 | 2.0625 | 5.960625 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 84 | 2.23e-16 | NR | WP_400070639.1 | 3365701 | g9975 | i0 | 48.4 | 0.986159169550173 | 95 | 48 | 97.6 | 1 | 283 | 2 | 1589 | 1683 | WP_400070639.1 amino acid adenylation domain-containing protein [Streptomyces sp. NPDC053427] | diamond | 285 | 84 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC053427 | ||
| 32445614 | 32445614 | PRJNA289590_P_NODE_26179_length_169_cov_0.866667_g25955_i0 | PRJNA289590 | 26179 | 169 | 0.866667 | 1.46466723 | Mycolicibacterium arenosum | 2952157 | Bacteria | Bacteria | 75.5 | 5.18e-16 | NR | WP_255062745.1 | 2952157 | g25955 | i0 | 81.4 | 0.763313609467456 | 43 | 8 | 76.3 | 0 | 130 | 2 | 20 | 62 | WP_255062745.1 hypothetical protein [Mycolicibacterium arenosum] | diamond | 129 | 75.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium arenosum | ||
| 32697706 | 32697706 | PRJNA289590_P_NODE_11580_length_270_cov_0.941176_g11356_i0 | PRJNA289590 | 11580 | 270 | 0.941176 | 2.5411752 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 43.1 | 0.0352 | NR | MDP9461866.1 | 2900548 | g11356 | i0 | 35.8 | 0.744444444444444 | 67 | 43 | 74.4 | 0 | 21 | 221 | 78 | 144 | MDP9461866.1 DUF4192 domain-containing protein [Actinomycetota bacterium] | diamond | 201 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 32841248 | 32841248 | PRJNA289590_P_NODE_12540_length_258_cov_1.937799_g12316_i0 | PRJNA289590 | 12540 | 258 | 1.937799 | 4.99952142 | Bacteria | 2 | Bacteria | Bacteria | 77 | 6.52e-16 | NR | WP_027004908.1 | 191495 | g12316 | i0 | 55.4 | 3.59302325581395 | 74 | 33 | 86 | 0 | 32 | 253 | 44 | 117 | WP_027004908.1 holo-ACP synthase [Conexibacter woesei] | diamond | 927 | 77 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Conexibacteraceae | Conexibacter | Conexibacter woesei |
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);;