contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 290030 | 290030 | PRJNA1146029_P_NODE_15521_length_253_cov_2.138889_g15240_i0 | PRJNA1146029 | 15521 | 253 | 2.138889 | 5.41138917 | Stachybotryaceae | 1667166 | Fungi | Fungi | 106 | 9.3e-25 | NR | KAH7326500.1 | 80388 | g15240 | i0 | 58.6 | 4.9802371541502 | 87 | 33 | 99.6 | 1 | 2 | 253 | 389 | 475 | KAH7326500.1 protein disulfide isomerase [Stachybotrys elegans] | diamond | 1260 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Stachybotryaceae | Stachybotrys | Stachybotrys elegans | |
| 1564804 | 1564804 | PRJNA1146029_P_NODE_21602_length_242_cov_0.911243_g21321_i0 | PRJNA1146029 | 21602 | 242 | 0.911243 | 2.20520806 | Arxiozyma heterogenica | 278026 | Fungi | Fungi | 53.1 | 7.97e-6 | NR | XP_064714813.1 | 278026 | g21321 | i0 | 39.2 | 2.83884297520661 | 79 | 46 | 95.5 | 1 | 3 | 233 | 29 | 107 | XP_064714813.1 uncharacterized protein PWA37_001480 [Arxiozyma heterogenica] | diamond | 687 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Arxiozyma | Arxiozyma heterogenica | |
| 1564844 | 1564844 | PRJNA1146029_P_NODE_5262_length_379_cov_2.013072_g4984_i0 | PRJNA1146029 | 5262 | 379 | 2.013072 | 7.62954288 | Gnomoniopsis smithogilvyi | 1191159 | Fungi | Fungi | 191 | 3.3199999999999996e-60 | NR | ALF37548.1 | 1191159 | g4984 | i0 | 71 | 2.84168865435356 | 124 | 36 | 98.2 | 0 | 377 | 6 | 3 | 126 | ALF37548.1 guanine nucleotide-binding protein subunit beta-like protein, partial [Gnomoniopsis smithogilvyi] | diamond | 1077 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Gnomoniaceae | Gnomoniopsis | Gnomoniopsis smithogilvyi | |
| 11236892 | 11236892 | PRJNA1146029_P_NODE_16829_length_250_cov_0.870056_g16548_i0 | PRJNA1146029 | 16829 | 250 | 0.870056 | 2.17514 | Fungi | 4751 | Fungi | Fungi | 106 | 1.36e-24 | NR | MDI1485777.1 | 258253 | g16548 | i0 | 69.9 | 9.828 | 73 | 22 | 87.6 | 0 | 220 | 2 | 301 | 373 | MDI1485777.1 DNA repair helicase RAD25 [Ramalina farinacea] | diamond | 2457 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Lecanorales | Ramalinaceae | Ramalina | Ramalina farinacea | |
| 26627405 | 26627405 | PRJNA1146029_P_NODE_20981_length_243_cov_0.905882_g20700_i0 | PRJNA1146029 | 20981 | 243 | 0.905882 | 2.20129326 | Pachysolen tannophilus NRRL Y-246 | 4918 | Fungi | Fungi | 64.3 | 7.06e-10 | NR | ODV93322.1 | 669874 | g20700 | i0 | 45.6 | 1.74074074074074 | 68 | 32 | 84 | 1 | 233 | 30 | 128 | 190 | ODV93322.1 hypothetical protein PACTADRAFT_46923 [Pachysolen tannophilus NRRL Y-2460] | diamond | 423 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Alaninales | Pachysolenaceae | Pachysolen | Pachysolen tannophilus | |
| 26690695 | 26690695 | PRJNA1146029_P_NODE_11181_length_283_cov_1.466667_g10900_i0 | PRJNA1146029 | 11181 | 283 | 1.466667 | 4.15066761 | Blumeria graminis f. sp. tritici 96224 | 1268274 | Fungi | Fungi | 64.7 | 4.78e-11 | NR | EPQ65637.1 | 1268274 | g10900 | i0 | 53.7 | 0.710247349823322 | 67 | 30 | 70 | 1 | 278 | 81 | 1 | 67 | EPQ65637.1 Ribosomal protein P2 beta [Blumeria graminis f. sp. tritici 96224] | diamond | 201 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria graminis | |
| 26869889 | 26869889 | PRJNA1146029_P_NODE_7321_length_331_cov_1.193798_g7043_i0 | PRJNA1146029 | 7321 | 331 | 1.193798 | 3.95147138 | Fungi | 4751 | Fungi | Fungi | 142 | 8.100000000000001e-37 | NR | GAO48315.1 | 698492 | g7043 | i0 | 65.1 | 18.3262839879154 | 109 | 38 | 98.8 | 0 | 3 | 329 | 879 | 987 | GAO48315.1 hypothetical protein G7K_2492-t1 [Saitoella complicata NRRL Y-17804] | diamond | 6066 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 27596726 | 27596726 | PRJNA1146029_P_NODE_21464_length_242_cov_0.911243_g21183_i0 | PRJNA1146029 | 21464 | 242 | 0.911243 | 2.20520806 | Aureobasidium | 5579 | Fungi | Fungi | 42.4 | 0.0477 | NR | KAI5199870.1 | 1042127 | g21183 | i0 | 29.3 | 1.8595041322314 | 75 | 50 | 89.3 | 1 | 10 | 225 | 49 | 123 | KAI5199870.1 hypothetical protein E4T38_06816 [Aureobasidium subglaciale] | diamond | 450 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium subglaciale | |
| 28270527 | 28270527 | PRJNA1146029_P_NODE_13706_length_267_cov_1.190722_g13425_i0 | PRJNA1146029 | 13706 | 267 | 1.190722 | 3.17922774 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 190 | 2.45e-60 | NR | KAJ8134228.1 | 27326 | g13425 | i0 | 100 | 0.98876404494382 | 88 | 0 | 98.9 | 0 | 266 | 3 | 13 | 100 | KAJ8134228.1 hypothetical protein OY671_012559, partial [Metschnikowia pulcherrima] | diamond | 264 | 190 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 28744360 | 28744360 | PRJNA1146029_P_NODE_3707_length_443_cov_1.240541_g3429_i0 | PRJNA1146029 | 3707 | 443 | 1.240541 | 5.49559663 | Xylogone sp. PMI_7 | 1769369 | Fungi | Fungi | 45.1 | 0.0323 | NR | KAH8820196.1 | 2614602 | g3429 | i0 | 45.3 | 0.358916478555305 | 53 | 24 | 35.2 | 2 | 160 | 5 | 129 | 177 | KAH8820196.1 hypothetical protein F5884DRAFT_39692 [Xylogone sp. PMI_703] | diamond | 159 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Xylogone | Xylogone sp. PMI_703 | |||
| 29249373 | 29249373 | PRJNA1146029_P_NODE_16649_length_250_cov_0.870056_g16368_i0 | PRJNA1146029 | 16649 | 250 | 0.870056 | 2.17514 | Xylographa carneopallida | 1590122 | Fungi | Fungi | 52.4 | 1.61e-5 | NR | MCJ1296781.1 | 1590122 | g16368 | i0 | 43.6 | 1.164 | 55 | 28 | 66 | 1 | 78 | 242 | 790 | 841 | MCJ1296781.1 hypothetical protein [Xylographa carneopallida] | diamond | 291 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Xylographa | Xylographa carneopallida | |
| 30070490 | 30070490 | PRJNA1146029_P_NODE_2672_length_523_cov_2.226667_g2396_i0 | PRJNA1146029 | 2672 | 523 | 2.226667 | 11.64546841 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 97.8 | 7.59e-23 | NR | XP_023629431.1 | 112498 | g2396 | i0 | 59.8 | 0.64244741873805 | 112 | 42 | 63.7 | 2 | 504 | 172 | 1 | 110 | XP_023629431.1 probable ribosomal protein P2 [Ramularia collo-cygni] | diamond | 336 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 30860500 | 30860500 | PRJNA1146029_P_NODE_9914_length_290_cov_1.741935_g9633_i0 | PRJNA1146029 | 9914 | 290 | 1.741935 | 5.0516115 | Dendryphion nanum | 256645 | Fungi | Fungi | 43.1 | 0.0475 | NR | KAH7109662.1 | 256645 | g9633 | i0 | 40.7 | 0.558620689655172 | 54 | 32 | 55.9 | 0 | 277 | 116 | 605 | 658 | KAH7109662.1 amidase signature domain-containing protein [Dendryphion nanum] | diamond | 162 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Torulaceae | Dendryphion | Dendryphion nanum | |
| 31081729 | 31081729 | PRJNA1146029_P_NODE_7495_length_328_cov_0.905882_g7216_i0 | PRJNA1146029 | 7495 | 328 | 0.905882 | 2.97129296 | Cladorrhinum samala | 585594 | Fungi | Fungi | 97.1 | 8.15e-23 | NR | KAK4460261.1 | 585594 | g7216 | i0 | 46.9 | 5.16768292682927 | 113 | 56 | 99.7 | 2 | 328 | 2 | 23 | 135 | KAK4460261.1 putative translationally-controlled tumor protein [Cladorrhinum samala] | diamond | 1695 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Cladorrhinum | Cladorrhinum samala | |
| 31196520 | 31196520 | PRJNA1146029_P_NODE_14995_length_257_cov_1.978261_g14714_i0 | PRJNA1146029 | 14995 | 257 | 1.978261 | 5.08413077 | Dothideomycetes | 147541 | Fungi | Fungi | 61.2 | 1.34e-8 | NR | THY28228.1 | 5580 | g14714 | i0 | 43.8 | 5.64980544747082 | 64 | 36 | 74.7 | 0 | 48 | 239 | 102 | 165 | THY28228.1 subtilisin-like protein [Aureobasidium pullulans] | diamond | 1452 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 31418266 | 31418266 | PRJNA1146029_P_NODE_20836_length_243_cov_0.905882_g20555_i0 | PRJNA1146029 | 20836 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 58.5 | 1.01e-7 | NR | KAJ6016516.1 | 69774 | g20555 | i0 | 61.5 | 3.88888888888889 | 39 | 15 | 48.1 | 0 | 224 | 108 | 611 | 649 | KAJ6016516.1 hypothetical protein N7540_011107 [Penicillium herquei] | diamond | 945 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium herquei | |
| 31587734 | 31587734 | PRJNA1146029_P_NODE_3836_length_436_cov_2.531680_g3558_i0 | PRJNA1146029 | 3836 | 436 | 2.53168 | 11.0381248 | Choiromyces venosus 12 | 44640 | Fungi | Fungi | 109 | 3.6e-25 | NR | RPA94405.1 | 1336337 | g3558 | i0 | 40.8 | 1.04587155963303 | 152 | 71 | 92.9 | 4 | 435 | 31 | 44 | 193 | RPA94405.1 cuticle-degrading serine protease [Choiromyces venosus 120613-1] | diamond | 456 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tuberaceae | Choiromyces | Choiromyces venosus | |
| 32125589 | 32125589 | PRJNA1146029_P_NODE_20998_length_243_cov_0.905882_g20717_i0 | PRJNA1146029 | 20998 | 243 | 0.905882 | 2.20129326 | Acrodontium crateriforme | 150365 | Fungi | Fungi | 65.9 | 2.6e-10 | NR | WPG99195.1 | 150365 | g20717 | i0 | 87.1 | 0.382716049382716 | 31 | 4 | 38.3 | 0 | 2 | 94 | 581 | 611 | WPG99195.1 Hypothetical protein R9X50_00200600 [Acrodontium crateriforme] | diamond | 93 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme | |
| 32757246 | 32757246 | PRJNA1146029_P_NODE_22160_length_241_cov_0.916667_g21879_i0 | PRJNA1146029 | 22160 | 241 | 0.916667 | 2.20916747 | Nadsonia fulvescens var. elongata DSM 6958 | 857566 | Fungi | Fungi | 72 | 9.27e-14 | NR | ODQ64286.1 | 857566 | g21879 | i0 | 49.4 | 1.91701244813278 | 79 | 39 | 98.3 | 1 | 3 | 239 | 3 | 80 | ODQ64286.1 calmodulin [Nadsonia fulvescens var. elongata DSM 6958] | diamond | 462 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Nadsonia | Nadsonia fulvescens |
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);;