contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJEB83711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26970931 | 26970931 | PRJEB83711_P_NODE_57862_length_253_cov_0.866667_g57596_i0 | PRJEB83711 | 57862 | 253 | 0.866667 | 2.19266751 | Moniliophthora perniciosa FA553 | 554373 | Fungi | Fungi | 115 | 5.679999999999999e-31 | NR | EEB91475.1 | 554373 | g57596 | i0 | 81.8 | 0.782608695652174 | 66 | 12 | 78.3 | 0 | 1 | 198 | 65 | 130 | EEB91475.1 hypothetical protein MPER_10155 [Moniliophthora perniciosa FA553] | diamond | 198 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Moniliophthora | Moniliophthora perniciosa | |
| 27065856 | 27065856 | PRJEB83711_P_NODE_67442_length_248_cov_0.891429_g67176_i0 | PRJEB83711 | 67442 | 248 | 0.891429 | 2.21074392 | Malassezia restricta | 76775 | Fungi | Fungi | 155 | 9.259999999999997e-42 | NR | XP_027483265.1 | 76775 | g67176 | i0 | 96.3 | 0.991935483870968 | 82 | 3 | 99.2 | 0 | 248 | 3 | 411 | 492 | XP_027483265.1 regulator of nonsense transcripts 1 [Malassezia restricta] | diamond | 246 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27445471 | 27445471 | PRJEB83711_P_NODE_73623_length_244_cov_3.730994_g73357_i0 | PRJEB83711 | 73623 | 244 | 3.730994 | 9.10362536 | Suillus variegatus | 48592 | Fungi | Fungi | 43.1 | 0.00398 | NR | KAG1834765.1 | 48592 | g73357 | i0 | 51.3 | 0.479508196721311 | 39 | 19 | 48 | 0 | 150 | 34 | 20 | 58 | KAG1834765.1 hypothetical protein EV424DRAFT_521225 [Suillus variegatus] | diamond | 117 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus variegatus | |
| 27508493 | 27508493 | PRJEB83711_P_NODE_60103_length_252_cov_0.871508_g59837_i0 | PRJEB83711 | 60103 | 252 | 0.871508 | 2.19620016 | Moesziomyces aphidis | 84754 | Fungi | Fungi | 159 | 2.7699999999999996e-47 | NR | ETS63440.1 | 84754 | g59837 | i0 | 97.6 | 0.988095238095238 | 83 | 2 | 98.8 | 0 | 251 | 3 | 95 | 177 | ETS63440.1 hypothetical protein PaG_01723 [Moesziomyces aphidis] | diamond | 249 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces aphidis | |
| 27571461 | 27571461 | PRJEB83711_P_NODE_78124_length_242_cov_1.289941_g77858_i0 | PRJEB83711 | 78124 | 242 | 1.289941 | 3.12165722 | Malassezia cuniculi | 948313 | Fungi | Fungi | 121 | 8.91e-30 | NR | WFD33969.1 | 948313 | g77858 | i0 | 77.5 | 0.991735537190083 | 80 | 17 | 99.2 | 1 | 241 | 2 | 446 | 524 | WFD33969.1 hypothetical protein MCUN1_000797 [Malassezia cuniculi] | diamond | 240 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 27634746 | 27634746 | PRJEB83711_P_NODE_74664_length_244_cov_0.912281_g74398_i0 | PRJEB83711 | 74664 | 244 | 0.912281 | 2.22596564 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 140 | 1.98e-38 | NR | AYO43009.1 | 425264 | g74398 | i0 | 79.7 | 0.971311475409836 | 79 | 16 | 97.1 | 0 | 238 | 2 | 121 | 199 | AYO43009.1 hypothetical protein DNF11_2059 [Malassezia restricta CBS 7877] | diamond | 237 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27824227 | 27824227 | PRJEB83711_P_NODE_74564_length_244_cov_0.912281_g74298_i0 | PRJEB83711 | 74564 | 244 | 0.912281 | 2.22596564 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 136 | 3.36e-35 | NR | AYO44306.1 | 425264 | g74298 | i0 | 86.3 | 0.983606557377049 | 80 | 11 | 98.4 | 0 | 3 | 242 | 442 | 521 | AYO44306.1 AP-3 complex subunit delta-1 [Malassezia restricta CBS 7877] | diamond | 240 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27981981 | 27981981 | PRJEB83711_P_NODE_72605_length_245_cov_0.906977_g72339_i0 | PRJEB83711 | 72605 | 245 | 0.906977 | 2.22209365 | Paramarasmius palmivorus | 297713 | Fungi | Fungi | 157 | 1.6999999999999996e-47 | NR | KAK7043689.1 | 297713 | g72339 | i0 | 100 | 0.979591836734694 | 80 | 0 | 98 | 0 | 241 | 2 | 1 | 80 | KAK7043689.1 Cytochrome b-c1 complex subunit 7, mitochondrial [Paramarasmius palmivorus] | diamond | 240 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Paramarasmius | Paramarasmius palmivorus | |
| 28013704 | 28013704 | PRJEB83711_P_NODE_79285_length_242_cov_0.923077_g79019_i0 | PRJEB83711 | 79285 | 242 | 0.923077 | 2.23384634 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 73.9 | 3.7e-13 | NR | XP_017992883.1 | 77020 | g79019 | i0 | 61.4 | 1.37603305785124 | 57 | 22 | 70.7 | 0 | 185 | 15 | 509 | 565 | XP_017992883.1 serine threonine kinase [Malassezia pachydermatis] | diamond | 333 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 28100720 | 28100720 | PRJEB83711_P_NODE_69705_length_247_cov_0.873563_g69439_i0 | PRJEB83711 | 69705 | 247 | 0.873563 | 2.15770061 | Malassezia | 55193 | Fungi | Fungi | 130 | 2.13e-33 | NR | WFD02799.1 | 76774 | g69439 | i0 | 73.1 | 2.89068825910931 | 78 | 21 | 94.7 | 0 | 246 | 13 | 419 | 496 | WFD02799.1 ceramide glucosyltransferase [Malassezia obtusa] | diamond | 714 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa | |
| 28164086 | 28164086 | PRJEB83711_P_NODE_71605_length_246_cov_0.878613_g71339_i0 | PRJEB83711 | 71605 | 246 | 0.878613 | 2.16138798 | Basidiomycota | 5204 | Fungi | Fungi | 44.3 | 0.0109 | NR | XP_060121950.1 | 223818 | g71339 | i0 | 65.4 | 0.597560975609756 | 26 | 9 | 31.7 | 0 | 242 | 165 | 595 | 620 | XP_060121950.1 uncharacterized protein MJAP1_002023 [Malassezia japonica] | diamond | 147 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 28385007 | 28385007 | PRJEB83711_P_NODE_78986_length_242_cov_0.923077_g78720_i0 | PRJEB83711 | 78986 | 242 | 0.923077 | 2.23384634 | Fomitopsis | 34474 | Fungi | Fungi | 103 | 1.69e-23 | NR | XP_047893682.1 | 139415 | g78720 | i0 | 59.5 | 17.5537190082645 | 79 | 32 | 97.9 | 0 | 4 | 240 | 214 | 292 | XP_047893682.1 uncharacterized protein B0H18DRAFT_1118953 [Fomitopsis serialis] | diamond | 4248 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Fomitopsis | Fomitopsis serialis | |
| 29426771 | 29426771 | PRJEB83711_P_NODE_61469_length_251_cov_0.876404_g61203_i0 | PRJEB83711 | 61469 | 251 | 0.876404 | 2.19977404 | Malassezia | 55193 | Fungi | Fungi | 145 | 1.04e-38 | NR | WFD28975.1 | 180528 | g61203 | i0 | 81.9 | 2.9402390438247 | 83 | 15 | 99.2 | 0 | 249 | 1 | 229 | 311 | WFD28975.1 rRNA-processing protein [Malassezia nana] | diamond | 738 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 30287505 | 30287505 | PRJEB83711_P_NODE_54632_length_258_cov_1.416216_g54366_i0 | PRJEB83711 | 54632 | 258 | 1.416216 | 3.65383728 | Malassezia globosa CBS 7966 | 425265 | Fungi | Fungi | 75.1 | 1.78e-13 | NR | XP_001730868.1 | 425265 | g54366 | i0 | 37.6 | 0.988372093023256 | 85 | 53 | 98.8 | 0 | 257 | 3 | 241 | 325 | XP_001730868.1 uncharacterized protein MGL_1867 [Malassezia globosa CBS 7966] | diamond | 255 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 31298213 | 31298213 | PRJEB83711_P_NODE_40455_length_288_cov_1.172093_g40189_i0 | PRJEB83711 | 40455 | 288 | 1.172093 | 3.37562784 | Austropuccinia psidii | 181123 | Fungi | Fungi | 42 | 0.0357 | NR | MBW0512907.1 | 1389203 | g40189 | i0 | 42.3 | 0.541666666666667 | 52 | 28 | 54.2 | 1 | 94 | 249 | 20 | 69 | MBW0512907.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 156 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 31519826 | 31519826 | PRJEB83711_P_NODE_44236_length_279_cov_1.359223_g43970_i0 | PRJEB83711 | 44236 | 279 | 1.359223 | 3.79223217 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 195 | 2.8300000000000007e-59 | NR | AYO43644.1 | 425264 | g43970 | i0 | 94.6 | 0.989247311827957 | 92 | 5 | 98.9 | 0 | 278 | 3 | 197 | 288 | AYO43644.1 Putative alpha-ketoglutarate-dependent sulfonatedioxygenase [Malassezia restricta CBS 7877] | diamond | 276 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 31860063 | 31860063 | PRJEB83711_P_NODE_40457_length_288_cov_1.162791_g40191_i0 | PRJEB83711 | 40457 | 288 | 1.162791 | 3.34883808 | Malassezia | 55193 | Fungi | Fungi | 140 | 4.799999999999999e-38 | NR | XP_060123885.1 | 223818 | g40191 | i0 | 74.2 | 7.04166666666667 | 97 | 24 | 100 | 1 | 1 | 288 | 228 | 324 | XP_060123885.1 uncharacterized protein MJAP1_003979 [Malassezia japonica] | diamond | 2028 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 31962482 | 31962482 | PRJEB83711_P_NODE_62978_length_250_cov_0.881356_g62712_i0 | PRJEB83711 | 62978 | 250 | 0.881356 | 2.20339 | Malassezia japonica | 223818 | Fungi | Fungi | 98.2 | 9.26e-22 | NR | XP_060121045.1 | 223818 | g62712 | i0 | 57.8 | 0.996 | 83 | 35 | 99.6 | 0 | 1 | 249 | 359 | 441 | XP_060121045.1 uncharacterized protein MJAP1_001096 [Malassezia japonica] | diamond | 249 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 31962492 | 31962492 | PRJEB83711_P_NODE_77238_length_243_cov_0.917647_g76972_i0 | PRJEB83711 | 77238 | 243 | 0.917647 | 2.22988221 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 93.2 | 5.19e-20 | NR | KAL4398733.1 | 77020 | g76972 | i0 | 52.5 | 0.987654320987654 | 80 | 38 | 98.8 | 0 | 241 | 2 | 397 | 476 | KAL4398733.1 transmembrane transporter [Malassezia pachydermatis] | diamond | 240 | 93.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 32279138 | 32279138 | PRJEB83711_P_NODE_47419_length_272_cov_1.562814_g47153_i0 | PRJEB83711 | 47419 | 272 | 1.562814 | 4.25085408 | Malassezia nana | 180528 | Fungi | Fungi | 103 | 2.99e-23 | NR | WFD28724.1 | 180528 | g47153 | i0 | 64.8 | 3.88235294117647 | 88 | 31 | 97.1 | 0 | 8 | 271 | 411 | 498 | WFD28724.1 hypothetical protein MNAN1_003737 [Malassezia nana] | diamond | 1056 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 32303515 | 32303515 | PRJEB83711_P_NODE_49299_length_268_cov_1.758974_g49033_i0 | PRJEB83711 | 49299 | 268 | 1.758974 | 4.71405032 | Malassezia | 55193 | Fungi | Fungi | 79.3 | 2.9e-15 | NR | SHO76393.1 | 1230383 | g49033 | i0 | 80.9 | 1.05223880597015 | 47 | 9 | 52.6 | 0 | 1 | 141 | 260 | 306 | SHO76393.1 Similar to S.cerevisiae protein MIR1 (Mitochondrial phosphate carrier) [Malassezia sympodialis ATCC 42132] | diamond | 282 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 32563960 | 32563960 | PRJEB83711_P_NODE_44139_length_279_cov_1.514563_g43873_i0 | PRJEB83711 | 44139 | 279 | 1.514563 | 4.22563077 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 170 | 1.13e-46 | NR | AYO42502.1 | 425264 | g43873 | i0 | 82.8 | 1 | 93 | 16 | 100 | 0 | 1 | 279 | 404 | 496 | AYO42502.1 hypothetical protein DNF11_1552 [Malassezia restricta CBS 7877] | diamond | 279 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 32783983 | 32783983 | PRJEB83711_P_NODE_69580_length_247_cov_0.896552_g69314_i0 | PRJEB83711 | 69580 | 247 | 0.896552 | 2.21448344 | Malassezia restricta | 76775 | Fungi | Fungi | 97.8 | 1.66e-21 | NR | XP_027485758.1 | 76775 | g69314 | i0 | 69.2 | 0.789473684210526 | 65 | 20 | 78.9 | 0 | 196 | 2 | 88 | 152 | XP_027485758.1 histone-lysine N-methyltransferase SUV420H [Malassezia restricta] | diamond | 195 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 32902585 | 32902585 | PRJEB83711_P_NODE_74780_length_244_cov_0.912281_g74514_i0 | PRJEB83711 | 74780 | 244 | 0.912281 | 2.22596564 | Malassezia | 55193 | Fungi | Fungi | 78.2 | 6.09e-15 | NR | WFD04164.1 | 76774 | g74514 | i0 | 58.2 | 1.30327868852459 | 55 | 23 | 67.6 | 0 | 78 | 242 | 16 | 70 | WFD04164.1 SAGA complex subunit Sgf73 [Malassezia obtusa] | diamond | 318 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa |
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);;