contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJEB49404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7764398 | 7764398 | PRJEB49404_P_NODE_527487_length_175_cov_1.205882_g513686_i0 | PRJEB49404 | 527487 | 175 | 1.205882 | 2.1102935 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 111 | 1.28e-29 | NR | KAJ8135180.1 | 27326 | g513686 | i0 | 93.1 | 0.994285714285714 | 58 | 4 | 99.4 | 0 | 174 | 1 | 42 | 99 | KAJ8135180.1 hypothetical protein OY671_011607, partial [Metschnikowia pulcherrima] | diamond | 174 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 26907012 | 26907012 | PRJEB49404_P_NODE_612482_length_157_cov_1.389831_g598681_i0 | PRJEB49404 | 612482 | 157 | 1.389831 | 2.18203467 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 87.8 | 6.620000000000001e-21 | NR | KAJ8135792.1 | 27326 | g598681 | i0 | 89.6 | 1.85350318471338 | 48 | 5 | 91.7 | 0 | 5 | 148 | 58 | 105 | KAJ8135792.1 hypothetical protein OY671_010995 [Metschnikowia pulcherrima] | diamond | 291 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 27286367 | 27286367 | PRJEB49404_P_NODE_547443_length_170_cov_1.809160_g533642_i0 | PRJEB49404 | 547443 | 170 | 1.80916 | 3.075572 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 110 | 2.54e-28 | NR | KAJ8137541.1 | 27326 | g533642 | i0 | 91.1 | 0.988235294117647 | 56 | 5 | 98.8 | 0 | 1 | 168 | 70 | 125 | KAJ8137541.1 hypothetical protein OY671_009246, partial [Metschnikowia pulcherrima] | diamond | 168 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 27444653 | 27444653 | PRJEB49404_P_NODE_452183_length_195_cov_3.102564_g438382_i0 | PRJEB49404 | 452183 | 195 | 3.102564 | 6.0499998 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 123 | 4.66e-34 | NR | KAJ8134740.1 | 27326 | g438382 | i0 | 95.2 | 0.969230769230769 | 63 | 3 | 96.9 | 0 | 2 | 190 | 67 | 129 | KAJ8134740.1 hypothetical protein OY671_012047, partial [Metschnikowia pulcherrima] | diamond | 189 | 123 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 27981174 | 27981174 | PRJEB49404_P_NODE_637665_length_152_cov_1.867257_g623864_i0 | PRJEB49404 | 637665 | 152 | 1.867257 | 2.83823064 | Acrodontium crateriforme | 150365 | Fungi | Fungi | 72.8 | 1.12e-13 | NR | WPH02968.1 | 150365 | g623864 | i0 | 90.7 | 1.69736842105263 | 43 | 4 | 84.9 | 0 | 150 | 22 | 227 | 269 | WPH02968.1 Hypothetical protein R9X50_00584000 [Acrodontium crateriforme] | diamond | 258 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme | |
| 28139251 | 28139251 | PRJEB49404_P_NODE_368625_length_227_cov_1.696809_g354824_i0 | PRJEB49404 | 368625 | 227 | 1.696809 | 3.85175643 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 113 | 5.85e-30 | NR | KAJ8134404.1 | 27326 | g354824 | i0 | 100 | 0.713656387665198 | 54 | 0 | 71.4 | 0 | 226 | 65 | 98 | 151 | KAJ8134404.1 hypothetical protein OY671_012383, partial [Metschnikowia pulcherrima] | diamond | 162 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 28707430 | 28707430 | PRJEB49404_P_NODE_530327_length_174_cov_1.703704_g516526_i0 | PRJEB49404 | 530327 | 174 | 1.703704 | 2.96444496 | Penicillium hispanicum | 1080232 | Fungi | Fungi | 41.6 | 0.0377 | NR | XP_056798702.1 | 1080232 | g516526 | i0 | 38.7 | 1.06896551724138 | 62 | 27 | 89.7 | 3 | 157 | 2 | 347 | 407 | XP_056798702.1 phosphoesterase family-domain-containing protein [Penicillium hispanicum] | diamond | 186 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium hispanicum | |
| 28738918 | 28738918 | PRJEB49404_P_NODE_467607_length_191_cov_1.348684_g453806_i0 | PRJEB49404 | 467607 | 191 | 1.348684 | 2.57598644 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 117 | 8.54e-32 | NR | KAJ8133689.1 | 27326 | g453806 | i0 | 96.6 | 0.910994764397906 | 58 | 2 | 91.1 | 0 | 18 | 191 | 1 | 58 | KAJ8133689.1 hypothetical protein OY671_013097, partial [Metschnikowia pulcherrima] | diamond | 174 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 29181100 | 29181100 | PRJEB49404_P_NODE_205249_length_346_cov_1.130293_g191450_i0 | PRJEB49404 | 205249 | 346 | 1.130293 | 3.91081378 | Aspergillus novofumigatus IBT 168 | 340412 | Fungi | Fungi | 44.3 | 0.0328 | NR | XP_024685771.1 | 1392255 | g191450 | i0 | 43.6 | 0.476878612716763 | 55 | 25 | 47.7 | 1 | 189 | 25 | 221 | 269 | XP_024685771.1 putative amino acid transporter [Aspergillus novofumigatus IBT 16806] | diamond | 165 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus novofumigatus | |
| 29591021 | 29591021 | PRJEB49404_P_NODE_567090_length_166_cov_1.291339_g553289_i0 | PRJEB49404 | 567090 | 166 | 1.291339 | 2.14362274 | Leptodontidium sp. 2 PMI_412 | 1485227 | Fungi | Fungi | 50.1 | 2.34e-5 | NR | KAH9204849.1 | 1485227 | g553289 | i0 | 43.8 | 0.867469879518072 | 48 | 27 | 86.7 | 0 | 161 | 18 | 121 | 168 | KAH9204849.1 cytochrome P450 [Leptodontidium sp. 2 PMI_412] | diamond | 144 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Leptodontidiaceae | Leptodontidium | Leptodontidium sp. 2 PMI_412 | |
| 29843976 | 29843976 | PRJEB49404_P_NODE_350251_length_236_cov_1.375635_g336450_i0 | PRJEB49404 | 350251 | 236 | 1.375635 | 3.2464986 | Ophiobolus disseminans | 1469910 | Fungi | Fungi | 42.7 | 0.0348 | NR | KAF2818298.1 | 1469910 | g336450 | i0 | 45.5 | 0.699152542372881 | 55 | 27 | 67.4 | 2 | 67 | 225 | 857 | 910 | KAF2818298.1 ankyrin [Ophiobolus disseminans] | diamond | 165 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Ophiobolus | Ophiobolus disseminans | |
| 29900584 | 29900584 | PRJEB49404_P_NODE_521971_length_176_cov_1.795620_g508170_i0 | PRJEB49404 | 521971 | 176 | 1.79562 | 3.1602912 | root | 1 | Root_unresolved | Root_unresolved | 99.4 | 7.64e-25 | NR | KAJ8134129.1 | 27326 | g508170 | i0 | 87.9 | 4.92613636363636 | 58 | 7 | 98.9 | 0 | 175 | 2 | 91 | 148 | KAJ8134129.1 hypothetical protein OY671_012657, partial [Metschnikowia pulcherrima] | diamond | 867 | 100 | 0.994 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 29907303 | 29907303 | PRJEB49404_P_NODE_555611_length_168_cov_2.124031_g541810_i0 | PRJEB49404 | 555611 | 168 | 2.124031 | 3.56837208 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 89.7 | 7.95e-22 | NR | KAJ8135179.1 | 27326 | g541810 | i0 | 98.1 | 0.964285714285714 | 54 | 1 | 96.4 | 0 | 167 | 6 | 34 | 87 | KAJ8135179.1 hypothetical protein OY671_011608 [Metschnikowia pulcherrima] | diamond | 162 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 30064998 | 30064998 | PRJEB49404_P_NODE_335512_length_243_cov_2.161765_g321711_i0 | PRJEB49404 | 335512 | 243 | 2.161765 | 5.25308895 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 63.5 | 6.24e-10 | NR | KAJ8137541.1 | 27326 | g321711 | i0 | 100 | 0.407407407407407 | 33 | 0 | 40.7 | 0 | 143 | 241 | 1 | 33 | KAJ8137541.1 hypothetical protein OY671_009246, partial [Metschnikowia pulcherrima] | diamond | 99 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 30128029 | 30128029 | PRJEB49404_P_NODE_370432_length_226_cov_1.962567_g356631_i0 | PRJEB49404 | 370432 | 226 | 1.962567 | 4.43540142 | Venturia nashicola | 86259 | Fungi | Fungi | 87.8 | 4.49e-20 | NR | TLD05626.1 | 86259 | g356631 | i0 | 73.8 | 1.61946902654867 | 61 | 16 | 81 | 0 | 44 | 226 | 1 | 61 | TLD05626.1 hypothetical protein E2P81_ATG10537 [Venturia nashicola] | diamond | 366 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Venturiaceae | Venturia | Venturia nashicola | |
| 30350039 | 30350039 | PRJEB49404_P_NODE_384192_length_220_cov_2.044199_g370391_i0 | PRJEB49404 | 384192 | 220 | 2.044199 | 4.4972378 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 144 | 2.0299999999999994e-42 | NR | KAJ8135014.1 | 27326 | g370391 | i0 | 98.5 | 0.927272727272727 | 68 | 1 | 92.7 | 0 | 205 | 2 | 1 | 68 | KAJ8135014.1 hypothetical protein OY671_011773 [Metschnikowia pulcherrima] | diamond | 204 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 30381488 | 30381488 | PRJEB49404_P_NODE_630873_length_153_cov_4.061404_g617072_i0 | PRJEB49404 | 630873 | 153 | 4.061404 | 6.21394812 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 80.9 | 7.6e-18 | NR | KAJ8134499.1 | 27326 | g617072 | i0 | 89.8 | 0.96078431372549 | 49 | 5 | 96.1 | 0 | 5 | 151 | 33 | 81 | KAJ8134499.1 hypothetical protein OY671_012288, partial [Metschnikowia pulcherrima] | diamond | 147 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 30570388 | 30570388 | PRJEB49404_P_NODE_524113_length_176_cov_1.109489_g510312_i0 | PRJEB49404 | 524113 | 176 | 1.109489 | 1.95270064 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 99.8 | 9.37e-25 | NR | KAJ8136015.1 | 27326 | g510312 | i0 | 97.8 | 0.784090909090909 | 46 | 1 | 78.4 | 0 | 3 | 140 | 124 | 169 | KAJ8136015.1 hypothetical protein OY671_010772, partial [Metschnikowia pulcherrima] | diamond | 138 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 30633660 | 30633660 | PRJEB49404_P_NODE_648953_length_150_cov_2.009009_g635152_i0 | PRJEB49404 | 648953 | 150 | 2.009009 | 3.0135135 | Valsa sordida | 252740 | Fungi | Fungi | 79.3 | 1.28e-15 | NR | ROV99332.1 | 252740 | g635152 | i0 | 89.8 | 0.98 | 49 | 5 | 98 | 0 | 149 | 3 | 1179 | 1227 | ROV99332.1 hypothetical protein VSDG_04009 [Cytospora chrysosperma] | diamond | 147 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora chrysosperma | |
| 31423934 | 31423934 | PRJEB49404_P_NODE_536596_length_173_cov_1.164179_g522795_i0 | PRJEB49404 | 536596 | 173 | 1.164179 | 2.01402967 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 62.4 | 2.94e-10 | NR | KAJ8136519.1 | 27326 | g522795 | i0 | 96.7 | 0.520231213872832 | 30 | 1 | 52 | 0 | 80 | 169 | 2 | 31 | KAJ8136519.1 hypothetical protein OY671_010268, partial [Metschnikowia pulcherrima] | diamond | 90 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 31676902 | 31676902 | PRJEB49404_P_NODE_556817_length_168_cov_1.589147_g543016_i0 | PRJEB49404 | 556817 | 168 | 1.589147 | 2.66976696 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 119 | 1.41e-33 | NR | KAJ8134610.1 | 27326 | g543016 | i0 | 100 | 1 | 56 | 0 | 100 | 0 | 168 | 1 | 33 | 88 | KAJ8134610.1 hypothetical protein OY671_012177, partial [Metschnikowia pulcherrima] | diamond | 168 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 31930001 | 31930001 | PRJEB49404_P_NODE_619197_length_156_cov_1.051282_g605396_i0 | PRJEB49404 | 619197 | 156 | 1.051282 | 1.63999992 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 107 | 2.11e-28 | NR | KAJ8134144.1 | 27326 | g605396 | i0 | 96.2 | 1 | 52 | 2 | 100 | 0 | 156 | 1 | 66 | 117 | KAJ8134144.1 hypothetical protein OY671_012642, partial [Metschnikowia pulcherrima] | diamond | 156 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 32657014 | 32657014 | PRJEB49404_P_NODE_353980_length_234_cov_1.666667_g340179_i0 | PRJEB49404 | 353980 | 234 | 1.666667 | 3.90000078 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 159 | 2.1999999999999997e-47 | NR | KAJ8137499.1 | 27326 | g340179 | i0 | 98.7 | 1 | 78 | 1 | 100 | 0 | 234 | 1 | 9 | 86 | KAJ8137499.1 hypothetical protein OY671_009288, partial [Metschnikowia pulcherrima] | diamond | 234 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 32688695 | 32688695 | PRJEB49404_P_NODE_308440_length_258_cov_3.059361_g294639_i0 | PRJEB49404 | 308440 | 258 | 3.059361 | 7.89315138 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 173 | 1.66e-53 | NR | KAJ8134404.1 | 27326 | g294639 | i0 | 98.8 | 0.988372093023256 | 85 | 1 | 98.8 | 0 | 2 | 256 | 8 | 92 | KAJ8134404.1 hypothetical protein OY671_012383, partial [Metschnikowia pulcherrima] | diamond | 255 | 173 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima |
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);;