contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1001940" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24373992 | 24373992 | PRJNA1001940_S_NODE_77060_length_248_cov_1.170732_g76006_i0 | PRJNA1001940 | 77060 | 248 | 1.170732 | 2.90341536 | Meira miltonrushii | 1280837 | Fungi | Fungi | 151 | 1.28e-42 | NR | XP_025355721.1 | 1280837 | g76006 | i0 | 86.6 | 1.98387096774194 | 82 | 11 | 99.2 | 0 | 1 | 246 | 270 | 351 | XP_025355721.1 putative FBA1-fructose-bisphosphate aldolase [Meira miltonrushii] | diamond | 492 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 26781317 | 26781317 | PRJNA1001940_S_NODE_21201_length_428_cov_4.571429_g20160_i0 | PRJNA1001940 | 21201 | 428 | 4.571429 | 19.56571612 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 52.8 | 7.91e-5 | NR | AYO42617.1 | 425264 | g20160 | i0 | 83.9 | 0.217289719626168 | 31 | 5 | 21.7 | 0 | 111 | 203 | 456 | 486 | AYO42617.1 Chitin deacetylase [Malassezia restricta CBS 7877] | diamond | 93 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 26939288 | 26939288 | PRJNA1001940_S_NODE_98902_length_218_cov_1.645714_g97848_i0 | PRJNA1001940 | 98902 | 218 | 1.645714 | 3.58765652 | Jaminaea rosea | 1569628 | Fungi | Fungi | 132 | 1.89e-36 | NR | XP_025363139.1 | 1569628 | g97848 | i0 | 91.7 | 0.990825688073395 | 72 | 6 | 99.1 | 0 | 218 | 3 | 146 | 217 | XP_025363139.1 NADP-dependent mannitol dehydrogenase [Jaminaea rosea] | diamond | 216 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Jaminaea | Jaminaea rosea | ||
| 27255566 | 27255566 | PRJNA1001940_S_NODE_48583_length_309_cov_3.007519_g47529_i0 | PRJNA1001940 | 48583 | 309 | 3.007519 | 9.29323371 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 49.3 | 1.66e-5 | NR | XP_025379985.1 | 215250 | g47529 | i0 | 70.2 | 0.456310679611651 | 47 | 13 | 44.7 | 1 | 60 | 197 | 1 | 47 | XP_025379985.1 hypothetical protein FA10DRAFT_282470 [Acaromyces ingoldii] | diamond | 141 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 27508528 | 27508528 | PRJNA1001940_S_NODE_95863_length_221_cov_5.882022_g94809_i0 | PRJNA1001940 | 95863 | 221 | 5.882022 | 12.99926862 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 79.7 | 1.92e-15 | NR | AYO41343.1 | 425264 | g94809 | i0 | 71.2 | 0.895927601809955 | 66 | 19 | 89.6 | 0 | 3 | 200 | 311 | 376 | AYO41343.1 Reduced viability upon starvation protein 167 [Malassezia restricta CBS 7877] | diamond | 198 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27540029 | 27540029 | PRJNA1001940_S_NODE_73564_length_253_cov_4.800000_g72510_i0 | PRJNA1001940 | 73564 | 253 | 4.8 | 12.144 | Vanrija albida | 181172 | Fungi | Fungi | 73.6 | 1.49e-13 | NR | XP_069205251.1 | 181172 | g72510 | i0 | 69.6 | 1.09090909090909 | 46 | 14 | 54.5 | 0 | 252 | 115 | 191 | 236 | XP_069205251.1 uncharacterized protein Q8F55_008934 [Vanrija albida] | diamond | 276 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija albida | |
| 27659043 | 27659043 | PRJNA1001940_S_NODE_148204_length_178_cov_3.555556_g147150_i0 | PRJNA1001940 | 148204 | 178 | 3.555556 | 6.32888968 | Malassezia | 55193 | Fungi | Fungi | 88.2 | 1.46e-18 | NR | XP_027483070.1 | 76775 | g147150 | i0 | 89.8 | 1.65168539325843 | 49 | 5 | 82.6 | 0 | 3 | 149 | 615 | 663 | XP_027483070.1 SCY1-like protein 2 [Malassezia restricta] | diamond | 294 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27722421 | 27722421 | PRJNA1001940_S_NODE_74784_length_251_cov_3.687500_g73730_i0 | PRJNA1001940 | 74784 | 251 | 3.6875 | 9.255625 | Mycena | 41247 | Fungi | Fungi | 80.1 | 4.69e-16 | NR | KAF8139195.1 | 1314675 | g73730 | i0 | 51.9 | 4.80478087649402 | 81 | 35 | 92 | 2 | 251 | 21 | 157 | 237 | KAF8139195.1 hypothetical protein K438DRAFT_1880426 [Mycena galopus ATCC 62051] | diamond | 1206 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galopus | |
| 27792660 | 27792660 | PRJNA1001940_S_NODE_35404_length_354_cov_6.581994_g34350_i0 | PRJNA1001940 | 35404 | 354 | 6.581994 | 23.30025876 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 79 | 2.04e-14 | NR | WFD17055.1 | 1514897 | g34350 | i0 | 82.1 | 0.991525423728814 | 117 | 21 | 99.2 | 0 | 352 | 2 | 247 | 363 | WFD17055.1 hypothetical protein MARU1_003102 [Malassezia arunalokei] | diamond | 351 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 27918748 | 27918748 | PRJNA1001940_S_NODE_36485_length_350_cov_2.889251_g35431_i0 | PRJNA1001940 | 36485 | 350 | 2.889251 | 10.1123785 | Meira miltonrushii | 1280837 | Fungi | Fungi | 208 | 6.470000000000001e-65 | NR | XP_025354955.1 | 1280837 | g35431 | i0 | 86.1 | 0.985714285714286 | 115 | 16 | 98.6 | 0 | 345 | 1 | 183 | 297 | XP_025354955.1 NAD(P)-binding protein [Meira miltonrushii] | diamond | 345 | 208 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 28487241 | 28487241 | PRJNA1001940_S_NODE_215027_length_150_cov_1.345794_g213973_i0 | PRJNA1001940 | 215027 | 150 | 1.345794 | 2.018691 | Crucibulum laeve | 68775 | Fungi | Fungi | 41.6 | 0.0173 | NR | TFK31555.1 | 68775 | g213973 | i0 | 37.2 | 0.86 | 43 | 25 | 82 | 1 | 5 | 127 | 101 | 143 | TFK31555.1 hypothetical protein BDQ12DRAFT_118509 [Crucibulum laeve] | diamond | 129 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Crucibulum | Crucibulum laeve | |
| 28739761 | 28739761 | PRJNA1001940_S_NODE_106047_length_210_cov_2.934132_g104993_i0 | PRJNA1001940 | 106047 | 210 | 2.934132 | 6.1616772 | Cutaneotrichosporon oleaginosum | 879819 | Fungi | Fungi | 57.4 | 1.01e-7 | NR | CAK9780688.1 | 879819 | g104993 | i0 | 65.2 | 0.985714285714286 | 69 | 15 | 85.7 | 3 | 12 | 191 | 161 | 229 | CAK9780688.1 unnamed protein product [Cutaneotrichosporon oleaginosum] | diamond | 207 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum | |
| 29118889 | 29118889 | PRJNA1001940_S_NODE_25329_length_402_cov_5.392758_g24282_i0 | PRJNA1001940 | 25329 | 402 | 5.392758 | 21.67888716 | Sterigmatomyces sp. | 1972484 | Fungi | Fungi | 68.9 | 6.49e-12 | NR | QNH82609.1 | 1972484 | g24282 | i0 | 60.4 | 1.7910447761194 | 48 | 19 | 35.8 | 0 | 259 | 402 | 23 | 70 | QNH82609.1 NADH dehydrogenase subunit 3 [Sterigmatomyces sp.] | diamond | 720 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricostilbomycetes | Agaricostilbales | Agaricostilbaceae | Sterigmatomyces | Sterigmatomyces sp. | |
| 29654989 | 29654989 | PRJNA1001940_S_NODE_17170_length_460_cov_3.436451_g16139_i0 | PRJNA1001940 | 17170 | 460 | 3.436451 | 15.8076746 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 66.6 | 1.42e-10 | NR | XP_017992297.1 | 77020 | g16139 | i0 | 38.1 | 0.73695652173913 | 113 | 68 | 73 | 2 | 2 | 337 | 40 | 151 | XP_017992297.1 hypothetical protein Malapachy_0644 [Malassezia pachydermatis] | diamond | 339 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 30034491 | 30034491 | PRJNA1001940_S_NODE_142251_length_182_cov_1.410072_g141197_i0 | PRJNA1001940 | 142251 | 182 | 1.410072 | 2.56633104 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 63.5 | 1.53e-10 | NR | XP_025379791.1 | 215250 | g141197 | i0 | 55.1 | 0.807692307692308 | 49 | 21 | 80.8 | 1 | 3 | 149 | 130 | 177 | XP_025379791.1 hypothetical protein FA10DRAFT_293363 [Acaromyces ingoldii] | diamond | 147 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 30343481 | 30343481 | PRJNA1001940_S_NODE_52392_length_299_cov_1.687500_g51338_i0 | PRJNA1001940 | 52392 | 299 | 1.6875 | 5.045625 | Basidiomycota | 5204 | Fungi | Fungi | 50.4 | 1.35e-4 | NR | KLT43349.1 | 879819 | g51338 | i0 | 31 | 1.68561872909699 | 87 | 59 | 86.3 | 1 | 295 | 38 | 322 | 408 | KLT43349.1 intracellular protein transport-related protein [Cutaneotrichosporon oleaginosum] | diamond | 504 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum | |
| 30697789 | 30697789 | PRJNA1001940_S_NODE_123794_length_195_cov_1.539474_g122740_i0 | PRJNA1001940 | 123794 | 195 | 1.539474 | 3.0019743 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 60.1 | 8.62e-10 | NR | AYO44642.1 | 425264 | g122740 | i0 | 100 | 0.430769230769231 | 28 | 0 | 43.1 | 0 | 85 | 2 | 1 | 28 | AYO44642.1 hypothetical protein DNF11_3692 [Malassezia restricta CBS 7877] | diamond | 84 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30729463 | 30729463 | PRJNA1001940_S_NODE_130114_length_190_cov_1.897959_g129060_i0 | PRJNA1001940 | 130114 | 190 | 1.897959 | 3.6061221 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 112 | 4.0400000000000005e-27 | NR | WFD14547.1 | 1514897 | g129060 | i0 | 96.9 | 1.01052631578947 | 64 | 1 | 99.5 | 1 | 189 | 1 | 897 | 960 | WFD14547.1 hypothetical protein MARU1_000553 [Malassezia arunalokei] | diamond | 192 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 31101084 | 31101084 | PRJNA1001940_S_NODE_91815_length_226_cov_3.934426_g90761_i0 | PRJNA1001940 | 91815 | 226 | 3.934426 | 8.89180276 | Exobasidiales | 5404 | Fungi | Fungi | 71.2 | 2.1e-13 | NR | XP_025381560.1 | 215250 | g90761 | i0 | 87.2 | 1.04867256637168 | 39 | 5 | 51.8 | 0 | 223 | 107 | 122 | 160 | XP_025381560.1 hypothetical protein FA10DRAFT_264899 [Acaromyces ingoldii] | diamond | 237 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 31519860 | 31519860 | PRJNA1001940_S_NODE_70696_length_258_cov_4.688372_g69642_i0 | PRJNA1001940 | 70696 | 258 | 4.688372 | 12.09599976 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 163 | 1.6e-44 | NR | WFD17641.1 | 1514897 | g69642 | i0 | 100 | 0.988372093023256 | 85 | 0 | 98.8 | 0 | 2 | 256 | 1774 | 1858 | WFD17641.1 hypothetical protein MARU1_003700 [Malassezia arunalokei] | diamond | 255 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 31646065 | 31646065 | PRJNA1001940_S_NODE_87557_length_232_cov_1.894180_g86503_i0 | PRJNA1001940 | 87557 | 232 | 1.89418 | 4.3944976 | Tremellales sp. Uapishka_1 | 3038892 | Fungi | Fungi | 60.1 | 1.02e-8 | NR | KAK4685525.1 | 3038892 | g86503 | i0 | 66.7 | 2.41810344827586 | 45 | 15 | 58.2 | 0 | 6 | 140 | 168 | 212 | KAK4685525.1 hypothetical protein P7C73_g4624, partial [Tremellales sp. Uapishka_1] | diamond | 561 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Uapishka_1 | |||
| 32342506 | 32342506 | PRJNA1001940_S_NODE_53119_length_297_cov_1.811024_g52065_i0 | PRJNA1001940 | 53119 | 297 | 1.811024 | 5.37874128 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 125 | 2.32e-31 | NR | WFD17028.1 | 1514897 | g52065 | i0 | 100 | 0.646464646464647 | 64 | 0 | 64.6 | 0 | 2 | 193 | 418 | 481 | WFD17028.1 rRNA biogenesis protein rrp36 [Malassezia arunalokei] | diamond | 192 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 32721212 | 32721212 | PRJNA1001940_S_NODE_58180_length_284_cov_3.186722_g57126_i0 | PRJNA1001940 | 58180 | 284 | 3.186722 | 9.05029048 | Malassezia restricta | 76775 | Fungi | Fungi | 80.1 | 4.45e-15 | NR | XP_027486662.1 | 76775 | g57126 | i0 | 86.4 | 0.464788732394366 | 44 | 6 | 46.5 | 0 | 153 | 284 | 1 | 44 | XP_027486662.1 Ras GTPase-activating-like protein IQGAP2/3 [Malassezia restricta] | diamond | 132 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;