contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA688736" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5771555 | 5771555 | PRJNA688736_P_NODE_38565_length_257_cov_1.309783_g38280_i0 | PRJNA688736 | 38565 | 257 | 1.309783 | 3.36614231 | Actinomycetales bacterium | 1911520 | Bacteria | Bacteria | 114 | 3.22e-30 | NR | NLI17885.1 | 1911520 | g38280 | i0 | 78.9 | 1.68093385214008 | 71 | 15 | 82.9 | 0 | 1 | 213 | 73 | 143 | NLI17885.1 PH domain-containing protein [Actinomycetales bacterium] | diamond | 432 | 114 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetales bacterium | ||||
| 26765791 | 26765791 | PRJNA688736_P_NODE_34781_length_272_cov_1.090452_g34496_i0 | PRJNA688736 | 34781 | 272 | 1.090452 | 2.96602944 | Catellatospora sp. TT | 54104 | Bacteria | Bacteria | 42.7 | 0.0451 | NR | WP_212830149.1 | 2733863 | g34496 | i0 | 34.5 | 0.926470588235294 | 84 | 46 | 87.1 | 4 | 257 | 21 | 8 | 87 | WP_212830149.1 hypothetical protein [Catellatospora sp. TT07R-123] | diamond | 252 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Catellatospora | Catellatospora sp. TT07R-123 | ||
| 27682837 | 27682837 | PRJNA688736_P_NODE_44104_length_249_cov_0.886364_g43819_i0 | PRJNA688736 | 44104 | 249 | 0.886364 | 2.20704636 | unclassified Rhodococcus (in: high G+C Gram-positive bacteria) | 192944 | Bacteria | Bacteria | 154 | 2.27e-41 | NR | WP_094638973.1 | 192944 | g43819 | i0 | 96.3 | 0.987951807228916 | 82 | 3 | 98.8 | 0 | 248 | 3 | 122 | 203 | WP_094638973.1 MULTISPECIES: LuxR C-terminal-related transcriptional regulator [unclassified Rhodococcus (in: high G+C Gram-positive bacteria)] | diamond | 246 | 154 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | |||
| 27966590 | 27966590 | PRJNA688736_P_NODE_39225_length_255_cov_1.010989_g38940_i0 | PRJNA688736 | 39225 | 255 | 1.010989 | 2.57802195 | Arthrobacter citreus | 1670 | Bacteria | Bacteria | 59.3 | 4.88e-8 | NR | WP_376934700.1 | 1670 | g38940 | i0 | 100 | 0.329411764705882 | 28 | 0 | 32.9 | 0 | 1 | 84 | 259 | 286 | WP_376934700.1 hypothetical protein [Arthrobacter citreus] | diamond | 84 | 59.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter citreus | ||
| 29481923 | 29481923 | PRJNA688736_P_NODE_910_length_1293_cov_43.992623_g790_i0 | PRJNA688736 | 910 | 1293 | 43.992623 | 568.82461539 | Arthrobacter citreus | 1670 | Bacteria | Bacteria | 539 | 2.2399999999999998e-190 | NR | WP_376934700.1 | 1670 | g790 | i0 | 100 | 0.663573085846868 | 286 | 0 | 66.4 | 0 | 228 | 1085 | 1 | 286 | WP_376934700.1 hypothetical protein [Arthrobacter citreus] | diamond | 858 | 539 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter citreus | ||
| 30145150 | 30145150 | PRJNA688736_P_NODE_42012_length_251_cov_0.876404_g41727_i0 | PRJNA688736 | 42012 | 251 | 0.876404 | 2.19977404 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 113 | 6.870000000000001e-27 | NR | MDQ3894990.1 | 2900548 | g41727 | i0 | 67.5 | 0.99203187250996006 | 83 | 26 | 99.2 | 1 | 251 | 3 | 254 | 335 | MDQ3894990.1 beta-propeller fold lactonase family protein [Actinomycetota bacterium] | diamond | 249 | 113 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30998597 | 30998597 | PRJNA688736_P_NODE_94_length_2271_cov_12.526388_g77_i0 | PRJNA688736 | 94 | 2271 | 12.526388 | 284.47427148 | Arthrobacter citreus | 1670 | Bacteria | Bacteria | 176 | 1.69e-48 | NR | WP_376934692.1 | 1670 | g77 | i0 | 100 | 0.121532364597094 | 92 | 0 | 12.2 | 0 | 697 | 422 | 1 | 92 | WP_376934692.1 hypothetical protein, partial [Arthrobacter citreus] | diamond | 276 | 176 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter citreus | ||
| 31156179 | 31156179 | PRJNA688736_P_NODE_75_length_2358_cov_20.123851_g64_i0 | PRJNA688736 | 75 | 2358 | 20.123851 | 474.52040658 | Arthrobacter citreus | 1670 | Bacteria | Bacteria | 823 | 9.05e-295 | NR | WP_376934698.1 | 1670 | g64 | i0 | 100 | 0.517811704834606 | 407 | 0 | 51.8 | 0 | 1010 | 2230 | 1 | 407 | WP_376934698.1 hypothetical protein, partial [Arthrobacter citreus] | diamond | 1221 | 823 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter citreus | ||
| 31852192 | 31852192 | PRJNA688736_P_NODE_7357_length_542_cov_2.515991_g7075_i0 | PRJNA688736 | 7357 | 542 | 2.515991 | 13.63667122 | Arthrobacter citreus | 1670 | Bacteria | Bacteria | 79.7 | 3.23e-14 | NR | WP_376934700.1 | 1670 | g7075 | i0 | 36.3 | 0.808118081180812 | 146 | 90 | 80.3 | 2 | 507 | 73 | 117 | 260 | WP_376934700.1 hypothetical protein [Arthrobacter citreus] | diamond | 438 | 79.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter citreus | ||
| 32073811 | 32073811 | PRJNA688736_P_NODE_45858_length_247_cov_0.896552_g45573_i0 | PRJNA688736 | 45858 | 247 | 0.896552 | 2.21448344 | Lancefieldella parvula | 1382 | Bacteria | Bacteria | 159 | 1.15e-43 | NR | WP_314950448.1 | 1382 | g45573 | i0 | 92.7 | 2.98785425101215 | 82 | 6 | 99.6 | 0 | 2 | 247 | 42 | 123 | WP_314950448.1 class I SAM-dependent DNA methyltransferase [Lancefieldella parvula] | diamond | 738 | 159 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriales | Atopobiaceae | Lancefieldella | Lancefieldella parvula | ||
| 32496841 | 32496841 | PRJNA688736_P_NODE_50019_length_243_cov_0.917647_g49734_i0 | PRJNA688736 | 50019 | 243 | 0.917647 | 2.22988221 | root | 1 | Root_unresolved | Root_unresolved | 90.9 | 8.200000000000001e-22 | NR | WP_285164290.1 | 1773 | g49734 | i0 | 62.7 | 19.1604938271605 | 75 | 27 | 91.4 | 1 | 224 | 3 | 15 | 89 | WP_285164290.1 glutathione S-transferase N-terminal domain-containing protein, partial [Mycobacterium tuberculosis] | diamond | 4656 | 91.7 | 0.991275899672846 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium tuberculosis |
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);;