contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA846110" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3383815 | 3383815 | PRJNA846110_P_NODE_21003_length_258_cov_1.583784_g20758_i0 | PRJNA846110 | 21003 | 258 | 1.583784 | 4.08616272 | Dothideomycetes | 147541 | Fungi | Fungi | 152 | 1.36e-40 | NR | KAH9811186.1 | 418781 | g20758 | i0 | 83.7 | 17 | 86 | 14 | 100 | 0 | 258 | 1 | 73 | 158 | KAH9811186.1 putative lipase, partial [Teratosphaeria destructans] | diamond | 4386 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Teratosphaeria | Teratosphaeria destructans | |
| 7211208 | 7211208 | PRJNA846110_P_NODE_25526_length_247_cov_0.885057_g25281_i0 | PRJNA846110 | 25526 | 247 | 0.885057 | 2.18609079 | Cercospora zeae-maydis SCOH1-5 | 717836 | Fungi | Fungi | 119 | 2.66e-31 | NR | KAF2208933.1 | 717836 | g25281 | i0 | 75.6 | 10.9676113360324 | 82 | 15 | 99.6 | 1 | 2 | 247 | 159 | 235 | KAF2208933.1 hypothetical protein CERZMDRAFT_114266 [Cercospora zeae-maydis SCOH1-5] | diamond | 2709 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Cercospora | Cercospora zeae-maydis | |
| 8485868 | 8485868 | PRJNA846110_P_NODE_21247_length_257_cov_1.293478_g21002_i0 | PRJNA846110 | 21247 | 257 | 1.293478 | 3.32423846 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 152 | 1.77e-40 | NR | XP_069230797.1 | 1052096 | g21002 | i0 | 88.2 | 0.992217898832685 | 85 | 10 | 99.2 | 0 | 255 | 1 | 1150 | 1234 | XP_069230797.1 uncharacterized protein WHR41_03526 [Cladosporium halotolerans] | diamond | 255 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 18684380 | 18684380 | PRJNA846110_P_NODE_26015_length_246_cov_1.780347_g25770_i0 | PRJNA846110 | 26015 | 246 | 1.780347 | 4.37965362 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 154 | 2.29e-41 | NR | KAK3181051.1 | 1964301 | g25770 | i0 | 86.4 | 0.98780487804878 | 81 | 11 | 98.8 | 0 | 3 | 245 | 549 | 629 | KAK3181051.1 mediator complex subunit [Lecanicillium sp. MT-2017a] | diamond | 243 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 26643075 | 26643075 | PRJNA846110_P_NODE_5741_length_435_cov_3.436464_g5497_i0 | PRJNA846110 | 5741 | 435 | 3.436464 | 14.9486184 | Lecanicillium saksenae | 468837 | Fungi | Fungi | 49.3 | 4.06e-4 | NR | KAJ3499711.1 | 468837 | g5497 | i0 | 46 | 0.6 | 87 | 41 | 57.2 | 2 | 346 | 98 | 64 | 148 | KAJ3499711.1 hypothetical protein NLG97_g106 [Lecanicillium saksenae] | diamond | 261 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium saksenae | |
| 26801486 | 26801486 | PRJNA846110_P_NODE_24401_length_249_cov_0.875000_g24156_i0 | PRJNA846110 | 24401 | 249 | 0.875 | 2.17875 | Pseudopithomyces chartarum | 1892770 | Fungi | Fungi | 139 | 4.58e-36 | NR | KAK3201841.1 | 1892770 | g24156 | i0 | 87.8 | 0.891566265060241 | 74 | 9 | 89.2 | 0 | 1 | 222 | 804 | 877 | KAK3201841.1 hypothetical protein GRF29_164g810128 [Pseudopithomyces chartarum] | diamond | 222 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymosphaeriaceae | Pseudopithomyces | Pseudopithomyces chartarum | |
| 27212603 | 27212603 | PRJNA846110_P_NODE_20442_length_261_cov_1.324468_g20197_i0 | PRJNA846110 | 20442 | 261 | 1.324468 | 3.45686148 | Penicillium glandicola | 197659 | Fungi | Fungi | 130 | 9.47e-33 | NR | CAI7609051.1 | 197659 | g20197 | i0 | 74.4 | 0.896551724137931 | 78 | 20 | 89.7 | 0 | 28 | 261 | 336 | 413 | CAI7609051.1 unnamed protein product [Penicillium glandicola] | diamond | 234 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium glandicola | |
| 27339364 | 27339364 | PRJNA846110_P_NODE_26903_length_245_cov_1.261628_g26658_i0 | PRJNA846110 | 26903 | 245 | 1.261628 | 3.0909886 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 121 | 3.52e-30 | NR | XP_043140684.1 | 182096 | g26658 | i0 | 75.8 | 0.808163265306122 | 66 | 16 | 80.8 | 0 | 245 | 48 | 62 | 127 | XP_043140684.1 uncharacterized protein ACHE_80071S [Aspergillus chevalieri] | diamond | 198 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 27402503 | 27402503 | PRJNA846110_P_NODE_25103_length_248_cov_0.880000_g24858_i0 | PRJNA846110 | 25103 | 248 | 0.88 | 2.1824 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 82.8 | 1.53e-17 | NR | XP_033666915.1 | 1080233 | g24858 | i0 | 55.1 | 1.92338709677419 | 78 | 31 | 89.5 | 3 | 26 | 247 | 17 | 94 | XP_033666915.1 uncharacterized protein M409DRAFT_23754 [Zasmidium cellare ATCC 36951] | diamond | 477 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 27718577 | 27718577 | PRJNA846110_P_NODE_20104_length_262_cov_3.354497_g19859_i0 | PRJNA846110 | 20104 | 262 | 3.354497 | 8.78878214 | Hortaea werneckii | 91943 | Fungi | Fungi | 122 | 5.0899999999999994e-30 | NR | RMZ09662.1 | 91943 | g19859 | i0 | 64.8 | 13.5114503816794 | 88 | 29 | 98.5 | 1 | 3 | 260 | 177 | 264 | RMZ09662.1 hypothetical protein D0864_01460 [Hortaea werneckii] | diamond | 3540 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 28065465 | 28065465 | PRJNA846110_P_NODE_14445_length_290_cov_1.124424_g14200_i0 | PRJNA846110 | 14445 | 290 | 1.124424 | 3.2608296 | Dissoconium aciculare CBS 342.82 | 1314786 | Fungi | Fungi | 48.9 | 3.92e-4 | NR | XP_033458376.1 | 1314786 | g14200 | i0 | 36.2 | 0.713793103448276 | 69 | 36 | 71.4 | 2 | 281 | 75 | 49 | 109 | XP_033458376.1 uncharacterized protein K489DRAFT_246404 [Dissoconium aciculare CBS 342.82] | diamond | 207 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Dissoconiaceae | Dissoconium | Dissoconium aciculare | |
| 28484401 | 28484401 | PRJNA846110_P_NODE_25146_length_248_cov_0.880000_g24901_i0 | PRJNA846110 | 25146 | 248 | 0.88 | 2.1824 | Zasmidium | 395590 | Fungi | Fungi | 132 | 1.57e-33 | NR | KAK4503982.1 | 395010 | g24901 | i0 | 78 | 1.98387096774194 | 82 | 18 | 99.2 | 0 | 1 | 246 | 273 | 354 | KAK4503982.1 hypothetical protein PRZ48_004897 [Zasmidium cellare] | diamond | 492 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 29044441 | 29044441 | PRJNA846110_P_NODE_24048_length_249_cov_0.875000_g23803_i0 | PRJNA846110 | 24048 | 249 | 0.875 | 2.17875 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 102 | 5.709999999999999e-23 | NR | XP_022404318.1 | 1160497 | g23803 | i0 | 82.4 | 0.819277108433735 | 68 | 10 | 80.7 | 2 | 49 | 249 | 666 | 732 | XP_022404318.1 uncharacterized protein ASPGLDRAFT_63781 [Aspergillus glaucus CBS 516.65] | diamond | 204 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 29202268 | 29202268 | PRJNA846110_P_NODE_17969_length_273_cov_1.445000_g17724_i0 | PRJNA846110 | 17969 | 273 | 1.445 | 3.94485 | Recurvomyces mirabilis | 574656 | Fungi | Fungi | 127 | 5.12e-34 | NR | XP_064693274.1 | 574656 | g17724 | i0 | 65.9 | 1 | 91 | 31 | 100 | 0 | 273 | 1 | 14 | 104 | XP_064693274.1 uncharacterized protein LTS14_006329 [Recurvomyces mirabilis] | diamond | 273 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 29305176 | 29305176 | PRJNA846110_P_NODE_20529_length_260_cov_2.267380_g20284_i0 | PRJNA846110 | 20529 | 260 | 2.26738 | 5.895188 | Didymosphaeriaceae | 221678 | Fungi | Fungi | 98.6 | 3.5999999999999986e-24 | NR | KAF2444365.1 | 1392251 | g20284 | i0 | 64.9 | 6.66923076923077 | 74 | 25 | 85.4 | 1 | 37 | 258 | 1 | 73 | KAF2444365.1 ACN9-domain-containing protein [Karstenula rhodostoma CBS 690.94] | diamond | 1734 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymosphaeriaceae | Karstenula | Karstenula rhodostoma | |
| 29360066 | 29360066 | PRJNA846110_P_NODE_22269_length_251_cov_2.735955_g22024_i0 | PRJNA846110 | 22269 | 251 | 2.735955 | 6.86724705 | Aspergillus nanangensis | 2582783 | Fungi | Fungi | 96.3 | 6.2e-21 | NR | KAF9892847.1 | 2582783 | g22024 | i0 | 62.1 | 3.25099601593626 | 87 | 28 | 98 | 1 | 248 | 3 | 428 | 514 | KAF9892847.1 hypothetical protein FE257_000436 [Aspergillus nanangensis] | diamond | 816 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus nanangensis | |
| 29422944 | 29422944 | PRJNA846110_P_NODE_22549_length_251_cov_0.865169_g22304_i0 | PRJNA846110 | 22549 | 251 | 0.865169 | 2.17157419 | Dissoconium aciculare CBS 342.82 | 1314786 | Fungi | Fungi | 56.2 | 7.05e-7 | NR | XP_033458230.1 | 1314786 | g22304 | i0 | 58.3 | 0.573705179282869 | 48 | 20 | 57.4 | 0 | 10 | 153 | 114 | 161 | XP_033458230.1 uncharacterized protein K489DRAFT_372120 [Dissoconium aciculare CBS 342.82] | diamond | 144 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Dissoconiaceae | Dissoconium | Dissoconium aciculare | |
| 29620545 | 29620545 | PRJNA846110_P_NODE_27010_length_245_cov_0.895349_g26765_i0 | PRJNA846110 | 27010 | 245 | 0.895349 | 2.19360505 | Dothideomycetes | 147541 | Fungi | Fungi | 155 | 6.28e-42 | NR | CAK4033032.1 | 111012 | g26765 | i0 | 90.1 | 18.8326530612245 | 81 | 8 | 99.2 | 0 | 244 | 2 | 603 | 683 | CAK4033032.1 Copper amine oxidase 1 [Lecanosticta acicola] | diamond | 4614 | 156 | 0.993589743589744 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Lecanosticta | Lecanosticta acicola | |
| 29801957 | 29801957 | PRJNA846110_P_NODE_16311_length_281_cov_1.370192_g16066_i0 | PRJNA846110 | 16311 | 281 | 1.370192 | 3.85023952 | Hortaea werneckii | 91943 | Fungi | Fungi | 184 | 9.82e-52 | NR | KAI7692317.1 | 91943 | g16066 | i0 | 98.9 | 6.95017793594306 | 93 | 1 | 99.3 | 0 | 281 | 3 | 355 | 447 | KAI7692317.1 origin recognition complex, subunit 4, partial [Hortaea werneckii] | diamond | 1953 | 184 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 29928558 | 29928558 | PRJNA846110_P_NODE_29571_length_242_cov_0.911243_g29326_i0 | PRJNA846110 | 29571 | 242 | 0.911243 | 2.20520806 | Diaporthe amygdali | 1214568 | Fungi | Fungi | 58.5 | 9.21e-8 | NR | XP_053000557.1 | 1214568 | g29326 | i0 | 52.2 | 0.830578512396694 | 67 | 26 | 75.6 | 2 | 58 | 240 | 3 | 69 | XP_053000557.1 uncharacterized protein J7T55_005786 [Diaporthe amygdali] | diamond | 201 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe amygdali | |
| 31034516 | 31034516 | PRJNA846110_P_NODE_16115_length_282_cov_1.277512_g15870_i0 | PRJNA846110 | 16115 | 282 | 1.277512 | 3.60258384 | Aspergillus tubingensis | 5068 | Fungi | Fungi | 43.1 | 0.0431 | NR | XP_035354173.1 | 5068 | g15870 | i0 | 43.5 | 0.48936170212766 | 46 | 25 | 47.9 | 1 | 203 | 69 | 544 | 589 | XP_035354173.1 MFS sugar transporter [Aspergillus tubingensis] | diamond | 138 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus tubingensis | |
| 31445212 | 31445212 | PRJNA846110_P_NODE_19316_length_266_cov_2.212435_g19071_i0 | PRJNA846110 | 19316 | 266 | 2.212435 | 5.8850771 | Dissoconium aciculare CBS 342.82 | 1314786 | Fungi | Fungi | 51.6 | 3.79e-5 | NR | XP_033462774.1 | 1314786 | g19071 | i0 | 65.9 | 0.496240601503759 | 44 | 9 | 49.6 | 2 | 154 | 23 | 501 | 538 | XP_033462774.1 uncharacterized protein K489DRAFT_393407 [Dissoconium aciculare CBS 342.82] | diamond | 132 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Dissoconiaceae | Dissoconium | Dissoconium aciculare | |
| 32014584 | 32014584 | PRJNA846110_P_NODE_24738_length_248_cov_0.880000_g24493_i0 | PRJNA846110 | 24738 | 248 | 0.88 | 2.1824 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 107 | 9.69e-25 | NR | XP_022400888.1 | 1160497 | g24493 | i0 | 71.1 | 1.00403225806452 | 83 | 23 | 99.2 | 1 | 3 | 248 | 509 | 591 | XP_022400888.1 uncharacterized protein ASPGLDRAFT_57913 [Aspergillus glaucus CBS 516.65] | diamond | 249 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 32772875 | 32772875 | PRJNA846110_P_NODE_28300_length_243_cov_1.458824_g28055_i0 | PRJNA846110 | 28300 | 243 | 1.458824 | 3.54494232 | Diaporthe helianthi | 158607 | Fungi | Fungi | 53.1 | 3.66e-6 | NR | POS69857.1 | 158607 | g28055 | i0 | 66 | 0.580246913580247 | 47 | 13 | 58 | 2 | 101 | 241 | 99 | 142 | POS69857.1 hypothetical protein DHEL01_v211749 [Diaporthe helianthi] | diamond | 141 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe helianthi |
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);;