contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA675638" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18500797 | 18500797 | PRJNA675638_P_NODE_18495_length_167_cov_0.864407_g18298_i0 | PRJNA675638 | 18495 | 167 | 0.864407 | 1.44355969 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 105 | 9.56e-25 | NR | XP_069226096.1 | 1052096 | g18298 | i0 | 92.7 | 0.988023952095808 | 55 | 4 | 98.8 | 0 | 167 | 3 | 421 | 475 | XP_069226096.1 uncharacterized protein WHR41_08201 [Cladosporium halotolerans] | diamond | 165 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27303337 | 27303337 | PRJNA675638_S_NODE_8943_length_162_cov_0.902655_g8881_i0 | PRJNA675638 | 8943 | 162 | 0.902655 | 1.4623011 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 94 | 8.670000000000001e-21 | NR | XP_069233273.1 | 1052096 | g8881 | i0 | 77.8 | 1 | 54 | 12 | 100 | 0 | 162 | 1 | 256 | 309 | XP_069233273.1 uncharacterized protein WHR41_00986 [Cladosporium halotolerans] | diamond | 162 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27619130 | 27619130 | PRJNA675638_P_NODE_19904_length_164_cov_1.678261_g19707_i0 | PRJNA675638 | 19904 | 164 | 1.678261 | 2.75234804 | Pleurostoma richardsiae | 41990 | Fungi | Fungi | 89.4 | 2.2700000000000004e-21 | NR | KAJ9155500.1 | 41990 | g19707 | i0 | 95.5 | 0.804878048780488 | 44 | 2 | 80.5 | 0 | 31 | 162 | 1 | 44 | KAJ9155500.1 hypothetical protein NKR23_g1876 [Pleurostoma richardsiae] | diamond | 132 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Calosphaeriales | Pleurostomataceae | Pleurostoma | Pleurostoma richardsiae | |
| 29134810 | 29134810 | PRJNA675638_P_NODE_22089_length_161_cov_0.910714_g21892_i0 | PRJNA675638 | 22089 | 161 | 0.910714 | 1.46624954 | Cladosporium cladosporioides | 29917 | Fungi | Fungi | 83.6 | 4.95e-17 | NR | WCL15692.1 | 29917 | g21892 | i0 | 88.7 | 1.95652173913043 | 53 | 6 | 98.8 | 0 | 3 | 161 | 603 | 655 | WCL15692.1 MYB transcription factor 13 [Cladosporium cladosporioides] | diamond | 315 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 29544898 | 29544898 | PRJNA675638_P_NODE_9170_length_230_cov_1.127072_g8973_i0 | PRJNA675638 | 9170 | 230 | 1.127072 | 2.5922656 | Fulvia fulva | 5499 | Fungi | Fungi | 46.6 | 0.00128 | NR | XP_047765476.1 | 5499 | g8973 | i0 | 61.5 | 0.508695652173913 | 39 | 8 | 41.7 | 1 | 228 | 133 | 182 | 220 | XP_047765476.1 uncharacterized protein CLAFUR5_10986 [Fulvia fulva] | diamond | 117 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 29765912 | 29765912 | PRJNA675638_P_NODE_22331_length_161_cov_0.910714_g22134_i0 | PRJNA675638 | 22331 | 161 | 0.910714 | 1.46624954 | Blumeria graminis f. sp. triticale | 1689686 | Fungi | Fungi | 67.8 | 2.61e-12 | NR | CAD6498871.1 | 1689686 | g22134 | i0 | 81 | 0.782608695652174 | 42 | 8 | 78.3 | 0 | 36 | 161 | 15 | 56 | CAD6498871.1 BgTH12-04529, partial [Blumeria graminis f. sp. triticale] | diamond | 126 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria graminis | |
| 29924086 | 29924086 | PRJNA675638_P_NODE_21871_length_161_cov_1.794643_g21674_i0 | PRJNA675638 | 21871 | 161 | 1.794643 | 2.88937523 | Blumeria hordei DH14 | 546991 | Fungi | Fungi | 103 | 6.21e-24 | NR | CCU77223.1 | 546991 | g21674 | i0 | 90.6 | 0.987577639751553 | 53 | 5 | 98.8 | 0 | 2 | 160 | 521 | 573 | CCU77223.1 hypothetical protein BGHDH14_bgh06159 [Blumeria hordei DH14] | diamond | 159 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria hordei | |
| 30347032 | 30347032 | PRJNA675638_P_NODE_15572_length_182_cov_1.533835_g15375_i0 | PRJNA675638 | 15572 | 182 | 1.533835 | 2.7915797 | Talaromyces | 5094 | Fungi | Fungi | 112 | 6.6e-27 | NR | XP_054115578.1 | 37727 | g15375 | i0 | 88.1 | 4.86263736263736 | 59 | 7 | 97.3 | 0 | 181 | 5 | 562 | 620 | XP_054115578.1 uncharacterized protein EYB26_000286 [Talaromyces marneffei] | diamond | 885 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei | |
| 30725579 | 30725579 | PRJNA675638_P_NODE_16914_length_174_cov_1.632000_g16717_i0 | PRJNA675638 | 16914 | 174 | 1.632 | 2.83968 | Ascomycota | 4890 | Fungi | Fungi | 100 | 5.42e-25 | NR | GAB0139335.1 | 79588 | g16717 | i0 | 80.4 | 1.94827586206897 | 56 | 11 | 96.6 | 0 | 173 | 6 | 104 | 159 | GAB0139335.1 hypothetical protein EsDP_00007550 [Epichloe bromicola] | diamond | 339 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Epichloe | Epichloe bromicola | |
| 30808641 | 30808641 | PRJNA675638_P_NODE_20974_length_163_cov_0.894737_g20777_i0 | PRJNA675638 | 20974 | 163 | 0.894737 | 1.45842131 | Erysiphe pulchra | 225359 | Fungi | Fungi | 72.8 | 2.22e-13 | NR | POS85684.1 | 225359 | g20777 | i0 | 78 | 0.754601226993865 | 41 | 9 | 75.5 | 0 | 161 | 39 | 298 | 338 | POS85684.1 hypothetical protein EPUL_006665 [Erysiphe pulchra] | diamond | 123 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe pulchra | |
| 31104655 | 31104655 | PRJNA675638_P_NODE_22355_length_161_cov_0.910714_g22158_i0 | PRJNA675638 | 22355 | 161 | 0.910714 | 1.46624954 | Blumeria | 34372 | Fungi | Fungi | 63.2 | 7.56e-10 | NR | CCU82389.1 | 546991 | g22158 | i0 | 56 | 2.79503105590062 | 50 | 22 | 93.2 | 0 | 4 | 153 | 425 | 474 | CCU82389.1 hypothetical protein BGHDH14_bgh05390 [Blumeria hordei DH14] | diamond | 450 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria hordei | |
| 31440716 | 31440716 | PRJNA675638_P_NODE_19456_length_165_cov_0.879310_g19259_i0 | PRJNA675638 | 19456 | 165 | 0.87931 | 1.4508615 | Blumeria hordei DH14 | 546991 | Fungi | Fungi | 53.1 | 7.13e-7 | NR | CCU77743.1 | 546991 | g19259 | i0 | 66.7 | 0.709090909090909 | 39 | 13 | 70.9 | 0 | 119 | 3 | 1 | 39 | CCU77743.1 CSEP0392 putative effector protein [Blumeria hordei DH14] | diamond | 117 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria hordei | |
| 31599120 | 31599120 | PRJNA675638_P_NODE_21716_length_162_cov_0.902655_g21519_i0 | PRJNA675638 | 21716 | 162 | 0.902655 | 1.4623011 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 94 | 2.1e-21 | NR | KAK3182497.1 | 1964301 | g21519 | i0 | 94 | 0.925925925925926 | 50 | 3 | 92.6 | 0 | 12 | 161 | 140 | 189 | KAK3182497.1 hypothetical protein K4F52_006137 [Lecanicillium sp. MT-2017a] | diamond | 150 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 31768835 | 31768835 | PRJNA675638_P_NODE_20037_length_164_cov_0.886957_g19840_i0 | PRJNA675638 | 20037 | 164 | 0.886957 | 1.45460948 | Ascomycota | 4890 | Fungi | Fungi | 112 | 1.94e-30 | NR | GAB0139317.1 | 79588 | g19840 | i0 | 96.3 | 2.96341463414634 | 54 | 2 | 98.8 | 0 | 163 | 2 | 1 | 54 | GAB0139317.1 hypothetical protein EsDP_00007530, partial [Epichloe bromicola] | diamond | 486 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Epichloe | Epichloe bromicola | |
| 31800300 | 31800300 | PRJNA675638_P_NODE_21417_length_162_cov_0.902655_g21220_i0 | PRJNA675638 | 21417 | 162 | 0.902655 | 1.4623011 | Erysiphaceae | 34371 | Fungi | Fungi | 104 | 4.410000000000001e-27 | NR | RKF74173.1 | 62708 | g21220 | i0 | 96.3 | 7 | 54 | 2 | 100 | 0 | 162 | 1 | 4 | 57 | RKF74173.1 GTP-binding protein ypt5 [Golovinomyces cichoracearum] | diamond | 1134 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Golovinomyces | Golovinomyces cichoracearum | |
| 31883527 | 31883527 | PRJNA675638_P_NODE_19777_length_165_cov_0.879310_g19580_i0 | PRJNA675638 | 19777 | 165 | 0.87931 | 1.4508615 | Erysiphe pulchra | 225359 | Fungi | Fungi | 85.9 | 8.33e-18 | NR | POS88336.1 | 225359 | g19580 | i0 | 72.7 | 2 | 55 | 15 | 100 | 0 | 165 | 1 | 619 | 673 | POS88336.1 hypothetical protein EPUL_000004 [Erysiphe pulchra] | diamond | 330 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe pulchra | |
| 32295318 | 32295318 | PRJNA675638_P_NODE_20879_length_163_cov_0.894737_g20682_i0 | PRJNA675638 | 20879 | 163 | 0.894737 | 1.45842131 | Blumeria graminis f. sp. triticale | 1689686 | Fungi | Fungi | 49.7 | 9.5e-6 | NR | CAD6506108.1 | 1689686 | g20682 | i0 | 85.2 | 0.496932515337423 | 27 | 4 | 49.7 | 0 | 2 | 82 | 91 | 117 | CAD6506108.1 BgTH12-07038 [Blumeria graminis f. sp. triticale] | diamond | 81 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria graminis | |
| 32484953 | 32484953 | PRJNA675638_P_NODE_18519_length_167_cov_0.864407_g18322_i0 | PRJNA675638 | 18519 | 167 | 0.864407 | 1.44355969 | Peltaster fructicola | 286661 | Fungi | Fungi | 99.8 | 4.809999999999999e-23 | NR | QIW99523.1 | 286661 | g18322 | i0 | 88.7 | 2.92814371257485 | 53 | 6 | 95.2 | 0 | 161 | 3 | 108 | 160 | QIW99523.1 hypothetical protein AMS68_005041 [Peltaster fructicola] | diamond | 489 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Peltaster | Peltaster fructicola | |||
| 32642333 | 32642333 | PRJNA675638_P_NODE_18360_length_167_cov_0.864407_g18163_i0 | PRJNA675638 | 18360 | 167 | 0.864407 | 1.44355969 | Podosphaera aphanis | 79252 | Fungi | Fungi | 87.8 | 1.73e-18 | NR | KAI0993216.1 | 79252 | g18163 | i0 | 78 | 2.62275449101796 | 50 | 11 | 89.8 | 0 | 167 | 18 | 502 | 551 | KAI0993216.1 hypothetical protein K3495_g14968 [Podosphaera aphanis] | diamond | 438 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Podosphaera | Podosphaera aphanis | |
| 32654078 | 32654078 | PRJNA675638_P_NODE_17600_length_170_cov_1.264463_g17403_i0 | PRJNA675638 | 17600 | 170 | 1.264463 | 2.1495871 | Blumeria | 34372 | Fungi | Fungi | 49.3 | 2e-5 | NR | EPQ65890.1 | 1268274 | g17403 | i0 | 80 | 2.11764705882353 | 30 | 6 | 52.9 | 0 | 169 | 80 | 90 | 119 | EPQ65890.1 hypothetical protein BGT96224_2778 [Blumeria graminis f. sp. tritici 96224] | diamond | 360 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria graminis | |
| 32705461 | 32705461 | PRJNA675638_P_NODE_21660_length_162_cov_0.902655_g21463_i0 | PRJNA675638 | 21660 | 162 | 0.902655 | 1.4623011 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 80.5 | 5.56e-16 | NR | XP_069227892.1 | 1052096 | g21463 | i0 | 72.2 | 3 | 54 | 15 | 100 | 0 | 1 | 162 | 348 | 401 | XP_069227892.1 uncharacterized protein WHR41_06592 [Cladosporium halotolerans] | diamond | 486 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans |
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);;