contig_metadata
13 rows where bioproject = "PRJNA641991", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4986759 | 4986759 | PRJNA641991_S_NODE_13104_length_165_cov_0.879310_g12985_i0 | PRJNA641991 | 13104 | 165 | 0.87931 | 1.4508615 | Cutibacterium | 1912216 | Bacteria | Bacteria | 294 | 2.08e-75 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g12985 | i0 | 100 | 51.0727272727273 | 159 | 0 | 96 | 0 | 1 | 159 | 845935 | 846093 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 8427 | 294 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 15186873 | 15186873 | PRJNA641991_S_NODE_9512_length_184_cov_0.844444_g9393_i0 | PRJNA641991 | 9512 | 184 | 0.844444 | 1.55377696 | Rhodococcus | 1827 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|2088797821|gb|CP082159.1| | 37919 | g9393 | i0 | 100 | 2.6195652173913 | 29 | 0 | 16 | 0 | 91 | 119 | 184193 | 184221 | Rhodococcus opacus strain DSM 44186 plasmid pRop44186_a, complete sequence | blastn | 482 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus opacus | ||
| 15920611 | 15920611 | PRJNA641991_S_NODE_13293_length_164_cov_0.886957_g13174_i0 | PRJNA641991 | 13293 | 164 | 0.886957 | 1.45460948 | Streptomyces malaysiensis | 92644 | Bacteria | Bacteria | 52.8 | 0.014 | NTclustered | gi|2619783426|gb|CP137895.1| | 92644 | g13174 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 17 | 44 | 7943397 | 7943370 | Streptomyces malaysiensis strain NA3722 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces malaysiensis | ||
| 19744612 | 19744612 | PRJNA641991_S_NODE_12036_length_167_cov_0.864407_g11917_i0 | PRJNA641991 | 12036 | 167 | 0.864407 | 1.44355969 | Tsukamurella tyrosinosolvens | 57704 | Bacteria | Bacteria | 292 | 7.58e-75 | NTclustered | gi|1540130960|emb|LR134451.1| | 57704 | g11917 | i0 | 98.204 | 9.65269461077844 | 167 | 3 | 100 | 0 | 1 | 167 | 74127 | 73961 | Tsukamurella tyrosinosolvens strain NCTC13231 genome assembly, plasmid: 9 | blastn | 1612 | 292 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Tsukamurellaceae | Tsukamurella | Tsukamurella tyrosinosolvens | ||
| 24110287 | 24110287 | PRJNA641991_S_NODE_5919_length_224_cov_1.165714_g5800_i0 | PRJNA641991 | 5919 | 224 | 1.165714 | 2.61119936 | Streptomyces | 1883 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2015360468|gb|CP071839.1| | 80860 | g5800 | i0 | 92.308 | 0.758928571428571 | 39 | 3 | 17 | 0 | 31 | 69 | 1621424 | 1621386 | Streptomyces cyanogenus strain S136 chromosome, complete genome | blastn | 170 | 56.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces cyanogenus | ||
| 27144043 | 27144043 | PRJNA641991_S_NODE_9362_length_185_cov_1.073529_g9243_i0 | PRJNA641991 | 9362 | 185 | 1.073529 | 1.98602865 | Collinsella sp. | 1965294 | Bacteria | Bacteria | 40 | 0.0342 | NR | MFR3450459.1 | 1965294 | g9243 | i0 | 37.3 | 0.827027027027027 | 51 | 31 | 82.7 | 1 | 3 | 155 | 9 | 58 | MFR3450459.1 hypothetical protein [Collinsella sp.] | diamond | 153 | 40 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriales | Coriobacteriaceae | Collinsella | Collinsella sp. | ||
| 27870822 | 27870822 | PRJNA641991_S_NODE_11825_length_167_cov_2.906780_g11706_i0 | PRJNA641991 | 11825 | 167 | 2.90678 | 4.8543226 | Aquihabitans sp. G128 | 2849779 | Bacteria | Bacteria | 43.5 | 0.00704 | NR | WP_216998947.1 | 2849779 | g11706 | i0 | 41.7 | 1.07784431137725 | 60 | 19 | 80.8 | 2 | 29 | 163 | 210 | 268 | WP_216998947.1 methionyl-tRNA formyltransferase [Aquihabitans sp. G128] | diamond | 180 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Iamiaceae | Aquihabitans | Aquihabitans sp. G128 | ||
| 28072596 | 28072596 | PRJNA641991_S_NODE_5065_length_239_cov_1.326316_g4946_i0 | PRJNA641991 | 5065 | 239 | 1.326316 | 3.16989524 | FCB group | 1783270 | Bacteria | Bacteria | 97.1 | 1.1e-23 | NR | WP_285918567.1 | 604315 | g4946 | i0 | 58.6 | 7.05439330543933 | 70 | 28 | 87.9 | 1 | 16 | 225 | 40 | 108 | WP_285918567.1 Mth938-like domain-containing protein [Actinomadura sp. OS1-43] | diamond | 1686 | 97.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Thermomonosporaceae | Actinomadura | Actinomadura sp. OS1-43 | ||
| 28798669 | 28798669 | PRJNA641991_S_NODE_14847_length_161_cov_0.910714_g14728_i0 | PRJNA641991 | 14847 | 161 | 0.910714 | 1.46624954 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.00898 | NR | HEU5005883.1 | 2811413 | g14728 | i0 | 37.5 | 5.18012422360248 | 48 | 30 | 89.4 | 0 | 9 | 152 | 234 | 281 | HEU5005883.1 ATP-binding protein [Jatrophihabitantaceae bacterium] | diamond | 834 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Jatrophihabitantales | Jatrophihabitantaceae | Jatrophihabitantaceae bacterium | |||
| 29102439 | 29102439 | PRJNA641991_S_NODE_10368_length_177_cov_1.593750_g10249_i0 | PRJNA641991 | 10368 | 177 | 1.59375 | 2.8209375 | Kineosporiaceae bacterium | 2487580 | Bacteria | Bacteria | 60.5 | 7.92e-9 | NR | HVN12469.1 | 2487580 | g10249 | i0 | 57.1 | 3.64406779661017 | 56 | 23 | 94.9 | 1 | 3 | 170 | 300 | 354 | HVN12469.1 trypsin-like peptidase domain-containing protein [Kineosporiaceae bacterium] | diamond | 645 | 60.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kineosporiales | Kineosporiaceae | Kineosporiaceae bacterium | |||
| 31060960 | 31060960 | PRJNA641991_P_NODE_2895_length_178_cov_0.875969_g2854_i0 | PRJNA641991 | 2895 | 178 | 0.875969 | 1.55922482 | Actinokineospora sp. UTMC 2448 | 2268449 | Bacteria | Bacteria | 41.6 | 0.0403 | NR | UVS78122.1 | 2268449 | g2854 | i0 | 51.4 | 0.623595505617977 | 37 | 16 | 59 | 1 | 68 | 172 | 77 | 113 | UVS78122.1 hypothetical protein Actkin_01846 [Actinokineospora sp. UTMC 2448] | diamond | 111 | 41.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinokineospora | Actinokineospora sp. UTMC 2448 | ||
| 32072791 | 32072791 | PRJNA641991_S_NODE_14158_length_162_cov_1.123894_g14039_i0 | PRJNA641991 | 14158 | 162 | 1.123894 | 1.82070828 | Streptomyces sp. NRRL F-5727 | 1463871 | Bacteria | Bacteria | 43.5 | 0.00684 | NR | WP_051716732.1 | 1463871 | g14039 | i0 | 45.1 | 1.88888888888889 | 51 | 26 | 94.4 | 1 | 4 | 156 | 322 | 370 | WP_051716732.1 MATE family efflux transporter [Streptomyces sp. NRRL F-5727] | diamond | 306 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NRRL F-5727 | ||
| 32389152 | 32389152 | PRJNA641991_P_NODE_3379_length_166_cov_0.871795_g3338_i0 | PRJNA641991 | 3379 | 166 | 0.871795 | 1.4471797 | Corynebacterium dentalis | 2014528 | Bacteria | Bacteria | 41.2 | 0.0465 | NR | WP_312097338.1 | 2014528 | g3338 | i0 | 73.9 | 0.41566265060241 | 23 | 6 | 41.6 | 0 | 70 | 2 | 1 | 23 | WP_312097338.1 esterase/lipase family protein [Corynebacterium dentalis] | diamond | 69 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium dentalis |
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);;