contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA631796" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6981826 | 6981826 | PRJNA631796_P_NODE_11606_length_207_cov_0.876712_g11328_i0 | PRJNA631796 | 11606 | 207 | 0.876712 | 1.81479384 | Macrolepiota fuliginosa MF-IS2 | 1400762 | Fungi | Fungi | 135 | 1.92e-35 | NR | KAF9455067.1 | 1400762 | g11328 | i0 | 89.6 | 0.971014492753623 | 67 | 7 | 97.1 | 0 | 5 | 205 | 477 | 543 | KAF9455067.1 glycoside hydrolase family 16 protein [Macrolepiota fuliginosa MF-IS2] | diamond | 201 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Macrolepiota | Macrolepiota fuliginosa | |
| 7529890 | 7529890 | PRJNA631796_P_NODE_14346_length_171_cov_6.136364_g14068_i0 | PRJNA631796 | 14346 | 171 | 6.136364 | 10.49318244 | Cubamyces sp. BRFM 1775 | 1513325 | Fungi | Fungi | 71.6 | 8.99e-13 | NR | KAI0323318.1 | 1513325 | g14068 | i0 | 64.9 | 1 | 57 | 20 | 100 | 0 | 1 | 171 | 80 | 136 | KAI0323318.1 hypothetical protein GY45DRAFT_1341516 [Cubamyces sp. BRFM 1775] | diamond | 171 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Cubamyces | Cubamyces sp. BRFM 1775 | |
| 26637678 | 26637678 | PRJNA631796_P_NODE_11161_length_208_cov_4.530612_g10883_i0 | PRJNA631796 | 11161 | 208 | 4.530612 | 9.42367296 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 82.8 | 1.86e-16 | NR | WFD16437.1 | 1514897 | g10883 | i0 | 74.2 | 0.894230769230769 | 62 | 4 | 72.1 | 1 | 208 | 59 | 940 | 1001 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 186 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 26777141 | 26777141 | PRJNA631796_P_NODE_13021_length_201_cov_2.328571_g12743_i0 | PRJNA631796 | 13021 | 201 | 2.328571 | 4.68042771 | Agaricomycetes | 155619 | Fungi | Fungi | 62 | 4.06e-10 | NR | KJA23076.1 | 945553 | g12743 | i0 | 73.2 | 1.22388059701493 | 41 | 11 | 61.2 | 0 | 199 | 77 | 103 | 143 | KJA23076.1 hypothetical protein HYPSUDRAFT_40197 [Hypholoma sublateritium FD-334 SS-4] | diamond | 246 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Hypholoma | Hypholoma sublateritium | |
| 27333953 | 27333953 | PRJNA631796_P_NODE_14283_length_174_cov_4.725664_g14005_i0 | PRJNA631796 | 14283 | 174 | 4.725664 | 8.22265536 | Serendipita vermifera | 109899 | Fungi | Fungi | 87 | 4.52e-19 | NR | PVG03238.1 | 109899 | g14005 | i0 | 74.1 | 0.931034482758621 | 54 | 14 | 93.1 | 0 | 12 | 173 | 1 | 54 | PVG03238.1 hypothetical protein CPB86DRAFT_804227 [Serendipita vermifera] | diamond | 162 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 27586504 | 27586504 | PRJNA631796_P_NODE_12244_length_204_cov_1.594406_g11966_i0 | PRJNA631796 | 12244 | 204 | 1.594406 | 3.25258824 | Filobasidium floriforme | 5210 | Fungi | Fungi | 131 | 1.47e-34 | NR | XP_046033209.1 | 5210 | g11966 | i0 | 91 | 0.985294117647059 | 67 | 6 | 98.5 | 0 | 203 | 3 | 152 | 218 | XP_046033209.1 phosphoserine transaminase [Filobasidium floriforme] | diamond | 201 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 28009600 | 28009600 | PRJNA631796_P_NODE_12605_length_203_cov_0.901408_g12327_i0 | PRJNA631796 | 12605 | 203 | 0.901408 | 1.82985824 | Polyporales | 5303 | Fungi | Fungi | 60.8 | 4.45e-9 | NR | XP_047774348.1 | 34475 | g12327 | i0 | 60 | 3.31034482758621 | 45 | 18 | 66.5 | 0 | 201 | 67 | 163 | 207 | XP_047774348.1 uncharacterized protein C8Q71DRAFT_727014 [Rhodofomes roseus] | diamond | 672 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Rhodofomes | Rhodofomes roseus | |
| 28123208 | 28123208 | PRJNA631796_P_NODE_9805_length_220_cov_1.062893_g9527_i0 | PRJNA631796 | 9805 | 220 | 1.062893 | 2.3383646 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 80.5 | 7.76e-16 | NR | XP_017990662.1 | 77020 | g9527 | i0 | 75 | 0.6 | 44 | 11 | 60 | 0 | 219 | 88 | 297 | 340 | XP_017990662.1 hsd1-er membrane protein [Malassezia pachydermatis] | diamond | 132 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 28502133 | 28502133 | PRJNA631796_P_NODE_9607_length_222_cov_1.291925_g9329_i0 | PRJNA631796 | 9607 | 222 | 1.291925 | 2.8680735 | Auriculariopsis ampla | 97359 | Fungi | Fungi | 154 | 2.21e-42 | NR | TRM67699.1 | 97359 | g9329 | i0 | 97.3 | 0.986486486486487 | 73 | 2 | 98.6 | 0 | 221 | 3 | 172 | 244 | TRM67699.1 kinase-like domain-containing protein [Schizophyllum amplum] | diamond | 219 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum amplum | |
| 28691740 | 28691740 | PRJNA631796_P_NODE_12927_length_202_cov_0.907801_g12649_i0 | PRJNA631796 | 12927 | 202 | 0.907801 | 1.83375802 | Leucogyrophana mollusca | 85980 | Fungi | Fungi | 95.5 | 5.78e-21 | NR | KAH7926366.1 | 85980 | g12649 | i0 | 70.1 | 1.99009900990099 | 67 | 20 | 99.5 | 0 | 201 | 1 | 259 | 325 | KAH7926366.1 hypothetical protein BV22DRAFT_1009273 [Leucogyrophana mollusca] | diamond | 402 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Leucogyrophana | Leucogyrophana mollusca | ||
| 29891520 | 29891520 | PRJNA631796_P_NODE_10191_length_216_cov_1.361290_g9913_i0 | PRJNA631796 | 10191 | 216 | 1.3612899999999999 | 2.9403864 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 50.8 | 3.75e-5 | NR | AYO44099.1 | 425264 | g9913 | i0 | 100 | 0.291666666666667 | 21 | 0 | 29.2 | 0 | 1 | 63 | 635 | 655 | AYO44099.1 Polyamine transporter 3 [Malassezia restricta CBS 7877] | diamond | 63 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30586272 | 30586272 | PRJNA631796_P_NODE_12473_length_203_cov_1.802817_g12195_i0 | PRJNA631796 | 12473 | 203 | 1.802817 | 3.65971851 | Rhodofomes roseus | 34475 | Fungi | Fungi | 84 | 6.65e-17 | NR | TFY68930.1 | 34475 | g12195 | i0 | 57.6 | 1.95073891625616 | 66 | 28 | 97.5 | 0 | 1 | 198 | 811 | 876 | TFY68930.1 hypothetical protein EVJ58_g720 [Rhodofomes roseus] | diamond | 396 | 84 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Rhodofomes | Rhodofomes roseus | |
| 30680993 | 30680993 | PRJNA631796_P_NODE_7653_length_245_cov_2.695652_g7375_i0 | PRJNA631796 | 7653 | 245 | 2.695652 | 6.6043474 | Marasmiellus scandens | 2682957 | Fungi | Fungi | 120 | 1.0699999999999999e-32 | NR | KAK7458172.1 | 2682957 | g7375 | i0 | 78.1 | 0.893877551020408 | 73 | 15 | 88.2 | 1 | 221 | 6 | 1 | 73 | KAK7458172.1 hypothetical protein VKT23_010080 [Marasmiellus scandens] | diamond | 219 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Marasmiellus | Marasmiellus scandens | |
| 30997248 | 30997248 | PRJNA631796_P_NODE_11254_length_208_cov_1.285714_g10976_i0 | PRJNA631796 | 11254 | 208 | 1.285714 | 2.67428512 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 60.8 | 9.55e-9 | NR | WFD16437.1 | 1514897 | g10976 | i0 | 61.7 | 0.865384615384615 | 60 | 11 | 69.2 | 1 | 200 | 57 | 932 | 991 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 180 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 31028979 | 31028979 | PRJNA631796_P_NODE_8155_length_238_cov_1.446328_g7877_i0 | PRJNA631796 | 8155 | 238 | 1.446328 | 3.44226064 | Punctularia strigosozonata HHB-11173 SS5 | 741275 | Fungi | Fungi | 145 | 3.37e-38 | NR | XP_007387157.1 | 741275 | g7877 | i0 | 89.9 | 0.995798319327731 | 79 | 8 | 99.6 | 0 | 238 | 2 | 623 | 701 | XP_007387157.1 uncharacterized protein PUNSTDRAFT_106990 [Punctularia strigosozonata HHB-11173 SS5] | diamond | 237 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Corticiales | Punctulariaceae | Punctularia | Punctularia strigosozonata | |
| 31060644 | 31060644 | PRJNA631796_P_NODE_14035_length_187_cov_4.349206_g13757_i0 | PRJNA631796 | 14035 | 187 | 4.349206 | 8.13301522 | Malassezia cuniculi | 948313 | Fungi | Fungi | 103 | 4.98e-24 | NR | WFD35195.1 | 948313 | g13757 | i0 | 77.4 | 0.994652406417112 | 62 | 14 | 99.5 | 0 | 187 | 2 | 249 | 310 | WFD35195.1 THO2 plays a role in transcriptional elongation [Malassezia cuniculi] | diamond | 186 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 31503193 | 31503193 | PRJNA631796_P_NODE_8316_length_236_cov_1.594286_g8038_i0 | PRJNA631796 | 8316 | 236 | 1.594286 | 3.76251496 | Malassezia cuniculi | 948313 | Fungi | Fungi | 58.9 | 6.11e-8 | NR | WFD35711.1 | 948313 | g8038 | i0 | 45.5 | 1.44915254237288 | 77 | 34 | 89 | 2 | 212 | 3 | 119 | 194 | WFD35711.1 transcriptional regulator [Malassezia cuniculi] | diamond | 342 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 31547409 | 31547409 | PRJNA631796_P_NODE_7936_length_241_cov_0.855556_g7658_i0 | PRJNA631796 | 7936 | 241 | 0.855556 | 2.06188996 | Malassezia | 55193 | Fungi | Fungi | 134 | 1.8199999999999999e-34 | NR | AYO43640.1 | 425264 | g7658 | i0 | 94.4 | 1.79253112033195 | 72 | 4 | 89.6 | 0 | 221 | 6 | 98 | 169 | AYO43640.1 hypothetical protein DNF11_2690 [Malassezia restricta CBS 7877] | diamond | 432 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 31578930 | 31578930 | PRJNA631796_P_NODE_9216_length_226_cov_1.400000_g8938_i0 | PRJNA631796 | 9216 | 226 | 1.4 | 3.164 | Rhodotorula | 5533 | Fungi | Fungi | 157 | 1.43e-42 | NR | GAA5967508.1 | 5537 | g8938 | i0 | 100 | 1.9646017699115 | 74 | 0 | 98.2 | 0 | 3 | 224 | 324 | 397 | GAA5967508.1 hypothetical protein JCM8115_004070 [Rhodotorula mucilaginosa] | diamond | 444 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa |
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);;