contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA703759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24910507 | 24910507 | PRJNA703759_P_NODE_21960_length_298_cov_2.382222_g21484_i0 | PRJNA703759 | 21960 | 298 | 2.382222 | 7.09902156 | Serendipita | 358905 | Fungi | Fungi | 72.4 | 2.62e-12 | NR | KAG8835368.1 | 2600213 | g21484 | i0 | 37.9 | 3.84563758389262 | 95 | 57 | 93.6 | 1 | 296 | 18 | 588 | 682 | KAG8835368.1 hypothetical protein FRC18_000623 [Serendipita sp. 400] | diamond | 1146 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita sp. 400 | |
| 26734234 | 26734234 | PRJNA703759_P_NODE_44641_length_246_cov_0.901734_g44165_i0 | PRJNA703759 | 44641 | 246 | 0.901734 | 2.21826564 | Malassezia brasiliensis | 1821822 | Fungi | Fungi | 141 | 5.61e-40 | NR | WFC93383.1 | 1821822 | g44165 | i0 | 94.2 | 0.841463414634146 | 69 | 4 | 84.1 | 0 | 2 | 208 | 160 | 228 | WFC93383.1 hypothetical protein MBRA1_000003 [Malassezia brasiliensis] | diamond | 207 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia brasiliensis | |
| 27399004 | 27399004 | PRJNA703759_P_NODE_40223_length_249_cov_0.886364_g39747_i0 | PRJNA703759 | 40223 | 249 | 0.886364 | 2.20704636 | Malassezia restricta | 76775 | Fungi | Fungi | 48.9 | 3.4e-5 | NR | XP_027482781.1 | 76775 | g39747 | i0 | 57.9 | 0.457831325301205 | 38 | 16 | 45.8 | 0 | 249 | 136 | 54 | 91 | XP_027482781.1 uncharacterized protein MRET_0101 [Malassezia restricta] | diamond | 114 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27504947 | 27504947 | PRJNA703759_P_NODE_40083_length_249_cov_0.886364_g39607_i0 | PRJNA703759 | 40083 | 249 | 0.886364 | 2.20704636 | Tremellomycetes | 155616 | Fungi | Fungi | 100 | 1.9300000000000001e-22 | NR | XP_052947494.1 | 4972 | g39607 | i0 | 82.7 | 7.43373493975904 | 52 | 9 | 62.7 | 0 | 77 | 232 | 442 | 493 | XP_052947494.1 transaminase [Dioszegia hungarica] | diamond | 1851 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 27620006 | 27620006 | PRJNA703759_P_NODE_44824_length_246_cov_0.901734_g44348_i0 | PRJNA703759 | 44824 | 246 | 0.901734 | 2.21826564 | Malassezia restricta | 76775 | Fungi | Fungi | 103 | 1.5799999999999998e-23 | NR | XP_027482508.1 | 76775 | g44348 | i0 | 70.4 | 1.97560975609756 | 81 | 20 | 98.8 | 2 | 1 | 243 | 757 | 833 | XP_027482508.1 DNA repair protein RAD5 [Malassezia restricta] | diamond | 486 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27715029 | 27715029 | PRJNA703759_P_NODE_26004_length_281_cov_1.240385_g25528_i0 | PRJNA703759 | 26004 | 281 | 1.240385 | 3.48548185 | Malassezia nana | 180528 | Fungi | Fungi | 73.9 | 6.17e-13 | NR | WFD26943.1 | 180528 | g25528 | i0 | 53.3 | 1.9644128113879 | 92 | 43 | 98.2 | 0 | 277 | 2 | 24 | 115 | WFD26943.1 Vacuolar protein sorting-associated protein 52 [Malassezia nana] | diamond | 552 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 27789001 | 27789001 | PRJNA703759_P_NODE_34944_length_253_cov_0.866667_g34468_i0 | PRJNA703759 | 34944 | 253 | 0.866667 | 2.19266751 | root | 1 | Root_unresolved | Root_unresolved | 58.9 | 8.55e-8 | NR | KZV95073.1 | 1314781 | g34468 | i0 | 52.3 | 1.94466403162055 | 44 | 21 | 52.2 | 0 | 249 | 118 | 708 | 751 | KZV95073.1 WD40 repeat-like protein [Exidia glandulosa HHB12029] | diamond | 492 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Exidiaceae | Exidia | Exidia glandulosa | |
| 27967148 | 27967148 | PRJNA703759_P_NODE_36665_length_252_cov_0.871508_g36189_i0 | PRJNA703759 | 36665 | 252 | 0.871508 | 2.19620016 | Malassezia restricta | 76775 | Fungi | Fungi | 62.8 | 3.39e-9 | NR | XP_027484125.1 | 76775 | g36189 | i0 | 64.4 | 0.535714285714286 | 45 | 16 | 53.6 | 0 | 247 | 113 | 346 | 390 | XP_027484125.1 mitochondrial fission process protein 1 [Malassezia restricta] | diamond | 135 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 28262325 | 28262325 | PRJNA703759_P_NODE_37266_length_251_cov_0.876404_g36790_i0 | PRJNA703759 | 37266 | 251 | 0.876404 | 2.19977404 | Malassezia | 55193 | Fungi | Fungi | 60.8 | 1.73e-8 | NR | WFD25845.1 | 180528 | g36790 | i0 | 44.4 | 2.21115537848606 | 90 | 42 | 99.2 | 3 | 2 | 250 | 708 | 796 | WFD25845.1 hypothetical protein MNAN1_000812 [Malassezia nana] | diamond | 555 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 28346073 | 28346073 | PRJNA703759_P_NODE_48826_length_243_cov_0.917647_g48350_i0 | PRJNA703759 | 48826 | 243 | 0.917647 | 2.22988221 | Malassezia nana | 180528 | Fungi | Fungi | 50.8 | 4.91e-5 | NR | WFD26907.1 | 180528 | g48350 | i0 | 54.7 | 1.30864197530864 | 53 | 22 | 63 | 1 | 20 | 172 | 6 | 58 | WFD26907.1 hypothetical protein MNAN1_001896 [Malassezia nana] | diamond | 318 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 28503988 | 28503988 | PRJNA703759_P_NODE_45687_length_245_cov_1.360465_g45211_i0 | PRJNA703759 | 45687 | 245 | 1.360465 | 3.33313925 | Testicularia cyperi | 1882483 | Fungi | Fungi | 76.6 | 4.38e-14 | NR | PWZ01475.1 | 1882483 | g45211 | i0 | 55.6 | 1.98367346938776 | 81 | 30 | 99.2 | 2 | 1 | 243 | 11 | 85 | PWZ01475.1 kinase-like protein [Testicularia cyperi] | diamond | 486 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Anthracoideaceae | Testicularia | Testicularia cyperi | |
| 29040972 | 29040972 | PRJNA703759_P_NODE_38608_length_250_cov_0.881356_g38132_i0 | PRJNA703759 | 38608 | 250 | 0.881356 | 2.20339 | Malassezia globosa CBS 7966 | 425265 | Fungi | Fungi | 62 | 6.07e-9 | NR | XP_001731638.1 | 425265 | g38132 | i0 | 50.6 | 0.924 | 77 | 31 | 88.8 | 2 | 15 | 236 | 300 | 372 | XP_001731638.1 uncharacterized protein MGL_0906 [Malassezia globosa CBS 7966] | diamond | 231 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 29198743 | 29198743 | PRJNA703759_P_NODE_27989_length_274_cov_0.990050_g27513_i0 | PRJNA703759 | 27989 | 274 | 0.99005 | 2.712737 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 80.5 | 2.77e-15 | NR | WFD16196.1 | 1514897 | g27513 | i0 | 75 | 0.613138686131387 | 56 | 14 | 61.3 | 0 | 170 | 3 | 567 | 622 | WFD16196.1 tRNA-dihydrouridine(16/17) synthase [NAD(P)(+)] [Malassezia arunalokei] | diamond | 168 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 29209829 | 29209829 | PRJNA703759_P_NODE_26709_length_278_cov_1.521951_g26233_i0 | PRJNA703759 | 26709 | 278 | 1.521951 | 4.23102378 | Malassezia | 55193 | Fungi | Fungi | 70.9 | 1.09e-12 | NR | XP_027482642.1 | 76775 | g26233 | i0 | 70.7 | 0.884892086330935 | 41 | 12 | 44.2 | 0 | 154 | 276 | 16 | 56 | XP_027482642.1 membrane-associated progesterone receptor component [Malassezia restricta] | diamond | 246 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29324811 | 29324811 | PRJNA703759_P_NODE_36209_length_252_cov_0.871508_g35733_i0 | PRJNA703759 | 36209 | 252 | 0.871508 | 2.19620016 | Cryptococcus depauperatus | 5208 | Fungi | Fungi | 92.4 | 1.38e-19 | NR | ACZ80693.1 | 5208 | g35733 | i0 | 50.7 | 2.64285714285714 | 73 | 36 | 86.9 | 0 | 3 | 221 | 328 | 400 | ACZ80693.1 putative retrotransposon nucleocapsid protein [Cryptococcus depauperatus] | diamond | 666 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus depauperatus | |
| 29766791 | 29766791 | PRJNA703759_P_NODE_43491_length_247_cov_0.896552_g43015_i0 | PRJNA703759 | 43491 | 247 | 0.896552 | 2.21448344 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 77.8 | 1.41e-14 | NR | WFD17718.1 | 1514897 | g43015 | i0 | 45 | 0.97165991902834 | 80 | 42 | 97.2 | 1 | 243 | 4 | 149 | 226 | WFD17718.1 hypothetical protein MARU1_003781 [Malassezia arunalokei] | diamond | 240 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 29924968 | 29924968 | PRJNA703759_P_NODE_34411_length_253_cov_0.866667_g33935_i0 | PRJNA703759 | 34411 | 253 | 0.866667 | 2.19266751 | Malassezia restricta | 76775 | Fungi | Fungi | 43.5 | 0.0209 | NR | XP_027482690.1 | 76775 | g33935 | i0 | 60 | 0.474308300395257 | 40 | 15 | 46.2 | 1 | 131 | 247 | 6 | 45 | XP_027482690.1 coiled-coil domain protein 130 [Malassezia restricta] | diamond | 120 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29956418 | 29956418 | PRJNA703759_P_NODE_34891_length_253_cov_0.866667_g34415_i0 | PRJNA703759 | 34891 | 253 | 0.866667 | 2.19266751 | Malassezia furfur | 55194 | Fungi | Fungi | 173 | 4.5699999999999996e-48 | NR | KAI3629190.1 | 55194 | g34415 | i0 | 98.8 | 1.96837944664032 | 83 | 1 | 98.4 | 0 | 251 | 3 | 276 | 358 | KAI3629190.1 hypothetical protein CBS9595_000262 [Malassezia furfur] | diamond | 498 | 173 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 30493634 | 30493634 | PRJNA703759_P_NODE_35053_length_253_cov_0.866667_g34577_i0 | PRJNA703759 | 35053 | 253 | 0.866667 | 2.19266751 | Rhodotorula taiwanensis | 741276 | Fungi | Fungi | 44.7 | 0.00909 | NR | POY71282.1 | 741276 | g34577 | i0 | 51.6 | 1.10276679841897 | 31 | 15 | 36.8 | 0 | 146 | 238 | 489 | 519 | POY71282.1 hypothetical protein BMF94_5594 [Rhodotorula taiwanensis] | diamond | 279 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula taiwanensis | |
| 30556541 | 30556541 | PRJNA703759_P_NODE_37233_length_251_cov_0.876404_g36757_i0 | PRJNA703759 | 37233 | 251 | 0.876404 | 2.19977404 | Malassezia restricta | 76775 | Fungi | Fungi | 131 | 5.28e-34 | NR | XP_027486031.1 | 76775 | g36757 | i0 | 89.4 | 1.57768924302789 | 66 | 7 | 78.9 | 0 | 199 | 2 | 1 | 66 | XP_027486031.1 uncharacterized protein MRET_3453 [Malassezia restricta] | diamond | 396 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30872673 | 30872673 | PRJNA703759_P_NODE_46374_length_245_cov_0.906977_g45898_i0 | PRJNA703759 | 46374 | 245 | 0.906977 | 2.22209365 | Mycena sanguinolenta | 230812 | Fungi | Fungi | 97.8 | 1.36e-21 | NR | KAF7348227.1 | 230812 | g45898 | i0 | 63.8 | 0.979591836734694 | 80 | 10 | 98 | 1 | 242 | 3 | 70 | 130 | KAF7348227.1 hypothetical protein MSAN_01776300 [Mycena sanguinolenta] | diamond | 240 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena sanguinolenta | |
| 31378525 | 31378525 | PRJNA703759_P_NODE_26196_length_280_cov_1.507246_g25720_i0 | PRJNA703759 | 26196 | 280 | 1.507246 | 4.2202888 | Favolaschia claudopus | 2862362 | Fungi | Fungi | 43.5 | 0.0292 | NR | KAK7046964.1 | 2862362 | g25720 | i0 | 65.2 | 0.246428571428571 | 23 | 8 | 24.6 | 0 | 280 | 212 | 175 | 197 | KAK7046964.1 kinase-like domain-containing protein [Favolaschia claudopus] | diamond | 69 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Favolaschia | Favolaschia claudopus | |
| 31852750 | 31852750 | PRJNA703759_P_NODE_40277_length_249_cov_0.886364_g39801_i0 | PRJNA703759 | 40277 | 249 | 0.886364 | 2.20704636 | Malassezia furfur | 55194 | Fungi | Fungi | 164 | 5.74e-45 | NR | KAI3627167.1 | 55194 | g39801 | i0 | 97.6 | 1 | 83 | 2 | 100 | 0 | 1 | 249 | 435 | 517 | KAI3627167.1 NUP84 [Malassezia furfur] | diamond | 249 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 32212152 | 32212152 | PRJNA703759_P_NODE_45018_length_246_cov_0.901734_g44542_i0 | PRJNA703759 | 45018 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | Fungi | Fungi | 84.3 | 8.69e-17 | NR | TFK49171.1 | 5364 | g44542 | i0 | 43.2 | 18.719512195122 | 81 | 45 | 97.6 | 1 | 245 | 6 | 308 | 388 | TFK49171.1 WD40 repeat-like protein [Heliocybe sulcata] | diamond | 4605 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Heliocybe | Heliocybe sulcata |
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);;