contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1249042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12530883 | 12530883 | PRJNA1249042_S_NODE_36670_length_229_cov_2.532258_g36456_i0 | PRJNA1249042 | 36670 | 229 | 2.532258 | 5.79887082 | Malassezia restricta | 76775 | Fungi | Fungi | 87.4 | 2.99e-20 | NR | XP_027485017.1 | 76775 | g36456 | i0 | 100 | 0.563318777292576 | 43 | 0 | 56.3 | 0 | 2 | 130 | 69 | 111 | XP_027485017.1 small nuclear ribonucleoprotein D2 [Malassezia restricta] | diamond | 129 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27263392 | 27263392 | PRJNA1249042_S_NODE_38403_length_226_cov_3.535519_g38189_i0 | PRJNA1249042 | 38403 | 226 | 3.535519 | 7.99027294 | Trametes elegans | 526244 | Fungi | Fungi | 42.7 | 0.0221 | NR | KAI0769410.1 | 526244 | g38189 | i0 | 37 | 1.00884955752212 | 54 | 34 | 71.7 | 0 | 175 | 14 | 53 | 106 | KAI0769410.1 hypothetical protein BD413DRAFT_558182 [Trametes elegans] | diamond | 228 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes elegans | |
| 27768860 | 27768860 | PRJNA1249042_S_NODE_44144_length_218_cov_1.645714_g43930_i0 | PRJNA1249042 | 44144 | 218 | 1.645714 | 3.58765652 | Malassezia furfur | 55194 | Fungi | Fungi | 61.2 | 5.4e-9 | NR | KAI3627752.1 | 55194 | g43930 | i0 | 44.1 | 1.78899082568807 | 68 | 29 | 81.2 | 1 | 181 | 5 | 159 | 226 | KAI3627752.1 OTU1 [Malassezia furfur] | diamond | 390 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 28544642 | 28544642 | PRJNA1249042_S_NODE_25187_length_251_cov_2.966346_g24973_i0 | PRJNA1249042 | 25187 | 251 | 2.966346 | 7.44552846 | Basidiomycota | 5204 | Fungi | Fungi | 47 | 0.00128 | NR | THH03869.1 | 167371 | g24973 | i0 | 82.6 | 4.14741035856574 | 23 | 4 | 27.5 | 0 | 109 | 41 | 429 | 451 | THH03869.1 hypothetical protein EW145_g5941 [Phellinidium pouzarii] | diamond | 1041 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Phellinidium | Phellinidium pouzarii | |
| 29347413 | 29347413 | PRJNA1249042_S_NODE_46209_length_215_cov_2.005814_g45995_i0 | PRJNA1249042 | 46209 | 215 | 2.005814 | 4.3125001 | Serendipita indica DSM 11827 | 1109443 | Fungi | Fungi | 42 | 0.0457 | NR | CAG7855149.1 | 1109443 | g45995 | i0 | 37.5 | 1.78604651162791 | 64 | 32 | 79.5 | 2 | 37 | 207 | 71 | 133 | CAG7855149.1 SubName: Full=Uncharacterized protein {ECO:0000313|EMBL:CCA68908.1} [Serendipita indica DSM 11827] | diamond | 384 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita indica | |
| 29631173 | 29631173 | PRJNA1249042_S_NODE_11450_length_299_cov_1.988281_g11236_i0 | PRJNA1249042 | 11450 | 299 | 1.988281 | 5.94496019 | Mycena galopus ATCC 62 | 41248 | Fungi | Fungi | 62 | 4.23e-10 | NR | KAF8146267.1 | 1314675 | g11236 | i0 | 63.8 | 1.11371237458194 | 58 | 20 | 57.2 | 1 | 299 | 129 | 33 | 90 | KAF8146267.1 hypothetical protein K438DRAFT_1734966 [Mycena galopus ATCC 62051] | diamond | 333 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galopus | |
| 30231628 | 30231628 | PRJNA1249042_S_NODE_18812_length_268_cov_1.804444_g18598_i0 | PRJNA1249042 | 18812 | 268 | 1.804444 | 4.83590992 | Cryptococcus gattii VGV | 2268382 | Fungi | Fungi | 43.5 | 0.0215 | NR | KAE8541691.1 | 2268382 | g18598 | i0 | 38.7 | 0.83955223880597 | 75 | 39 | 77.2 | 2 | 226 | 20 | 18 | 91 | KAE8541691.1 presequence translocated-associated motor subunit PAM17, mitochondrial [Cryptococcus gattii VGV] | diamond | 225 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus gattii VGV | |
| 30390016 | 30390016 | PRJNA1249042_S_NODE_104493_length_158_cov_1.669565_g104279_i0 | PRJNA1249042 | 104493 | 158 | 1.669565 | 2.6379127000000002 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 89.7 | 7.39e-22 | NR | SHO75991.1 | 1230383 | g104279 | i0 | 80.8 | 1.9746835443038 | 52 | 10 | 98.7 | 0 | 158 | 3 | 35 | 86 | SHO75991.1 Uncharacterized protein MSYG_0325 [Malassezia sympodialis ATCC 42132] | diamond | 312 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 30895325 | 30895325 | PRJNA1249042_S_NODE_66434_length_191_cov_1.945946_g66220_i0 | PRJNA1249042 | 66434 | 191 | 1.945946 | 3.71675686 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 68.9 | 1.33e-13 | NR | SHO77802.1 | 1230383 | g66220 | i0 | 64.7 | 1.55497382198953 | 51 | 18 | 80.1 | 0 | 190 | 38 | 23 | 73 | SHO77802.1 Hypothetical protein MSYG_2144 [Malassezia sympodialis ATCC 42132] | diamond | 297 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 31861577 | 31861577 | PRJNA1249042_S_NODE_22957_length_256_cov_3.089202_g22743_i0 | PRJNA1249042 | 22957 | 256 | 3.089202 | 7.90835712 | Opisthokonta | 33154 | Fungi | Fungi | 50.4 | 6.99e-5 | NR | KAF8195625.1 | 1314675 | g22743 | i0 | 47.5 | 0.9375 | 40 | 21 | 46.9 | 0 | 5 | 124 | 13 | 52 | KAF8195625.1 hypothetical protein K438DRAFT_1968137 [Mycena galopus ATCC 62051] | diamond | 240 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galopus | |
| 32350111 | 32350111 | PRJNA1249042_S_NODE_101499_length_160_cov_2.051282_g101285_i0 | PRJNA1249042 | 101499 | 160 | 2.051282 | 3.2820512 | Malassezia cuniculi | 948313 | Fungi | Fungi | 49.3 | 2.49e-5 | NR | WFD34580.1 | 948313 | g101285 | i0 | 75.9 | 0.54375 | 29 | 7 | 54.4 | 0 | 159 | 73 | 131 | 159 | WFD34580.1 hypothetical protein MCUN1_001421 [Malassezia cuniculi] | diamond | 87 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 32368222 | 32368222 | PRJNA1249042_S_NODE_25359_length_251_cov_1.937500_g25145_i0 | PRJNA1249042 | 25359 | 251 | 1.9375 | 4.863125 | Agaricomycetes | 155619 | Fungi | Fungi | 98.2 | 3.179999999999999e-23 | NR | KAH7930890.1 | 85980 | g25145 | i0 | 58.6 | 1.66135458167331 | 70 | 29 | 83.7 | 0 | 250 | 41 | 146 | 215 | KAH7930890.1 hypothetical protein BV22DRAFT_999907 [Leucogyrophana mollusca] | diamond | 417 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Leucogyrophana | Leucogyrophana mollusca | ||
| 32571620 | 32571620 | PRJNA1249042_S_NODE_25959_length_249_cov_4.334951_g25745_i0 | PRJNA1249042 | 25959 | 249 | 4.334951 | 10.79402799 | Crucibulum laeve | 68775 | Fungi | Fungi | 41.2 | 0.025 | NR | TFK32071.1 | 68775 | g25745 | i0 | 31.8 | 0.795180722891566 | 66 | 45 | 79.5 | 0 | 240 | 43 | 1 | 66 | TFK32071.1 hypothetical protein BDQ12DRAFT_530198 [Crucibulum laeve] | diamond | 198 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Crucibulum | Crucibulum laeve | |
| 32634086 | 32634086 | PRJNA1249042_S_NODE_65760_length_192_cov_1.489933_g65546_i0 | PRJNA1249042 | 65760 | 192 | 1.489933 | 2.86067136 | Malassezia psittaci | 1821823 | Fungi | Fungi | 42 | 0.036 | NR | WFD44584.1 | 1821823 | g65546 | i0 | 47.4 | 0.59375 | 38 | 19 | 59.4 | 1 | 161 | 48 | 796 | 832 | WFD44584.1 vacuolar protein sorting/targeting protein PEP1 [Malassezia psittaci] | diamond | 114 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia psittaci | |
| 32760304 | 32760304 | PRJNA1249042_S_NODE_77460_length_180_cov_2.401460_g77246_i0 | PRJNA1249042 | 77460 | 180 | 2.40146 | 4.322628 | Athelia sp. TMB | 2748771 | Fungi | Fungi | 42 | 0.0295 | NR | KAF7969714.1 | 2748771 | g77246 | i0 | 39.6 | 0.8 | 48 | 18 | 80 | 1 | 6 | 149 | 66 | 102 | KAF7969714.1 hypothetical protein HWV62_26114 [Athelia sp. TMB] | diamond | 144 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Atheliales | Atheliaceae | Athelia | Athelia sp. TMB | |
| 32854689 | 32854689 | PRJNA1249042_S_NODE_85440_length_173_cov_1.807692_g85226_i0 | PRJNA1249042 | 85440 | 173 | 1.807692 | 3.12730716 | Macrolepiota fuliginosa MF-IS2 | 1400762 | Fungi | Fungi | 41.6 | 0.0378 | NR | KAF9454252.1 | 1400762 | g85226 | i0 | 47.4 | 0.658959537572254 | 38 | 20 | 65.9 | 0 | 156 | 43 | 580 | 617 | KAF9454252.1 hypothetical protein P691DRAFT_809798 [Macrolepiota fuliginosa MF-IS2] | diamond | 114 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Macrolepiota | Macrolepiota fuliginosa | |
| 32886078 | 32886078 | PRJNA1249042_S_NODE_44180_length_218_cov_1.611429_g43966_i0 | PRJNA1249042 | 44180 | 218 | 1.611429 | 3.51291522 | Phaffia rhodozyma | 264483 | Fungi | Fungi | 55.5 | 1.55e-7 | NR | CDZ96532.1 | 264483 | g43966 | i0 | 92.9 | 0.385321100917431 | 28 | 2 | 38.5 | 0 | 1 | 84 | 108 | 135 | CDZ96532.1 Acyl carrier protein [Phaffia rhodozyma] | diamond | 84 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Phaffia | Phaffia rhodozyma |
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);;