contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA177642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2916165 | 2916165 | PRJNA177642_P_NODE_17003_length_169_cov_1.014286_g15778_i0 | PRJNA177642 | 17003 | 169 | 1.014286 | 1.71414334 | Xylariales | 37989 | Fungi | Fungi | 104 | 4.88e-25 | NR | OTA87298.1 | 1001938 | g15778 | i0 | 87.5 | 1.98816568047337 | 56 | 7 | 99.4 | 0 | 168 | 1 | 204 | 259 | OTA87298.1 hypothetical protein M434DRAFT_399569 [Hypoxylon sp. CO27-5] | diamond | 336 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Hypoxylon | Hypoxylon sp. CO27-5 | |
| 20767009 | 20767009 | PRJNA177642_P_NODE_16697_length_170_cov_1.936170_g15472_i0 | PRJNA177642 | 16697 | 170 | 1.93617 | 3.291489 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 108 | 4.04e-26 | NR | KAK3191253.1 | 1964301 | g15472 | i0 | 98 | 0.864705882352941 | 49 | 1 | 86.5 | 0 | 22 | 168 | 220 | 268 | KAK3191253.1 hypothetical protein K4F52_002843 [Lecanicillium sp. MT-2017a] | diamond | 147 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 26743180 | 26743180 | PRJNA177642_P_NODE_16881_length_169_cov_1.978571_g15656_i0 | PRJNA177642 | 16881 | 169 | 1.978571 | 3.34378499 | Eukaryota | 2759 | Fungi | Fungi | 42.7 | 0.0134 | NR | XP_043050320.1 | 45513 | g15656 | i0 | 63 | 9.15976331360947 | 27 | 10 | 47.9 | 0 | 3 | 83 | 286 | 312 | XP_043050320.1 deubiquitinating enzyme [Scheffersomyces spartinae] | diamond | 1548 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces spartinae | |
| 26978987 | 26978987 | PRJNA177642_P_NODE_17262_length_168_cov_1.007194_g16037_i0 | PRJNA177642 | 17262 | 168 | 1.007194 | 1.69208592 | Aspergillus egyptiacus | 41743 | Fungi | Fungi | 105 | 2.5e-25 | NR | KAI9371234.1 | 41743 | g16037 | i0 | 83.3 | 1.92857142857143 | 54 | 9 | 96.4 | 0 | 5 | 166 | 213 | 266 | KAI9371234.1 histidine-specific methyltransferase [Aspergillus egyptiacus] | diamond | 324 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus egyptiacus | |
| 27200144 | 27200144 | PRJNA177642_P_NODE_18402_length_163_cov_1.044776_g17177_i0 | PRJNA177642 | 18402 | 163 | 1.044776 | 1.70298488 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 50.8 | 1.68e-5 | NR | KAK3181506.1 | 1964301 | g17177 | i0 | 70.3 | 0.680981595092024 | 37 | 11 | 68.1 | 0 | 51 | 161 | 276 | 312 | KAK3181506.1 hypothetical protein K4F52_007216 [Lecanicillium sp. MT-2017a] | diamond | 111 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 28432012 | 28432012 | PRJNA177642_P_NODE_15286_length_190_cov_3.757764_g14061_i0 | PRJNA177642 | 15286 | 190 | 3.757764 | 7.1397516 | Neodothiora populina | 2781224 | Fungi | Fungi | 42 | 0.0343 | NR | XP_069202214.1 | 2781224 | g14061 | i0 | 34 | 0.836842105263158 | 53 | 35 | 83.7 | 0 | 9 | 167 | 338 | 390 | XP_069202214.1 uncharacterized protein AAFC00_004082 [Neodothiora populina] | diamond | 159 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothioraceae | Neodothiora | Neodothiora populina | |
| 28891582 | 28891582 | PRJNA177642_P_NODE_16508_length_172_cov_1.006993_g15283_i0 | PRJNA177642 | 16508 | 172 | 1.006993 | 1.73202796 | Ascomycota | 4890 | Fungi | Fungi | 111 | 5.11e-28 | NR | KAK5678373.1 | 574655 | g15283 | i0 | 91.2 | 3.97674418604651 | 57 | 5 | 99.4 | 0 | 2 | 172 | 177 | 233 | KAK5678373.1 hypothetical protein LTS12_029414, partial [Elasticomyces elasticus] | diamond | 684 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Elasticomyces | Elasticomyces elasticus | |
| 29018395 | 29018395 | PRJNA177642_P_NODE_11688_length_320_cov_1.611684_g10463_i0 | PRJNA177642 | 11688 | 320 | 1.611684 | 5.1573888 | Pichiaceae | 1156497 | Fungi | Fungi | 83.2 | 4.08e-17 | NR | KGK38667.1 | 4909 | g10463 | i0 | 38.9 | 20.7375 | 126 | 55 | 97.5 | 1 | 315 | 4 | 54 | 179 | KGK38667.1 hypothetical protein JL09_g2231 [Pichia kudriavzevii] | diamond | 6636 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 29631473 | 29631473 | PRJNA177642_P_NODE_17010_length_169_cov_1.007143_g15785_i0 | PRJNA177642 | 17010 | 169 | 1.007143 | 1.70207167 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 89.4 | 5.28e-19 | NR | KAK3181658.1 | 1964301 | g15785 | i0 | 71.4 | 0.994082840236686 | 56 | 16 | 99.4 | 0 | 168 | 1 | 190 | 245 | KAK3181658.1 NRPS [Lecanicillium sp. MT-2017a] | diamond | 168 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 29852878 | 29852878 | PRJNA177642_P_NODE_18391_length_163_cov_1.052239_g17166_i0 | PRJNA177642 | 18391 | 163 | 1.052239 | 1.71514957 | Endocarpon pusillum Z | 364733 | Fungi | Fungi | 57.8 | 6.03e-8 | NR | XP_007805116.1 | 1263415 | g17166 | i0 | 49.1 | 0.975460122699387 | 53 | 27 | 97.5 | 0 | 161 | 3 | 472 | 524 | XP_007805116.1 uncharacterized protein EPUS_09501 [Endocarpon pusillum Z07020] | diamond | 159 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 30390322 | 30390322 | PRJNA177642_P_NODE_17933_length_165_cov_1.036765_g16708_i0 | PRJNA177642 | 17933 | 165 | 1.036765 | 1.71066225 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 51.2 | 1.29e-5 | NR | KAK3187465.1 | 1964301 | g16708 | i0 | 63 | 0.981818181818182 | 54 | 19 | 98.2 | 1 | 2 | 163 | 34 | 86 | KAK3187465.1 hypothetical protein K4F52_003812 [Lecanicillium sp. MT-2017a] | diamond | 162 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 30579223 | 30579223 | PRJNA177642_P_NODE_18093_length_164_cov_1.066667_g16868_i0 | PRJNA177642 | 18093 | 164 | 1.066667 | 1.74933388 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 43.5 | 0.00693 | NR | XP_069232622.1 | 1052096 | g16868 | i0 | 76.7 | 0.548780487804878 | 30 | 7 | 54.9 | 0 | 66 | 155 | 1 | 30 | XP_069232622.1 uncharacterized protein WHR41_01481 [Cladosporium halotolerans] | diamond | 90 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 30610936 | 30610936 | PRJNA177642_P_NODE_17033_length_169_cov_1.007143_g15808_i0 | PRJNA177642 | 17033 | 169 | 1.007143 | 1.70207167 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 54.3 | 1.15e-6 | NR | KAK3182487.1 | 1964301 | g15808 | i0 | 66.7 | 0.85207100591716 | 48 | 16 | 85.2 | 0 | 8 | 151 | 275 | 322 | KAK3182487.1 hypothetical protein K4F52_006127 [Lecanicillium sp. MT-2017a] | diamond | 144 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 30705725 | 30705725 | PRJNA177642_P_NODE_18114_length_164_cov_1.066667_g16889_i0 | PRJNA177642 | 18114 | 164 | 1.066667 | 1.74933388 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 63.9 | 2.44e-11 | NR | KAK3185609.1 | 1964301 | g16889 | i0 | 59.3 | 0.98780487804878 | 54 | 18 | 98.8 | 2 | 1 | 162 | 11 | 60 | KAK3185609.1 hypothetical protein K4F52_005709 [Lecanicillium sp. MT-2017a] | diamond | 162 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 31653981 | 31653981 | PRJNA177642_P_NODE_17877_length_165_cov_1.058824_g16652_i0 | PRJNA177642 | 17877 | 165 | 1.058824 | 1.7470596 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 55.5 | 1.39e-7 | NR | KAK5097741.1 | 1690604 | g16652 | i0 | 82.8 | 0.527272727272727 | 29 | 5 | 52.7 | 0 | 94 | 8 | 1 | 29 | KAK5097741.1 hypothetical protein LTR24_001997 [Lithohypha guttulata] | diamond | 87 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata |
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);;