contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA235310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 367360 | 367360 | PRJNA235310_P_NODE_2961_length_221_cov_1.697674_g2935_i0 | PRJNA235310 | 2961 | 221 | 1.697674 | 3.75185954 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 139 | 1.46e-28 | NTclustered | gi|1418948054|ref|XM_025522858.1| | 215250 | g2935 | i0 | 81.818 | 8.1131221719457 | 165 | 30 | 75 | 0 | 5 | 169 | 166 | 330 | Acaromyces ingoldii dihydrolipoyl dehydrogenase (FA10DRAFT_269719), mRNA | blastn | 1793 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 1642181 | 1642181 | PRJNA235310_P_NODE_5202_length_168_cov_0.873950_g5176_i0 | PRJNA235310 | 5202 | 168 | 0.87395 | 1.468236 | Malassezia japonica | 223818 | Fungi | Fungi | 52.8 | 0.014 | NTclustered | gi|2594586290|ref|XM_060264118.1| | 223818 | g5176 | i0 | 100 | 0.333333333333333 | 28 | 0 | 17 | 0 | 27 | 54 | 2165 | 2138 | Malassezia japonica uncharacterized protein (MJAP1_000146), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 2917989 | 2917989 | PRJNA235310_P_NODE_4383_length_178_cov_1.573643_g4357_i0 | PRJNA235310 | 4383 | 178 | 1.573643 | 2.80108454 | Trametes versicolor | 5325 | Fungi | Fungi | 82.4 | 1.92e-11 | NTclustered | gi|636603070|ref|XM_008034479.1| | 717944 | g4357 | i0 | 82.796 | 1.21348314606742 | 93 | 14 | 52 | 2 | 2 | 93 | 1012 | 1103 | Trametes versicolor FP-101664 SS1 Calreticulin-domain-containing protein (TRAVEDRAFT_110458), partial mRNA | blastn | 216 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes versicolor | |
| 4194472 | 4194472 | PRJNA235310_P_NODE_4604_length_174_cov_0.992000_g4578_i0 | PRJNA235310 | 4604 | 174 | 0.992 | 1.72608 | Mixia osmundae | 34349 | Fungi | Fungi | 86.1 | 1.44e-12 | NTclustered | gi|953448238|ref|XM_014712186.1| | 764103 | g4578 | i0 | 85.542 | 35.683908045977 | 83 | 10 | 47 | 2 | 93 | 174 | 503 | 422 | Mixia osmundae IAM 14324 uncharacterized protein (L969DRAFT_88566), mRNA | blastn | 6209 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Mixiomycetes | Mixiales | Mixiaceae | Mixia | Mixia osmundae | |
| 4884603 | 4884603 | PRJNA235310_P_NODE_3904_length_191_cov_1.288732_g3878_i0 | PRJNA235310 | 3904 | 191 | 1.288732 | 2.46147812 | Trichosporonaceae | 1759442 | Fungi | Fungi | 78.7 | 2.71e-10 | NTclustered | gi|1607512182|ref|XM_028622984.1| | 105984 | g3878 | i0 | 97.778 | 0.471204188481675 | 45 | 1 | 24 | 0 | 1 | 45 | 448 | 492 | Apiotrichum porosum GTP-binding protein of the rab (YPT1), partial mRNA | blastn | 90 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 4884605 | 4884605 | PRJNA235310_P_NODE_4344_length_179_cov_1.884615_g4318_i0 | PRJNA235310 | 4344 | 179 | 1.884615 | 3.37346085 | Malassezia | 55193 | Fungi | Fungi | 331 | 1.74e-86 | NTclustered | gi|1101565660|gb|KX839636.1| | 55194 | g4318 | i0 | 100 | 100 | 179 | 0 | 100 | 0 | 1 | 179 | 82 | 260 | Malassezia furfur isolate GDMUZJ2015102 26S ribosomal RNA gene, partial sequence | blastn | 17900 | 331 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 8020758 | 8020758 | PRJNA235310_P_NODE_2907_length_224_cov_0.891429_g2881_i0 | PRJNA235310 | 2907 | 224 | 0.891429 | 1.99680096 | Melanopsichium pennsylvanicum | 63383 | Fungi | Fungi | 119 | 1.9300000000000001e-22 | NTclustered | gi|673525158|emb|HG529513.1| | 1398559 | g2881 | i0 | 77.5 | 5.83482142857143 | 200 | 43 | 89 | 2 | 26 | 224 | 13190 | 12992 | Melanopsichium pennsylvanicum 4 genomic scaffold, scaffold SCAFFOLD39 | blastn | 1307 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Melanopsichium | Melanopsichium pennsylvanicum | |
| 10571464 | 10571464 | PRJNA235310_P_NODE_6189_length_163_cov_0.912281_g6163_i0 | PRJNA235310 | 6189 | 163 | 0.912281 | 1.48701803 | Cutaneotrichosporon oleaginosum | 879819 | Fungi | Fungi | 150 | 4.68e-32 | NTclustered | gi|2741444616|ref|XM_018422823.2| | 879819 | g6163 | i0 | 83.333 | 26.2699386503067 | 162 | 27 | 99 | 0 | 1 | 162 | 603 | 442 | Cutaneotrichosporon oleaginosum uncharacterized protein (COLE_00655), partial mRNA | blastn | 4282 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum | |
| 15084205 | 15084205 | PRJNA235310_P_NODE_6012_length_164_cov_0.904348_g5986_i0 | PRJNA235310 | 6012 | 164 | 0.904348 | 1.48313072 | Basidiomycota | 5204 | Fungi | Fungi | 147 | 6.109999999999999e-31 | NTclustered | gi|1063854136|ref|XM_018137186.1| | 77020 | g5986 | i0 | 88.983 | 48.7256097560976 | 118 | 13 | 72 | 0 | 1 | 118 | 947 | 830 | Malassezia pachydermatis heat shock protein 90 (Malapachy_2698), partial mRNA | blastn | 7991 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 16944670 | 16944670 | PRJNA235310_P_NODE_4234_length_182_cov_1.496241_g4208_i0 | PRJNA235310 | 4234 | 182 | 1.496241 | 2.72315862 | Filobasidium floriforme | 5210 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|2185537628|ref|XM_046180870.1| | 5210 | g4208 | i0 | 100 | 0.159340659340659 | 29 | 0 | 16 | 0 | 34 | 62 | 1267 | 1239 | Filobasidium floriforme uncharacterized protein (HD553DRAFT_318433), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 18219044 | 18219044 | PRJNA235310_P_NODE_3835_length_193_cov_1.104167_g3809_i0 | PRJNA235310 | 3835 | 193 | 1.104167 | 2.13104231 | Stereum hirsutum | 40492 | Fungi | Fungi | 182 | 2.03e-41 | NTclustered | gi|597903735|ref|XM_007299105.1| | 721885 | g3809 | i0 | 83.938 | 91.1088082901554 | 193 | 27 | 99 | 4 | 3 | 193 | 1927 | 2117 | Stereum hirsutum FP-91666 SS1 pectin lyase-like protein (STEHIDRAFT_136613), partial mRNA | blastn | 17584 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Stereum | Stereum hirsutum | |
| 18908083 | 18908083 | PRJNA235310_P_NODE_1015_length_396_cov_8.412104_g989_i0 | PRJNA235310 | 1015 | 396 | 8.412104 | 33.31193184 | Fungi | 4751 | Fungi | Fungi | 217 | 1.27e-51 | NTclustered | gi|1607527352|ref|XM_028624905.1| | 105984 | g989 | i0 | 82.591 | 64.7373737373737 | 247 | 41 | 62 | 2 | 95 | 340 | 1992 | 1747 | Apiotrichum porosum uncharacterized protein (EHS24_009635), partial mRNA | blastn | 25636 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 25282723 | 25282723 | PRJNA235310_P_NODE_200_length_731_cov_2.111437_g180_i0 | PRJNA235310 | 200 | 731 | 2.111437 | 15.43460447 | Eukaryota | 2759 | Fungi | Fungi | 333 | 2.33e-86 | NTclustered | gi|2234846081|ref|XM_047889590.1| | 181762 | g180 | i0 | 77.951 | 51.5608755129959 | 576 | 98 | 77 | 26 | 169 | 731 | 1865 | 1306 | Psilocybe cubensis uncharacterized protein (JR316_0003820), partial mRNA | blastn | 37691 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cubensis |
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);;