contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA641991" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17195701 | 17195701 | PRJNA641991_S_NODE_12614_length_166_cov_0.871795_g12495_i0 | PRJNA641991 | 12614 | 166 | 0.871795 | 1.4471797 | Pleosporales | 92860 | Fungi | Fungi | 104 | 1.88e-24 | NR | KAH6861696.1 | 5599 | g12495 | i0 | 88.9 | 8.78313253012048 | 54 | 6 | 97.6 | 0 | 3 | 164 | 684 | 737 | KAH6861696.1 CobB/CobQ-like glutamine amidotransferase domain-containing protein [Alternaria alternata] | diamond | 1458 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 26637996 | 26637996 | PRJNA641991_S_NODE_6401_length_217_cov_0.928571_g6282_i0 | PRJNA641991 | 6401 | 217 | 0.928571 | 2.01499907 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 41.2 | 0.0362 | NR | KAG9570084.1 | 46634 | g6282 | i0 | 41.5 | 0.566820276497696 | 41 | 24 | 56.7 | 0 | 2 | 124 | 76 | 116 | KAG9570084.1 hypothetical protein KCU79_g1179, partial [Aureobasidium melanogenum] | diamond | 123 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 26872399 | 26872399 | PRJNA641991_P_NODE_3961_length_163_cov_0.894737_g3920_i0 | PRJNA641991 | 3961 | 163 | 0.894737 | 1.45842131 | Pleosporales | 92860 | Fungi | Fungi | 87.8 | 1.68e-18 | NR | OAL07724.1 | 765868 | g3920 | i0 | 77.8 | 7.91411042944785 | 54 | 12 | 99.4 | 0 | 162 | 1 | 103 | 156 | OAL07724.1 hypothetical protein IQ06DRAFT_372655 [Phaeosphaeriaceae sp. SRC1lsM3a] | diamond | 1290 | 88.2 | 0.99546485260771 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Phaeosphaeriaceae sp. SRC1lsM3a | ||
| 26986221 | 26986221 | PRJNA641991_S_NODE_14302_length_162_cov_0.902655_g14183_i0 | PRJNA641991 | 14302 | 162 | 0.902655 | 1.4623011 | [Candida] arabinofermentans NRRL YB-2248 | 983967 | Fungi | Fungi | 58.5 | 3.35e-8 | NR | ODV86831.1 | 983967 | g14183 | i0 | 51.9 | 1 | 54 | 26 | 100 | 0 | 162 | 1 | 366 | 419 | ODV86831.1 hypothetical protein CANARDRAFT_27215 [[Candida] arabinofermentans NRRL YB-2248] | diamond | 162 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | [Candida] arabinofermentans | |
| 27302633 | 27302633 | PRJNA641991_P_NODE_843_length_369_cov_1.087500_g802_i0 | PRJNA641991 | 843 | 369 | 1.0875 | 4.012875 | Choiromyces venosus 12 | 44640 | Fungi | Fungi | 45.8 | 0.00424 | NR | RPB02611.1 | 1336337 | g802 | i0 | 46.3 | 0.439024390243902 | 54 | 24 | 43.9 | 2 | 12 | 173 | 14 | 62 | RPB02611.1 hypothetical protein L873DRAFT_1787605 [Choiromyces venosus 120613-1] | diamond | 162 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tuberaceae | Choiromyces | Choiromyces venosus | |
| 27997362 | 27997362 | PRJNA641991_S_NODE_12805_length_165_cov_1.310345_g12686_i0 | PRJNA641991 | 12805 | 165 | 1.310345 | 2.16206925 | Hirsutella minnesotensis 36 | 332947 | Fungi | Fungi | 100 | 1.47e-25 | NR | KJZ73469.1 | 1043627 | g12686 | i0 | 83.3 | 1.96363636363636 | 54 | 9 | 98.2 | 0 | 3 | 164 | 67 | 120 | KJZ73469.1 hypothetical protein HIM_07025 [Hirsutella minnesotensis 3608] | diamond | 324 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Hirsutella | Hirsutella minnesotensis | |
| 28167476 | 28167476 | PRJNA641991_S_NODE_10105_length_179_cov_1.661538_g9986_i0 | PRJNA641991 | 10105 | 179 | 1.661538 | 2.97415302 | Pichia | 4919 | Fungi | Fungi | 42.7 | 0.0151 | NR | TID30708.1 | 52247 | g9986 | i0 | 41.1 | 3.75418994413408 | 56 | 33 | 93.9 | 0 | 11 | 178 | 182 | 237 | TID30708.1 hypothetical protein CANINC_000624 [Pichia inconspicua] | diamond | 672 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia inconspicua | |
| 29954916 | 29954916 | PRJNA641991_S_NODE_6971_length_209_cov_1.275000_g6852_i0 | PRJNA641991 | 6971 | 209 | 1.275 | 2.66475 | Komagataella phaffii | 460519 | Fungi | Fungi | 47.4 | 2.93e-4 | NR | AOA64359.1 | 460519 | g6852 | i0 | 45.8 | 1.37799043062201 | 48 | 25 | 67.5 | 1 | 203 | 63 | 121 | 168 | AOA64359.1 GQ67_03066T0 [Komagataella phaffii] | diamond | 288 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella phaffii | |
| 30346826 | 30346826 | PRJNA641991_S_NODE_14692_length_161_cov_0.910714_g14573_i0 | PRJNA641991 | 14692 | 161 | 0.910714 | 1.46624954 | Fungi | 4751 | Fungi | Fungi | 41.6 | 0.0245 | NR | ONH68754.1 | 36022 | g14573 | i0 | 48.9 | 3.5776397515528 | 45 | 22 | 82 | 1 | 2 | 133 | 57 | 101 | ONH68754.1 hypothetical protein BON22_1124 [Cyberlindnera fabianii] | diamond | 576 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera fabianii | |
| 31104473 | 31104473 | PRJNA641991_S_NODE_8855_length_189_cov_1.457143_g8736_i0 | PRJNA641991 | 8855 | 189 | 1.457143 | 2.75400027 | root | 1 | Root_unresolved | Root_unresolved | 112 | 4.27e-29 | NR | KAK3362469.1 | 260671 | g8736 | i0 | 82.3 | 33.3650793650794 | 62 | 11 | 98.4 | 0 | 2 | 187 | 94 | 155 | KAK3362469.1 cyclophilin-like domain-containing protein [Lasiosphaeria hispida] | diamond | 6306 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Lasiosphaeria | Lasiosphaeria hispida | |
| 31484265 | 31484265 | PRJNA641991_P_NODE_3756_length_164_cov_0.886957_g3715_i0 | PRJNA641991 | 3756 | 164 | 0.886957 | 1.45460948 | Pneumocystis | 4753 | Fungi | Fungi | 65.9 | 5.31e-11 | NR | XP_018229326.1 | 1408657 | g3715 | i0 | 49.2 | 2.10365853658537 | 61 | 24 | 98.8 | 1 | 2 | 163 | 146 | 206 | XP_018229326.1 uncharacterized protein T551_02111 [Pneumocystis jirovecii RU7] | diamond | 345 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis jirovecii | |
| 31629900 | 31629900 | PRJNA641991_S_NODE_12656_length_166_cov_0.871795_g12537_i0 | PRJNA641991 | 12656 | 166 | 0.871795 | 1.4471797 | Ophiobolus disseminans | 1469910 | Fungi | Fungi | 94.4 | 8.790000000000001e-21 | NR | KAF2823600.1 | 1469910 | g12537 | i0 | 89.1 | 0.993975903614458 | 55 | 6 | 99.4 | 0 | 2 | 166 | 549 | 603 | KAF2823600.1 patatin-domain-containing protein [Ophiobolus disseminans] | diamond | 165 | 94.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Ophiobolus | Ophiobolus disseminans | |
| 31851154 | 31851154 | PRJNA641991_S_NODE_14477_length_161_cov_2.973214_g14358_i0 | PRJNA641991 | 14477 | 161 | 2.973214 | 4.78687454 | Elasticomyces elasticus | 574655 | Fungi | Fungi | 44.7 | 0.00251 | NR | KAK5737946.1 | 574655 | g14358 | i0 | 38 | 0.93167701863354 | 50 | 29 | 89.4 | 1 | 148 | 5 | 67 | 116 | KAK5737946.1 hypothetical protein LTR17_006386 [Elasticomyces elasticus] | diamond | 150 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Elasticomyces | Elasticomyces elasticus | |
| 32009524 | 32009524 | PRJNA641991_S_NODE_12578_length_166_cov_0.871795_g12459_i0 | PRJNA641991 | 12578 | 166 | 0.871795 | 1.4471797 | Icmadophila ericetorum | 90408 | Fungi | Fungi | 50.1 | 3.38e-5 | NR | MCJ1359731.1 | 90408 | g12459 | i0 | 48.8 | 1.78915662650602 | 43 | 22 | 77.7 | 0 | 133 | 5 | 238 | 280 | MCJ1359731.1 hypothetical protein [Icmadophila ericetorum] | diamond | 297 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Pertusariales | Icmadophilaceae | Icmadophila | Icmadophila ericetorum | |
| 32072784 | 32072784 | PRJNA641991_P_NODE_698_length_416_cov_3.321526_g657_i0 | PRJNA641991 | 698 | 416 | 3.321526 | 13.81754816 | Bisporella sp. PMI_857 | 1954211 | Fungi | Fungi | 49.7 | 7.88e-4 | NR | KAH8601976.1 | 1954211 | g657 | i0 | 45.9 | 0.533653846153846 | 74 | 31 | 46.9 | 3 | 5 | 199 | 224 | 297 | KAH8601976.1 hypothetical protein B0O99DRAFT_205364 [Bisporella sp. PMI_857] | diamond | 222 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Helotiaceae | Bisporella | Bisporella sp. PMI_857 | |
| 32389155 | 32389155 | PRJNA641991_S_NODE_11879_length_167_cov_1.389831_g11760_i0 | PRJNA641991 | 11879 | 167 | 1.389831 | 2.32101777 | Myxozyma melibiosi | 54550 | Fungi | Fungi | 53.1 | 2.83e-6 | NR | XP_064767838.1 | 54550 | g11760 | i0 | 52.4 | 0.754491017964072 | 42 | 20 | 75.4 | 0 | 1 | 126 | 170 | 211 | XP_064767838.1 WD40-repeat-containing domain protein [Myxozyma melibiosi] | diamond | 126 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Myxozyma | Myxozyma melibiosi |
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);;