contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1005695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3979856 | 3979856 | PRJNA1005695_P_NODE_20364_length_334_cov_2.590038_g19512_i0 | PRJNA1005695 | 20364 | 334 | 2.590038 | 8.65072692 | Mycena | 41247 | Fungi | Fungi | 117 | 2.2e-31 | NR | KAJ7900010.1 | 230810 | g19512 | i0 | 72.4 | 12.3862275449102 | 76 | 21 | 68.3 | 0 | 321 | 94 | 44 | 119 | KAJ7900010.1 ribosomal protein S27-domain-containing protein [Mycena olivaceomarginata] | diamond | 4137 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena olivaceomarginata | |
| 7806052 | 7806052 | PRJNA1005695_P_NODE_25467_length_297_cov_1.741071_g24615_i0 | PRJNA1005695 | 25467 | 297 | 1.741071 | 5.17098087 | Hericium alpestre | 135208 | Fungi | Fungi | 133 | 2.78e-34 | NR | TFY78561.1 | 135208 | g24615 | i0 | 69.4 | 4.94949494949495 | 98 | 29 | 99 | 1 | 296 | 3 | 240 | 336 | TFY78561.1 hypothetical protein EWM64_g5451, partial [Hericium alpestre] | diamond | 1470 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Hericium | Hericium alpestre | |
| 18005265 | 18005265 | PRJNA1005695_P_NODE_27655_length_284_cov_2.587678_g26803_i0 | PRJNA1005695 | 27655 | 284 | 2.587678 | 7.34900552 | Eukaryota | 2759 | Fungi | Fungi | 81.6 | 1.3e-15 | NR | OCB87046.1 | 108892 | g26803 | i0 | 50.6 | 4.89084507042254 | 77 | 38 | 81.3 | 0 | 269 | 39 | 413 | 489 | OCB87046.1 coatomer protein [Sanghuangporus baumii] | diamond | 1389 | 82.4 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Sanghuangporus | Sanghuangporus baumii | |
| 21830234 | 21830234 | PRJNA1005695_P_NODE_18138_length_355_cov_1.106383_g17286_i0 | PRJNA1005695 | 18138 | 355 | 1.106383 | 3.92765965 | Fungi | 4751 | Fungi | Fungi | 115 | 6.729999999999999e-31 | NR | GAA5879064.1 | 86832 | g17286 | i0 | 73 | 5.56901408450704 | 74 | 20 | 62.5 | 0 | 222 | 1 | 1 | 74 | GAA5879064.1 hypothetical protein JCM3774_005558, partial [Rhodotorula dairenensis] | diamond | 1977 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula dairenensis | |
| 24379405 | 24379405 | PRJNA1005695_P_NODE_10380_length_482_cov_1.819071_g9528_i0 | PRJNA1005695 | 10380 | 482 | 1.819071 | 8.76792222 | Violaceomyces palustris | 1673888 | Fungi | Fungi | 251 | 1.18e-76 | NR | PWN54024.1 | 1673888 | g9528 | i0 | 73 | 1.9792531120332 | 159 | 43 | 99 | 0 | 478 | 2 | 373 | 531 | PWN54024.1 putative branching enzyme [Violaceomyces palustris] | diamond | 954 | 251 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Violaceomycetales | Violaceomycetaceae | Violaceomyces | Violaceomyces palustris | |
| 26900554 | 26900554 | PRJNA1005695_P_NODE_15301_length_389_cov_1.310127_g14449_i0 | PRJNA1005695 | 15301 | 389 | 1.310127 | 5.09639403 | Opisthokonta | 33154 | Fungi | Fungi | 44.3 | 0.0479 | NR | KAL4246282.1 | 137743 | g14449 | i0 | 28.7 | 1.09511568123393 | 101 | 59 | 67.9 | 3 | 389 | 126 | 65 | 165 | KAL4246282.1 Homeobox DNA-binding [Abortiporus biennis] | diamond | 426 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Podoscyphaceae | Abortiporus | Abortiporus biennis | |
| 27634870 | 27634870 | PRJNA1005695_P_NODE_24424_length_304_cov_0.904762_g23572_i0 | PRJNA1005695 | 24424 | 304 | 0.904762 | 2.75047648 | Mycena leptocephala | 230808 | Fungi | Fungi | 48.5 | 6.96e-4 | NR | KAJ7938234.1 | 230808 | g23572 | i0 | 48.6 | 1.81578947368421 | 37 | 19 | 36.5 | 0 | 171 | 281 | 224 | 260 | KAJ7938234.1 DNA cross-link repair protein pso2/snm1 [Mycena leptocephala] | diamond | 552 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena leptocephala | |
| 28550625 | 28550625 | PRJNA1005695_P_NODE_36207_length_250_cov_0.881356_g35355_i0 | PRJNA1005695 | 36207 | 250 | 0.881356 | 2.20339 | Phenoliferia sp. Uapishka_3 | 3038894 | Fungi | Fungi | 50.8 | 5.8e-5 | NR | KAK4700923.1 | 3038894 | g35355 | i0 | 32.5 | 0.96 | 80 | 52 | 93.6 | 1 | 2 | 235 | 637 | 716 | KAK4700923.1 multisite-specific tRNA:(cytosine-C5)-methyltransferase, partial [Phenoliferia sp. Uapishka_3] | diamond | 240 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Kriegeriales | Kriegeriaceae | Phenoliferia | Phenoliferia sp. Uapishka_3 | |
| 29276461 | 29276461 | PRJNA1005695_P_NODE_40289_length_241_cov_2.232143_g39437_i0 | PRJNA1005695 | 40289 | 241 | 2.232143 | 5.37946463 | Rhodotorula graminis WP1 | 578459 | Fungi | Fungi | 60.5 | 1.97e-8 | NR | XP_018269030.1 | 578459 | g39437 | i0 | 45.1 | 1.26970954356846 | 51 | 28 | 63.5 | 0 | 47 | 199 | 23 | 73 | XP_018269030.1 uncharacterized protein RHOBADRAFT_55228 [Rhodotorula graminis WP1] | diamond | 306 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 29932462 | 29932462 | PRJNA1005695_P_NODE_37511_length_247_cov_0.896552_g36659_i0 | PRJNA1005695 | 37511 | 247 | 0.896552 | 2.21448344 | Agaricomycetes | 155619 | Fungi | Fungi | 43.9 | 0.0153 | NR | KAF8523120.1 | 150792 | g36659 | i0 | 34.4 | 3.15789473684211 | 61 | 39 | 74.1 | 1 | 31 | 213 | 215 | 274 | KAF8523120.1 hypothetical protein BU17DRAFT_64018 [Hysterangium stoloniferum] | diamond | 780 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hysterangiales | Hysterangiaceae | Hysterangium | Hysterangium stoloniferum | |
| 30350959 | 30350959 | PRJNA1005695_P_NODE_34572_length_253_cov_1.205556_g33720_i0 | PRJNA1005695 | 34572 | 253 | 1.205556 | 3.05005668 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 157 | 9.56e-47 | NR | XP_017990602.1 | 77020 | g33720 | i0 | 83.3 | 0.99604743083004 | 84 | 14 | 99.6 | 0 | 253 | 2 | 82 | 165 | XP_017990602.1 manganese superoxide dismutase [Malassezia pachydermatis] | diamond | 252 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 30500981 | 30500981 | PRJNA1005695_P_NODE_37673_length_247_cov_0.896552_g36821_i0 | PRJNA1005695 | 37673 | 247 | 0.896552 | 2.21448344 | Rhodotorula | 5533 | Fungi | Fungi | 52 | 2.19e-5 | NR | KAG0659393.1 | 5537 | g36821 | i0 | 38.8 | 3.09716599190283 | 85 | 36 | 96 | 2 | 246 | 10 | 534 | 608 | KAG0659393.1 Mannose-6-phosphate isomerase [Rhodotorula mucilaginosa] | diamond | 765 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 30634636 | 30634636 | PRJNA1005695_P_NODE_38593_length_245_cov_0.906977_g37741_i0 | PRJNA1005695 | 38593 | 245 | 0.906977 | 2.22209365 | Wallemia mellicola CBS 633.66 | 671144 | Fungi | Fungi | 71.2 | 1.3e-12 | NR | XP_006960461.1 | 671144 | g37741 | i0 | 50.6 | 0.942857142857143 | 77 | 33 | 88.2 | 2 | 25 | 240 | 86 | 162 | XP_006960461.1 protein phosphatase 2C [Wallemia mellicola CBS 633.66] | diamond | 231 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia mellicola | |
| 30753755 | 30753755 | PRJNA1005695_P_NODE_39994_length_242_cov_0.923077_g39142_i0 | PRJNA1005695 | 39994 | 242 | 0.923077 | 2.23384634 | Polyporales | 5303 | Fungi | Fungi | 57 | 4.42e-8 | NR | XP_047882067.1 | 378194 | g39142 | i0 | 38.2 | 1.88429752066116 | 76 | 46 | 93 | 1 | 235 | 11 | 51 | 126 | XP_047882067.1 Prefoldin beta-like protein [Epithele typhae] | diamond | 456 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Epitheliaceae | Epithele | Epithele typhae | |
| 30880064 | 30880064 | PRJNA1005695_P_NODE_38474_length_245_cov_0.906977_g37622_i0 | PRJNA1005695 | 38474 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | Fungi | Fungi | 111 | 2.97e-26 | NR | PVF93529.1 | 109899 | g37622 | i0 | 60.5 | 4.95918367346939 | 81 | 30 | 96.7 | 1 | 3 | 239 | 35 | 115 | PVF93529.1 putative SEC23-component of COPII coat of ER-golgi vesicles [Serendipita vermifera] | diamond | 1215 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 31171675 | 31171675 | PRJNA1005695_P_NODE_38175_length_246_cov_0.890173_g37323_i0 | PRJNA1005695 | 38175 | 246 | 0.890173 | 2.18982558 | Malassezia restricta | 76775 | Fungi | Fungi | 79.3 | 7.08e-17 | NR | XP_027482549.1 | 76775 | g37323 | i0 | 91.4 | 0.98780487804878 | 81 | 7 | 98.8 | 0 | 245 | 3 | 13 | 93 | XP_027482549.1 V-type H+-transporting ATPase subunit G [Malassezia restricta] | diamond | 243 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 31456678 | 31456678 | PRJNA1005695_P_NODE_38796_length_244_cov_2.432749_g37944_i0 | PRJNA1005695 | 38796 | 244 | 2.432749 | 5.93590756 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 70.9 | 4.72e-12 | NR | AYO43640.1 | 425264 | g37944 | i0 | 72.2 | 0.663934426229508 | 54 | 11 | 61.5 | 1 | 219 | 70 | 493 | 546 | AYO43640.1 hypothetical protein DNF11_2690 [Malassezia restricta CBS 7877] | diamond | 162 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 31481038 | 31481038 | PRJNA1005695_P_NODE_34816_length_253_cov_0.866667_g33964_i0 | PRJNA1005695 | 34816 | 253 | 0.866667 | 2.19266751 | Naganishia | 1851509 | Fungi | Fungi | 129 | 1.22e-33 | NR | KAI5452207.1 | 100951 | g33964 | i0 | 71.4 | 2.98814229249012 | 84 | 24 | 99.6 | 0 | 1 | 252 | 153 | 236 | KAI5452207.1 hypothetical protein NCC49_001142 [Naganishia albida] | diamond | 756 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 31638732 | 31638732 | PRJNA1005695_P_NODE_14976_length_393_cov_2.768750_g14124_i0 | PRJNA1005695 | 14976 | 393 | 2.76875 | 10.8811875 | Opisthokonta | 33154 | Fungi | Fungi | 164 | 5.35e-44 | NR | KAK2467771.1 | 67723 | g14124 | i0 | 55.4 | 15.6335877862595 | 130 | 55 | 96.9 | 1 | 12 | 392 | 972 | 1101 | KAK2467771.1 hypothetical protein APHAL10511_000066 [Amanita phalloides] | diamond | 6144 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita phalloides | |
| 31994316 | 31994316 | PRJNA1005695_P_NODE_27458_length_285_cov_2.207547_g26606_i0 | PRJNA1005695 | 27458 | 285 | 2.207547 | 6.29150895 | Dichomitus squalens LYAD-421 SS1 | 732165 | Fungi | Fungi | 68.9 | 3.45e-11 | NR | XP_007365708.1 | 732165 | g26606 | i0 | 41.4 | 1.04210526315789 | 99 | 48 | 97.9 | 4 | 283 | 5 | 193 | 287 | XP_007365708.1 glycoside hydrolase [Dichomitus squalens LYAD-421 SS1] | diamond | 297 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Dichomitus | Dichomitus squalens | |
| 32057553 | 32057553 | PRJNA1005695_P_NODE_36198_length_250_cov_0.881356_g35346_i0 | PRJNA1005695 | 36198 | 250 | 0.881356 | 2.20339 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 181 | 8.87e-52 | NR | AYO43635.1 | 425264 | g35346 | i0 | 96.4 | 1.992 | 83 | 3 | 99.6 | 0 | 249 | 1 | 101 | 183 | AYO43635.1 Non-hemolytic phospholipase C [Malassezia restricta CBS 7877] | diamond | 498 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 32839659 | 32839659 | PRJNA1005695_P_NODE_24080_length_306_cov_1.982833_g23228_i0 | PRJNA1005695 | 24080 | 306 | 1.982833 | 6.06746898 | Opisthokonta | 33154 | Fungi | Fungi | 199 | 8.069999999999999e-61 | NR | CEQ41885.1 | 5005 | g23228 | i0 | 92.1 | 213.78431372549 | 101 | 8 | 99 | 0 | 304 | 2 | 112 | 212 | CEQ41885.1 SPOSA6832_03674 [Sporobolomyces salmonicolor] | diamond | 65418 | 201 | 0.990049751243781 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor |
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);;