contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA796975" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3768536 | 3768536 | PRJNA796975_S_NODE_11643_length_165_cov_0.879310_g11566_i0 | PRJNA796975 | 11643 | 165 | 0.87931 | 1.4508615 | Dipodascales | 3243772 | Fungi | Fungi | 87.8 | 1.76e-18 | NR | XP_018737756.1 | 796027 | g11566 | i0 | 79.6 | 1.98181818181818 | 54 | 11 | 98.2 | 0 | 1 | 162 | 546 | 599 | XP_018737756.1 Cu(2+)-transporting P-type ATPase CCC2 [Sugiyamaella lignohabitans] | diamond | 327 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Sugiyamaella | Sugiyamaella lignohabitans | |
| 18632686 | 18632686 | PRJNA796975_S_NODE_15055_length_161_cov_0.910714_g14978_i0 | PRJNA796975 | 15055 | 161 | 0.910714 | 1.46624954 | Monilinia laxa | 61186 | Fungi | Fungi | 86.3 | 3.53e-18 | NR | QYB20068.1 | 61186 | g14978 | i0 | 71.7 | 0.987577639751553 | 53 | 15 | 98.8 | 0 | 3 | 161 | 322 | 374 | QYB20068.1 LAGLIDADG endonuclease, partial [Monilinia laxa] | diamond | 159 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Monilinia | Monilinia laxa | |
| 26990356 | 26990356 | PRJNA796975_S_NODE_11642_length_165_cov_0.879310_g11565_i0 | PRJNA796975 | 11642 | 165 | 0.87931 | 1.4508615 | Diatrype stigma | 117547 | Fungi | Fungi | 102 | 1.2699999999999999e-23 | NR | KAK7744045.1 | 117547 | g11565 | i0 | 90.9 | 1 | 55 | 5 | 100 | 0 | 165 | 1 | 525 | 579 | KAK7744045.1 Vacuolar protein sorting-associated protein 8 [Diatrype stigma] | diamond | 165 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Diatrypaceae | Diatrype | Diatrype stigma | |
| 27053978 | 27053978 | PRJNA796975_S_NODE_15162_length_161_cov_0.910714_g15085_i0 | PRJNA796975 | 15162 | 161 | 0.910714 | 1.46624954 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 45.1 | 5.48e-4 | NR | KAG9759343.1 | 46634 | g15085 | i0 | 52.6 | 1.41614906832298 | 38 | 18 | 70.8 | 0 | 48 | 161 | 73 | 110 | KAG9759343.1 hypothetical protein KCU73_g3435, partial [Aureobasidium melanogenum] | diamond | 228 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 27125802 | 27125802 | PRJNA796975_S_NODE_12682_length_164_cov_0.886957_g12605_i0 | PRJNA796975 | 12682 | 164 | 0.886957 | 1.45460948 | Monosporascus | 155415 | Fungi | Fungi | 52 | 6.95e-6 | NR | RYP79615.1 | 2211644 | g12605 | i0 | 91.7 | 1.31707317073171 | 24 | 2 | 43.9 | 0 | 125 | 54 | 542 | 565 | RYP79615.1 hypothetical protein DL769_002854 [Monosporascus sp. CRB-8-3] | diamond | 216 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Monosporascus | Monosporascus sp. CRB-8-3 | ||
| 27338471 | 27338471 | PRJNA796975_S_NODE_11503_length_165_cov_0.879310_g11426_i0 | PRJNA796975 | 11503 | 165 | 0.87931 | 1.4508615 | Rhizodiscina lignyota | 1504668 | Fungi | Fungi | 49.3 | 6.24e-5 | NR | KAF2100954.1 | 1504668 | g11426 | i0 | 70 | 0.727272727272727 | 40 | 11 | 70.9 | 1 | 163 | 47 | 410 | 449 | KAF2100954.1 hypothetical protein NA57DRAFT_74551 [Rhizodiscina lignyota] | diamond | 120 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Aulographales | Rhizodiscinaceae | Rhizodiscina | Rhizodiscina lignyota | |
| 27821285 | 27821285 | PRJNA796975_S_NODE_11404_length_165_cov_0.879310_g11327_i0 | PRJNA796975 | 11404 | 165 | 0.87931 | 1.4508615 | Aspergillus | 5052 | Fungi | Fungi | 97.4 | 5.07e-22 | NR | ODM15763.1 | 573508 | g11327 | i0 | 87 | 2.94545454545455 | 54 | 7 | 98.2 | 0 | 2 | 163 | 282 | 335 | ODM15763.1 hypothetical protein SI65_08997 [Aspergillus cristatus] | diamond | 486 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus cristatus | |
| 28096179 | 28096179 | PRJNA796975_S_NODE_4885_length_211_cov_1.098765_g4808_i0 | PRJNA796975 | 4885 | 211 | 1.098765 | 2.31839415 | Fusarium solani | 169388 | Fungi | Fungi | 57 | 2.3e-7 | NR | XP_065475107.1 | 169388 | g4808 | i0 | 50 | 1.96208530805687 | 46 | 23 | 65.4 | 0 | 178 | 41 | 434 | 479 | XP_065475107.1 uncharacterized protein MRS44_013065 [Fusarium solani] | diamond | 414 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium solani | |
| 28190683 | 28190683 | PRJNA796975_S_NODE_9486_length_167_cov_0.864407_g9409_i0 | PRJNA796975 | 9486 | 167 | 0.864407 | 1.44355969 | Aspergillus ruber CBS 13568 | 396024 | Fungi | Fungi | 99.8 | 4.549999999999999e-23 | NR | XP_040636211.1 | 1388766 | g9409 | i0 | 78.2 | 0.988023952095808 | 55 | 12 | 98.8 | 0 | 166 | 2 | 278 | 332 | XP_040636211.1 C6 finger domain protein [Aspergillus ruber CBS 135680] | diamond | 165 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus ruber | |
| 28727700 | 28727700 | PRJNA796975_S_NODE_12387_length_164_cov_0.886957_g12310_i0 | PRJNA796975 | 12387 | 164 | 0.886957 | 1.45460948 | Starmerella bacillaris | 1247836 | Fungi | Fungi | 44.3 | 0.00331 | NR | GMM53343.1 | 1247836 | g12310 | i0 | 56.3 | 0.585365853658537 | 32 | 14 | 58.5 | 0 | 96 | 1 | 5 | 36 | GMM53343.1 hypothetical protein DASB73_043060 [Starmerella bacillaris] | diamond | 96 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Starmerella | Starmerella bacillaris | |
| 28894519 | 28894519 | PRJNA796975_S_NODE_15168_length_161_cov_0.910714_g15091_i0 | PRJNA796975 | 15168 | 161 | 0.910714 | 1.46624954 | Aspergillus | 5052 | Fungi | Fungi | 66.6 | 4.55e-11 | NR | XP_043133374.1 | 182096 | g15091 | i0 | 93.9 | 2.45962732919255 | 33 | 2 | 61.5 | 0 | 52 | 150 | 644 | 676 | XP_043133374.1 uncharacterized protein ACHE_20310A [Aspergillus chevalieri] | diamond | 396 | 67 | 0.994029850746269 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 29959097 | 29959097 | PRJNA796975_S_NODE_14551_length_162_cov_0.902655_g14474_i0 | PRJNA796975 | 14551 | 162 | 0.902655 | 1.4623011 | Eutypa lata UCREL1 | 1287681 | Fungi | Fungi | 47.8 | 2.1e-4 | NR | EMR66245.1 | 1287681 | g14474 | i0 | 54.7 | 0.981481481481482 | 53 | 23 | 98.1 | 1 | 160 | 2 | 788 | 839 | EMR66245.1 hypothetical protein UCREL1_6761 [Eutypa lata UCREL1] | diamond | 159 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Diatrypaceae | Eutypa | Eutypa lata | |
| 30180184 | 30180184 | PRJNA796975_S_NODE_13012_length_163_cov_0.894737_g12935_i0 | PRJNA796975 | 13012 | 163 | 0.894737 | 1.45842131 | Blumeria hordei DH14 | 546991 | Fungi | Fungi | 79.7 | 1.06e-15 | NR | CCU81781.1 | 546991 | g12935 | i0 | 80.4 | 0.846625766871166 | 46 | 9 | 84.7 | 0 | 3 | 140 | 45 | 90 | CCU81781.1 reverse transcriptase, putative [Blumeria hordei DH14] | diamond | 138 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria hordei | |
| 30220866 | 30220866 | PRJNA796975_S_NODE_11212_length_165_cov_0.879310_g11135_i0 | PRJNA796975 | 11212 | 165 | 0.87931 | 1.4508615 | Eurotiales | 5042 | Fungi | Fungi | 62.4 | 1.47e-9 | NR | BDD58955.1 | 5098 | g11135 | i0 | 61 | 3.67272727272727 | 41 | 16 | 74.5 | 0 | 132 | 10 | 100 | 140 | BDD58955.1 hypothetical protein MAP00_004190 [Monascus purpureus] | diamond | 606 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Monascus | Monascus purpureus | |
| 30970295 | 30970295 | PRJNA796975_S_NODE_11554_length_165_cov_0.879310_g11477_i0 | PRJNA796975 | 11554 | 165 | 0.87931 | 1.4508615 | [Torrubiella] hemipterigena | 1531966 | Fungi | Fungi | 102 | 4.44e-24 | NR | CEJ80397.1 | 1531966 | g11477 | i0 | 81.8 | 1 | 55 | 10 | 100 | 0 | 165 | 1 | 198 | 252 | CEJ80397.1 hypothetical protein VHEMI00580 [[Torrubiella] hemipterigena] | diamond | 165 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | [Torrubiella] hemipterigena | ||
| 31254532 | 31254532 | PRJNA796975_S_NODE_12755_length_164_cov_0.869565_g12678_i0 | PRJNA796975 | 12755 | 164 | 0.869565 | 1.4260866 | Eutypa lata UCREL1 | 1287681 | Fungi | Fungi | 66.6 | 4.76e-11 | NR | EMR64223.1 | 1287681 | g12678 | i0 | 82.9 | 0.640243902439024 | 35 | 6 | 64 | 0 | 108 | 4 | 28 | 62 | EMR64223.1 putative nol1 nop2 sun family protein [Eutypa lata UCREL1] | diamond | 105 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Diatrypaceae | Eutypa | Eutypa lata | |
| 31444338 | 31444338 | PRJNA796975_S_NODE_14796_length_161_cov_1.187500_g14719_i0 | PRJNA796975 | 14796 | 161 | 1.1875 | 1.911875 | Starmerella bacillaris | 1247836 | Fungi | Fungi | 60.8 | 4.97e-9 | NR | GMM49962.1 | 1247836 | g14719 | i0 | 52.1 | 1.84472049689441 | 48 | 23 | 89.4 | 0 | 149 | 6 | 166 | 213 | GMM49962.1 hypothetical protein DASB73_009200 [Starmerella bacillaris] | diamond | 297 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Starmerella | Starmerella bacillaris | |
| 32203619 | 32203619 | PRJNA796975_S_NODE_9938_length_167_cov_0.864407_g9861_i0 | PRJNA796975 | 9938 | 167 | 0.864407 | 1.44355969 | Acrodontium crateriforme | 150365 | Fungi | Fungi | 103 | 3.66e-24 | NR | WPH02050.1 | 150365 | g9861 | i0 | 90.9 | 0.988023952095808 | 55 | 5 | 98.8 | 0 | 167 | 3 | 305 | 359 | WPH02050.1 Hypothetical protein R9X50_00490500 [Acrodontium crateriforme] | diamond | 165 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme | |
| 32488524 | 32488524 | PRJNA796975_S_NODE_12699_length_164_cov_0.886957_g12622_i0 | PRJNA796975 | 12699 | 164 | 0.886957 | 1.45460948 | Lasiodiplodia theobromae | 45133 | Fungi | Fungi | 103 | 8.61e-25 | NR | KAF9641142.1 | 45133 | g12622 | i0 | 94.1 | 1.86585365853659 | 51 | 3 | 93.3 | 0 | 163 | 11 | 165 | 215 | KAF9641142.1 2og-fe oxygenase [Lasiodiplodia theobromae] | diamond | 306 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Botryosphaeriaceae | Lasiodiplodia | Lasiodiplodia theobromae | |
| 32645843 | 32645843 | PRJNA796975_S_NODE_13380_length_163_cov_0.894737_g13303_i0 | PRJNA796975 | 13380 | 163 | 0.894737 | 1.45842131 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 79.7 | 1.1e-15 | NR | XP_022402215.1 | 1160497 | g13303 | i0 | 77.1 | 0.883435582822086 | 48 | 11 | 88.3 | 0 | 146 | 3 | 208 | 255 | XP_022402215.1 uncharacterized protein ASPGLDRAFT_73446 [Aspergillus glaucus CBS 516.65] | diamond | 144 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 32718252 | 32718252 | PRJNA796975_S_NODE_10540_length_166_cov_0.871795_g10463_i0 | PRJNA796975 | 10540 | 166 | 0.871795 | 1.4471797 | Pleosporales | 92860 | Fungi | Fungi | 70.9 | 1.6e-12 | NR | XP_040784980.1 | 1168544 | g10463 | i0 | 82.9 | 5.29518072289157 | 41 | 7 | 74.1 | 0 | 43 | 165 | 178 | 218 | XP_040784980.1 uncharacterized protein K460DRAFT_346241 [Cucurbitaria berberidis CBS 394.84] | diamond | 879 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Cucurbitariaceae | Cucurbitaria | Cucurbitaria berberidis |
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);;