contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA610520" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15891450 | 15891450 | PRJNA610520_S_NODE_56133_length_260_cov_1.609626_g56043_i0 | PRJNA610520 | 56133 | 260 | 1.609626 | 4.1850276 | Ascomycota | 4890 | Fungi | Fungi | 108 | 1.26e-27 | NR | XP_023628946.1 | 112498 | g56043 | i0 | 77.3 | 32.7461538461538 | 66 | 15 | 76.2 | 0 | 3 | 200 | 100 | 165 | XP_023628946.1 ubiquitin-conjugating enzyme E2-18 kDa [Ramularia collo-cygni] | diamond | 8514 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 15891519 | 15891519 | PRJNA610520_S_NODE_71553_length_228_cov_2.561290_g71463_i0 | PRJNA610520 | 71553 | 228 | 2.56129 | 5.8397412 | Alternaria | 5598 | Fungi | Fungi | 144 | 2.04e-41 | NR | KAH6846327.1 | 5599 | g71463 | i0 | 94.7 | 5.92105263157895 | 75 | 4 | 98.7 | 0 | 1 | 225 | 127 | 201 | KAH6846327.1 class I glutamine amidotransferase-like protein [Alternaria alternata] | diamond | 1350 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 16450149 | 16450149 | PRJNA610520_S_NODE_37373_length_302_cov_1.681223_g37283_i0 | PRJNA610520 | 37373 | 302 | 1.681223 | 5.07729346 | Eurotiomycetes | 147545 | Fungi | Fungi | 89.7 | 2.09e-18 | NR | KAJ5622330.1 | 69774 | g37283 | i0 | 93.3 | 7.1523178807947 | 45 | 3 | 44.7 | 0 | 300 | 166 | 458 | 502 | KAJ5622330.1 mitochondrial aldehyde dehydrogenase [Penicillium herquei] | diamond | 2160 | 90.5 | 0.991160220994475 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium herquei | |
| 18440465 | 18440465 | PRJNA610520_S_NODE_45255_length_282_cov_4.272727_g45165_i0 | PRJNA610520 | 45255 | 282 | 4.272727 | 12.04909014 | Aspergillus alliaceus | 209559 | Fungi | Fungi | 79.7 | 3.39e-17 | NR | XP_031900895.1 | 209559 | g45165 | i0 | 74.1 | 0.574468085106383 | 54 | 14 | 57.4 | 0 | 280 | 119 | 33 | 86 | XP_031900895.1 heat shock protein 9/12-domain-containing protein [Aspergillus alliaceus] | diamond | 162 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus alliaceus | |
| 26605112 | 26605112 | PRJNA610520_S_NODE_33921_length_311_cov_3.142857_g33831_i0 | PRJNA610520 | 33921 | 311 | 3.142857 | 9.77428527 | Niveomyces insectorum RCEF 264 | 1081102 | Fungi | Fungi | 137 | 5.149999999999999e-37 | NR | OAA57991.1 | 1081102 | g33831 | i0 | 72.3 | 2.39228295819936 | 83 | 23 | 80.1 | 0 | 6 | 254 | 231 | 313 | OAA57991.1 Pyruvate/Phosphoenolpyruvate kinase [Niveomyces insectorum RCEF 264] | diamond | 744 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Niveomyces | Niveomyces insectorum | |
| 26935028 | 26935028 | PRJNA610520_S_NODE_19742_length_360_cov_18.062718_g19652_i0 | PRJNA610520 | 19742 | 360 | 18.062718 | 65.0257848 | Eurotiomycetes | 147545 | Fungi | Fungi | 47 | 0.0018600000000000001 | NR | XP_016260207.1 | 215243 | g19652 | i0 | 61.5 | 5.88333333333333 | 52 | 16 | 43.3 | 2 | 325 | 170 | 112 | 159 | XP_016260207.1 uncharacterized protein PV06_08548 [Exophiala oligosperma] | diamond | 2118 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala oligosperma | |
| 27756907 | 27756907 | PRJNA610520_S_NODE_47084_length_278_cov_2.829268_g46994_i0 | PRJNA610520 | 47084 | 278 | 2.829268 | 7.86536504 | Dothideomycetes | 147541 | Fungi | Fungi | 124 | 4.31e-32 | NR | XP_003835191.1 | 5022 | g46994 | i0 | 94.7 | 28.294964028777 | 57 | 3 | 61.5 | 0 | 277 | 107 | 263 | 319 | XP_003835191.1 electron carrier [Plenodomus lingam] | diamond | 7866 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus lingam | |
| 28722434 | 28722434 | PRJNA610520_S_NODE_50587_length_271_cov_1.555556_g50497_i0 | PRJNA610520 | 50587 | 271 | 1.555556 | 4.21555676 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 110 | 1.04e-29 | NR | KAL2034457.1 | 5580 | g50497 | i0 | 98.2 | 1.21771217712177 | 55 | 1 | 60.9 | 0 | 270 | 106 | 10 | 64 | KAL2034457.1 hypothetical protein VTO58DRAFT_105171 [Aureobasidium pullulans] | diamond | 330 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 29196070 | 29196070 | PRJNA610520_S_NODE_32029_length_317_cov_1.204918_g31939_i0 | PRJNA610520 | 32029 | 317 | 1.204918 | 3.81959006 | Sarocladium strictum | 5046 | Fungi | Fungi | 175 | 6.34e-53 | NR | KAK0390053.1 | 5046 | g31939 | i0 | 81 | 0.993690851735016 | 105 | 20 | 99.4 | 0 | 1 | 315 | 120 | 224 | KAK0390053.1 hypothetical protein NLU13_3626 [Sarocladium strictum] | diamond | 315 | 175 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 29700752 | 29700752 | PRJNA610520_S_NODE_18710_length_365_cov_5.017123_g18620_i0 | PRJNA610520 | 18710 | 365 | 5.017123 | 18.31249895 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 100 | 1.17e-24 | NR | XP_022398178.1 | 1160497 | g18620 | i0 | 75.7 | 0.575342465753425 | 70 | 17 | 57.5 | 0 | 4 | 213 | 55 | 124 | XP_022398178.1 uncharacterized protein ASPGLDRAFT_38248 [Aspergillus glaucus CBS 516.65] | diamond | 210 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 29858931 | 29858931 | PRJNA610520_S_NODE_22031_length_351_cov_1.629496_g21941_i0 | PRJNA610520 | 22031 | 351 | 1.629496 | 5.71953096 | Didymella glomerata | 749621 | Fungi | Fungi | 112 | 1.9000000000000003e-28 | NR | KAJ4331554.1 | 749621 | g21941 | i0 | 82.1 | 0.572649572649573 | 67 | 12 | 57.3 | 0 | 2 | 202 | 128 | 194 | KAJ4331554.1 hypothetical protein N0V87_009055 [Didymella glomerata] | diamond | 201 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella glomerata | |
| 29890759 | 29890759 | PRJNA610520_S_NODE_58971_length_254_cov_4.889503_g58881_i0 | PRJNA610520 | 58971 | 254 | 4.889503 | 12.41933762 | Sarocladium strictum | 5046 | Fungi | Fungi | 89.7 | 1.47e-19 | NR | KAK0392484.1 | 5046 | g58881 | i0 | 97.8 | 0.531496062992126 | 45 | 1 | 53.1 | 0 | 135 | 1 | 1 | 45 | KAK0392484.1 hypothetical protein NLU13_1979 [Sarocladium strictum] | diamond | 135 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31167202 | 31167202 | PRJNA610520_S_NODE_70415_length_235_cov_2.790123_g70325_i0 | PRJNA610520 | 70415 | 235 | 2.790123 | 6.55678905 | Aspergillus | 5052 | Fungi | Fungi | 118 | 1.06e-30 | NR | CEL05197.1 | 454130 | g70325 | i0 | 83.6 | 8.51489361702128 | 61 | 10 | 77.9 | 0 | 235 | 53 | 195 | 255 | CEL05197.1 Putative Nitroreductase family protein [Aspergillus calidoustus] | diamond | 2001 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus calidoustus | |
| 31249152 | 31249152 | PRJNA610520_S_NODE_35075_length_308_cov_2.293617_g34985_i0 | PRJNA610520 | 35075 | 308 | 2.293617 | 7.06434036 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 143 | 4.79e-39 | NR | THX84787.1 | 5580 | g34985 | i0 | 97.2 | 2.07467532467532 | 71 | 2 | 69.2 | 0 | 3 | 215 | 282 | 352 | THX84787.1 alpha/beta hydrolase fold family protein [Aureobasidium pullulans] | diamond | 639 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 31407485 | 31407485 | PRJNA610520_S_NODE_27416_length_331_cov_3.310078_g27326_i0 | PRJNA610520 | 27416 | 331 | 3.310078 | 10.95635818 | Dothidotthia symphoricarpi CBS 119687 | 1392245 | Fungi | Fungi | 55.8 | 2.84e-7 | NR | XP_033523900.1 | 1392245 | g27326 | i0 | 40 | 1.79456193353474 | 70 | 41 | 63.4 | 1 | 327 | 118 | 43 | 111 | XP_033523900.1 uncharacterized protein P153DRAFT_385716 [Dothidotthia symphoricarpi CBS 119687] | diamond | 594 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Dothidotthiaceae | Dothidotthia | Dothidotthia symphoricarpi | |
| 31660226 | 31660226 | PRJNA610520_S_NODE_24397_length_342_cov_1.527881_g24307_i0 | PRJNA610520 | 24397 | 342 | 1.527881 | 5.22535302 | Penicillium roqueforti | 5082 | Fungi | Fungi | 44.7 | 0.00374 | NR | XP_038925110.1 | 5082 | g24307 | i0 | 57.9 | 1.06140350877193 | 38 | 16 | 33.3 | 0 | 337 | 224 | 9 | 46 | XP_038925110.1 con-6 [Penicillium roqueforti] | diamond | 363 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 31660227 | 31660227 | PRJNA610520_S_NODE_44877_length_283_cov_2.957143_g44787_i0 | PRJNA610520 | 44877 | 283 | 2.957143 | 8.36871469 | Colletotrichum phormii | 359342 | Fungi | Fungi | 68.9 | 1.74e-11 | NR | XP_060450848.1 | 359342 | g44787 | i0 | 43.5 | 0.975265017667845 | 92 | 47 | 97.5 | 2 | 3 | 278 | 162 | 248 | XP_060450848.1 meiotic recombination protein DMC1 [Colletotrichum phormii] | diamond | 276 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum phormii | |
| 31705151 | 31705151 | PRJNA610520_S_NODE_37937_length_300_cov_4.044053_g37847_i0 | PRJNA610520 | 37937 | 300 | 4.044053 | 12.132159 | Aspergillaceae | 1131492 | Fungi | Fungi | 92 | 1.34e-20 | NR | CEO59317.1 | 104259 | g37847 | i0 | 76.8 | 4.47 | 56 | 13 | 56 | 0 | 2 | 169 | 155 | 210 | CEO59317.1 Putative Blue light-inducible protein Bli-3 [Penicillium brasilianum] | diamond | 1341 | 92.8 | 0.991379310344828 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brasilianum | |
| 31850115 | 31850115 | PRJNA610520_S_NODE_54857_length_262_cov_4.000000_g54767_i0 | PRJNA610520 | 54857 | 262 | 4 | 10.48 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 119 | 2.2099999999999998e-32 | NR | XP_043132638.1 | 182096 | g54767 | i0 | 83.3 | 1.64885496183206 | 72 | 12 | 82.4 | 0 | 3 | 218 | 53 | 124 | XP_043132638.1 uncharacterized protein ACHE_11518A [Aspergillus chevalieri] | diamond | 432 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 31913454 | 31913454 | PRJNA610520_S_NODE_24337_length_342_cov_2.293680_g24247_i0 | PRJNA610520 | 24337 | 342 | 2.29368 | 7.8443856 | Aspergillus avenaceus | 36643 | Fungi | Fungi | 108 | 4.58e-27 | NR | KAE8155292.1 | 36643 | g24247 | i0 | 73.3 | 1.12280701754386 | 60 | 16 | 52.6 | 0 | 262 | 83 | 115 | 174 | KAE8155292.1 hypothetical protein BDV25DRAFT_135039 [Aspergillus avenaceus] | diamond | 384 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus avenaceus | |
| 32243341 | 32243341 | PRJNA610520_S_NODE_69918_length_238_cov_2.484848_g69828_i0 | PRJNA610520 | 69918 | 238 | 2.484848 | 5.91393824 | Aspergillus | 5052 | Fungi | Fungi | 74.3 | 6.62e-15 | NR | XHG09102.1 | 5066 | g69828 | i0 | 83 | 4.70168067226891 | 47 | 8 | 59.2 | 0 | 27 | 167 | 76 | 122 | XHG09102.1 hypothetical protein AWENTII_012183 [Aspergillus wentii] | diamond | 1119 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus wentii | |
| 32514927 | 32514927 | PRJNA610520_S_NODE_32519_length_315_cov_2.863636_g32429_i0 | PRJNA610520 | 32519 | 315 | 2.863636 | 9.0204534 | Cladophialophora chaetospira | 386627 | Fungi | Fungi | 52.8 | 8.51e-6 | NR | KAJ9606153.1 | 386627 | g32429 | i0 | 41.4 | 0.666666666666667 | 70 | 30 | 65.7 | 2 | 62 | 268 | 69 | 128 | KAJ9606153.1 hypothetical protein H2200_009114 [Cladophialophora chaetospira] | diamond | 210 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora chaetospira | |
| 32653603 | 32653603 | PRJNA610520_S_NODE_55020_length_262_cov_1.830688_g54930_i0 | PRJNA610520 | 55020 | 262 | 1.830688 | 4.79640256 | Ascomycota | 4890 | Fungi | Fungi | 45.8 | 3.84e-4 | NR | MCJ1248835.1 | 129515 | g54930 | i0 | 47.5 | 1.35114503816794 | 59 | 31 | 67.6 | 0 | 2 | 178 | 13 | 71 | MCJ1248835.1 Glucose-repressible protein [Trapelia coarctata] | diamond | 354 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Trapeliales | Trapeliaceae | Trapelia | Trapelia coarctata |
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);;