contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1226487" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9974890 | 9974890 | PRJNA1226487_P_NODE_12828_length_413_cov_1.794118_g12728_i0 | PRJNA1226487 | 12828 | 413 | 1.794118 | 7.40970734 | Malassezia cuniculi | 948313 | Fungi | Fungi | 269 | 1e-88 | NR | WFD34182.1 | 948313 | g12728 | i0 | 88.3 | 0.995157384987893 | 137 | 16 | 99.5 | 0 | 2 | 412 | 143 | 279 | WFD34182.1 succinate dehydrogenase [Malassezia cuniculi] | diamond | 411 | 269 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 14363858 | 14363858 | PRJNA1226487_P_NODE_1212_length_895_cov_13.435523_g1137_i0 | PRJNA1226487 | 1212 | 895 | 13.435523 | 120.24793085 | Kwoniella dejecticola CBS 1 | 324770 | Fungi | Fungi | 63.9 | 3.35e-7 | NR | XP_065824233.1 | 1296121 | g1137 | i0 | 42.4 | 0.489385474860335 | 99 | 43 | 28.5 | 1 | 312 | 58 | 1305 | 1403 | XP_065824233.1 uncharacterized protein I303_100657 [Kwoniella dejecticola CBS 10117] | diamond | 438 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dejecticola | |
| 14363868 | 14363868 | PRJNA1226487_P_NODE_1432_length_843_cov_14.993506_g1354_i0 | PRJNA1226487 | 1432 | 843 | 14.993506 | 126.39525558 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 409 | 3.5e-142 | NR | XP_018738668.1 | 1230383 | g1354 | i0 | 87.1 | 0.882562277580071 | 248 | 28 | 87.2 | 2 | 735 | 1 | 1 | 247 | XP_018738668.1 uncharacterized protein MSY001_0017 [Malassezia sympodialis ATCC 42132] | diamond | 744 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 22723766 | 22723766 | PRJNA1226487_P_NODE_8038_length_478_cov_4.437037_g7939_i0 | PRJNA1226487 | 8038 | 478 | 4.437037 | 21.20903686 | Malassezia cuniculi | 948313 | Fungi | Fungi | 258 | 6.24e-84 | NR | WFD34182.1 | 948313 | g7939 | i0 | 85.4 | 0.947698744769874 | 151 | 22 | 94.8 | 0 | 25 | 477 | 1 | 151 | WFD34182.1 succinate dehydrogenase [Malassezia cuniculi] | diamond | 453 | 258 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 26819774 | 26819774 | PRJNA1226487_P_NODE_721_length_1062_cov_2.777553_g657_i0 | PRJNA1226487 | 721 | 1062 | 2.777553 | 29.49761286 | Mycena metata | 1033252 | Fungi | Fungi | 48.9 | 0.0334 | NR | KAJ7714877.1 | 1033252 | g657 | i0 | 47.3 | 0.155367231638418 | 55 | 29 | 15.5 | 0 | 1061 | 897 | 466 | 520 | KAJ7714877.1 P-loop containing nucleoside triphosphate hydrolase protein [Mycena metata] | diamond | 165 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena metata | |
| 27546697 | 27546697 | PRJNA1226487_P_NODE_1384_length_854_cov_30.422535_g1307_i0 | PRJNA1226487 | 1384 | 854 | 30.422535 | 259.8084489 | Kwoniella sp. CBS 6 | 1941230 | Fungi | Fungi | 139 | 3.71e-35 | NR | WVF72245.1 | 2770021 | g1307 | i0 | 62.4 | 0.382903981264637 | 109 | 40 | 38.3 | 1 | 688 | 362 | 75 | 182 | WVF72245.1 hypothetical protein IAT40_007057 [Kwoniella sp. CBS 6097] | diamond | 327 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella sp. CBS 6097 | |
| 29157164 | 29157164 | PRJNA1226487_P_NODE_79889_length_236_cov_7.288344_g79787_i0 | PRJNA1226487 | 79889 | 236 | 7.288344 | 17.20049184 | Malassezia cuniculi | 948313 | Fungi | Fungi | 47.4 | 6.79e-4 | NR | WFD33617.1 | 948313 | g79787 | i0 | 100 | 0.533898305084746 | 21 | 0 | 26.7 | 0 | 231 | 169 | 232 | 252 | WFD33617.1 60S ribosomal protein L7 [Malassezia cuniculi] | diamond | 126 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 29207449 | 29207449 | PRJNA1226487_P_NODE_20169_length_359_cov_9.993007_g20067_i0 | PRJNA1226487 | 20169 | 359 | 9.993007 | 35.87489513 | Malassezia | 55193 | Fungi | Fungi | 105 | 2.8e-27 | NR | XP_001731430.1 | 425265 | g20067 | i0 | 75.4 | 1.5125348189415 | 61 | 14 | 50.1 | 1 | 65 | 244 | 1 | 61 | XP_001731430.1 uncharacterized protein MGL_1613 [Malassezia globosa CBS 7966] | diamond | 543 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 29459570 | 29459570 | PRJNA1226487_P_NODE_25470_length_334_cov_25.498084_g25368_i0 | PRJNA1226487 | 25470 | 334 | 25.498084 | 85.16360056 | Malassezia | 55193 | Fungi | Fungi | 71.2 | 8.15e-12 | NR | XP_027485970.1 | 76775 | g25368 | i0 | 87.2 | 0.70059880239521 | 39 | 5 | 35 | 0 | 56 | 172 | 316 | 354 | XP_027485970.1 tRNA-dihydrouridine synthase 4 [Malassezia restricta] | diamond | 234 | 71.6 | 0.994413407821229 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29756745 | 29756745 | PRJNA1226487_P_NODE_79191_length_240_cov_3.197605_g79089_i0 | PRJNA1226487 | 79191 | 240 | 3.197605 | 7.674252 | Malassezia restricta | 76775 | Fungi | Fungi | 45.4 | 0.00352 | NR | XP_027484041.1 | 76775 | g79089 | i0 | 89.3 | 0.35 | 28 | 3 | 35 | 0 | 42 | 125 | 233 | 260 | XP_027484041.1 cysteine-rich secretory protein [Malassezia restricta] | diamond | 84 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30894389 | 30894389 | PRJNA1226487_P_NODE_63854_length_251_cov_2.061798_g63752_i0 | PRJNA1226487 | 63854 | 251 | 2.061798 | 5.17511298 | Malassezia caprae | 1381934 | Fungi | Fungi | 68.6 | 1.96e-11 | NR | WFD18662.1 | 1381934 | g63752 | i0 | 76.1 | 0.549800796812749 | 46 | 11 | 55 | 0 | 7 | 144 | 228 | 273 | WFD18662.1 structural constituent of ribosome [Malassezia caprae] | diamond | 138 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia caprae | |
| 31463417 | 31463417 | PRJNA1226487_P_NODE_36716_length_296_cov_5.533632_g36614_i0 | PRJNA1226487 | 36716 | 296 | 5.533632 | 16.37955072 | Auricularia subglabra TFB-1 | 1331295 | Fungi | Fungi | 55.8 | 1.77e-6 | NR | EJD42846.1 | 717982 | g36614 | i0 | 48.4 | 0.648648648648649 | 64 | 27 | 64.9 | 2 | 14 | 205 | 149 | 206 | EJD42846.1 hypothetical protein AURDEDRAFT_67176, partial [Auricularia subglabra TFB-10046 SS5] | diamond | 192 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia subglabra | |
| 31558336 | 31558336 | PRJNA1226487_P_NODE_6136_length_521_cov_11.895089_g6041_i0 | PRJNA1226487 | 6136 | 521 | 11.895089 | 61.97341369 | Malassezia vespertilionis | 2020962 | Fungi | Fungi | 95.9 | 2.11e-19 | NR | XP_056061303.1 | 2020962 | g6041 | i0 | 47.7 | 1.76199616122841 | 153 | 63 | 88.1 | 4 | 7 | 465 | 546 | 681 | XP_056061303.1 uncharacterized protein MVES1_000468 [Malassezia vespertilionis] | diamond | 918 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia vespertilionis | |
| 31652807 | 31652807 | PRJNA1226487_P_NODE_53617_length_267_cov_1.587629_g53515_i0 | PRJNA1226487 | 53617 | 267 | 1.587629 | 4.23896943 | Melampsora americana | 2182807 | Fungi | Fungi | 81.3 | 1.39e-15 | NR | KAH9820157.1 | 2182807 | g53515 | i0 | 78.9 | 0.640449438202247 | 57 | 11 | 62.9 | 1 | 226 | 59 | 204 | 260 | KAH9820157.1 hypothetical protein DFH28DRAFT_1093440 [Melampsora americana] | diamond | 171 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora americana | |
| 32475779 | 32475779 | PRJNA1226487_P_NODE_54479_length_265_cov_3.875000_g54377_i0 | PRJNA1226487 | 54479 | 265 | 3.875 | 10.26875 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 137 | 5.85e-40 | NR | SHO75991.1 | 1230383 | g54377 | i0 | 77.4 | 0.950943396226415 | 84 | 19 | 95.1 | 0 | 14 | 265 | 4 | 87 | SHO75991.1 Uncharacterized protein MSYG_0325 [Malassezia sympodialis ATCC 42132] | diamond | 252 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis |
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);;