contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB58983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125003 | 125003 | PRJEB58983_P_NODE_30301_length_247_cov_0.896552_g29886_i0 | PRJEB58983 | 30301 | 247 | 0.896552 | 2.21448344 | Pyronemataceae | 110846 | Fungi | Fungi | 103 | 1.1199999999999999e-23 | NR | KAI5818404.1 | 337075 | g29886 | i0 | 56.8 | 3.93522267206478 | 81 | 35 | 98.4 | 0 | 3 | 245 | 1722 | 1802 | KAI5818404.1 hypothetical protein BZA77DRAFT_14709 [Pyronema omphalodes] | diamond | 972 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Pyronema | Pyronema omphalodes | |
| 125026 | 125026 | PRJEB58983_P_NODE_31461_length_244_cov_1.380117_g31046_i0 | PRJEB58983 | 31461 | 244 | 1.380117 | 3.36748548 | Lipomyces japonicus | 56871 | Fungi | Fungi | 156 | 1.48e-44 | NR | XP_066782060.1 | 56871 | g31046 | i0 | 86.4 | 46.8073770491803 | 81 | 11 | 99.6 | 0 | 2 | 244 | 134 | 214 | XP_066782060.1 Serine/threonine-protein phosphatase PP2A catalytic subunit [Lipomyces japonicus] | diamond | 11421 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces japonicus | |
| 1399648 | 1399648 | PRJEB58983_P_NODE_6202_length_494_cov_2.456057_g5788_i0 | PRJEB58983 | 6202 | 494 | 2.456057 | 12.13292158 | Opisthokonta | 33154 | Fungi | Fungi | 226 | 9.33e-73 | NR | XP_035362743.1 | 45133 | g5788 | i0 | 68.9 | 25.2570850202429 | 148 | 46 | 89.9 | 0 | 486 | 43 | 40 | 187 | XP_035362743.1 Nucleoside diphosphate kinase protein [Lasiodiplodia theobromae] | diamond | 12477 | 227 | 0.995594713656388 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Botryosphaeriaceae | Lasiodiplodia | Lasiodiplodia theobromae | |
| 12878407 | 12878407 | PRJEB58983_P_NODE_19351_length_293_cov_7.300000_g18936_i0 | PRJEB58983 | 19351 | 293 | 7.3 | 21.389 | Wickerhamiella sorbophila | 45607 | Fungi | Fungi | 90.1 | 1.06e-20 | NR | XP_024665262.1 | 45607 | g18936 | i0 | 60.5 | 3.20477815699659 | 76 | 30 | 77.8 | 0 | 293 | 66 | 55 | 130 | XP_024665262.1 Histone H2A-beta [Wickerhamiella sorbophila] | diamond | 939 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella sorbophila | |
| 16701658 | 16701658 | PRJEB58983_P_NODE_27074_length_256_cov_1.595628_g26659_i0 | PRJEB58983 | 27074 | 256 | 1.595628 | 4.08480768 | Fungi | 4751 | Fungi | Fungi | 141 | 1.1e-39 | NR | ROW01840.1 | 448051 | g26659 | i0 | 75.3 | 20.859375 | 85 | 21 | 99.6 | 0 | 255 | 1 | 146 | 230 | ROW01840.1 hypothetical protein VMCG_05647 [Cytospora schulzeri] | diamond | 5340 | 142 | 0.992957746478873 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora schulzeri | |
| 16701674 | 16701674 | PRJEB58983_P_NODE_28074_length_252_cov_2.486034_g27659_i0 | PRJEB58983 | 28074 | 252 | 2.486034 | 6.26480568 | Tortispora caseinolytica NRRL Y-17796 | 767744 | Fungi | Fungi | 129 | 2.01e-33 | NR | ODV88432.1 | 767744 | g27659 | i0 | 67.5 | 2.94047619047619 | 80 | 26 | 95.2 | 0 | 252 | 13 | 194 | 273 | ODV88432.1 hypothetical protein CANCADRAFT_146191 [Tortispora caseinolytica NRRL Y-17796] | diamond | 741 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Trigonopsidomycetes | Trigonopsidales | Trigonopsidaceae | Tortispora | Tortispora caseinolytica | |
| 20525762 | 20525762 | PRJEB58983_P_NODE_20397_length_288_cov_1.051163_g19982_i0 | PRJEB58983 | 20397 | 288 | 1.051163 | 3.02734944 | Opisthokonta | 33154 | Fungi | Fungi | 59.3 | 8.21e-9 | NR | NP_592853.1 | 4896 | g19982 | i0 | 75.7 | 5.95833333333333 | 37 | 9 | 38.5 | 0 | 286 | 176 | 66 | 102 | NP_592853.1 40S ribosomal protein eS26 [Schizosaccharomyces pombe] | diamond | 1716 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 26868804 | 26868804 | PRJEB58983_P_NODE_31841_length_243_cov_1.823529_g31426_i0 | PRJEB58983 | 31841 | 243 | 1.823529 | 4.43117547 | Ascomycota | 4890 | Fungi | Fungi | 101 | 5.86e-23 | NR | KXL46420.1 | 245562 | g31426 | i0 | 51.9 | 17.9753086419753 | 81 | 39 | 100 | 0 | 243 | 1 | 332 | 412 | KXL46420.1 MAG: hypothetical protein FE78DRAFT_89456 [Acidomyces sp. 'richmondensis'] | diamond | 4368 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acidomyces | Acidomyces sp. 'richmondensis' | |
| 27191533 | 27191533 | PRJEB58983_P_NODE_35462_length_203_cov_4.992308_g35047_i0 | PRJEB58983 | 35462 | 203 | 4.992308 | 10.13438524 | Dipodascopsis tothii | 44089 | Fungi | Fungi | 56.6 | 1.19e-7 | NR | XP_066791156.1 | 44089 | g35047 | i0 | 58.8 | 4.56650246305419 | 51 | 20 | 73.9 | 1 | 21 | 170 | 147 | 197 | XP_066791156.1 60S ribosomal protein eL6 [Dipodascopsis tothii] | diamond | 927 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Dipodascopsis | Dipodascopsis tothii | |
| 27665646 | 27665646 | PRJEB58983_P_NODE_32244_length_242_cov_1.846154_g31829_i0 | PRJEB58983 | 32244 | 242 | 1.846154 | 4.46769268 | Tortispora caseinolytica NRRL Y-17796 | 767744 | Fungi | Fungi | 105 | 2.76e-24 | NR | ODV91088.1 | 767744 | g31829 | i0 | 64.2 | 1.00413223140496 | 81 | 27 | 97.9 | 1 | 241 | 5 | 334 | 414 | ODV91088.1 hypothetical protein CANCADRAFT_116458 [Tortispora caseinolytica NRRL Y-17796] | diamond | 243 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Trigonopsidomycetes | Trigonopsidales | Trigonopsidaceae | Tortispora | Tortispora caseinolytica | |
| 27697418 | 27697418 | PRJEB58983_P_NODE_28724_length_251_cov_0.870787_g28309_i0 | PRJEB58983 | 28724 | 251 | 0.870787 | 2.18567537 | Diploschistes diacapsis | 150877 | Fungi | Fungi | 62.4 | 4.99e-9 | NR | KAI4143695.1 | 150877 | g28309 | i0 | 40 | 0.896414342629482 | 75 | 45 | 89.6 | 0 | 22 | 246 | 108 | 182 | KAI4143695.1 MAG: hypothetical protein LQ340_006906 [Diploschistes diacapsis] | diamond | 225 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Diploschistes | Diploschistes diacapsis | |
| 28359924 | 28359924 | PRJEB58983_P_NODE_22286_length_278_cov_0.990244_g21871_i0 | PRJEB58983 | 22286 | 278 | 0.990244 | 2.75287832 | Kockiozyma suomiensis | 1337062 | Fungi | Fungi | 113 | 1.01e-26 | NR | XP_066766158.1 | 1337062 | g21871 | i0 | 58.1 | 7.39208633093525 | 86 | 36 | 92.8 | 0 | 21 | 278 | 626 | 711 | XP_066766158.1 NUC185 domain-containing protein [Kockiozyma suomiensis] | diamond | 2055 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Kockiozyma | Kockiozyma suomiensis | |
| 28637697 | 28637697 | PRJEB58983_P_NODE_3907_length_617_cov_2.968750_g3502_i0 | PRJEB58983 | 3907 | 617 | 2.96875 | 18.3171875 | Opisthokonta | 33154 | Fungi | Fungi | 130 | 2.28e-34 | NR | KAA8900778.1 | 44093 | g3502 | i0 | 35.2 | 1.90113452188006 | 199 | 118 | 96.8 | 2 | 5 | 601 | 2 | 189 | KAA8900778.1 hypothetical protein TRICI_006157 [Trichomonascus ciferrii] | diamond | 1173 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Trichomonascus | Trichomonascus ciferrii | |
| 28801888 | 28801888 | PRJEB58983_P_NODE_2208_length_849_cov_3.086340_g1846_i0 | PRJEB58983 | 2208 | 849 | 3.08634 | 26.2030266 | Didymella glomerata | 749621 | Fungi | Fungi | 50.1 | 0.0101 | NR | KAJ4339737.1 | 749621 | g1846 | i0 | 30.7 | 0.530035335689046 | 150 | 76 | 45.9 | 5 | 840 | 451 | 3486 | 3627 | KAJ4339737.1 hypothetical protein N0V87_002937 [Didymella glomerata] | diamond | 450 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella glomerata | |
| 29584390 | 29584390 | PRJEB58983_P_NODE_11610_length_369_cov_4.351351_g11195_i0 | PRJEB58983 | 11610 | 369 | 4.351351 | 16.05648519 | Sordariomycetes | 147550 | Fungi | Fungi | 47.8 | 9.9e-4 | NR | KAK0384808.1 | 5046 | g11195 | i0 | 36.1 | 2.8780487804878 | 61 | 39 | 49.6 | 0 | 19 | 201 | 12 | 72 | KAK0384808.1 hypothetical protein NLU13_7286 [Sarocladium strictum] | diamond | 1062 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 29654251 | 29654251 | PRJEB58983_P_NODE_9510_length_404_cov_3.365559_g9096_i0 | PRJEB58983 | 9510 | 404 | 3.365559 | 13.59685836 | Lipomyces arxii | 56418 | Fungi | Fungi | 72 | 6.3e-13 | NR | XP_066769882.1 | 56418 | g9096 | i0 | 37.9 | 1.44059405940594 | 95 | 59 | 70.5 | 0 | 396 | 112 | 52 | 146 | XP_066769882.1 ribosomal protein S27a-domain-containing protein [Lipomyces arxii] | diamond | 582 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces arxii | |
| 30437840 | 30437840 | PRJEB58983_P_NODE_21693_length_281_cov_1.125000_g21278_i0 | PRJEB58983 | 21693 | 281 | 1.125 | 3.16125 | Eukaryota | 2759 | Fungi | Fungi | 81.6 | 7.55e-16 | NR | XP_011274490.1 | 1041607 | g21278 | i0 | 44.6 | 7.11032028469751 | 83 | 46 | 88.6 | 0 | 280 | 32 | 277 | 359 | XP_011274490.1 isocitrate dehydrogenase (NAD(+)) IDH1 [Wickerhamomyces ciferrii] | diamond | 1998 | 82 | 0.995121951219512 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces ciferrii | |
| 30886671 | 30886671 | PRJEB58983_P_NODE_17574_length_307_cov_1.564103_g17159_i0 | PRJEB58983 | 17574 | 307 | 1.564103 | 4.80179621 | Arxiozyma heterogenica | 278026 | Fungi | Fungi | 127 | 8.82e-36 | NR | XP_064713664.1 | 278026 | g17159 | i0 | 69 | 3.43973941368078 | 84 | 25 | 82.1 | 1 | 296 | 45 | 2 | 84 | XP_064713664.1 uncharacterized protein PWA37_002870 [Arxiozyma heterogenica] | diamond | 1056 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Arxiozyma | Arxiozyma heterogenica | |
| 31265927 | 31265927 | PRJEB58983_P_NODE_34655_length_227_cov_2.902597_g34240_i0 | PRJEB58983 | 34655 | 227 | 2.902597 | 6.58889519 | Peltigera leucophlebia | 52883 | Fungi | Fungi | 53.9 | 3.57e-6 | NR | MCJ1342159.1 | 52883 | g34240 | i0 | 31.1 | 0.977973568281938 | 74 | 51 | 97.8 | 0 | 226 | 5 | 599 | 672 | MCJ1342159.1 hypothetical protein [Peltigera leucophlebia] | diamond | 222 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Peltigerales | Peltigeraceae | Peltigera | Peltigera leucophlebia | |
| 31322285 | 31322285 | PRJEB58983_P_NODE_8715_length_421_cov_3.094828_g8301_i0 | PRJEB58983 | 8715 | 421 | 3.094828 | 13.02922588 | Ascomycota | 4890 | Fungi | Fungi | 76.3 | 3.76e-14 | NR | KAI2732586.1 | 5082 | g8301 | i0 | 34.9 | 10.938242280285 | 109 | 71 | 77.7 | 0 | 421 | 95 | 71 | 179 | KAI2732586.1 hypothetical protein CBS147332_1725 [Penicillium roqueforti] | diamond | 4605 | 77 | 0.990909090909091 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 31385780 | 31385780 | PRJEB58983_P_NODE_13996_length_339_cov_5.041353_g13581_i0 | PRJEB58983 | 13996 | 339 | 5.041353 | 17.09018667 | Ascomycota | 4890 | Fungi | Fungi | 75.9 | 2.15e-15 | NR | TID13282.1 | 52247 | g13581 | i0 | 46.1 | 8.07079646017699 | 76 | 41 | 67.3 | 0 | 56 | 283 | 3 | 78 | TID13282.1 hypothetical protein CANINC_004968 [Pichia inconspicua] | diamond | 2736 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia inconspicua | |
| 32025097 | 32025097 | PRJEB58983_P_NODE_16918_length_312_cov_2.899582_g16503_i0 | PRJEB58983 | 16918 | 312 | 2.899582 | 9.04669584 | Dactylellina haptotyla CBS 2 | 430498 | Fungi | Fungi | 61.2 | 4.92e-9 | NR | EPS40448.1 | 1284197 | g16503 | i0 | 58.7 | 0.442307692307692 | 46 | 19 | 44.2 | 0 | 162 | 299 | 73 | 118 | EPS40448.1 hypothetical protein H072_5716 [Dactylellina haptotyla CBS 200.50] | diamond | 138 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Dactylellina | Dactylellina haptotyla | |
| 32049887 | 32049887 | PRJEB58983_P_NODE_21318_length_283_cov_1.090476_g20903_i0 | PRJEB58983 | 21318 | 283 | 1.090476 | 3.08604708 | Ascomycota | 4890 | Fungi | Fungi | 66.2 | 6.35e-11 | NR | KUI67359.1 | 578113 | g20903 | i0 | 52.5 | 3.24381625441696 | 61 | 24 | 59.4 | 1 | 111 | 278 | 44 | 104 | KUI67359.1 hypothetical protein VM1G_02654 [Cytospora mali] | diamond | 918 | 66.6 | 0.993993993993994 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora mali | |
| 32113304 | 32113304 | PRJEB58983_P_NODE_10478_length_387_cov_2.264331_g10063_i0 | PRJEB58983 | 10478 | 387 | 2.264331 | 8.76296097 | Fungi | 4751 | Fungi | Fungi | 124 | 3.01e-32 | NR | ONH69752.1 | 36022 | g10063 | i0 | 46.5 | 2.9922480620155 | 129 | 68 | 100 | 1 | 387 | 1 | 1 | 128 | ONH69752.1 hypothetical protein BON22_0035 [Cyberlindnera fabianii] | diamond | 1158 | 125 | 0.992 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera fabianii | |
| 32398092 | 32398092 | PRJEB58983_P_NODE_15519_length_324_cov_41.705179_g15104_i0 | PRJEB58983 | 15519 | 324 | 41.705179 | 135.12477996 | Saccharomycetaceae | 4893 | Fungi | Fungi | 63.5 | 5.8e-10 | NR | KAF4001137.1 | 4932 | g15104 | i0 | 54.5 | 3.03703703703704 | 66 | 20 | 61.1 | 1 | 7 | 204 | 51 | 106 | KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] | diamond | 984 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae |
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);;