contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5028555 | 5028555 | PRJNA751877_P_NODE_26304_length_246_cov_0.890173_g26182_i0 | PRJNA751877 | 26304 | 246 | 0.890173 | 2.18982558 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 87 | 1.04e-17 | NR | KAK4090026.1 | 33203 | g26182 | i0 | 97.5 | 0.48780487804878 | 40 | 1 | 48.8 | 0 | 1 | 120 | 131 | 170 | KAK4090026.1 hypothetical protein Purlil1_5652 [Purpureocillium lilacinum] | diamond | 120 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 7105158 | 7105158 | PRJNA751877_P_NODE_26946_length_245_cov_0.895349_g26824_i0 | PRJNA751877 | 26946 | 245 | 0.895349 | 2.19360505 | Hypocreales | 5125 | Fungi | Fungi | 107 | 2.92e-27 | NR | POR33722.1 | 94208 | g26824 | i0 | 63.2 | 8.43673469387755 | 76 | 28 | 93.1 | 0 | 229 | 2 | 1 | 76 | POR33722.1 Small nuclear ribonucleoprotein Sm D3 [Tolypocladium paradoxum] | diamond | 2067 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Tolypocladium | Tolypocladium paradoxum | |
| 14755236 | 14755236 | PRJNA751877_P_NODE_23452_length_250_cov_0.870056_g23330_i0 | PRJNA751877 | 23452 | 250 | 0.870056 | 2.17514 | Ascomycota | 4890 | Fungi | Fungi | 108 | 3.9799999999999998e-25 | NR | KAG9787220.1 | 46634 | g23330 | i0 | 68.7 | 22.524 | 83 | 24 | 99.6 | 1 | 2 | 250 | 881 | 961 | KAG9787220.1 beta-glucan synthesis-associated, partial [Aureobasidium melanogenum] | diamond | 5631 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 17304614 | 17304614 | PRJNA751877_P_NODE_29554_length_242_cov_0.911243_g29432_i0 | PRJNA751877 | 29554 | 242 | 0.911243 | 2.20520806 | Aspergillus melleus | 138277 | Fungi | Fungi | 115 | 2.15e-28 | NR | XP_045938525.1 | 138277 | g29432 | i0 | 67.5 | 1.98347107438017 | 80 | 25 | 99.2 | 1 | 3 | 242 | 181 | 259 | XP_045938525.1 uncharacterized protein LDX57_000922 [Aspergillus melleus] | diamond | 480 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus melleus | |
| 26619502 | 26619502 | PRJNA751877_P_NODE_14121_length_306_cov_1.321888_g13999_i0 | PRJNA751877 | 14121 | 306 | 1.321888 | 4.04497728 | Ascomycota | 4890 | Fungi | Fungi | 126 | 1.14e-33 | NR | OUM53127.1 | 5477 | g13999 | i0 | 58.9 | 9.37254901960784 | 95 | 39 | 93.1 | 0 | 302 | 18 | 153 | 247 | OUM53127.1 hypothetical protein BVG19_g2383 [[Candida] boidinii] | diamond | 2868 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | [Candida] boidinii | |
| 27653186 | 27653186 | PRJNA751877_P_NODE_22424_length_251_cov_0.865169_g22302_i0 | PRJNA751877 | 22424 | 251 | 0.865169 | 2.17157419 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 89 | 5.95e-20 | NR | OAQ79143.1 | 33203 | g22302 | i0 | 100 | 0.49003984063745 | 41 | 0 | 49 | 0 | 127 | 249 | 1 | 41 | OAQ79143.1 hypothetical protein VFPBJ_07264 [Purpureocillium lilacinum] | diamond | 123 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 28032004 | 28032004 | PRJNA751877_P_NODE_20205_length_264_cov_1.277487_g20083_i0 | PRJNA751877 | 20205 | 264 | 1.277487 | 3.37256568 | Penicillium herquei | 69774 | Fungi | Fungi | 83.6 | 1.52e-16 | NR | KAJ5627100.1 | 69774 | g20083 | i0 | 75.9 | 0.659090909090909 | 58 | 13 | 65.9 | 1 | 185 | 12 | 113 | 169 | KAJ5627100.1 hypothetical protein N7528_004527, partial [Penicillium herquei] | diamond | 174 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium herquei | |
| 28673398 | 28673398 | PRJNA751877_P_NODE_24687_length_248_cov_0.880000_g24565_i0 | PRJNA751877 | 24687 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 130 | 6.599999999999999e-33 | NR | RPA81968.1 | 1160509 | g24565 | i0 | 67.1 | 1.98387096774194 | 82 | 27 | 99.2 | 0 | 246 | 1 | 108 | 189 | RPA81968.1 hypothetical protein BJ508DRAFT_414444 [Ascobolus immersus RN42] | diamond | 492 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Ascobolaceae | Ascobolus | Ascobolus immersus | |
| 28758045 | 28758045 | PRJNA751877_P_NODE_27447_length_244_cov_1.801170_g27325_i0 | PRJNA751877 | 27447 | 244 | 1.80117 | 4.3948548 | Plectosphaerella cucumerina | 40658 | Fungi | Fungi | 74.7 | 6.06e-14 | NR | KAH7369222.1 | 40658 | g27325 | i0 | 48.8 | 1.0327868852459 | 84 | 35 | 98.4 | 3 | 241 | 2 | 93 | 172 | KAH7369222.1 immunoglobulin E-set [Plectosphaerella cucumerina] | diamond | 252 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Plectosphaerella | Plectosphaerella cucumerina | |
| 29011095 | 29011095 | PRJNA751877_P_NODE_21628_length_254_cov_2.281768_g21506_i0 | PRJNA751877 | 21628 | 254 | 2.281768 | 5.79569072 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 164 | 5.999999999999999e-45 | NR | PWI68897.1 | 33203 | g21506 | i0 | 98.8 | 1.98425196850394 | 84 | 1 | 99.2 | 0 | 2 | 253 | 964 | 1047 | PWI68897.1 hypothetical protein PCL_01282 [Purpureocillium lilacinum] | diamond | 504 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 29074051 | 29074051 | PRJNA751877_P_NODE_2508_length_542_cov_3.332623_g2387_i0 | PRJNA751877 | 2508 | 542 | 3.332623 | 18.06281666 | Wickerhamomyces pijperi | 599730 | Fungi | Fungi | 155 | 6.699999999999998e-43 | NR | KAH3688936.1 | 599730 | g2387 | i0 | 51 | 9.16051660516605 | 149 | 72 | 82.5 | 1 | 535 | 89 | 98 | 245 | KAH3688936.1 hypothetical protein WICPIJ_000109 [Wickerhamomyces pijperi] | diamond | 4965 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces pijperi | |
| 29430856 | 29430856 | PRJNA751877_P_NODE_14849_length_299_cov_2.044248_g14727_i0 | PRJNA751877 | 14849 | 299 | 2.044248 | 6.11230152 | root | 1 | Root_unresolved | Root_unresolved | 119 | 1.84e-32 | NR | KAJ8134344.1 | 27326 | g14727 | i0 | 80.3 | 2.67892976588629 | 71 | 14 | 71.2 | 0 | 86 | 298 | 1 | 71 | KAJ8134344.1 hypothetical protein OY671_012443, partial [Metschnikowia pulcherrima] | diamond | 801 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 29578790 | 29578790 | PRJNA751877_P_NODE_16470_length_287_cov_1.247664_g16348_i0 | PRJNA751877 | 16470 | 287 | 1.247664 | 3.58079568 | Scedosporium apiospermum | 563466 | Fungi | Fungi | 52.8 | 1.5e-5 | NR | XP_016644188.1 | 563466 | g16348 | i0 | 76.7 | 1.02439024390244 | 30 | 7 | 31.4 | 0 | 286 | 197 | 214 | 243 | XP_016644188.1 uncharacterized protein SAPIO_CDS3373 [Scedosporium apiospermum] | diamond | 294 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Scedosporium | Scedosporium apiospermum | |
| 29746587 | 29746587 | PRJNA751877_P_NODE_27010_length_245_cov_0.895349_g26888_i0 | PRJNA751877 | 27010 | 245 | 0.895349 | 2.19360505 | Ascomycota | 4890 | Fungi | Fungi | 136 | 3.47e-35 | NR | OCL05442.1 | 574774 | g26888 | i0 | 82.7 | 2.97551020408163 | 81 | 14 | 99.2 | 0 | 245 | 3 | 698 | 778 | OCL05442.1 anthranilate synthase component II [Glonium stellatum] | diamond | 729 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Gloniales | Gloniaceae | Glonium | Glonium stellatum | |
| 30526653 | 30526653 | PRJNA751877_P_NODE_2033_length_581_cov_1.818898_g1912_i0 | PRJNA751877 | 2033 | 581 | 1.818898 | 10.56779738 | Xylographa carneopallida | 1590122 | Fungi | Fungi | 74.3 | 1.23e-11 | NR | MCJ1296781.1 | 1590122 | g1912 | i0 | 45.7 | 0.418244406196213 | 81 | 35 | 38.7 | 3 | 357 | 581 | 790 | 867 | MCJ1296781.1 hypothetical protein [Xylographa carneopallida] | diamond | 243 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Xylographa | Xylographa carneopallida | |
| 30684556 | 30684556 | PRJNA751877_P_NODE_26613_length_246_cov_0.890173_g26491_i0 | PRJNA751877 | 26613 | 246 | 0.890173 | 2.18982558 | Hyphodiscus hymeniophilus | 353542 | Fungi | Fungi | 80.9 | 1.38e-15 | NR | KAG0648279.1 | 353542 | g26491 | i0 | 67.4 | 0.560975609756098 | 46 | 15 | 56.1 | 0 | 50 | 187 | 291 | 336 | KAG0648279.1 Asparagine-rich zinc finger AZF1 [Hyphodiscus hymeniophilus] | diamond | 138 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Hyphodiscaceae | Hyphodiscus | Hyphodiscus hymeniophilus | |
| 31927613 | 31927613 | PRJNA751877_P_NODE_25317_length_247_cov_1.155172_g25195_i0 | PRJNA751877 | 25317 | 247 | 1.155172 | 2.85327484 | Eukaryota | 2759 | Fungi | Fungi | 52 | 2.12e-5 | NR | KAL4780063.1 | 176181 | g25195 | i0 | 34.9 | 6.72874493927126 | 86 | 48 | 96 | 3 | 244 | 8 | 170 | 254 | KAL4780063.1 ras guanine nucleotide exchange factor domain-containing protein [Aspergillus varians] | diamond | 1662 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus varians | |
| 32012657 | 32012657 | PRJNA751877_P_NODE_27258_length_245_cov_0.895349_g27136_i0 | PRJNA751877 | 27258 | 245 | 0.895349 | 2.19360505 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 98.2 | 1.99e-22 | NR | OAQ95482.1 | 33203 | g27136 | i0 | 93.8 | 0.587755102040816 | 48 | 3 | 58.8 | 0 | 102 | 245 | 100 | 147 | OAQ95482.1 hypothetical protein VFPFJ_01592 [Purpureocillium lilacinum] | diamond | 144 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 32012658 | 32012658 | PRJNA751877_P_NODE_30038_length_241_cov_0.916667_g29916_i0 | PRJNA751877 | 30038 | 241 | 0.916667 | 2.20916747 | Aspergillus terreus NIH2624 | 341663 | Fungi | Fungi | 108 | 3.4999999999999997e-25 | NR | XP_001212019.1 | 341663 | g29916 | i0 | 67.5 | 0.995850622406639 | 80 | 26 | 99.6 | 0 | 241 | 2 | 507 | 586 | XP_001212019.1 uncharacterized protein ATEG_02841 [Aspergillus terreus NIH2624] | diamond | 240 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus terreus | |
| 32202509 | 32202509 | PRJNA751877_P_NODE_29058_length_242_cov_0.911243_g28936_i0 | PRJNA751877 | 29058 | 242 | 0.911243 | 2.20520806 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 136 | 3.3999999999999997e-35 | NR | XP_022402378.1 | 1160497 | g28936 | i0 | 84.6 | 2.88842975206612 | 78 | 12 | 96.7 | 0 | 1 | 234 | 632 | 709 | XP_022402378.1 uncharacterized protein ASPGLDRAFT_45674 [Aspergillus glaucus CBS 516.65] | diamond | 699 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 32487407 | 32487407 | PRJNA751877_P_NODE_25539_length_247_cov_0.885057_g25417_i0 | PRJNA751877 | 25539 | 247 | 0.885057 | 2.18609079 | Penicillium oxalicum | 69781 | Fungi | Fungi | 43.9 | 0.0152 | NR | XP_049969900.1 | 69781 | g25417 | i0 | 43.8 | 0.777327935222672 | 64 | 23 | 77.7 | 2 | 215 | 24 | 7 | 57 | XP_049969900.1 Kinesin-like protein klpA [Penicillium oxalicum] | diamond | 192 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium oxalicum | |
| 32550824 | 32550824 | PRJNA751877_P_NODE_22099_length_251_cov_1.511236_g21977_i0 | PRJNA751877 | 22099 | 251 | 1.511236 | 3.79320236 | Aspergillus sp. HF37 | 1960876 | Fungi | Fungi | 139 | 3.35e-36 | NR | RMJ25943.1 | 1960876 | g21977 | i0 | 95.2 | 0.99203187250996006 | 83 | 4 | 99.2 | 0 | 3 | 251 | 144 | 226 | RMJ25943.1 TBC domain protein [Aspergillus sp. HF37] | diamond | 249 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sp. HF37 |
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);;