contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJEB48218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2612554 | 2612554 | PRJEB48218_S_NODE_30103_length_152_cov_2.382114_g29141_i0 | PRJEB48218 | 30103 | 152 | 2.382114 | 3.62081328 | Tremellomycetes | 155616 | Fungi | Fungi | 83.2 | 1.06e-18 | NR | KAK1925120.1 | 5418 | g29141 | i0 | 84 | 3.94736842105263 | 50 | 8 | 98.7 | 0 | 152 | 3 | 26 | 75 | KAK1925120.1 putative structural constituent of ribosome [Papiliotrema laurentii] | diamond | 600 | 83.6 | 0.995215311004785 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii | |
| 14091225 | 14091225 | PRJEB48218_S_NODE_892_length_1531_cov_2459.908123_g653_i0 | PRJEB48218 | 892 | 1531 | 2459.908123 | 37661.19336313 | Kwoniella heveanensis BCC8398 | 1296120 | Fungi | Fungi | 337 | 5.92e-108 | NR | OCF32111.1 | 1296120 | g653 | i0 | 53.8 | 1.29915088177662 | 329 | 134 | 61.1 | 5 | 204 | 1139 | 11 | 338 | OCF32111.1 hypothetical protein I316_06267 [Kwoniella heveanensis BCC8398] | diamond | 1989 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 26906982 | 26906982 | PRJEB48218_S_NODE_27522_length_162_cov_2.225564_g26560_i0 | PRJEB48218 | 27522 | 162 | 2.225564 | 3.60541368 | Filobasidium floriforme | 5210 | Fungi | Fungi | 110 | 1.69e-26 | NR | KAG7575370.1 | 5210 | g26560 | i0 | 98.1 | 0.981481481481482 | 53 | 1 | 98.1 | 0 | 161 | 3 | 876 | 928 | KAG7575370.1 hypothetical protein FFLO_00360 [Filobasidium floriforme] | diamond | 159 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 27570595 | 27570595 | PRJEB48218_S_NODE_26564_length_166_cov_2.583942_g25602_i0 | PRJEB48218 | 26564 | 166 | 2.583942 | 4.28934372 | Thelephora ganbajun | 370292 | Fungi | Fungi | 48.9 | 1.38e-5 | NR | KAF9645455.1 | 370292 | g25602 | i0 | 92 | 0.451807228915663 | 25 | 2 | 45.2 | 0 | 166 | 92 | 75 | 99 | KAF9645455.1 hypothetical protein BDM02DRAFT_3120219 [Thelephora ganbajun] | diamond | 75 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Thelephorales | Thelephoraceae | Thelephora | Thelephora ganbajun | |
| 27602386 | 27602386 | PRJEB48218_S_NODE_30444_length_151_cov_2.008197_g29482_i0 | PRJEB48218 | 30444 | 151 | 2.008197 | 3.03237747 | Thelephora terrestris | 56493 | Fungi | Fungi | 82 | 9.74e-19 | NR | KAF9785062.1 | 56493 | g29482 | i0 | 84.8 | 0.913907284768212 | 46 | 7 | 91.4 | 0 | 3 | 140 | 21 | 66 | KAF9785062.1 hypothetical protein BJ322DRAFT_805389 [Thelephora terrestris] | diamond | 138 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Thelephorales | Thelephoraceae | Thelephora | Thelephora terrestris | |
| 27697299 | 27697299 | PRJEB48218_S_NODE_28804_length_157_cov_1.664062_g27842_i0 | PRJEB48218 | 28804 | 157 | 1.664062 | 2.61257734 | Filobasidium floriforme | 5210 | Fungi | Fungi | 64.3 | 1.99e-10 | NR | XP_046038099.1 | 5210 | g27842 | i0 | 90.6 | 0.611464968152866 | 32 | 3 | 61.1 | 0 | 156 | 61 | 257 | 288 | XP_046038099.1 polynucleotide kinase 3 phosphatase-domain-containing protein [Filobasidium floriforme] | diamond | 96 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 27886318 | 27886318 | PRJEB48218_S_NODE_21445_length_198_cov_2.349112_g20483_i0 | PRJEB48218 | 21445 | 198 | 2.349112 | 4.65124176 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 107 | 4.7199999999999995e-25 | NR | WFD16437.1 | 1514897 | g20483 | i0 | 96.6 | 0.893939393939394 | 59 | 2 | 89.4 | 0 | 20 | 196 | 2647 | 2705 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 177 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 27949570 | 27949570 | PRJEB48218_S_NODE_19105_length_216_cov_3.064171_g18143_i0 | PRJEB48218 | 19105 | 216 | 3.064171 | 6.61860936 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 70.9 | 3.22e-12 | NR | WFD16437.1 | 1514897 | g18143 | i0 | 100 | 0.486111111111111 | 35 | 0 | 48.6 | 0 | 143 | 39 | 2838 | 2872 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 105 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 28391537 | 28391537 | PRJEB48218_S_NODE_12986_length_247_cov_6.394495_g12024_i0 | PRJEB48218 | 12986 | 247 | 6.394495 | 15.79440265 | Malassezia furfur | 55194 | Fungi | Fungi | 43.1 | 0.0271 | NR | WFD45940.1 | 55194 | g12024 | i0 | 43.5 | 1.11740890688259 | 46 | 17 | 44.9 | 1 | 14 | 124 | 173 | 218 | WFD45940.1 ubiquitin-specific protease otu1 [Malassezia furfur] | diamond | 276 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 28391538 | 28391538 | PRJEB48218_S_NODE_21866_length_195_cov_2.524096_g20904_i0 | PRJEB48218 | 21866 | 195 | 2.524096 | 4.9219872 | Crepidotus variabilis | 179855 | Fungi | Fungi | 111 | 4.18e-28 | NR | KAF9526638.1 | 179855 | g20904 | i0 | 90.8 | 1 | 65 | 6 | 100 | 0 | 1 | 195 | 24 | 88 | KAF9526638.1 SWIB/MDM2 domain-containing protein [Crepidotus variabilis] | diamond | 195 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Crepidotaceae | Crepidotus | Crepidotus variabilis | |
| 28637670 | 28637670 | PRJEB48218_S_NODE_11407_length_266_cov_2.202532_g10445_i0 | PRJEB48218 | 11407 | 266 | 2.202532 | 5.85873512 | Trichosporonaceae | 1759442 | Fungi | Fungi | 144 | 1.4699999999999999e-38 | NR | TXT07322.1 | 5417 | g10445 | i0 | 76.1 | 4.96240601503759 | 88 | 21 | 99.2 | 0 | 1 | 264 | 211 | 298 | TXT07322.1 hypothetical protein VHUM_03492 [Vanrija humicola] | diamond | 1320 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija humicola | |
| 29086329 | 29086329 | PRJEB48218_S_NODE_20228_length_207_cov_3.089888_g19266_i0 | PRJEB48218 | 20228 | 207 | 3.089888 | 6.39606816 | Crepidotus variabilis | 179855 | Fungi | Fungi | 62.8 | 1.25e-9 | NR | KAF9526638.1 | 179855 | g19266 | i0 | 100 | 0.420289855072464 | 29 | 0 | 42 | 0 | 3 | 89 | 242 | 270 | KAF9526638.1 SWIB/MDM2 domain-containing protein [Crepidotus variabilis] | diamond | 87 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Crepidotaceae | Crepidotus | Crepidotus variabilis | |
| 29812249 | 29812249 | PRJEB48218_S_NODE_4591_length_534_cov_2.809901_g3661_i0 | PRJEB48218 | 4591 | 534 | 2.809901 | 15.00487134 | Naganishia albida | 100951 | Fungi | Fungi | 140 | 3.95e-39 | NR | KAI5455439.1 | 100951 | g3661 | i0 | 61.7 | 1.37640449438202 | 120 | 29 | 57.9 | 1 | 416 | 108 | 14 | 133 | KAI5455439.1 hypothetical protein NCC49_000249 [Naganishia albida] | diamond | 735 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 30974801 | 30974801 | PRJEB48218_S_NODE_29654_length_154_cov_1.408000_g28692_i0 | PRJEB48218 | 29654 | 154 | 1.408 | 2.16832 | Tremellales | 5234 | Fungi | Fungi | 89.4 | 3.63e-21 | NR | ACR84570.1 | 37769 | g28692 | i0 | 84 | 6.81818181818182 | 50 | 8 | 97.4 | 0 | 3 | 152 | 43 | 92 | ACR84570.1 cytochrome oxidase subunit I, partial [Cryptococcus gattii] | diamond | 1050 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus gattii | |
| 31012931 | 31012931 | PRJEB48218_S_NODE_11395_length_266_cov_3.434599_g10433_i0 | PRJEB48218 | 11395 | 266 | 3.434599 | 9.13603334 | Filobasidium floriforme | 5210 | Fungi | Fungi | 62.8 | 2.82e-9 | NR | XP_046035358.1 | 5210 | g10433 | i0 | 96.9 | 0.360902255639098 | 32 | 1 | 36.1 | 0 | 3 | 98 | 246 | 277 | XP_046035358.1 NUDIX hydrolase domain-like protein [Filobasidium floriforme] | diamond | 96 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 31012939 | 31012939 | PRJEB48218_S_NODE_27815_length_161_cov_1.734848_g26853_i0 | PRJEB48218 | 27815 | 161 | 1.734848 | 2.79310528 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 116 | 1.59e-28 | NR | GHJ89535.1 | 104408 | g26853 | i0 | 100 | 0.987577639751553 | 53 | 0 | 98.8 | 0 | 3 | 161 | 522 | 574 | GHJ89535.1 hypothetical protein NliqN6_5937 [Naganishia liquefaciens] | diamond | 159 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 31076275 | 31076275 | PRJEB48218_S_NODE_17135_length_227_cov_2.964646_g16173_i0 | PRJEB48218 | 17135 | 227 | 2.964646 | 6.72974642 | Filobasidium floriforme | 5210 | Fungi | Fungi | 132 | 3.5e-36 | NR | XP_046035313.1 | 5210 | g16173 | i0 | 82.7 | 0.991189427312775 | 75 | 13 | 99.1 | 0 | 1 | 225 | 76 | 150 | XP_046035313.1 aquaporin-like protein [Filobasidium floriforme] | diamond | 225 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 31107594 | 31107594 | PRJEB48218_S_NODE_9495_length_297_cov_3.063433_g8533_i0 | PRJEB48218 | 9495 | 297 | 3.063433 | 9.09839601 | Filobasidium floriforme | 5210 | Fungi | Fungi | 59.7 | 7.92e-8 | NR | KAG7566975.1 | 5210 | g8533 | i0 | 60 | 0.505050505050505 | 50 | 20 | 50.5 | 0 | 31 | 180 | 104 | 153 | KAG7566975.1 hypothetical protein FFLO_01234 [Filobasidium floriforme] | diamond | 150 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 31360836 | 31360836 | PRJEB48218_S_NODE_26736_length_165_cov_3.294118_g25774_i0 | PRJEB48218 | 26736 | 165 | 3.294118 | 5.4352947 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 59.7 | 1.39e-8 | NR | WFD16437.1 | 1514897 | g25774 | i0 | 63.8 | 1.05454545454545 | 58 | 9 | 83.6 | 1 | 138 | 1 | 932 | 989 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 174 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 31645199 | 31645199 | PRJEB48218_S_NODE_20477_length_205_cov_2.710227_g19515_i0 | PRJEB48218 | 20477 | 205 | 2.710227 | 5.55596535 | Lactarius quietus | 111141 | Fungi | Fungi | 103 | 6.41e-24 | NR | KAF8266336.1 | 111141 | g19515 | i0 | 65.2 | 2.92682926829268 | 66 | 23 | 96.6 | 0 | 201 | 4 | 579 | 644 | KAF8266336.1 hypothetical protein EI94DRAFT_1803184 [Lactarius quietus] | diamond | 600 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactarius | Lactarius quietus | |
| 31961608 | 31961608 | PRJEB48218_S_NODE_3618_length_648_cov_5.368336_g2771_i0 | PRJEB48218 | 3618 | 648 | 5.368336 | 34.78681728 | Filobasidium floriforme | 5210 | Fungi | Fungi | 188 | 7.72e-56 | NR | XP_046035313.1 | 5210 | g2771 | i0 | 79.5 | 0.518518518518518 | 112 | 23 | 51.9 | 0 | 647 | 312 | 156 | 267 | XP_046035313.1 aquaporin-like protein [Filobasidium floriforme] | diamond | 336 | 188 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 32310039 | 32310039 | PRJEB48218_S_NODE_21139_length_200_cov_2.783626_g20177_i0 | PRJEB48218 | 21139 | 200 | 2.783626 | 5.567252 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 109 | 2.24e-29 | NR | SHO75991.1 | 1230383 | g20177 | i0 | 78.1 | 0.96 | 64 | 14 | 96 | 0 | 3 | 194 | 12 | 75 | SHO75991.1 Uncharacterized protein MSYG_0325 [Malassezia sympodialis ATCC 42132] | diamond | 192 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 32499807 | 32499807 | PRJEB48218_S_NODE_25159_length_173_cov_1.902778_g24197_i0 | PRJEB48218 | 25159 | 173 | 1.902778 | 3.29180594 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 107 | 3.32e-25 | NR | GHJ89535.1 | 104408 | g24197 | i0 | 100 | 0.988439306358382 | 57 | 0 | 98.8 | 0 | 171 | 1 | 658 | 714 | GHJ89535.1 hypothetical protein NliqN6_5937 [Naganishia liquefaciens] | diamond | 171 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 32846188 | 32846188 | PRJEB48218_S_NODE_1520_length_1177_cov_18.404181_g653_i1 | PRJEB48218 | 1520 | 1177 | 18.404181 | 216.61721037 | Kwoniella heveanensis BCC8398 | 1296120 | Fungi | Fungi | 249 | 3.02e-75 | NR | OCF32111.1 | 1296120 | g653 | i1 | 53.6 | 1.27442650807137 | 248 | 101 | 59.9 | 4 | 81 | 785 | 92 | 338 | OCF32111.1 hypothetical protein I316_06267 [Kwoniella heveanensis BCC8398] | diamond | 1500 | 249 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis |
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);;