contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA859990" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7224087 | 7224087 | PRJNA859990_S_NODE_19426_length_247_cov_0.885057_g19165_i0 | PRJNA859990 | 19426 | 247 | 0.885057 | 2.18609079 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 145 | 2.0999999999999999e-38 | NR | XP_069233288.1 | 1052096 | g19165 | i0 | 84.1 | 0.995951417004049 | 82 | 13 | 99.6 | 0 | 246 | 1 | 210 | 291 | XP_069233288.1 AdoMet-dependent rRNA methyltransferase SPB1 [Cladosporium halotolerans] | diamond | 246 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 26960015 | 26960015 | PRJNA859990_S_NODE_18122_length_250_cov_1.333333_g17861_i0 | PRJNA859990 | 18122 | 250 | 1.333333 | 3.3333325 | Beauveria asiatica | 1069075 | Fungi | Fungi | 130 | 3.28e-37 | NR | KAK8141060.1 | 1069075 | g17861 | i0 | 92.9 | 0.84 | 70 | 5 | 84 | 0 | 1 | 210 | 39 | 108 | KAK8141060.1 hypothetical protein G3M48_000905, partial [Beauveria asiatica] | diamond | 210 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Beauveria | Beauveria asiatica | |
| 27023440 | 27023440 | PRJNA859990_S_NODE_22162_length_241_cov_0.916667_g21901_i0 | PRJNA859990 | 22162 | 241 | 0.916667 | 2.20916747 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 53.1 | 4.74e-6 | NR | XP_069233078.1 | 1052096 | g21901 | i0 | 64.9 | 0.460580912863071 | 37 | 10 | 42.3 | 1 | 138 | 239 | 37 | 73 | XP_069233078.1 uncharacterized protein WHR41_01428 [Cladosporium halotolerans] | diamond | 111 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27339730 | 27339730 | PRJNA859990_S_NODE_18003_length_251_cov_0.865169_g17742_i0 | PRJNA859990 | 18003 | 251 | 0.865169 | 2.17157419 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 57 | 3.8e-7 | NR | XP_069233481.1 | 1052096 | g17742 | i0 | 70.3 | 0.442231075697211 | 37 | 10 | 43 | 1 | 227 | 120 | 1 | 37 | XP_069233481.1 H/ACA ribonucleoprotein complex subunit cbf5 [Cladosporium halotolerans] | diamond | 111 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 28034389 | 28034389 | PRJNA859990_S_NODE_21685_length_242_cov_0.911243_g21424_i0 | PRJNA859990 | 21685 | 242 | 0.911243 | 2.20520806 | Neophaeococcomyces mojaviensis | 3383035 | Fungi | Fungi | 152 | 7.72e-41 | NR | KAJ9653070.1 | 3383035 | g21424 | i0 | 97.5 | 0.991735537190083 | 80 | 2 | 99.2 | 0 | 242 | 3 | 341 | 420 | KAJ9653070.1 bud site selection protein [Neophaeococcomyces mojaviensis] | diamond | 240 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Neophaeococcomyces | Neophaeococcomyces mojaviensis | ||
| 28065799 | 28065799 | PRJNA859990_S_NODE_22045_length_241_cov_1.238095_g21784_i0 | PRJNA859990 | 22045 | 241 | 1.238095 | 2.98380895 | Aspergillus puulaauensis | 1220207 | Fungi | Fungi | 93.6 | 3.5e-20 | NR | XP_041562196.1 | 1220207 | g21784 | i0 | 67.2 | 0.796680497925311 | 64 | 21 | 79.7 | 0 | 7 | 198 | 14 | 77 | XP_041562196.1 uncharacterized protein APUU_80313S [Aspergillus puulaauensis] | diamond | 192 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus puulaauensis | |
| 28263235 | 28263235 | PRJNA859990_S_NODE_11306_length_304_cov_5.424242_g11045_i0 | PRJNA859990 | 11306 | 304 | 5.424242 | 16.48969568 | Saccharomycetaceae | 4893 | Fungi | Fungi | 63.2 | 6.44e-10 | NR | KAF4001137.1 | 4932 | g11045 | i0 | 54.5 | 3.23684210526316 | 66 | 20 | 65.1 | 1 | 303 | 106 | 51 | 106 | KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] | diamond | 984 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 28728912 | 28728912 | PRJNA859990_S_NODE_21527_length_242_cov_1.390533_g21266_i0 | PRJNA859990 | 21527 | 242 | 1.390533 | 3.36508986 | Lophiostoma macrostomum CBS 122681 | 1314788 | Fungi | Fungi | 76.3 | 4.95e-14 | NR | KAF2658552.1 | 1314788 | g21266 | i0 | 53.3 | 0.929752066115702 | 75 | 16 | 93 | 1 | 227 | 3 | 1 | 56 | KAF2658552.1 hypothetical protein K491DRAFT_690067 [Lophiostoma macrostomum CBS 122681] | diamond | 225 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lophiostomataceae | Lophiostoma | Lophiostoma macrostomum | |
| 28958250 | 28958250 | PRJNA859990_S_NODE_12408_length_293_cov_1.086364_g12147_i0 | PRJNA859990 | 12408 | 293 | 1.086364 | 3.18304652 | Acarosporaceae | 88746 | Fungi | Fungi | 67 | 2.36e-11 | NR | KAI9805417.1 | 286406 | g12147 | i0 | 66 | 2.68259385665529 | 50 | 17 | 51.2 | 0 | 3 | 152 | 32 | 81 | KAI9805417.1 MAG: hypothetical protein M1825_000668 [Sarcosagium campestre] | diamond | 786 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sarcosagium | Sarcosagium campestre | ||||
| 31232108 | 31232108 | PRJNA859990_S_NODE_11015_length_308_cov_0.953191_g10754_i0 | PRJNA859990 | 11015 | 308 | 0.953191 | 2.93582828 | Dothideomycetes | 147541 | Fungi | Fungi | 214 | 4.72e-65 | NR | TKA75374.1 | 329884 | g10754 | i0 | 97.1 | 15.8961038961039 | 102 | 3 | 99.4 | 0 | 2 | 307 | 54 | 155 | TKA75374.1 hypothetical protein B0A55_06018 [Friedmanniomyces simplex] | diamond | 4896 | 214 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces simplex | |
| 31730132 | 31730132 | PRJNA859990_S_NODE_18477_length_249_cov_1.505682_g18216_i0 | PRJNA859990 | 18477 | 249 | 1.505682 | 3.74914818 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 130 | 2.73e-35 | NR | XP_069228756.1 | 1052096 | g18216 | i0 | 74.4 | 0.987951807228916 | 82 | 21 | 98.8 | 0 | 2 | 247 | 44 | 125 | XP_069228756.1 uncharacterized protein WHR41_06031 [Cladosporium halotolerans] | diamond | 246 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 32553142 | 32553142 | PRJNA859990_S_NODE_19559_length_247_cov_0.862069_g19298_i0 | PRJNA859990 | 19559 | 247 | 0.862069 | 2.12931043 | Trichocladium antarcticum | 1450529 | Fungi | Fungi | 42.7 | 0.0358 | NR | KAK4136691.1 | 1450529 | g19298 | i0 | 44.9 | 0.595141700404858 | 49 | 17 | 59.5 | 1 | 203 | 57 | 257 | 295 | KAK4136691.1 hypothetical protein BT67DRAFT_188219 [Trichocladium antarcticum] | diamond | 147 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Trichocladium | Trichocladium antarcticum | |
| 32749937 | 32749937 | PRJNA859990_S_NODE_19060_length_248_cov_0.880000_g18799_i0 | PRJNA859990 | 19060 | 248 | 0.88 | 2.1824 | Dothideomycetes | 147541 | Fungi | Fungi | 90.9 | 4.56e-19 | NR | OQO22684.1 | 1974281 | g18799 | i0 | 52.4 | 1.98387096774194 | 82 | 39 | 99.2 | 0 | 2 | 247 | 608 | 689 | OQO22684.1 hypothetical protein B0A51_10374 [Rachicladosporium sp. CCFEE 5018] | diamond | 492 | 91.7 | 0.991275899672846 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Rachicladosporium | Rachicladosporium sp. CCFEE 5018 |
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);;