contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2962565 | 2962565 | PRJNA395690_P_NODE_5123_length_352_cov_1.009901_g4974_i0 | PRJNA395690 | 5123 | 352 | 1.009901 | 3.55485152 | Ustilago esculenta | 185366 | Fungi | Fungi | 180 | 4.879999999999999e-54 | NR | WNR50574.1 | 185366 | g4974 | i0 | 72.1 | 3.78409090909091 | 111 | 31 | 94.6 | 0 | 350 | 18 | 166 | 276 | WNR50574.1 cytochrome c oxidase subunit 3 [Ustilago esculenta] | diamond | 1332 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Ustilago | Ustilago esculenta | |
| 14440747 | 14440747 | PRJNA395690_P_NODE_7452_length_296_cov_0.825911_g7300_i0 | PRJNA395690 | 7452 | 296 | 0.825911 | 2.44469656 | Malassezia cuniculi | 948313 | Fungi | Fungi | 130 | 6.19e-33 | NR | YP_011037156.1 | 948313 | g7300 | i0 | 65.3 | 0.993243243243243 | 98 | 34 | 99.3 | 0 | 294 | 1 | 389 | 486 | YP_011037156.1 NADH dehydrogenase subunit 5 [Malassezia cuniculi] | diamond | 294 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 20813249 | 20813249 | PRJNA395690_P_NODE_21377_length_183_cov_1.649254_g21225_i0 | PRJNA395690 | 21377 | 183 | 1.649254 | 3.01813482 | Coprinellus aureogranulatus | 752674 | Fungi | Fungi | 59.7 | 1.73e-8 | NR | KAJ3540068.1 | 752674 | g21225 | i0 | 40 | 1.9672131147541 | 60 | 36 | 98.4 | 0 | 2 | 181 | 1095 | 1154 | KAJ3540068.1 hypothetical protein NMY22_g4458 [Coprinellus aureogranulatus] | diamond | 360 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus aureogranulatus | |
| 24638026 | 24638026 | PRJNA395690_P_NODE_26300_length_171_cov_2.401639_g26148_i0 | PRJNA395690 | 26300 | 171 | 2.401639 | 4.10680269 | Malassezia caprae | 1381934 | Fungi | Fungi | 67.8 | 2.13e-11 | NR | WFD18012.1 | 1381934 | g26148 | i0 | 66.1 | 0.982456140350877 | 56 | 19 | 98.2 | 0 | 1 | 168 | 1006 | 1061 | WFD18012.1 hypothetical protein MCAP1_000224 [Malassezia caprae] | diamond | 168 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia caprae | |
| 27391599 | 27391599 | PRJNA395690_P_NODE_34683_length_162_cov_0.902655_g34531_i0 | PRJNA395690 | 34683 | 162 | 0.902655 | 1.4623011 | Plicaturopsis crispa FD-325 SS-3 | 944288 | Fungi | Fungi | 48.9 | 8.19e-5 | NR | KII83760.1 | 944288 | g34531 | i0 | 41.7 | 1.85185185185185 | 48 | 28 | 88.9 | 0 | 12 | 155 | 362 | 409 | KII83760.1 hypothetical protein PLICRDRAFT_119100 [Plicaturopsis crispa FD-325 SS-3] | diamond | 300 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Amylocorticiales | Amylocorticiaceae | Plicatura | Plicatura crispa | |
| 27896495 | 27896495 | PRJNA395690_P_NODE_28005_length_167_cov_1.720339_g27853_i0 | PRJNA395690 | 28005 | 167 | 1.720339 | 2.87296613 | Cutaneotrichosporon spelunceum | 1672016 | Fungi | Fungi | 88.2 | 1.29e-18 | NR | GMK57217.1 | 1672016 | g27853 | i0 | 72.7 | 1.97604790419162 | 55 | 15 | 98.8 | 0 | 165 | 1 | 990 | 1044 | GMK57217.1 hypothetical protein CspeluHIS016_0400510 [Cutaneotrichosporon spelunceum] | diamond | 330 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon spelunceum | |
| 28797215 | 28797215 | PRJNA395690_P_NODE_26227_length_172_cov_1.138211_g26075_i0 | PRJNA395690 | 26227 | 172 | 1.138211 | 1.95772292 | Microbotryomycetes | 162481 | Fungi | Fungi | 67 | 3.81e-11 | NR | KAK4335605.1 | 5286 | g26075 | i0 | 70.9 | 17.2848837209302 | 55 | 16 | 95.9 | 0 | 3 | 167 | 18 | 72 | KAK4335605.1 putative histone H3 (putative) [Rhodotorula toruloides] | diamond | 2973 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 28938663 | 28938663 | PRJNA395690_P_NODE_4608_length_369_cov_1.753125_g4459_i0 | PRJNA395690 | 4608 | 369 | 1.753125 | 6.46903125 | Rhodotorula diobovata | 5288 | Fungi | Fungi | 49.7 | 1.04e-4 | NR | TNY20005.1 | 5288 | g4459 | i0 | 66.7 | 0.658536585365854 | 81 | 27 | 65.9 | 0 | 1 | 243 | 38 | 118 | TNY20005.1 60S acidic ribosomal protein P2 [Rhodotorula diobovata] | diamond | 243 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata | |
| 30075234 | 30075234 | PRJNA395690_P_NODE_36932_length_155_cov_2.830189_g36779_i0 | PRJNA395690 | 36932 | 155 | 2.830189 | 4.38679295 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 68.6 | 8.73e-12 | NR | AUN28153.1 | 77020 | g36779 | i0 | 78 | 0.793548387096774 | 41 | 9 | 79.4 | 0 | 2 | 124 | 465 | 505 | AUN28153.1 NADH dehydrogenase subunit 4 [Malassezia pachydermatis] | diamond | 123 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 30233340 | 30233340 | PRJNA395690_P_NODE_34192_length_162_cov_1.637168_g34040_i0 | PRJNA395690 | 34192 | 162 | 1.637168 | 2.65221216 | Trichosporon asahii var. asahii CBS 89 | 82508 | Fungi | Fungi | 99 | 4.019999999999999e-23 | NR | EKD04446.1 | 1220162 | g34040 | i0 | 97.8 | 0.833333333333333 | 45 | 1 | 83.3 | 0 | 27 | 161 | 93 | 137 | EKD04446.1 hypothetical protein A1Q2_01222 [Trichosporon asahii var. asahii CBS 8904] | diamond | 135 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 30328652 | 30328652 | PRJNA395690_P_NODE_20352_length_186_cov_1.175182_g20200_i0 | PRJNA395690 | 20352 | 186 | 1.175182 | 2.18583852 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 118 | 1.06e-30 | NR | SHO78670.1 | 1230383 | g20200 | i0 | 98.4 | 0.983870967741935 | 61 | 1 | 98.4 | 0 | 184 | 2 | 211 | 271 | SHO78670.1 Similar to S.cerevisiae protein YPL199C (Putative protein of unknown function) [Malassezia sympodialis ATCC 42132] | diamond | 183 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 30755674 | 30755674 | PRJNA395690_P_NODE_13514_length_221_cov_2.075581_g13362_i0 | PRJNA395690 | 13514 | 221 | 2.075581 | 4.58703401 | Cryptococcus | 5206 | Fungi | Fungi | 43.9 | 0.00442 | NR | XP_570598.2 | 214684 | g13362 | i0 | 53.5 | 5.83710407239819 | 43 | 20 | 58.4 | 0 | 10 | 138 | 86 | 128 | XP_570598.2 structural constituent of ribosome, putative [Cryptococcus neoformans var. neoformans JEC21] | diamond | 1290 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus deneoformans | |
| 30865179 | 30865179 | PRJNA395690_P_NODE_34694_length_162_cov_0.902655_g34542_i0 | PRJNA395690 | 34694 | 162 | 0.902655 | 1.4623011 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 52 | 6.56e-6 | NR | CAD6564591.1 | 2778381 | g34542 | i0 | 54.5 | 0.814814814814815 | 44 | 20 | 81.5 | 0 | 11 | 142 | 299 | 342 | CAD6564591.1 MAG: hypothetical protein CYPHOPRED_004103 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 132 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 30881943 | 30881943 | PRJNA395690_P_NODE_5474_length_342_cov_1.723549_g5324_i0 | PRJNA395690 | 5474 | 342 | 1.723549 | 5.89453758 | Eukaryota | 2759 | Fungi | Fungi | 124 | 2.8399999999999997e-31 | NR | KAI8461260.1 | 170000 | g5324 | i0 | 60.8 | 4.57017543859649 | 102 | 40 | 89.5 | 0 | 340 | 35 | 107 | 208 | KAI8461260.1 ribosomal protein L4 domain-containing protein [Phakopsora pachyrhizi] | diamond | 1563 | 125 | 0.992 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 31117763 | 31117763 | PRJNA395690_P_NODE_34395_length_162_cov_0.902655_g34243_i0 | PRJNA395690 | 34395 | 162 | 0.902655 | 1.4623011 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 97.8 | 2.13e-23 | NR | XP_066822806.1 | 1397322 | g34243 | i0 | 94.1 | 6.68518518518519 | 51 | 3 | 94.4 | 0 | 160 | 8 | 103 | 153 | XP_066822806.1 60S ribosomal protein eL6 [Cystobasidium minutum MCA 4210] | diamond | 1083 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 31339229 | 31339229 | PRJNA395690_P_NODE_26296_length_171_cov_2.434426_g26144_i0 | PRJNA395690 | 26296 | 171 | 2.434426 | 4.16286846 | Malassezia obtusa | 76774 | Fungi | Fungi | 80.9 | 5.02e-16 | NR | WFD03302.1 | 76774 | g26144 | i0 | 67.3 | 0.964912280701754 | 55 | 18 | 96.5 | 0 | 169 | 5 | 1363 | 1417 | WFD03302.1 hypothetical protein MOBT1_001991 [Malassezia obtusa] | diamond | 165 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa | |
| 32083610 | 32083610 | PRJNA395690_P_NODE_30998_length_165_cov_0.879310_g30846_i0 | PRJNA395690 | 30998 | 165 | 0.87931 | 1.4508615 | Agaricomycetes | 155619 | Fungi | Fungi | 65.5 | 1.21e-10 | NR | TEB36730.1 | 71717 | g30846 | i0 | 66.7 | 10.1090909090909 | 45 | 15 | 81.8 | 0 | 146 | 12 | 410 | 454 | TEB36730.1 ATP-dependent RNA helicase dbp9 [Coprinellus micaceus] | diamond | 1668 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus micaceus | |
| 32573356 | 32573356 | PRJNA395690_P_NODE_30579_length_165_cov_1.543103_g30427_i0 | PRJNA395690 | 30579 | 165 | 1.543103 | 2.54611995 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 109 | 1.54e-26 | NR | KWU45362.1 | 1305733 | g30427 | i0 | 100 | 0.981818181818182 | 54 | 0 | 98.2 | 0 | 163 | 2 | 369 | 422 | KWU45362.1 NADH oxidase [Rhodotorula sp. JG-1b] | diamond | 162 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b |
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);;