contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA549880" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3062912 | 3062912 | PRJNA549880_P_NODE_7783_length_287_cov_2.056075_g7690_i0 | PRJNA549880 | 7783 | 287 | 2.056075 | 5.90093525 | Thermoleophilia bacterium | 2026888 | Bacteria | Bacteria | 166 | 2.7199999999999993e-46 | NR | MCW2921874.1 | 2026888 | g7690 | i0 | 86.3 | 0.993031358885017 | 95 | 13 | 99.3 | 0 | 3 | 287 | 391 | 485 | MCW2921874.1 glycosyl transferase group 1 [Thermoleophilia bacterium] | diamond | 285 | 166 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Thermoleophilia bacterium | |||||
| 11322773 | 11322773 | PRJNA549880_P_NODE_9969_length_256_cov_1.672131_g9876_i0 | PRJNA549880 | 9969 | 256 | 1.672131 | 4.28065536 | Pseudonocardia sp. C8 | 2762759 | Bacteria | Bacteria | 143 | 3.69e-41 | NR | WP_186357458.1 | 2762759 | g9876 | i0 | 83.3 | 1.96875 | 84 | 14 | 98.4 | 0 | 3 | 254 | 1 | 84 | WP_186357458.1 DUF6879 family protein [Pseudonocardia sp. C8] | diamond | 504 | 143 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Pseudonocardia | Pseudonocardia sp. C8 | ||
| 17089351 | 17089351 | PRJNA549880_P_NODE_15154_length_242_cov_0.911243_g15061_i0 | PRJNA549880 | 15154 | 242 | 0.911243 | 2.20520806 | Microbacterium sp. Leaf2 | 51671 | Bacteria | Bacteria | 130 | 1.18e-33 | NR | WP_056226784.1 | 1735677 | g15061 | i0 | 87.5 | 1.98347107438017 | 80 | 10 | 99.2 | 0 | 2 | 241 | 113 | 192 | WP_056226784.1 LCP family protein [Microbacterium sp. Leaf203] | diamond | 480 | 130 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. Leaf203 | ||
| 17089353 | 17089353 | PRJNA549880_P_NODE_15194_length_242_cov_0.911243_g15101_i0 | PRJNA549880 | 15194 | 242 | 0.911243 | 2.20520806 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 154 | 3.569999999999999e-42 | NR | MSZ63347.1 | 2900548 | g15101 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 240 | 1 | 277 | 356 | MSZ63347.1 DNA polymerase III subunit gamma and tau [Actinomycetota bacterium] | diamond | 240 | 154 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 26919786 | 26919786 | PRJNA549880_P_NODE_14482_length_243_cov_0.905882_g14389_i0 | PRJNA549880 | 14482 | 243 | 0.905882 | 2.20129326 | Nocardia jinanensis | 382504 | Bacteria | Bacteria | 105 | 3.71e-25 | NR | WP_058855660.1 | 382504 | g14389 | i0 | 71.3 | 0.987654320987654 | 80 | 23 | 98.8 | 0 | 241 | 2 | 102 | 181 | WP_058855660.1 prenyltransferase/squalene oxidase repeat-containing protein [Nocardia jinanensis] | diamond | 240 | 105 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia jinanensis | ||
| 27204145 | 27204145 | PRJNA549880_P_NODE_10902_length_250_cov_0.870056_g10809_i0 | PRJNA549880 | 10902 | 250 | 0.870056 | 2.17514 | Aurantimicrobium sp. | 1930784 | Bacteria | Bacteria | 50.4 | 7.6e-5 | NR | WP_332627284.1 | 1930784 | g10809 | i0 | 40.3 | 0.744 | 62 | 35 | 72 | 1 | 51 | 230 | 216 | 277 | WP_332627284.1 hypothetical protein [Aurantimicrobium sp.] | diamond | 186 | 50.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Aurantimicrobium | Aurantimicrobium sp. | ||
| 27583348 | 27583348 | PRJNA549880_P_NODE_9164_length_268_cov_1.410256_g9071_i0 | PRJNA549880 | 9164 | 268 | 1.410256 | 3.77948608 | Leifsonia sp. Root4 | 1736525 | Bacteria | Bacteria | 73.2 | 5.03e-14 | NR | WP_157509566.1 | 1736525 | g9071 | i0 | 67.3 | 0.615671641791045 | 55 | 18 | 61.6 | 0 | 104 | 268 | 1 | 55 | WP_157509566.1 DUF3995 domain-containing protein [Leifsonia sp. Root4] | diamond | 165 | 73.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Leifsonia | Leifsonia sp. Root4 | ||
| 28088511 | 28088511 | PRJNA549880_P_NODE_11005_length_250_cov_0.870056_g10912_i0 | PRJNA549880 | 11005 | 250 | 0.870056 | 2.17514 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 52.8 | 1.23e-5 | NR | HET6965850.1 | 2201156 | g10912 | i0 | 46.8 | 1.572 | 62 | 33 | 74.4 | 0 | 244 | 59 | 443 | 504 | HET6965850.1 glycosyltransferase [Acidimicrobiales bacterium] | diamond | 393 | 52.8 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 28151967 | 28151967 | PRJNA549880_P_NODE_15565_length_241_cov_0.916667_g15472_i0 | PRJNA549880 | 15565 | 241 | 0.916667 | 2.20916747 | Corynebacterium dentalis | 2014528 | Bacteria | Bacteria | 89.4 | 1.3e-18 | NR | WP_312099008.1 | 2014528 | g15472 | i0 | 97.7 | 1.12033195020747 | 44 | 1 | 54.8 | 0 | 1 | 132 | 451 | 494 | WP_312099008.1 phage portal protein family protein [Corynebacterium dentalis] | diamond | 270 | 89.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium dentalis | ||
| 28292776 | 28292776 | PRJNA549880_P_NODE_14806_length_243_cov_0.888235_g14713_i0 | PRJNA549880 | 14806 | 243 | 0.888235 | 2.15841105 | Rubrobacter | 42255 | Bacteria | Bacteria | 143 | 1.38e-37 | NR | WP_011564819.1 | 49319 | g14713 | i0 | 82.5 | 3.95061728395062 | 80 | 14 | 98.8 | 0 | 2 | 241 | 384 | 463 | WP_011564819.1 hydantoinase/oxoprolinase family protein [Rubrobacter xylanophilus] | diamond | 960 | 143 | 1 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacter | Rubrobacter xylanophilus | ||
| 28720199 | 28720199 | PRJNA549880_P_NODE_12227_length_248_cov_0.880000_g12134_i0 | PRJNA549880 | 12227 | 248 | 0.88 | 2.1824 | Saccharopolyspora dendranthemae | 1181886 | Bacteria | Bacteria | 167 | 2.9799999999999998e-46 | NR | WP_145738170.1 | 1181886 | g12134 | i0 | 97.6 | 0.991935483870968 | 82 | 2 | 99.2 | 0 | 3 | 248 | 229 | 310 | WP_145738170.1 GtrA family protein [Saccharopolyspora dendranthemae] | diamond | 246 | 167 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Saccharopolyspora | Saccharopolyspora dendranthemae | ||
| 28751659 | 28751659 | PRJNA549880_P_NODE_10447_length_251_cov_0.865169_g10354_i0 | PRJNA549880 | 10447 | 251 | 0.865169 | 2.17157419 | Arthrobacter tumbae | 163874 | Bacteria | Bacteria | 154 | 2.21e-41 | NR | WP_204530929.1 | 163874 | g10354 | i0 | 95.2 | 4.9601593625498 | 83 | 4 | 99.2 | 0 | 251 | 3 | 626 | 708 | WP_204530929.1 ATP-dependent DNA helicase RecG [Arthrobacter tumbae] | diamond | 1245 | 154 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter tumbae | ||
| 29524349 | 29524349 | PRJNA549880_P_NODE_13710_length_245_cov_0.895349_g13617_i0 | PRJNA549880 | 13710 | 245 | 0.895349 | 2.19360505 | Janibacter | 53457 | Bacteria | Bacteria | 122 | 1.8399999999999998e-31 | NR | WP_165399562.1 | 53458 | g13617 | i0 | 74.1 | 4.95918367346939 | 81 | 21 | 99.2 | 0 | 3 | 245 | 37 | 117 | WP_165399562.1 AMP-binding protein [Janibacter limosus] | diamond | 1215 | 123 | 0.991869918699187 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Janibacter | Janibacter limosus | ||
| 30029708 | 30029708 | PRJNA549880_P_NODE_9151_length_268_cov_1.579487_g9058_i0 | PRJNA549880 | 9151 | 268 | 1.579487 | 4.23302516 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 81.6 | 5.5e-18 | NR | MCW2971728.1 | 2026888 | g9058 | i0 | 58.4 | 4.52238805970149 | 77 | 30 | 86.2 | 1 | 22 | 252 | 14 | 88 | MCW2971728.1 adenine phosphoribosyltransferase [Thermoleophilia bacterium] | diamond | 1212 | 82.4 | 0.990291262135922 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Thermoleophilia bacterium | |||||
| 30488688 | 30488688 | PRJNA549880_P_NODE_12253_length_248_cov_0.880000_g12160_i0 | PRJNA549880 | 12253 | 248 | 0.88 | 2.1824 | Lawsonella sp. | 2041415 | Bacteria | Bacteria | 173 | 3.959999999999999e-48 | NR | WP_290595345.1 | 2041415 | g12160 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 248 | 3 | 742 | 823 | WP_290595345.1 DEAD/DEAH box helicase [Lawsonella sp.] | diamond | 246 | 173 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella sp. | ||
| 30741392 | 30741392 | PRJNA549880_P_NODE_11794_length_249_cov_0.875000_g11701_i0 | PRJNA549880 | 11794 | 249 | 0.875 | 2.17875 | Pseudoclavibacter sp. | 1915061 | Bacteria | Bacteria | 142 | 1.75e-41 | NR | HHW51297.1 | 1915061 | g11701 | i0 | 98.6 | 0.831325301204819 | 69 | 1 | 83.1 | 0 | 207 | 1 | 1 | 69 | HHW51297.1 hydroxyacid dehydrogenase [Pseudoclavibacter sp.] | diamond | 207 | 142 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Pseudoclavibacter | Pseudoclavibacter sp. | ||
| 32385873 | 32385873 | PRJNA549880_P_NODE_15099_length_242_cov_0.911243_g15006_i0 | PRJNA549880 | 15099 | 242 | 0.911243 | 2.20520806 | unclassified Micrococcus | 2620948 | Bacteria | Bacteria | 123 | 3.86e-33 | NR | WP_248115086.1 | 2620948 | g15006 | i0 | 98.4 | 0.756198347107438 | 61 | 1 | 75.6 | 0 | 11 | 193 | 1 | 61 | WP_248115086.1 MULTISPECIES: acyltransferase [unclassified Micrococcus] | diamond | 183 | 123 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus |
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);;