contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26773169 | 26773169 | PRJNA983848_P_NODE_156321_length_244_cov_0.912281_g150438_i0 | PRJNA983848 | 156321 | 244 | 0.912281 | 2.22596564 | Cryptococcus sp. DSM 1 | 2770023 | Fungi | Fungi | 123 | 3.939999999999999e-32 | NR | WVQ76836.1 | 2770023 | g150438 | i0 | 74.7 | 2.91393442622951 | 79 | 20 | 97.1 | 0 | 239 | 3 | 30 | 108 | WVQ76836.1 hypothetical protein IAR50_006510 [Cryptococcus sp. DSM 104548] | diamond | 711 | 123 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus sp. DSM 104548 | |
| 26804740 | 26804740 | PRJNA983848_P_NODE_137861_length_253_cov_0.866667_g131978_i0 | PRJNA983848 | 137861 | 253 | 0.866667 | 2.19266751 | Malassezia cuniculi | 948313 | Fungi | Fungi | 138 | 8.42e-36 | NR | WFD34763.1 | 948313 | g131978 | i0 | 85.7 | 0.99604743083004 | 84 | 12 | 99.6 | 0 | 2 | 253 | 143 | 226 | WFD34763.1 GTPase required for pre-60S ribosomal subunit nuclear export and maturation [Malassezia cuniculi] | diamond | 252 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 27089670 | 27089670 | PRJNA983848_P_NODE_158382_length_243_cov_0.917647_g152499_i0 | PRJNA983848 | 158382 | 243 | 0.917647 | 2.22988221 | Filobasidium floriforme | 5210 | Fungi | Fungi | 93.2 | 6.51e-20 | NR | XP_046032700.1 | 5210 | g152499 | i0 | 83.3 | 0.666666666666667 | 54 | 9 | 66.7 | 0 | 2 | 163 | 948 | 1001 | XP_046032700.1 Nrap protein [Filobasidium floriforme] | diamond | 162 | 93.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 27184240 | 27184240 | PRJNA983848_P_NODE_81142_length_343_cov_2.348148_g75259_i0 | PRJNA983848 | 81142 | 343 | 2.348148 | 8.05414764 | Tulosesus angulatus | 980116 | Fungi | Fungi | 45.1 | 0.0185 | NR | KAF5331401.1 | 980116 | g75259 | i0 | 39.1 | 0.603498542274053 | 69 | 41 | 59.5 | 1 | 312 | 109 | 198 | 266 | KAF5331401.1 hypothetical protein D9611_011827 [Tulosesus angulatus] | diamond | 207 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Ephemerocybe | Ephemerocybe angulata | |
| 27500455 | 27500455 | PRJNA983848_P_NODE_162263_length_237_cov_2.774390_g156380_i0 | PRJNA983848 | 162263 | 237 | 2.77439 | 6.5753043 | Cristinia sonorae | 1940300 | Fungi | Fungi | 134 | 1.52e-36 | NR | KAH8093960.1 | 1940300 | g156380 | i0 | 75.6 | 3.92405063291139 | 78 | 19 | 98.7 | 0 | 237 | 4 | 15 | 92 | KAH8093960.1 guanine nucleotide binding protein beta subunit [Cristinia sonorae] | diamond | 930 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Stephanosporaceae | Cristinia | Cristinia sonorae | |
| 27531908 | 27531908 | PRJNA983848_P_NODE_137903_length_253_cov_0.866667_g132020_i0 | PRJNA983848 | 137903 | 253 | 0.866667 | 2.19266751 | Ramaria rubella | 113071 | Fungi | Fungi | 67.8 | 6.6e-11 | NR | KAF8582394.1 | 113071 | g132020 | i0 | 55.8 | 0.616600790513834 | 52 | 23 | 61.7 | 0 | 253 | 98 | 1343 | 1394 | KAF8582394.1 ABC protein [Ramaria rubella] | diamond | 156 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gomphales | Gomphaceae | Ramaria | Ramaria rubella | |
| 27721820 | 27721820 | PRJNA983848_P_NODE_160564_length_242_cov_0.923077_g154681_i0 | PRJNA983848 | 160564 | 242 | 0.923077 | 2.23384634 | Filobasidium floriforme | 5210 | Fungi | Fungi | 103 | 1.41e-23 | NR | KAG7527588.1 | 5210 | g154681 | i0 | 73.1 | 0.966942148760331 | 78 | 19 | 96.7 | 1 | 8 | 241 | 196 | 271 | KAG7527588.1 hypothetical protein FFLO_06782 [Filobasidium floriforme] | diamond | 234 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 28011700 | 28011700 | PRJNA983848_P_NODE_155505_length_244_cov_0.912281_g149622_i0 | PRJNA983848 | 155505 | 244 | 0.912281 | 2.22596564 | Rhodotorula | 5533 | Fungi | Fungi | 162 | 3.89e-44 | NR | KAG0654381.1 | 5537 | g149622 | i0 | 100 | 1.99180327868852 | 81 | 0 | 99.6 | 0 | 1 | 243 | 529 | 609 | KAG0654381.1 hypothetical protein C6P46_001766 [Rhodotorula mucilaginosa] | diamond | 486 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 28232257 | 28232257 | PRJNA983848_P_NODE_162366_length_237_cov_2.378049_g156483_i0 | PRJNA983848 | 162366 | 237 | 2.378049 | 5.63597613 | Fungi | 4751 | Fungi | Fungi | 117 | 1.8599999999999997e-30 | NR | TIB76799.1 | 1708541 | g156483 | i0 | 75.6 | 37.5189873417722 | 78 | 19 | 98.7 | 0 | 2 | 235 | 70 | 147 | TIB76799.1 hypothetical protein E3Q23_01653 [Wallemia mellicola] | diamond | 8892 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia mellicola | |
| 28763164 | 28763164 | PRJNA983848_P_NODE_110307_length_286_cov_2.262911_g104424_i0 | PRJNA983848 | 110307 | 286 | 2.262911 | 6.47192546 | Tulasnella sp. 419 | 2600227 | Fungi | Fungi | 45.4 | 0.00638 | NR | KAG8967046.1 | 2600227 | g104424 | i0 | 34.8 | 0.933566433566434 | 89 | 45 | 93.4 | 3 | 286 | 20 | 194 | 269 | KAG8967046.1 hypothetical protein FRC03_010794 [Tulasnella sp. 419] | diamond | 267 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 419 | |
| 29110705 | 29110705 | PRJNA983848_P_NODE_140728_length_251_cov_2.247191_g134845_i0 | PRJNA983848 | 140728 | 251 | 2.247191 | 5.64044941 | Coniferiporia weirii | 135589 | Fungi | Fungi | 43.9 | 0.016 | NR | KAI5120423.1 | 135589 | g134845 | i0 | 36.6 | 0.848605577689243 | 71 | 33 | 84.9 | 1 | 20 | 232 | 368 | 426 | KAI5120423.1 hypothetical protein M0805_006923 [Coniferiporia weirii] | diamond | 213 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Coniferiporia | Coniferiporia weirii | |
| 29300054 | 29300054 | PRJNA983848_P_NODE_155809_length_244_cov_0.912281_g149926_i0 | PRJNA983848 | 155809 | 244 | 0.912281 | 2.22596564 | Filobasidium floriforme | 5210 | Fungi | Fungi | 49.7 | 6.72e-5 | NR | XP_046038822.1 | 5210 | g149926 | i0 | 91.7 | 0.590163934426229 | 24 | 2 | 29.5 | 0 | 145 | 74 | 1 | 24 | XP_046038822.1 uncharacterized protein HD553DRAFT_306352 [Filobasidium floriforme] | diamond | 144 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 29337653 | 29337653 | PRJNA983848_P_NODE_138429_length_253_cov_0.866667_g132546_i0 | PRJNA983848 | 138429 | 253 | 0.866667 | 2.19266751 | Basidiomycota | 5204 | Fungi | Fungi | 133 | 1.34e-37 | NR | SPO36875.1 | 84751 | g132546 | i0 | 78.3 | 20.596837944664 | 83 | 18 | 98.4 | 0 | 251 | 3 | 51 | 133 | SPO36875.1 probable 60s ribosomal protein L21-A [Pseudozyma flocculosa] | diamond | 5211 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 29842789 | 29842789 | PRJNA983848_P_NODE_142251_length_251_cov_0.876404_g136368_i0 | PRJNA983848 | 142251 | 251 | 0.876404 | 2.19977404 | Rhodotorula | 5533 | Fungi | Fungi | 65.5 | 4.03e-10 | NR | KWU43431.1 | 1305733 | g136368 | i0 | 100 | 0.812749003984064 | 34 | 0 | 40.6 | 0 | 83 | 184 | 244 | 277 | KWU43431.1 hypothetical protein RHOSPDRAFT_19585 [Rhodotorula sp. JG-1b] | diamond | 204 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 29994925 | 29994925 | PRJNA983848_P_NODE_140411_length_252_cov_0.871508_g134528_i0 | PRJNA983848 | 140411 | 252 | 0.871508 | 2.19620016 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 53.1 | 9.15e-6 | NR | KWU44432.1 | 1305733 | g134528 | i0 | 44.1 | 1.14285714285714 | 68 | 27 | 67.9 | 1 | 82 | 252 | 152 | 219 | KWU44432.1 hypothetical protein RHOSPDRAFT_25728 [Rhodotorula sp. JG-1b] | diamond | 288 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 30152492 | 30152492 | PRJNA983848_P_NODE_150492_length_246_cov_2.520231_g144609_i0 | PRJNA983848 | 150492 | 246 | 2.520231 | 6.19976826 | Pleurotus cornucopiae | 5321 | Fungi | Fungi | 43.1 | 0.0288 | NR | KAG9222749.1 | 5321 | g144609 | i0 | 55.9 | 0.414634146341463 | 34 | 15 | 41.5 | 0 | 56 | 157 | 621 | 654 | KAG9222749.1 hypothetical protein CCMSSC00406_0004663 [Pleurotus cornucopiae] | diamond | 102 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus cornucopiae | |
| 30468925 | 30468925 | PRJNA983848_P_NODE_144053_length_250_cov_0.881356_g138170_i0 | PRJNA983848 | 144053 | 250 | 0.881356 | 2.20339 | Filobasidium floriforme | 5210 | Fungi | Fungi | 63.2 | 2.65e-9 | NR | KAG7531928.1 | 5210 | g138170 | i0 | 64.7 | 1.428 | 51 | 18 | 61.2 | 0 | 153 | 1 | 233 | 283 | KAG7531928.1 hypothetical protein FFLO_03996 [Filobasidium floriforme] | diamond | 357 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 31954398 | 31954398 | PRJNA983848_P_NODE_117517_length_276_cov_3.359606_g111634_i0 | PRJNA983848 | 117517 | 276 | 3.359606 | 9.27251256 | Mycena filopes | 858877 | Fungi | Fungi | 43.9 | 0.019 | NR | KAJ7176923.1 | 858877 | g111634 | i0 | 33 | 0.956521739130435 | 88 | 58 | 95.7 | 1 | 4 | 267 | 92 | 178 | KAJ7176923.1 hypothetical protein C8R46DRAFT_1213492 [Mycena filopes] | diamond | 264 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena filopes | |
| 31986021 | 31986021 | PRJNA983848_P_NODE_155078_length_244_cov_1.637427_g149195_i0 | PRJNA983848 | 155078 | 244 | 1.637427 | 3.99532188 | Hypsizygus marmoreus | 39966 | Fungi | Fungi | 42.7 | 0.0365 | NR | RDB19938.1 | 39966 | g149195 | i0 | 39.3 | 0.688524590163934 | 56 | 28 | 68.9 | 2 | 54 | 221 | 486 | 535 | RDB19938.1 hypothetical protein Hypma_013019 [Hypsizygus marmoreus] | diamond | 168 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Hypsizygus | Hypsizygus marmoreus | |
| 32081016 | 32081016 | PRJNA983848_P_NODE_146418_length_248_cov_2.800000_g140535_i0 | PRJNA983848 | 146418 | 248 | 2.8 | 6.944 | Hydnum rufescens UP5 | 139363 | Fungi | Fungi | 98.2 | 7.929999999999999e-23 | NR | KAF9518317.1 | 1448309 | g140535 | i0 | 54.9 | 2.9758064516129 | 82 | 35 | 99.2 | 1 | 1 | 246 | 24 | 103 | KAF9518317.1 hypothetical protein BS47DRAFT_1423141 [Hydnum rufescens UP504] | diamond | 738 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Hydnaceae | Hydnum | Hydnum rufescens | |
| 32524366 | 32524366 | PRJNA983848_P_NODE_152759_length_245_cov_1.813953_g146876_i0 | PRJNA983848 | 152759 | 245 | 1.813953 | 4.44418485 | Lentinus brumalis | 2498619 | Fungi | Fungi | 43.1 | 0.0159 | NR | RDX44163.1 | 2498619 | g146876 | i0 | 43.9 | 0.697959183673469 | 57 | 27 | 69.8 | 1 | 47 | 217 | 107 | 158 | RDX44163.1 hypothetical protein OH76DRAFT_1116227 [Lentinus brumalis] | diamond | 171 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus brumalis | |
| 32781934 | 32781934 | PRJNA983848_P_NODE_151120_length_246_cov_1.439306_g145237_i0 | PRJNA983848 | 151120 | 246 | 1.439306 | 3.54069276 | Candolleomyces | 2791032 | Fungi | Fungi | 42.7 | 0.0401 | NR | RXW21720.1 | 2316362 | g145237 | i0 | 45.2 | 1.02439024390244 | 42 | 20 | 51.2 | 1 | 201 | 76 | 594 | 632 | RXW21720.1 hypothetical protein EST38_g4117 [Candolleomyces aberdarensis] | diamond | 252 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Candolleomyces | Candolleomyces aberdarensis |
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);;