contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1097627" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12498604 | 12498604 | PRJNA1097627_P_NODE_43390_length_325_cov_2.107143_g43098_i0 | PRJNA1097627 | 43390 | 325 | 2.107143 | 6.84821475 | Emergomyces | 1955773 | Fungi | Fungi | 60.1 | 7.37e-8 | NR | OJD14323.1 | 1447872 | g43098 | i0 | 54.5 | 1.62461538461538 | 44 | 20 | 40.6 | 0 | 269 | 138 | 381 | 424 | OJD14323.1 hypothetical protein AJ78_05318 [Emergomyces pasteurianus Ep9510] | diamond | 528 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Emergomyces | Emergomyces pasteurianus | |
| 26615682 | 26615682 | PRJNA1097627_P_NODE_188781_length_243_cov_0.905882_g188488_i0 | PRJNA1097627 | 188781 | 243 | 0.905882 | 2.20129326 | Phaeosphaeriaceae | 5020 | Fungi | Fungi | 112 | 4.63e-28 | NR | KAH7076776.1 | 798071 | g188488 | i0 | 92.2 | 3.75308641975309 | 64 | 5 | 79 | 0 | 192 | 1 | 200 | 263 | KAH7076776.1 actin cortical patch SUR7/pH-response regulator pali [Paraphoma chrysanthemicola] | diamond | 912 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Paraphoma | Paraphoma chrysanthemicola | |
| 27983577 | 27983577 | PRJNA1097627_P_NODE_176225_length_245_cov_0.895349_g175932_i0 | PRJNA1097627 | 176225 | 245 | 0.895349 | 2.19360505 | Ophiocordyceps australis | 1399860 | Fungi | Fungi | 75.9 | 8.37e-14 | NR | PHH67395.1 | 1399860 | g175932 | i0 | 61.7 | 1.98367346938776 | 81 | 30 | 98 | 1 | 244 | 5 | 3 | 83 | PHH67395.1 hypothetical protein CDD81_3 [Ophiocordyceps australis] | diamond | 486 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps australis | |
| 28141724 | 28141724 | PRJNA1097627_P_NODE_142985_length_251_cov_0.865169_g142692_i0 | PRJNA1097627 | 142985 | 251 | 0.865169 | 2.17157419 | Didymella heteroderae | 1769908 | Fungi | Fungi | 65.9 | 3.02e-10 | NR | KAF3033439.1 | 1769908 | g142692 | i0 | 64 | 0.597609561752988 | 50 | 17 | 59.8 | 1 | 150 | 1 | 1174 | 1222 | KAF3033439.1 hypothetical protein E8E12_003964 [Didymella heteroderae] | diamond | 150 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella heteroderae | |
| 29017246 | 29017246 | PRJNA1097627_P_NODE_202448_length_241_cov_0.916667_g202155_i0 | PRJNA1097627 | 202448 | 241 | 0.916667 | 2.20916747 | Sordariomycetes | 147550 | Fungi | Fungi | 44.7 | 0.00739 | NR | KAK1753122.1 | 438768 | g202155 | i0 | 60.5 | 1.64315352697095 | 38 | 15 | 47.3 | 0 | 13 | 126 | 27 | 64 | KAK1753122.1 hypothetical protein QBC47DRAFT_304223 [Echria macrotheca] | diamond | 396 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Schizotheciaceae | Echria | Echria macrotheca | |
| 30627510 | 30627510 | PRJNA1097627_P_NODE_5393_length_496_cov_2.009456_g5106_i0 | PRJNA1097627 | 5393 | 496 | 2.009456 | 9.96690176 | Pleosporales | 92860 | Fungi | Fungi | 233 | 3.4899999999999998e-74 | NR | KAF9693513.1 | 205686 | g5106 | i0 | 87.8 | 3.16935483870968 | 131 | 16 | 79.2 | 0 | 1 | 393 | 127 | 257 | KAF9693513.1 hypothetical protein EKO04_008517 [Ascochyta lentis] | diamond | 1572 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Ascochyta | Ascochyta lentis | |
| 30825881 | 30825881 | PRJNA1097627_P_NODE_193174_length_242_cov_1.544379_g192881_i0 | PRJNA1097627 | 193174 | 242 | 1.544379 | 3.73739718 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 42 | 0.0488 | NR | CAC9884696.1 | 5580 | g192881 | i0 | 77.3 | 0.272727272727273 | 22 | 5 | 27.3 | 0 | 69 | 134 | 7 | 28 | CAC9884696.1 unnamed protein product, partial [Aureobasidium pullulans] | diamond | 66 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 32565688 | 32565688 | PRJNA1097627_P_NODE_140679_length_251_cov_0.865169_g140386_i0 | PRJNA1097627 | 140679 | 251 | 0.865169 | 2.17157419 | Ophiocordyceps australis | 1399860 | Fungi | Fungi | 81.6 | 1.82e-17 | NR | PHH81929.1 | 1399860 | g140386 | i0 | 69.2 | 2.50996015936255 | 65 | 19 | 77.7 | 1 | 200 | 6 | 2 | 65 | PHH81929.1 hypothetical protein CDD82_7531 [Ophiocordyceps australis] | diamond | 630 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps australis | |
| 32619686 | 32619686 | PRJNA1097627_P_NODE_200900_length_241_cov_0.916667_g200607_i0 | PRJNA1097627 | 200900 | 241 | 0.916667 | 2.20916747 | Ascomycota | 4890 | Fungi | Fungi | 101 | 4.3e-23 | NR | SPO03031.1 | 2041049 | g200607 | i0 | 67.5 | 1.92946058091286 | 77 | 8 | 95.9 | 1 | 235 | 5 | 48 | 107 | SPO03031.1 related to tetracycline resistance proteins [Cephalotrichum gorgonifer] | diamond | 465 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Microascaceae | Cephalotrichum | Cephalotrichum gorgonifer | |
| 32691219 | 32691219 | PRJNA1097627_P_NODE_158040_length_248_cov_0.880000_g157747_i0 | PRJNA1097627 | 158040 | 248 | 0.88 | 2.1824 | Fusarium oxysporum f. sp. conglutinans race 2 54 | 5507 | Fungi | Fungi | 50.4 | 2.35e-6 | NR | EXL67383.1 | 1089457 | g157747 | i0 | 77.4 | 0.375 | 31 | 7 | 37.5 | 0 | 131 | 223 | 6 | 36 | EXL67383.1 hypothetical protein FOPG_16489 [Fusarium oxysporum f. sp. conglutinans race 2 54008] | diamond | 93 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 32691221 | 32691221 | PRJNA1097627_P_NODE_178060_length_245_cov_0.895349_g177767_i0 | PRJNA1097627 | 178060 | 245 | 0.895349 | 2.19360505 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 59.7 | 3.35e-8 | NR | KAK3185804.1 | 1964301 | g177767 | i0 | 71.4 | 0.428571428571429 | 35 | 10 | 42.9 | 0 | 245 | 141 | 275 | 309 | KAK3185804.1 hypothetical protein K4F52_005460 [Lecanicillium sp. MT-2017a] | diamond | 105 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 32714136 | 32714136 | PRJNA1097627_P_NODE_157640_length_248_cov_0.880000_g157347_i0 | PRJNA1097627 | 157640 | 248 | 0.88 | 2.1824 | Dothideomycetes | 147541 | Fungi | Fungi | 110 | 7.840000000000001e-26 | NR | XP_033665578.1 | 1080233 | g157347 | i0 | 64.2 | 1.94758064516129 | 81 | 29 | 98 | 0 | 2 | 244 | 124 | 204 | XP_033665578.1 uncharacterized protein M409DRAFT_67797 [Zasmidium cellare ATCC 36951] | diamond | 483 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 32722888 | 32722888 | PRJNA1097627_P_NODE_164040_length_247_cov_0.885057_g163747_i0 | PRJNA1097627 | 164040 | 247 | 0.885057 | 2.18609079 | Metschnikowia bicuspidata | 27322 | Fungi | Fungi | 78.6 | 5.79e-15 | NR | RKP30686.1 | 27322 | g163747 | i0 | 48.8 | 0.97165991902834 | 80 | 41 | 97.2 | 0 | 242 | 3 | 252 | 331 | RKP30686.1 hypothetical protein METBISCDRAFT_23115 [Metschnikowia bicuspidata] | diamond | 240 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia bicuspidata |
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);;