contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1047551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15477469 | 15477469 | PRJNA1047551_S_NODE_7473_length_186_cov_1.834437_g7346_i0 | PRJNA1047551 | 7473 | 186 | 1.834437 | 3.41205282 | Corynebacterium suicordis | 203264 | Bacteria | Bacteria | 122 | 4.6e-31 | NR | MBF4554160.1 | 1121369 | g7346 | i0 | 96.7 | 0.983870967741935 | 61 | 2 | 98.4 | 0 | 4 | 186 | 387 | 447 | MBF4554160.1 PepSY domain-containing protein [Corynebacterium suicordis DSM 45110] | diamond | 183 | 122 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium suicordis | ||
| 19300521 | 19300521 | PRJNA1047551_S_NODE_9376_length_172_cov_1.350365_g9249_i0 | PRJNA1047551 | 9376 | 172 | 1.350365 | 2.3226278 | Kocuria carniphila | 262208 | Bacteria | Bacteria | 114 | 3.87e-28 | NR | WP_129699457.1 | 262208 | g9249 | i0 | 94.7 | 0.994186046511628 | 57 | 3 | 99.4 | 0 | 2 | 172 | 59 | 115 | WP_129699457.1 anthranilate synthase component I [Kocuria carniphila] | diamond | 171 | 114 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Kocuria | Kocuria carniphila | ||
| 27825126 | 27825126 | PRJNA1047551_S_NODE_6224_length_199_cov_2.719512_g6097_i0 | PRJNA1047551 | 6224 | 199 | 2.719512 | 5.41182888 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 87.4 | 3.81e-18 | NR | HEX2102415.1 | 2586742 | g6097 | i0 | 56.1 | 2.95477386934673 | 66 | 29 | 99.5 | 0 | 198 | 1 | 502 | 567 | HEX2102415.1 phosphoenolpyruvate carboxykinase (GTP) [Solirubrobacteraceae bacterium] | diamond | 588 | 87.4 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 29017076 | 29017076 | PRJNA1047551_S_NODE_9588_length_170_cov_3.162963_g9461_i0 | PRJNA1047551 | 9588 | 170 | 3.162963 | 5.3770371 | Actinomadura | 1988 | Bacteria | Bacteria | 41.2 | 0.0354 | NR | WP_176403677.1 | 2745202 | g9461 | i0 | 40.9 | 1.53529411764706 | 44 | 26 | 77.6 | 0 | 4 | 135 | 29 | 72 | WP_176403677.1 GNAT family N-acetyltransferase [Actinomadura sp. BRA 177] | diamond | 261 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Thermomonosporaceae | Actinomadura | Actinomadura sp. BRA 177 | ||
| 29490202 | 29490202 | PRJNA1047551_S_NODE_12190_length_156_cov_1.793388_g12063_i0 | PRJNA1047551 | 12190 | 156 | 1.793388 | 2.79768528 | Actinomycetes | 1760 | Bacteria | Bacteria | 76.3 | 1.77e-14 | NR | MEO6714109.1 | 1957017 | g12063 | i0 | 70.6 | 3.90384615384615 | 51 | 15 | 98.1 | 0 | 156 | 4 | 107 | 157 | MEO6714109.1 PAS domain-containing protein [Mycobacteriales bacterium] | diamond | 609 | 77 | 0.990909090909091 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriales bacterium | ||||
| 30603894 | 30603894 | PRJNA1047551_S_NODE_7453_length_186_cov_2.264901_g7326_i0 | PRJNA1047551 | 7453 | 186 | 2.264901 | 4.21271586 | Amycolatopsis suaedae | 2510978 | Bacteria | Bacteria | 42.4 | 0.0233 | NR | WP_130474293.1 | 2510978 | g7326 | i0 | 39.7 | 0.935483870967742 | 58 | 35 | 93.5 | 0 | 9 | 182 | 117 | 174 | WP_130474293.1 aldose 1-epimerase family protein [Amycolatopsis suaedae] | diamond | 174 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Amycolatopsis | Amycolatopsis suaedae | ||
| 30635408 | 30635408 | PRJNA1047551_S_NODE_11873_length_158_cov_1.186992_g11746_i0 | PRJNA1047551 | 11873 | 158 | 1.186992 | 1.87544736 | Corynebacterium bouchesdurhonense | 1720192 | Bacteria | Bacteria | 54.7 | 6.94e-8 | NR | WP_078056841.1 | 1720192 | g11746 | i0 | 96.7 | 0.569620253164557 | 30 | 1 | 57 | 0 | 109 | 20 | 1 | 30 | WP_078056841.1 DUF2516 family protein [Corynebacterium bouchesdurhonense] | diamond | 90 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium bouchesdurhonense | ||
| 31046614 | 31046614 | PRJNA1047551_S_NODE_3755_length_243_cov_1.543269_g3628_i0 | PRJNA1047551 | 3755 | 243 | 1.543269 | 3.75014367 | Varibaculum cambriense | 184870 | Bacteria | Bacteria | 43.1 | 0.0277 | NR | WP_060920419.1 | 184870 | g3628 | i0 | 39.5 | 0.530864197530864 | 43 | 25 | 51.9 | 1 | 209 | 84 | 1457 | 1499 | WP_060920419.1 InlB B-repeat-containing protein [Varibaculum cambriense] | diamond | 129 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Varibaculum | Varibaculum cambriense | ||
| 31330745 | 31330745 | PRJNA1047551_S_NODE_2736_length_277_cov_2.227273_g2609_i0 | PRJNA1047551 | 2736 | 277 | 2.227273 | 6.16954621 | unclassified Modestobacter | 2643866 | Bacteria | Bacteria | 44.3 | 0.0156 | NR | WP_269172644.1 | 2643866 | g2609 | i0 | 36.8 | 1.02888086642599 | 95 | 40 | 83.4 | 4 | 34 | 264 | 263 | 355 | WP_269172644.1 MULTISPECIES: DUF1015 domain-containing protein [unclassified Modestobacter] | diamond | 285 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Modestobacter | |||
| 32533220 | 32533220 | PRJNA1047551_S_NODE_9919_length_168_cov_2.240602_g9792_i0 | PRJNA1047551 | 9919 | 168 | 2.240602 | 3.76421136 | Acidimicrobiaceae bacterium | 2024894 | Bacteria | Bacteria | 43.9 | 0.00516 | NR | MEY2588768.1 | 2024894 | g9792 | i0 | 46.3 | 0.732142857142857 | 41 | 21 | 71.4 | 1 | 14 | 133 | 70 | 110 | MEY2588768.1 hypothetical protein [Acidimicrobiaceae bacterium] | diamond | 123 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiaceae | Acidimicrobiaceae bacterium | |||
| 32722122 | 32722122 | PRJNA1047551_S_NODE_7400_length_187_cov_1.434211_g7273_i0 | PRJNA1047551 | 7400 | 187 | 1.434211 | 2.68197457 | Kitasatospora sp. NPDC | 1871188 | Bacteria | Bacteria | 40.8 | 0.0171 | NR | WP_380269986.1 | 3346001 | g7273 | i0 | 48.6 | 0.593582887700535 | 37 | 19 | 59.4 | 0 | 60 | 170 | 42 | 78 | WP_380269986.1 NUDIX domain-containing protein [Kitasatospora sp. NPDC057015] | diamond | 111 | 40.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora sp. NPDC057015 | ||
| 32847979 | 32847979 | PRJNA1047551_S_NODE_13060_length_152_cov_4.623932_g12933_i0 | PRJNA1047551 | 13060 | 152 | 4.623932 | 7.02837664 | Ilumatobacteraceae bacterium | 2497619 | Bacteria | Bacteria | 46.2 | 3.34e-4 | NR | HEY4608371.1 | 2497619 | g12933 | i0 | 88 | 0.493421052631579 | 25 | 3 | 49.3 | 0 | 151 | 77 | 137 | 161 | HEY4608371.1 OsmC family peroxiredoxin [Ilumatobacteraceae bacterium] | diamond | 75 | 46.2 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Ilumatobacteraceae | Ilumatobacteraceae 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);;