contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJEB56027" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3948694 | 3948694 | PRJEB56027_P_NODE_125964_length_245_cov_0.895349_g123155_i0 | PRJEB56027 | 125964 | 245 | 0.895349 | 2.19360505 | Malassezia furfur | 55194 | Fungi | Fungi | 135 | 5.73e-35 | NR | KAI3620492.1 | 55194 | g123155 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 243 | 1 | 241 | 321 | KAI3620492.1 hypothetical protein CBS9595_002459 [Malassezia furfur] | diamond | 243 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 26773657 | 26773657 | PRJEB56027_P_NODE_112581_length_252_cov_2.173184_g109772_i0 | PRJEB56027 | 112581 | 252 | 2.173184 | 5.47642368 | Polyporales | 5303 | Fungi | Fungi | 137 | 5.41e-36 | NR | GJE89691.1 | 48140 | g109772 | i0 | 78.5 | 7.76190476190476 | 79 | 17 | 94 | 0 | 16 | 252 | 277 | 355 | GJE89691.1 glycosyltransferase family 69 protein [Phanerochaete sordida] | diamond | 1956 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete sordida | |
| 27349906 | 27349906 | PRJEB56027_P_NODE_116863_length_250_cov_0.870056_g114054_i0 | PRJEB56027 | 116863 | 250 | 0.870056 | 2.17514 | Malassezia yamatoensis | 253288 | Fungi | Fungi | 50.1 | 1.03e-4 | NR | WFC98575.1 | 253288 | g114054 | i0 | 84.6 | 0.312 | 26 | 4 | 31.2 | 0 | 166 | 89 | 113 | 138 | WFC98575.1 hypothetical protein MYAM1_001305 [Malassezia yamatoensis] | diamond | 78 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia yamatoensis | |
| 27469366 | 27469366 | PRJEB56027_P_NODE_122003_length_247_cov_0.885057_g119194_i0 | PRJEB56027 | 122003 | 247 | 0.885057 | 2.18609079 | Tremellales | 5234 | Fungi | Fungi | 107 | 4.270000000000001e-27 | NR | OCF40919.1 | 1296119 | g119194 | i0 | 68.3 | 5.00404858299595 | 82 | 20 | 99.6 | 1 | 2 | 247 | 37 | 112 | OCF40919.1 hypothetical protein I317_05278 [Kwoniella heveanensis CBS 569] | diamond | 1236 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 27475975 | 27475975 | PRJEB56027_P_NODE_138083_length_226_cov_2.013072_g135274_i0 | PRJEB56027 | 138083 | 226 | 2.013072 | 4.54954272 | Malassezia furfur | 55194 | Fungi | Fungi | 139 | 3.14e-36 | NR | KAI3620038.1 | 55194 | g135274 | i0 | 100 | 1.9646017699115 | 74 | 0 | 98.2 | 0 | 3 | 224 | 861 | 934 | KAI3620038.1 hypothetical protein CBS9595_002005 [Malassezia furfur] | diamond | 444 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 27760477 | 27760477 | PRJEB56027_P_NODE_128124_length_244_cov_0.871345_g125315_i0 | PRJEB56027 | 128124 | 244 | 0.871345 | 2.1260818 | Lenzites betulinus | 5632 | Fungi | Fungi | 122 | 3.51e-30 | NR | KAH9853484.1 | 5632 | g125315 | i0 | 96.8 | 0.762295081967213 | 62 | 2 | 76.2 | 0 | 242 | 57 | 265 | 326 | KAH9853484.1 hypothetical protein C2E23DRAFT_728496 [Lenzites betulinus] | diamond | 186 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lenzites | Lenzites betulinus | |
| 27791834 | 27791834 | PRJEB56027_P_NODE_97944_length_271_cov_2.171717_g95135_i0 | PRJEB56027 | 97944 | 271 | 2.171717 | 5.88535307 | Stereum hirsutum FP-91666 SS1 | 721885 | Fungi | Fungi | 54.3 | 4.55e-6 | NR | XP_007306172.1 | 721885 | g95135 | i0 | 83.9 | 0.343173431734317 | 31 | 5 | 34.3 | 0 | 94 | 2 | 364 | 394 | XP_007306172.1 uncharacterized protein STEHIDRAFT_158754 [Stereum hirsutum FP-91666 SS1] | diamond | 93 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Stereum | Stereum hirsutum | |
| 27981232 | 27981232 | PRJEB56027_P_NODE_89385_length_283_cov_2.542857_g86576_i0 | PRJEB56027 | 89385 | 283 | 2.542857 | 7.19628531 | Malassezia furfur | 55194 | Fungi | Fungi | 188 | 2.04e-58 | NR | KAI3625773.1 | 55194 | g86576 | i0 | 100 | 1.99293286219081 | 94 | 0 | 99.6 | 0 | 282 | 1 | 17 | 110 | KAI3625773.1 hypothetical protein CBS9595_001134 [Malassezia furfur] | diamond | 564 | 188 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 28139311 | 28139311 | PRJEB56027_P_NODE_108705_length_257_cov_1.673913_g105896_i0 | PRJEB56027 | 108705 | 257 | 1.673913 | 4.30195641 | Malassezia furfur | 55194 | Fungi | Fungi | 167 | 7.15e-46 | NR | KAI3627443.1 | 55194 | g105896 | i0 | 95.3 | 1.98443579766537 | 85 | 4 | 99.2 | 0 | 256 | 2 | 843 | 927 | KAI3627443.1 hypothetical protein CBS14141_001444 [Malassezia furfur] | diamond | 510 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 28201985 | 28201985 | PRJEB56027_P_NODE_130346_length_242_cov_1.822485_g127537_i0 | PRJEB56027 | 130346 | 242 | 1.822485 | 4.4104137 | Malassezia yamatoensis | 253288 | Fungi | Fungi | 86.7 | 1.3e-17 | NR | WFC99804.1 | 253288 | g127537 | i0 | 100 | 0.570247933884298 | 46 | 0 | 57 | 0 | 139 | 2 | 1189 | 1234 | WFC99804.1 hypothetical protein MYAM1_002549 [Malassezia yamatoensis] | diamond | 138 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia yamatoensis | |
| 28391638 | 28391638 | PRJEB56027_P_NODE_131566_length_242_cov_0.911243_g128757_i0 | PRJEB56027 | 131566 | 242 | 0.911243 | 2.20520806 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 44.3 | 0.0107 | NR | XP_066820102.1 | 1397322 | g128757 | i0 | 95.7 | 0.285123966942149 | 23 | 1 | 28.5 | 0 | 1 | 69 | 28 | 50 | XP_066820102.1 TBC-domain-containing protein [Cystobasidium minutum MCA 4210] | diamond | 69 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 28391639 | 28391639 | PRJEB56027_P_NODE_132166_length_241_cov_1.833333_g129357_i0 | PRJEB56027 | 132166 | 241 | 1.833333 | 4.41833253 | Malassezia furfur | 55194 | Fungi | Fungi | 179 | 2.42e-51 | NR | KAI3617799.1 | 55194 | g129357 | i0 | 100 | 0.983402489626556 | 79 | 0 | 98.3 | 0 | 3 | 239 | 26 | 104 | KAI3617799.1 hypothetical protein CBS9595_003708 [Malassezia furfur] | diamond | 237 | 179 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 28763703 | 28763703 | PRJEB56027_P_NODE_88927_length_284_cov_1.459716_g86118_i0 | PRJEB56027 | 88927 | 284 | 1.459716 | 4.14559344 | Agaricaceae | 5339 | Fungi | Fungi | 115 | 1.24e-27 | NR | KAJ3560382.1 | 56174 | g86118 | i0 | 70.2 | 1.98591549295775 | 94 | 8 | 99.3 | 3 | 283 | 2 | 32 | 105 | KAJ3560382.1 hypothetical protein NP233_g10876 [Leucocoprinus birnbaumii] | diamond | 564 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Leucocoprinus | Leucocoprinus birnbaumii | |
| 28801875 | 28801875 | PRJEB56027_P_NODE_137188_length_228_cov_3.554839_g134379_i0 | PRJEB56027 | 137188 | 228 | 3.554839 | 8.10503292 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 54.7 | 1.93e-6 | NR | KWU47291.1 | 1305733 | g134379 | i0 | 91.9 | 0.486842105263158 | 37 | 2 | 47.4 | 1 | 108 | 1 | 1 | 37 | KWU47291.1 glycoside hydrolase [Rhodotorula sp. JG-1b] | diamond | 111 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 29212749 | 29212749 | PRJEB56027_P_NODE_137829_length_226_cov_2.803922_g135020_i0 | PRJEB56027 | 137829 | 226 | 2.803922 | 6.33686372 | Trametopsis cervina | 1111950 | Fungi | Fungi | 90.9 | 2e-20 | NR | KAI0344700.1 | 1111950 | g135020 | i0 | 85.7 | 0.743362831858407 | 56 | 7 | 74.3 | 1 | 225 | 58 | 4 | 58 | KAI0344700.1 hypothetical protein BDW22DRAFT_1354839 [Trametopsis cervina] | diamond | 168 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Trametopsis | Trametopsis cervina | |
| 30406338 | 30406338 | PRJEB56027_P_NODE_76693_length_310_cov_2.261603_g73884_i0 | PRJEB56027 | 76693 | 310 | 2.261603 | 7.0109693 | Agaricomycetes | 155619 | Fungi | Fungi | 63.5 | 2.86e-9 | NR | GJE84347.1 | 48140 | g73884 | i0 | 51 | 3.25161290322581 | 49 | 24 | 47.4 | 0 | 164 | 310 | 46 | 94 | GJE84347.1 C2H2-type zinc finger protein [Phanerochaete sordida] | diamond | 1008 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete sordida | |
| 30476045 | 30476045 | PRJEB56027_P_NODE_107913_length_258_cov_1.664865_g105104_i0 | PRJEB56027 | 107913 | 258 | 1.664865 | 4.2953517 | Malassezia yamatoensis | 253288 | Fungi | Fungi | 169 | 9.869999999999998e-47 | NR | WFC99515.1 | 253288 | g105104 | i0 | 100 | 0.988372093023256 | 85 | 0 | 98.8 | 0 | 3 | 257 | 402 | 486 | WFC99515.1 hypothetical protein MYAM1_002260 [Malassezia yamatoensis] | diamond | 255 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia yamatoensis | |
| 30855020 | 30855020 | PRJEB56027_P_NODE_119874_length_248_cov_0.880000_g117065_i0 | PRJEB56027 | 119874 | 248 | 0.88 | 2.1824 | Malassezia brasiliensis | 1821822 | Fungi | Fungi | 158 | 1.0599999999999999e-42 | NR | WFC94915.1 | 1821822 | g117065 | i0 | 98.8 | 0.991935483870968 | 82 | 1 | 99.2 | 0 | 1 | 246 | 887 | 968 | WFC94915.1 hypothetical protein MBRA1_001553 [Malassezia brasiliensis] | diamond | 246 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia brasiliensis | |
| 31360914 | 31360914 | PRJEB56027_P_NODE_98956_length_270_cov_1.507614_g96147_i0 | PRJEB56027 | 98956 | 270 | 1.507614 | 4.0705578 | Malassezia equina | 1381935 | Fungi | Fungi | 58.9 | 9.97e-8 | NR | WFD21625.1 | 1381935 | g96147 | i0 | 70.2 | 1.06666666666667 | 47 | 13 | 52.2 | 1 | 149 | 9 | 1 | 46 | WFD21625.1 RNA polymerase-associated protein rtf1 [Malassezia equina] | diamond | 288 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia equina | |
| 31392578 | 31392578 | PRJEB56027_P_NODE_137336_length_228_cov_2.458065_g134527_i0 | PRJEB56027 | 137336 | 228 | 2.458065 | 5.6043882 | Malassezia furfur | 55194 | Fungi | Fungi | 148 | 2.59e-39 | NR | KAI3627451.1 | 55194 | g134527 | i0 | 98.7 | 1.97368421052632 | 75 | 1 | 98.7 | 0 | 227 | 3 | 966 | 1040 | KAI3627451.1 hypothetical protein CBS14141_001452 [Malassezia furfur] | diamond | 450 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 32563196 | 32563196 | PRJEB56027_P_NODE_128479_length_243_cov_1.811765_g125670_i0 | PRJEB56027 | 128479 | 243 | 1.811765 | 4.40258895 | Malassezia furfur | 55194 | Fungi | Fungi | 160 | 3.52e-44 | NR | KAI3620261.1 | 55194 | g125670 | i0 | 100 | 0.950617283950617 | 77 | 0 | 95.1 | 0 | 12 | 242 | 92 | 168 | KAI3620261.1 hypothetical protein CBS9595_002228 [Malassezia furfur] | diamond | 231 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 32625805 | 32625805 | PRJEB56027_P_NODE_88280_length_285_cov_1.452830_g85471_i0 | PRJEB56027 | 88280 | 285 | 1.45283 | 4.1405655 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 145 | 6.89e-38 | NR | XP_025378437.1 | 215250 | g85471 | i0 | 73.4 | 0.989473684210526 | 94 | 25 | 98.9 | 0 | 2 | 283 | 97 | 190 | XP_025378437.1 hypothetical protein FA10DRAFT_299868 [Acaromyces ingoldii] | diamond | 282 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii |
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);;