contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26890213 | 26890213 | PRJNA596870_P_NODE_10261_length_395_cov_0.956522_g10128_i0 | PRJNA596870 | 10261 | 395 | 0.956522 | 3.7782619 | Diutina rugosa | 5481 | Fungi | Fungi | 62 | 3.46e-8 | NR | XP_034010484.1 | 5481 | g10128 | i0 | 33.3 | 1.04810126582278 | 138 | 77 | 99.5 | 3 | 395 | 3 | 19 | 148 | XP_034010484.1 uncharacterized protein DIURU_004720 [Diutina rugosa] | diamond | 414 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Diutina | Diutina rugosa | |
| 27016462 | 27016462 | PRJNA596870_P_NODE_32982_length_248_cov_0.880000_g32849_i0 | PRJNA596870 | 32982 | 248 | 0.88 | 2.1824 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 43.5 | 0.0111 | NR | XP_461899.2 | 284592 | g32849 | i0 | 43.1 | 0.616935483870968 | 51 | 28 | 60.5 | 1 | 229 | 80 | 105 | 155 | XP_461899.2 DEHA2G08074p [Debaryomyces hansenii CBS767] | diamond | 153 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 27142672 | 27142672 | PRJNA596870_P_NODE_35642_length_245_cov_0.895349_g35509_i0 | PRJNA596870 | 35642 | 245 | 0.895349 | 2.19360505 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 94 | 3.33e-20 | NR | PWI64249.1 | 33203 | g35509 | i0 | 97.9 | 0.575510204081633 | 47 | 1 | 57.6 | 0 | 142 | 2 | 163 | 209 | PWI64249.1 hypothetical protein PCL_11347 [Purpureocillium lilacinum] | diamond | 141 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 27585330 | 27585330 | PRJNA596870_P_NODE_34324_length_246_cov_1.393064_g34191_i0 | PRJNA596870 | 34324 | 246 | 1.393064 | 3.42693744 | Kockiozyma suomiensis | 1337062 | Fungi | Fungi | 109 | 1.3e-26 | NR | XP_066768201.1 | 1337062 | g34191 | i0 | 62.2 | 4.68292682926829 | 74 | 28 | 90.2 | 0 | 224 | 3 | 234 | 307 | XP_066768201.1 uncharacterized protein V2V93DRAFT_332144 [Kockiozyma suomiensis] | diamond | 1152 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Kockiozyma | Kockiozyma suomiensis | |
| 28343108 | 28343108 | PRJNA596870_P_NODE_34126_length_247_cov_0.885057_g33993_i0 | PRJNA596870 | 34126 | 247 | 0.885057 | 2.18609079 | Sphaerulina musiva SO22 | 85929 | Fungi | Fungi | 57.4 | 2.6e-7 | NR | XP_016759927.1 | 692275 | g33993 | i0 | 52.9 | 0.619433198380567 | 51 | 23 | 61.9 | 1 | 95 | 247 | 142 | 191 | XP_016759927.1 uncharacterized protein SEPMUDRAFT_133791 [Sphaerulina musiva SO2202] | diamond | 153 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Sphaerulina | Sphaerulina musiva | |
| 28356365 | 28356365 | PRJNA596870_P_NODE_15606_length_332_cov_1.189189_g15473_i0 | PRJNA596870 | 15606 | 332 | 1.189189 | 3.94810748 | Dothideomycetes | 147541 | Fungi | Fungi | 43.9 | 0.0375 | NR | XP_064695751.1 | 574656 | g15473 | i0 | 31.1 | 2.69277108433735 | 90 | 58 | 78.6 | 2 | 18 | 278 | 212 | 300 | XP_064695751.1 GPI transamidase component [Recurvomyces mirabilis] | diamond | 894 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 28406326 | 28406326 | PRJNA596870_P_NODE_26786_length_262_cov_1.428571_g26653_i0 | PRJNA596870 | 26786 | 262 | 1.428571 | 3.74285602 | Ascosphaera pollenicola | 51576 | Fungi | Fungi | 42.7 | 0.0475 | NR | KAI5299712.1 | 51576 | g26653 | i0 | 37.3 | 0.583969465648855 | 51 | 32 | 58.4 | 0 | 70 | 222 | 537 | 587 | KAI5299712.1 Cell differentiation protein RCD1 [Ascosphaera pollenicola] | diamond | 153 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ascosphaeraceae | Ascosphaera | Ascosphaera pollenicola | |
| 28482794 | 28482794 | PRJNA596870_P_NODE_22246_length_285_cov_1.528302_g22113_i0 | PRJNA596870 | 22246 | 285 | 1.528302 | 4.3556607 | root | 1 | Root_unresolved | Root_unresolved | 60.8 | 2.48e-8 | NR | KAI1831057.1 | 5082 | g22113 | i0 | 37.6 | 9.78947368421053 | 93 | 56 | 97.9 | 1 | 284 | 6 | 50 | 140 | KAI1831057.1 CAZyme family GH18 [Penicillium roqueforti] | diamond | 2790 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 29227416 | 29227416 | PRJNA596870_P_NODE_26729_length_262_cov_1.894180_g26596_i0 | PRJNA596870 | 26729 | 262 | 1.89418 | 4.9627516 | Protomyces lactucae-debilis | 2754530 | Fungi | Fungi | 127 | 1.73e-32 | NR | XP_040725142.1 | 2754530 | g26596 | i0 | 68.5 | 13.4885496183206 | 92 | 24 | 99.6 | 1 | 262 | 2 | 70 | 161 | XP_040725142.1 P-loop containing nucleoside triphosphate hydrolase protein [Protomyces lactucae-debilis] | diamond | 3534 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Taphrinomycetes | Taphrinales | Protomycetaceae | Protomyces | Protomyces lactucae-debilis | |
| 29777208 | 29777208 | PRJNA596870_P_NODE_16191_length_327_cov_1.212598_g16058_i0 | PRJNA596870 | 16191 | 327 | 1.212598 | 3.96519546 | Ascomycota | 4890 | Fungi | Fungi | 62.8 | 8.48e-9 | NR | KAI1810471.1 | 101475 | g16058 | i0 | 37.9 | 1.56880733944954 | 87 | 47 | 76.1 | 2 | 307 | 59 | 304 | 387 | KAI1810471.1 endochitinase [Poronia punctata] | diamond | 513 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Poronia | Poronia punctata | |
| 29935380 | 29935380 | PRJNA596870_P_NODE_21851_length_287_cov_1.439252_g21718_i0 | PRJNA596870 | 21851 | 287 | 1.439252 | 4.13065324 | Eukaryota | 2759 | Fungi | Fungi | 81.6 | 1.37e-15 | NR | XP_045933037.1 | 36035 | g21718 | i0 | 45.3 | 6.90940766550523 | 95 | 49 | 99.3 | 2 | 285 | 1 | 1104 | 1195 | XP_045933037.1 phosphatidylserine decarboxylase 2 [Saccharomycodes ludwigii] | diamond | 1983 | 82.4 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Saccharomycodes | Saccharomycodes ludwigii | |
| 29935386 | 29935386 | PRJNA596870_P_NODE_38991_length_242_cov_0.911243_g38858_i0 | PRJNA596870 | 38991 | 242 | 0.911243 | 2.20520806 | Sordariomycetes | 147550 | Fungi | Fungi | 49.7 | 6.33e-6 | NR | KAK3938116.1 | 303347 | g38858 | i0 | 52.2 | 1.11570247933884 | 46 | 22 | 57 | 0 | 72 | 209 | 1 | 46 | KAK3938116.1 hypothetical protein QBC46DRAFT_266073, partial [Diplogelasinospora grovesii] | diamond | 270 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Diplogelasinosporaceae | Diplogelasinospora | Diplogelasinospora grovesii | |
| 30346479 | 30346479 | PRJNA596870_P_NODE_17252_length_318_cov_1.885714_g17119_i0 | PRJNA596870 | 17252 | 318 | 1.885714 | 5.99657052 | Ascomycota | 4890 | Fungi | Fungi | 126 | 9.039999999999999e-35 | NR | KAL1987446.1 | 68825 | g17119 | i0 | 70.8 | 8.00943396226415 | 96 | 28 | 90.6 | 0 | 31 | 318 | 1 | 96 | KAL1987446.1 hypothetical protein VTN96DRAFT_3828 [Rasamsonia emersonii] | diamond | 2547 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Rasamsonia | Rasamsonia emersonii | |
| 30566833 | 30566833 | PRJNA596870_P_NODE_34613_length_246_cov_0.890173_g34480_i0 | PRJNA596870 | 34613 | 246 | 0.890173 | 2.18982558 | Ascomycota | 4890 | Fungi | Fungi | 125 | 2.2299999999999996e-31 | NR | KAI5295275.1 | 51565 | g34480 | i0 | 65.4 | 15.8048780487805 | 81 | 28 | 98.8 | 0 | 245 | 3 | 684 | 764 | KAI5295275.1 AMP deaminase [Ascosphaera acerosa] | diamond | 3888 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ascosphaeraceae | Ascosphaera | Ascosphaera acerosa | |
| 30679915 | 30679915 | PRJNA596870_P_NODE_29293_length_251_cov_0.865169_g29160_i0 | PRJNA596870 | 29293 | 251 | 0.865169 | 2.17157419 | Aspergillus heterothallicus | 41742 | Fungi | Fungi | 53.5 | 6.36e-6 | NR | KAL3456470.1 | 41742 | g29160 | i0 | 50 | 0.645418326693227 | 54 | 26 | 64.5 | 1 | 73 | 234 | 1 | 53 | KAL3456470.1 DNA polymerase III, clamp loader complex, gamma/delta/delta subunit [Aspergillus heterothallicus] | diamond | 162 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus heterothallicus | |
| 30788304 | 30788304 | PRJNA596870_P_NODE_29474_length_251_cov_0.865169_g29341_i0 | PRJNA596870 | 29474 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | Fungi | Fungi | 48.1 | 5.31e-4 | NR | XP_007930522.1 | 383855 | g29341 | i0 | 65.4 | 3.78884462151394 | 26 | 9 | 31.1 | 0 | 246 | 169 | 2 | 27 | XP_007930522.1 uncharacterized protein MYCFIDRAFT_37116 [Pseudocercospora fijiensis CIRAD86] | diamond | 951 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fijiensis | |
| 30946429 | 30946429 | PRJNA596870_P_NODE_3074_length_670_cov_1.966499_g2946_i0 | PRJNA596870 | 3074 | 670 | 1.966499 | 13.1755433 | Fungi | 4751 | Fungi | Fungi | 138 | 1.24e-37 | NR | QEU61064.1 | 28985 | g2946 | i0 | 49.7 | 8.72238805970149 | 147 | 70 | 64.5 | 3 | 620 | 189 | 1 | 146 | QEU61064.1 Rps31 [Kluyveromyces lactis] | diamond | 5844 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kluyveromyces | Kluyveromyces lactis | |
| 31312090 | 31312090 | PRJNA596870_P_NODE_22395_length_284_cov_3.260664_g22262_i0 | PRJNA596870 | 22395 | 284 | 3.260664 | 9.26028576 | Dendryphion nanum | 256645 | Fungi | Fungi | 91.3 | 2.1e-21 | NR | KAH7138046.1 | 256645 | g22262 | i0 | 60.3 | 0.71830985915493 | 68 | 27 | 71.8 | 0 | 79 | 282 | 9 | 76 | KAH7138046.1 ribosomal protein S10 domain-containing protein [Dendryphion nanum] | diamond | 204 | 91.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Torulaceae | Dendryphion | Dendryphion nanum | |
| 32905628 | 32905628 | PRJNA596870_P_NODE_35220_length_246_cov_0.890173_g35087_i0 | PRJNA596870 | 35220 | 246 | 0.890173 | 2.18982558 | Fungi | 4751 | Fungi | Fungi | 134 | 7.05e-37 | NR | NP_594174.1 | 4896 | g35087 | i0 | 76.5 | 10.8658536585366 | 81 | 19 | 98.8 | 0 | 245 | 3 | 61 | 141 | NP_594174.1 40S ribosomal protein eS4 [Schizosaccharomyces pombe] | diamond | 2673 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe |
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);;