contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1182301" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 318802 | 318802 | PRJNA1182301_P_NODE_42401_length_259_cov_1.430108_g42276_i0 | PRJNA1182301 | 42401 | 259 | 1.430108 | 3.70397972 | Eukaryota | 2759 | Fungi | Fungi | 127 | 7.369999999999998e-32 | NR | KAL1667074.1 | 5334 | g42276 | i0 | 69 | 15.7413127413127 | 84 | 26 | 97.3 | 0 | 254 | 3 | 571 | 654 | KAL1667074.1 hypothetical protein GGF50DRAFT_86962 [Schizophyllum commune] | diamond | 4077 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 14347506 | 14347506 | PRJNA1182301_P_NODE_32292_length_272_cov_1.547739_g32167_i0 | PRJNA1182301 | 32292 | 272 | 1.547739 | 4.20985008 | Malassezia | 55193 | Fungi | Fungi | 172 | 8.03e-48 | NR | WFD20323.1 | 1381934 | g32167 | i0 | 90 | 5.95588235294118 | 90 | 9 | 99.3 | 0 | 270 | 1 | 725 | 814 | WFD20323.1 Pre-mRNA-splicing factor cwf19 [Malassezia caprae] | diamond | 1620 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia caprae | |
| 20720231 | 20720231 | PRJNA1182301_P_NODE_48497_length_251_cov_1.657303_g48372_i0 | PRJNA1182301 | 48497 | 251 | 1.657303 | 4.15983053 | Psilocybe cyanescens | 93625 | Fungi | Fungi | 123 | 1.56e-30 | NR | PPQ93848.1 | 93625 | g48372 | i0 | 81.7 | 0.848605577689243 | 71 | 13 | 84.9 | 0 | 214 | 2 | 815 | 885 | PPQ93848.1 hypothetical protein CVT25_013557 [Psilocybe cyanescens] | diamond | 213 | 123 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cyanescens | |
| 27072198 | 27072198 | PRJNA1182301_P_NODE_55362_length_246_cov_2.369942_g55237_i0 | PRJNA1182301 | 55362 | 246 | 2.369942 | 5.83005732 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 78.6 | 9.45e-15 | NR | XP_025597371.1 | 58919 | g55237 | i0 | 71.7 | 0.646341463414634 | 53 | 15 | 64.6 | 0 | 160 | 2 | 1273 | 1325 | XP_025597371.1 RecF/RecN/SMC protein [Tilletiopsis washingtonensis] | diamond | 159 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 27230213 | 27230213 | PRJNA1182301_P_NODE_31623_length_273_cov_1.495000_g31498_i0 | PRJNA1182301 | 31623 | 273 | 1.495 | 4.08135 | Cryptococcus sp. DSM 1 | 2770023 | Fungi | Fungi | 48.5 | 4.89e-4 | NR | WVQ75977.1 | 2770023 | g31498 | i0 | 47.7 | 0.967032967032967 | 44 | 23 | 48.4 | 0 | 16 | 147 | 121 | 164 | WVQ75977.1 hypothetical protein IAR50_005613 [Cryptococcus sp. DSM 104548] | diamond | 264 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus sp. DSM 104548 | |
| 27420120 | 27420120 | PRJNA1182301_P_NODE_21743_length_286_cov_2.314554_g21618_i0 | PRJNA1182301 | 21743 | 286 | 2.3145539999999998 | 6.61962444 | Puccinia triticina | 208348 | Fungi | Fungi | 70.9 | 6.12e-12 | NR | XP_053024486.1 | 208348 | g21618 | i0 | 85.3 | 0.356643356643357 | 34 | 5 | 35.7 | 0 | 279 | 178 | 174 | 207 | XP_053024486.1 uncharacterized protein PtA15_10A354 [Puccinia triticina] | diamond | 102 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 27546212 | 27546212 | PRJNA1182301_P_NODE_54524_length_247_cov_0.885057_g54399_i0 | PRJNA1182301 | 54524 | 247 | 0.885057 | 2.18609079 | Ceratobasidium sp. 414 | 2600205 | Fungi | Fungi | 45.8 | 0.0033 | NR | KAG8735312.1 | 2600205 | g54399 | i0 | 37.1 | 0.753036437246964 | 62 | 39 | 75.3 | 0 | 199 | 14 | 948 | 1009 | KAG8735312.1 hypothetical protein FRC10_010750 [Ceratobasidium sp. 414] | diamond | 186 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. 414 | |
| 27861809 | 27861809 | PRJNA1182301_P_NODE_56125_length_246_cov_0.890173_g56000_i0 | PRJNA1182301 | 56125 | 246 | 0.890173 | 2.18982558 | Malassezia nana | 180528 | Fungi | Fungi | 67 | 1.06e-10 | NR | WFD25581.1 | 180528 | g56000 | i0 | 39.8 | 1.13414634146341 | 93 | 44 | 98.8 | 2 | 3 | 245 | 243 | 335 | WFD25581.1 hypothetical protein MNAN1_000542 [Malassezia nana] | diamond | 279 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 27988252 | 27988252 | PRJNA1182301_P_NODE_38985_length_263_cov_1.852632_g38860_i0 | PRJNA1182301 | 38985 | 263 | 1.852632 | 4.87242216 | Sporobolomyces koalae | 500713 | Fungi | Fungi | 85.5 | 4.33e-17 | NR | GAA5942355.1 | 500713 | g38860 | i0 | 100 | 0.479087452471483 | 42 | 0 | 47.9 | 0 | 137 | 262 | 334 | 375 | GAA5942355.1 hypothetical protein JCM15063_002980 [Sporobolomyces koalae] | diamond | 126 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces koalae | |
| 28240621 | 28240621 | PRJNA1182301_P_NODE_67166_length_228_cov_2.922581_g67041_i0 | PRJNA1182301 | 67166 | 228 | 2.922581 | 6.66348468 | Naematelia encephala | 71784 | Fungi | Fungi | 65.9 | 2.26e-10 | NR | ORY33736.1 | 71784 | g67041 | i0 | 87.5 | 0.842105263157895 | 32 | 4 | 42.1 | 0 | 96 | 1 | 319 | 350 | ORY33736.1 tRNA synthetases class I-domain-containing protein [Naematelia encephala] | diamond | 192 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 28808826 | 28808826 | PRJNA1182301_P_NODE_67428_length_227_cov_2.889610_g67303_i0 | PRJNA1182301 | 67428 | 227 | 2.88961 | 6.5594147 | Paxillus rubicundulus Ve | 463315 | Fungi | Fungi | 42.4 | 0.0393 | NR | KIK77608.1 | 930991 | g67303 | i0 | 40.3 | 0.819383259911894 | 62 | 37 | 81.9 | 0 | 3 | 188 | 198 | 259 | KIK77608.1 hypothetical protein PAXRUDRAFT_17390 [Paxillus rubicundulus Ve08.2h10] | diamond | 186 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Paxillaceae | Paxillus | Paxillus rubicundulus | |
| 28840615 | 28840615 | PRJNA1182301_P_NODE_37248_length_265_cov_2.640625_g37123_i0 | PRJNA1182301 | 37248 | 265 | 2.640625 | 6.99765625 | Sphaerobolus stellatus SS14 | 990650 | Fungi | Fungi | 45.1 | 0.00709 | NR | KIJ51433.1 | 990650 | g37123 | i0 | 91.3 | 0.260377358490566 | 23 | 2 | 26 | 0 | 218 | 150 | 432 | 454 | KIJ51433.1 hypothetical protein M422DRAFT_158478 [Sphaerobolus stellatus SS14] | diamond | 69 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Geastrales | Sphaerobolaceae | Sphaerobolus | Sphaerobolus stellatus | |
| 28872214 | 28872214 | PRJNA1182301_P_NODE_49868_length_250_cov_1.740113_g49743_i0 | PRJNA1182301 | 49868 | 250 | 1.740113 | 4.3502825 | Vanrija humicola | 5417 | Fungi | Fungi | 149 | 1.91e-39 | NR | TXT04243.1 | 5417 | g49743 | i0 | 82.7 | 1.944 | 81 | 14 | 97.2 | 0 | 7 | 249 | 703 | 783 | TXT04243.1 hypothetical protein VHUM_04241 [Vanrija humicola] | diamond | 486 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija humicola | |
| 28967163 | 28967163 | PRJNA1182301_P_NODE_57068_length_245_cov_1.790698_g56943_i0 | PRJNA1182301 | 57068 | 245 | 1.790698 | 4.3872101 | Malassezia restricta | 76775 | Fungi | Fungi | 108 | 1.3e-25 | NR | XP_027484532.1 | 76775 | g56943 | i0 | 80.3 | 0.930612244897959 | 76 | 15 | 93.1 | 0 | 229 | 2 | 1 | 76 | XP_027484532.1 interactor of little elongation complex ELL subunit 2 [Malassezia restricta] | diamond | 228 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29093472 | 29093472 | PRJNA1182301_P_NODE_32488_length_272_cov_1.226131_g32363_i0 | PRJNA1182301 | 32488 | 272 | 1.226131 | 3.33507632 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 49.3 | 2.6e-4 | NR | XP_017993888.1 | 77020 | g32363 | i0 | 90.9 | 0.485294117647059 | 22 | 2 | 24.3 | 0 | 167 | 232 | 1 | 22 | XP_017993888.1 rna polymerase ii subunit a c-terminal domain phosphatase [Malassezia pachydermatis] | diamond | 132 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 29219739 | 29219739 | PRJNA1182301_P_NODE_23449_length_284_cov_1.459716_g23324_i0 | PRJNA1182301 | 23449 | 284 | 1.459716 | 4.14559344 | Pisolithus albus | 178870 | Fungi | Fungi | 54.7 | 3.74e-6 | NR | KAI5993545.1 | 178870 | g23324 | i0 | 44.9 | 3.52816901408451 | 78 | 42 | 81.3 | 1 | 231 | 1 | 263 | 340 | KAI5993545.1 interferon-inducible GTPase-domain-containing protein [Pisolithus albus] | diamond | 1002 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Pisolithaceae | Pisolithus | Pisolithus albus | |
| 29598155 | 29598155 | PRJNA1182301_P_NODE_22270_length_286_cov_1.023474_g22145_i0 | PRJNA1182301 | 22270 | 286 | 1.023474 | 2.92713564 | Coprinellus micaceus | 71717 | Fungi | Fungi | 122 | 2.8399999999999997e-31 | NR | TEB37601.1 | 71717 | g22145 | i0 | 97.9 | 0.996503496503496 | 95 | 2 | 99.7 | 0 | 286 | 2 | 149 | 243 | TEB37601.1 hypothetical protein FA13DRAFT_922056 [Coprinellus micaceus] | diamond | 285 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus micaceus | |
| 29819298 | 29819298 | PRJNA1182301_P_NODE_29231_length_276_cov_1.517241_g29106_i0 | PRJNA1182301 | 29231 | 276 | 1.517241 | 4.18758516 | Schizopora paradoxa | 27342 | Fungi | Fungi | 92.4 | 1.97e-19 | NR | KLO18592.1 | 27342 | g29106 | i0 | 76.3 | 0.641304347826087 | 59 | 14 | 64.1 | 0 | 276 | 100 | 260 | 318 | KLO18592.1 hypothetical protein SCHPADRAFT_844897 [Schizopora paradoxa] | diamond | 177 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 30325521 | 30325521 | PRJNA1182301_P_NODE_19232_length_290_cov_1.419355_g19107_i0 | PRJNA1182301 | 19232 | 290 | 1.419355 | 4.1161295 | Dioszegia hungarica | 4972 | Fungi | Fungi | 105 | 4.26e-24 | NR | XP_052947196.1 | 4972 | g19107 | i0 | 66.3 | 0.920689655172414 | 89 | 18 | 92.1 | 1 | 268 | 2 | 622 | 698 | XP_052947196.1 uncharacterized protein MKK02DRAFT_36404 [Dioszegia hungarica] | diamond | 267 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 30830461 | 30830461 | PRJNA1182301_P_NODE_59314_length_244_cov_0.900585_g59189_i0 | PRJNA1182301 | 59314 | 244 | 0.900585 | 2.1974274 | Rhodotorula taiwanensis | 741276 | Fungi | Fungi | 49.3 | 1.01e-4 | NR | POY71799.1 | 741276 | g59189 | i0 | 31.9 | 0.885245901639344 | 72 | 49 | 88.5 | 0 | 27 | 242 | 79 | 150 | POY71799.1 putative Laccase [Rhodotorula taiwanensis] | diamond | 216 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula taiwanensis | |
| 31083309 | 31083309 | PRJNA1182301_P_NODE_24015_length_283_cov_1.938095_g23890_i0 | PRJNA1182301 | 24015 | 283 | 1.938095 | 5.48480885 | Ganoderma boninense | 34458 | Fungi | Fungi | 126 | 2.4699999999999996e-32 | NR | VWO94584.1 | 34458 | g23890 | i0 | 75.6 | 3.96466431095406 | 82 | 20 | 86.9 | 0 | 249 | 4 | 292 | 373 | VWO94584.1 Beta-lactamase (EC [Ganoderma boninense] | diamond | 1122 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 31291943 | 31291943 | PRJNA1182301_P_NODE_31835_length_272_cov_3.396985_g31710_i0 | PRJNA1182301 | 31835 | 272 | 3.396985 | 9.2397992 | Candolleomyces | 2791032 | Fungi | Fungi | 66.2 | 2.86e-10 | NR | RXW15644.1 | 2316362 | g31710 | i0 | 97 | 1.09191176470588 | 33 | 1 | 36.4 | 0 | 138 | 40 | 625 | 657 | RXW15644.1 hypothetical protein EST38_g10211 [Candolleomyces aberdarensis] | diamond | 297 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Candolleomyces | Candolleomyces aberdarensis | |
| 31526087 | 31526087 | PRJNA1182301_P_NODE_17776_length_293_cov_3.027273_g17651_i0 | PRJNA1182301 | 17776 | 293 | 3.027273 | 8.86990989 | Trametes versicolor | 5325 | Fungi | Fungi | 182 | 1.44e-51 | NR | KAL1940907.1 | 5325 | g17651 | i0 | 96 | 1.01365187713311 | 99 | 2 | 99.3 | 1 | 292 | 2 | 274 | 372 | KAL1940907.1 hypothetical protein VTO73DRAFT_7543 [Trametes versicolor] | diamond | 297 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes versicolor | |
| 32000450 | 32000450 | PRJNA1182301_P_NODE_44018_length_257_cov_1.288043_g43893_i0 | PRJNA1182301 | 44018 | 257 | 1.288043 | 3.31027051 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 125 | 3.5799999999999995e-31 | NR | XP_066823310.1 | 1397322 | g43893 | i0 | 75.3 | 0.992217898832685 | 85 | 19 | 99.2 | 1 | 3 | 257 | 881 | 963 | XP_066823310.1 FAS1 domain-containing protein [Cystobasidium minutum MCA 4210] | diamond | 255 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum |
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);;