contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA753112" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8854709 | 8854709 | PRJNA753112_P_NODE_33307_length_243_cov_0.917647_g32965_i0 | PRJNA753112 | 33307 | 243 | 0.917647 | 2.22988221 | Nocardioides jiangsuensis | 2866161 | Bacteria | Bacteria | 122 | 1.98e-30 | NR | WP_221026628.1 | 2866161 | g32965 | i0 | 86.1 | 0.975308641975309 | 79 | 11 | 97.5 | 0 | 238 | 2 | 289 | 367 | WP_221026628.1 potassium-transporting ATPase subunit KdpA [Nocardioides jiangsuensis] | diamond | 237 | 122 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides jiangsuensis | ||
| 24955709 | 24955709 | PRJNA753112_P_NODE_32340_length_245_cov_0.906977_g31998_i0 | PRJNA753112 | 32340 | 245 | 0.906977 | 2.22209365 | Microbacterium ginsengisoli | 400772 | Bacteria | Bacteria | 166 | 2.58e-48 | NR | WP_045247539.1 | 400772 | g31998 | i0 | 97.5 | 0.979591836734694 | 80 | 2 | 98 | 0 | 240 | 1 | 216 | 295 | WP_045247539.1 Rv2578c family radical SAM protein [Microbacterium ginsengisoli] | diamond | 240 | 166 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium ginsengisoli | ||
| 26704486 | 26704486 | PRJNA753112_P_NODE_28941_length_253_cov_0.866667_g28599_i0 | PRJNA753112 | 28941 | 253 | 0.866667 | 2.19266751 | Nocardia sp. alder85J | 2862949 | Bacteria | Bacteria | 49.7 | 1.43e-4 | NR | WP_323138010.1 | 2862949 | g28599 | i0 | 40.2 | 1.94466403162055 | 82 | 39 | 96 | 3 | 10 | 252 | 219 | 291 | WP_323138010.1 metal-dependent hydrolase [Nocardia sp. alder85J] | diamond | 492 | 49.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia sp. alder85J | ||
| 27337478 | 27337478 | PRJNA753112_P_NODE_29923_length_250_cov_1.514124_g29581_i0 | PRJNA753112 | 29923 | 250 | 1.514124 | 3.78531 | Nocardioides aquiterrae | 203799 | Bacteria | Bacteria | 58.2 | 8.81e-8 | NR | GAA1164235.1 | 203799 | g29581 | i0 | 58.1 | 0.744 | 62 | 25 | 73.2 | 1 | 31 | 213 | 31 | 92 | GAA1164235.1 hypothetical protein GCM10009606_47390 [Nocardioides aquiterrae] | diamond | 186 | 58.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides aquiterrae | ||
| 27400675 | 27400675 | PRJNA753112_P_NODE_31683_length_246_cov_1.317919_g31341_i0 | PRJNA753112 | 31683 | 246 | 1.317919 | 3.24208074 | Streptomyces tendae | 1932 | Bacteria | Bacteria | 44.7 | 0.00811 | NR | MFJ3044153.1 | 1932 | g31341 | i0 | 59.5 | 0.451219512195122 | 37 | 13 | 45.1 | 1 | 131 | 241 | 714 | 748 | MFJ3044153.1 hypothetical protein [Streptomyces tendae] | diamond | 111 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces tendae | ||
| 27558222 | 27558222 | PRJNA753112_P_NODE_8084_length_480_cov_2.732187_g7742_i0 | PRJNA753112 | 8084 | 480 | 2.732187 | 13.1144976 | Curtobacterium sp. ER1/6 | 1891920 | Bacteria | Bacteria | 45.1 | 0.0496 | NR | OEI69057.1 | 1891920 | g7742 | i0 | 33.3 | 0.9375 | 150 | 88 | 89.4 | 3 | 17 | 445 | 36 | 180 | OEI69057.1 hypothetical protein Cus16_0887 [Curtobacterium sp. ER1/6] | diamond | 450 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Curtobacterium | Curtobacterium sp. ER1/6 | ||
| 28032132 | 28032132 | PRJNA753112_P_NODE_24765_length_274_cov_1.363184_g24423_i0 | PRJNA753112 | 24765 | 274 | 1.363184 | 3.73512416 | Micromonospora aurantiaca | 47850 | Bacteria | Bacteria | 45.1 | 0.0056 | NR | WP_162881542.1 | 47850 | g24423 | i0 | 38.2 | 1.80656934306569 | 55 | 32 | 58 | 1 | 36 | 194 | 144 | 198 | WP_162881542.1 DUF4352 domain-containing protein [Micromonospora aurantiaca] | diamond | 495 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora aurantiaca (nom. illeg.) | ||
| 28032133 | 28032133 | PRJNA753112_P_NODE_27565_length_259_cov_1.268817_g27223_i0 | PRJNA753112 | 27565 | 259 | 1.268817 | 3.28623603 | Saccharothrix variisporea | 543527 | Bacteria | Bacteria | 43.5 | 0.025 | NR | WP_246029499.1 | 543527 | g27223 | i0 | 40 | 0.694980694980695 | 60 | 32 | 64.9 | 2 | 92 | 259 | 884 | 943 | WP_246029499.1 hypothetical protein [Saccharothrix variisporea] | diamond | 180 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharothrix | Saccharothrix variisporea | ||
| 30589916 | 30589916 | PRJNA753112_P_NODE_11693_length_397_cov_2.842593_g11351_i0 | PRJNA753112 | 11693 | 397 | 2.842593 | 11.28509421 | Mycolicibacterium brumae | 85968 | Bacteria | Bacteria | 49.3 | 0.00106 | NR | WP_090587324.1 | 85968 | g11351 | i0 | 33 | 0.755667506297229 | 100 | 62 | 74.8 | 3 | 327 | 31 | 809 | 904 | WP_090587324.1 arabinosyltransferase domain-containing protein [Mycolicibacterium brumae] | diamond | 300 | 49.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium brumae | ||
| 31538417 | 31538417 | PRJNA753112_P_NODE_28756_length_253_cov_0.866667_g28414_i0 | PRJNA753112 | 28756 | 253 | 0.866667 | 2.19266751 | Streptomyces sp. MBT84 | 1488414 | Bacteria | Bacteria | 42.7 | 0.0417 | NR | MBW8705193.1 | 1488414 | g28414 | i0 | 40.3 | 0.735177865612648 | 62 | 34 | 73.5 | 1 | 66 | 251 | 704 | 762 | MBW8705193.1 Cyclic di-GMP phosphodiesterase Gmr [Streptomyces sp. MBT84] | diamond | 186 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. MBT84 | ||
| 32592123 | 32592123 | PRJNA753112_P_NODE_17539_length_324_cov_1.657371_g17197_i0 | PRJNA753112 | 17539 | 324 | 1.657371 | 5.36988204 | Streptomyces | 1883 | Bacteria | Bacteria | 56.2 | 1.62e-6 | NR | WP_016643678.1 | 47760 | g17197 | i0 | 52.5 | 4.69444444444444 | 61 | 23 | 50.9 | 2 | 322 | 158 | 138 | 198 | WP_016643678.1 Kelch repeat-containing protein [Streptomyces aurantiacus] | diamond | 1521 | 56.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces aurantiacus | ||
| 32644858 | 32644858 | PRJNA753112_P_NODE_26380_length_265_cov_1.625000_g26038_i0 | PRJNA753112 | 26380 | 265 | 1.625 | 4.30625 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 77.4 | 3.06e-14 | NR | HLN17668.1 | 2201156 | g26038 | i0 | 68.6 | 2.11698113207547 | 51 | 16 | 57.7 | 0 | 264 | 112 | 520 | 570 | HLN17668.1 amidohydrolase family protein [Acidimicrobiales bacterium] | diamond | 561 | 77.4 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium |
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);;