contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1067443" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1013582 | 1013582 | PRJNA1067443_P_NODE_7821_length_307_cov_3.397436_g7803_i0 | PRJNA1067443 | 7821 | 307 | 3.397436 | 10.43012852 | Wallemia hederae | 1540922 | Fungi | Fungi | 198 | 1.71e-61 | NR | TIA86889.1 | 1540922 | g7803 | i0 | 100 | 0.928338762214984 | 95 | 0 | 92.8 | 0 | 3 | 287 | 2 | 96 | TIA86889.1 hypothetical protein E3P99_03545 [Wallemia hederae] | diamond | 285 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia hederae | |
| 7391072 | 7391072 | PRJNA1067443_P_NODE_10766_length_280_cov_5.801932_g10748_i0 | PRJNA1067443 | 10766 | 280 | 5.801932 | 16.2454096 | Ophiobolus disseminans | 1469910 | Fungi | Fungi | 105 | 3.95e-25 | NR | KAF2830475.1 | 1469910 | g10748 | i0 | 90.2 | 0.546428571428571 | 51 | 5 | 54.6 | 0 | 255 | 103 | 232 | 282 | KAF2830475.1 NAD(P)-binding protein [Ophiobolus disseminans] | diamond | 153 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Ophiobolus | Ophiobolus disseminans | |
| 19306890 | 19306890 | PRJNA1067443_P_NODE_11196_length_278_cov_1.502439_g11178_i0 | PRJNA1067443 | 11196 | 278 | 1.502439 | 4.17678042 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 160 | 4.95e-47 | NR | AYO41766.1 | 425264 | g11178 | i0 | 83.7 | 2.97841726618705 | 92 | 15 | 99.3 | 0 | 278 | 3 | 122 | 213 | AYO41766.1 putative 6-phosphogluconolactonase [Malassezia restricta CBS 7877] | diamond | 828 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27003851 | 27003851 | PRJNA1067443_P_NODE_21942_length_242_cov_0.911243_g21924_i0 | PRJNA1067443 | 21942 | 242 | 0.911243 | 2.20520806 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 101 | 5.319999999999999e-23 | NR | KAG0658434.1 | 5537 | g21924 | i0 | 100 | 0.582644628099174 | 47 | 0 | 58.3 | 0 | 141 | 1 | 390 | 436 | KAG0658434.1 surf-like protein [Rhodotorula mucilaginosa] | diamond | 141 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 27185174 | 27185174 | PRJNA1067443_P_NODE_19222_length_246_cov_1.705202_g19204_i0 | PRJNA1067443 | 19222 | 246 | 1.705202 | 4.19479692 | Ascomycota | 4890 | Fungi | Fungi | 59.3 | 5.42e-8 | NR | XP_008079054.1 | 1116229 | g19204 | i0 | 79.3 | 1.01219512195122 | 29 | 6 | 35.4 | 0 | 3 | 89 | 442 | 470 | XP_008079054.1 Ribokinase-like protein [Glarea lozoyensis ATCC 20868] | diamond | 249 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Helotiaceae | Glarea | Glarea lozoyensis | |
| 27185175 | 27185175 | PRJNA1067443_P_NODE_19442_length_246_cov_0.890173_g19424_i0 | PRJNA1067443 | 19442 | 246 | 0.890173 | 2.18982558 | Ascomycota | 4890 | Fungi | Fungi | 53.5 | 5.88e-6 | NR | KAF2769708.1 | 161662 | g19424 | i0 | 62.5 | 1.48780487804878 | 32 | 12 | 39 | 0 | 122 | 217 | 1 | 32 | KAF2769708.1 splicesome-associated protein [Teratosphaeria nubilosa] | diamond | 366 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Teratosphaeria | Teratosphaeria nubilosa | |
| 27343625 | 27343625 | PRJNA1067443_P_NODE_10163_length_284_cov_2.137441_g10145_i0 | PRJNA1067443 | 10163 | 284 | 2.137441 | 6.07033244 | Malassezia | 55193 | Fungi | Fungi | 138 | 1.79e-35 | NR | WFD04384.1 | 76774 | g10145 | i0 | 73.4 | 2.95774647887324 | 94 | 25 | 99.3 | 0 | 284 | 3 | 650 | 743 | WFD04384.1 hypothetical protein MOBT1_003091 [Malassezia obtusa] | diamond | 840 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa | |
| 27856886 | 27856886 | PRJNA1067443_P_NODE_16585_length_251_cov_0.865169_g16567_i0 | PRJNA1067443 | 16585 | 251 | 0.865169 | 2.17157419 | Rhodotorula sp. CCFEE 5 | 1853554 | Fungi | Fungi | 134 | 1.9099999999999999e-34 | NR | TKA55791.1 | 1965284 | g16567 | i0 | 89.2 | 1.97211155378486 | 83 | 8 | 99.2 | 1 | 2 | 250 | 700 | 781 | TKA55791.1 hypothetical protein B0A53_02929 [Rhodotorula sp. CCFEE 5036] | diamond | 495 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. CCFEE 5036 | |
| 28204084 | 28204084 | PRJNA1067443_P_NODE_20746_length_244_cov_0.900585_g20728_i0 | PRJNA1067443 | 20746 | 244 | 0.900585 | 2.1974274 | Dactylonectria macrodidyma | 307937 | Fungi | Fungi | 58.9 | 7.66e-8 | NR | KAH7117488.1 | 307937 | g20728 | i0 | 50.8 | 4.38934426229508 | 59 | 29 | 72.5 | 0 | 44 | 220 | 223 | 281 | KAH7117488.1 hypothetical protein EDB81DRAFT_767268 [Dactylonectria macrodidyma] | diamond | 1071 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Dactylonectria | Dactylonectria macrodidyma | |
| 28678039 | 28678039 | PRJNA1067443_P_NODE_9247_length_290_cov_1.419355_g9229_i0 | PRJNA1067443 | 9247 | 290 | 1.419355 | 4.1161295 | Remersonia thermophila | 72144 | Fungi | Fungi | 43.5 | 0.0348 | NR | XP_070866785.1 | 72144 | g9229 | i0 | 32.8 | 0.693103448275862 | 67 | 45 | 69.3 | 0 | 46 | 246 | 7 | 73 | XP_070866785.1 hypothetical protein VTJ83DRAFT_2904 [Remersonia thermophila] | diamond | 201 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Remersonia | Remersonia thermophila | ||
| 28953904 | 28953904 | PRJNA1067443_P_NODE_18908_length_247_cov_0.885057_g18890_i0 | PRJNA1067443 | 18908 | 247 | 0.885057 | 2.18609079 | Mucorales | 4827 | Fungi | Fungi | 90.5 | 6.16e-19 | NR | KAG2193041.1 | 64648 | g18890 | i0 | 66.7 | 5.08906882591093 | 60 | 20 | 72.9 | 0 | 181 | 2 | 304 | 363 | KAG2193041.1 hypothetical protein INT47_009291 [Mucor saturninus] | diamond | 1257 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor saturninus | |
| 29056888 | 29056888 | PRJNA1067443_P_NODE_14328_length_260_cov_2.155080_g14310_i0 | PRJNA1067443 | 14328 | 260 | 2.15508 | 5.603208 | Macroventuria anomochaeta | 301207 | Fungi | Fungi | 47 | 0.00105 | NR | XP_033556360.1 | 301207 | g14310 | i0 | 61.5 | 0.45 | 39 | 14 | 45 | 1 | 43 | 159 | 17 | 54 | XP_033556360.1 uncharacterized protein BU25DRAFT_425946 [Macroventuria anomochaeta] | diamond | 117 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Macroventuria | Macroventuria anomochaeta | |
| 29246209 | 29246209 | PRJNA1067443_P_NODE_15329_length_255_cov_2.340659_g15311_i0 | PRJNA1067443 | 15329 | 255 | 2.340659 | 5.96868045 | Ophiostoma piceae UAMH 11346 | 1262450 | Fungi | Fungi | 160 | 1.37e-43 | NR | EPE03758.1 | 1262450 | g15311 | i0 | 98.8 | 1 | 85 | 1 | 100 | 0 | 255 | 1 | 409 | 493 | EPE03758.1 serine threonine protein kinase [Ophiostoma piceae UAMH 11346] | diamond | 255 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma piceae | |
| 29530435 | 29530435 | PRJNA1067443_P_NODE_13570_length_264_cov_2.319372_g13552_i0 | PRJNA1067443 | 13570 | 264 | 2.319372 | 6.12314208 | Malassezia restricta | 76775 | Fungi | Fungi | 48.5 | 3.65e-5 | NR | XP_027483267.1 | 76775 | g13552 | i0 | 70.6 | 0.386363636363636 | 34 | 9 | 37.5 | 1 | 264 | 166 | 34 | 67 | XP_027483267.1 mitochondrial export protein SOM1 [Malassezia restricta] | diamond | 102 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30415186 | 30415186 | PRJNA1067443_P_NODE_18253_length_248_cov_0.880000_g18235_i0 | PRJNA1067443 | 18253 | 248 | 0.88 | 2.1824 | Hortaea werneckii | 91943 | Fungi | Fungi | 87.8 | 5.55e-18 | NR | GAB1731874.1 | 91943 | g18235 | i0 | 72.6 | 0.75 | 62 | 17 | 75 | 0 | 188 | 3 | 100 | 161 | GAB1731874.1 hypothetical protein NU195Hw_Modified_347t1 [Hortaea werneckii] | diamond | 186 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 31172800 | 31172800 | PRJNA1067443_P_NODE_6835_length_321_cov_3.512097_g6817_i0 | PRJNA1067443 | 6835 | 321 | 3.512097 | 11.27383137 | Coprinopsis cinerea okayama7#13 | 5346 | Fungi | Fungi | 199 | 8.16e-60 | NR | XP_001838108.2 | 240176 | g6817 | i0 | 99 | 0.934579439252336 | 100 | 1 | 93.5 | 0 | 1 | 300 | 225 | 324 | XP_001838108.2 hypothetical protein CC1G_05589 [Coprinopsis cinerea okayama7#130] | diamond | 300 | 199 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis cinerea | |
| 31204261 | 31204261 | PRJNA1067443_P_NODE_515_length_684_cov_14.883797_g498_i0 | PRJNA1067443 | 515 | 684 | 14.883797 | 101.80517148 | Ambispora leptoticha | 144679 | Fungi | Fungi | 67 | 5.83e-9 | NR | CAG8514923.1 | 144679 | g498 | i0 | 29.3 | 3.83771929824561 | 215 | 124 | 90.4 | 8 | 33 | 650 | 94 | 289 | CAG8514923.1 3636_t:CDS:2 [Ambispora leptoticha] | diamond | 2625 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Ambisporaceae | Ambispora | Ambispora leptoticha | |
| 31227775 | 31227775 | PRJNA1067443_P_NODE_22735_length_241_cov_0.916667_g22717_i0 | PRJNA1067443 | 22735 | 241 | 0.916667 | 2.20916747 | Penicillium | 5073 | Fungi | Fungi | 109 | 1.37e-25 | NR | KAJ5184172.1 | 69766 | g22717 | i0 | 85.2 | 6.149377593361 | 61 | 9 | 75.9 | 0 | 241 | 59 | 935 | 995 | KAJ5184172.1 hypothetical protein N7492_001788 [Penicillium capsulatum] | diamond | 1482 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium capsulatum | |
| 31236227 | 31236227 | PRJNA1067443_P_NODE_21235_length_243_cov_0.905882_g21217_i0 | PRJNA1067443 | 21235 | 243 | 0.905882 | 2.20129326 | Malassezia cuniculi | 948313 | Fungi | Fungi | 108 | 2.55e-25 | NR | WFD33702.1 | 948313 | g21217 | i0 | 65 | 0.987654320987654 | 80 | 28 | 98.8 | 0 | 241 | 2 | 359 | 438 | WFD33702.1 hypothetical protein MCUN1_000515 [Malassezia cuniculi] | diamond | 240 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 31268012 | 31268012 | PRJNA1067443_P_NODE_5215_length_351_cov_4.115108_g5197_i0 | PRJNA1067443 | 5215 | 351 | 4.115108 | 14.44402908 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 155 | 2.6499999999999994e-42 | NR | PWI73734.1 | 33203 | g5197 | i0 | 68.1 | 1.93162393162393 | 113 | 36 | 96.6 | 0 | 341 | 3 | 350 | 462 | PWI73734.1 C6 zinc finger domain protein [Purpureocillium lilacinum] | diamond | 678 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 32470350 | 32470350 | PRJNA1067443_P_NODE_24199_length_213_cov_6.378571_g24181_i0 | PRJNA1067443 | 24199 | 213 | 6.378571 | 13.58635623 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 114 | 1.16e-27 | NR | KAK5094920.1 | 1690604 | g24181 | i0 | 74.6 | 1 | 71 | 18 | 100 | 0 | 1 | 213 | 318 | 388 | KAK5094920.1 hypothetical protein LTR24_003368 [Lithohypha guttulata] | diamond | 213 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 32879870 | 32879870 | PRJNA1067443_P_NODE_22760_length_241_cov_0.916667_g22742_i0 | PRJNA1067443 | 22760 | 241 | 0.916667 | 2.20916747 | Malassezia equina | 1381935 | Fungi | Fungi | 72.4 | 1.19e-12 | NR | WFD21610.1 | 1381935 | g22742 | i0 | 51.4 | 2.4149377593361 | 74 | 33 | 92.1 | 1 | 239 | 18 | 379 | 449 | WFD21610.1 Manganese transporter smf1 [Malassezia equina] | diamond | 582 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia equina |
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);;