contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA554794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3071841 | 3071841 | PRJNA554794_P_NODE_16323_length_209_cov_2.356250_g12394_i0 | PRJNA554794 | 16323 | 209 | 2.35625 | 4.9245625 | Malassezia restricta | 76775 | Fungi | Fungi | 368 | 1.5999999999999996e-97 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12394 | i0 | 98.565 | 105.846889952153 | 209 | 2 | 100 | 1 | 1 | 209 | 2992 | 3199 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 22122 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3071870 | 3071870 | PRJNA554794_P_NODE_22703_length_167_cov_0.864407_g18774_i0 | PRJNA554794 | 22703 | 167 | 0.864407 | 1.44355969 | Malassezia japonica | 223818 | Fungi | Fungi | 309 | 7.53e-80 | NTclustered | gi|2594586012|ref|XM_060263979.1| | 223818 | g18774 | i0 | 100 | 4.22155688622755 | 167 | 0 | 100 | 0 | 1 | 167 | 876 | 1042 | Malassezia japonica electron-transferring-flavoprotein dehydrogenase (MJAP1_000006), partial mRNA | blastn | 705 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 4347976 | 4347976 | PRJNA554794_P_NODE_11224_length_325_cov_1.626812_g7298_i0 | PRJNA554794 | 11224 | 325 | 1.626812 | 5.287139 | Malassezia japonica | 223818 | Fungi | Fungi | 588 | 1.88e-163 | NTclustered | gi|1102644830|gb|KY108400.1| | 223818 | g7298 | i0 | 99.383 | 96.0153846153846 | 324 | 2 | 99 | 0 | 2 | 325 | 625 | 302 | Malassezia japonica culture CBS:9432 large subunit ribosomal RNA gene, partial sequence | blastn | 31205 | 588 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 4348048 | 4348048 | PRJNA554794_P_NODE_24024_length_163_cov_0.877193_g20095_i0 | PRJNA554794 | 24024 | 163 | 0.877193 | 1.42982459 | Malassezia restricta | 76775 | Fungi | Fungi | 296 | 5.68e-76 | NTclustered | gi|1546631850|ref|XM_027627585.1| | 76775 | g20095 | i0 | 99.387 | 18.760736196319 | 163 | 1 | 100 | 0 | 1 | 163 | 3150 | 3312 | Malassezia restricta midasin (MRET_0958), partial mRNA | blastn | 3058 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6898854 | 6898854 | PRJNA554794_P_NODE_24686_length_161_cov_0.901786_g20757_i0 | PRJNA554794 | 24686 | 161 | 0.901786 | 1.45187546 | Malassezia restricta | 76775 | Fungi | Fungi | 298 | 1.56e-76 | NTclustered | gi|1546637759|ref|XM_027630521.1| | 76775 | g20757 | i0 | 100 | 1 | 161 | 0 | 100 | 0 | 1 | 161 | 735 | 575 | Malassezia restricta chitin synthase (MRET_3894), partial mRNA | blastn | 161 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8173698 | 8173698 | PRJNA554794_P_NODE_23147_length_165_cov_0.879310_g19218_i0 | PRJNA554794 | 23147 | 165 | 0.87931 | 1.4508615 | Malassezia restricta | 76775 | Fungi | Fungi | 300 | 4.46e-77 | NTclustered | gi|1546633392|ref|XM_027628356.1| | 76775 | g19218 | i0 | 99.394 | 1 | 165 | 1 | 100 | 0 | 1 | 165 | 3293 | 3129 | Malassezia restricta map microtubule affinity-regulating kinase (MRET_1729), partial mRNA | blastn | 165 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9449335 | 9449335 | PRJNA554794_P_NODE_24528_length_161_cov_0.982143_g20599_i0 | PRJNA554794 | 24528 | 161 | 0.982143 | 1.58125023 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 154 | 3.5600000000000004e-33 | NTclustered | gi|1423578170|ref|XM_025740577.1| | 58919 | g20599 | i0 | 86.62 | 31.7204968944099 | 142 | 15 | 87 | 3 | 1 | 140 | 1414 | 1275 | Tilletiopsis washingtonensis translation elongation factor 1a (FA09DRAFT_308338), mRNA | blastn | 5107 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 10051781 | 10051781 | PRJNA554794_P_NODE_12808_length_264_cov_1.265116_g8879_i0 | PRJNA554794 | 12808 | 264 | 1.265116 | 3.33990624 | Trichosporonaceae | 1759442 | Fungi | Fungi | 161 | 3.84e-35 | NTclustered | gi|1607500194|ref|XM_028621581.1| | 105984 | g8879 | i0 | 78.992 | 33.094696969697 | 238 | 48 | 90 | 2 | 25 | 261 | 17 | 253 | Apiotrichum porosum uncharacterized protein (EHS24_006108), partial mRNA | blastn | 8737 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 10052369 | 10052369 | PRJNA554794_P_NODE_9688_length_420_cov_1.072776_g5840_i0 | PRJNA554794 | 9688 | 420 | 1.072776 | 4.5056592 | Basidiomycota | 5204 | Fungi | Fungi | 300 | 1.31e-76 | NTclustered | gi|1928140042|gb|MN901695.1| | 215253 | g5840 | i0 | 81.522 | 84.6690476190476 | 368 | 64 | 87 | 4 | 11 | 376 | 1073 | 708 | Meira geulakonigae strain XZ114F4 translation elongation factor 1-alpha (tef1) gene, partial cds | blastn | 35561 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira geulakonigae | |
| 10725105 | 10725105 | PRJNA554794_P_NODE_24209_length_162_cov_0.902655_g20280_i0 | PRJNA554794 | 24209 | 162 | 0.902655 | 1.4623011 | Malassezia globosa | 76773 | Fungi | Fungi | 102 | 1.32e-17 | NTclustered | gi|164656325|ref|XM_001729239.1| | 425265 | g20280 | i0 | 100 | 0.339506172839506 | 55 | 0 | 34 | 0 | 108 | 162 | 1 | 55 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3758), partial mRNA | blastn | 55 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 11999818 | 11999818 | PRJNA554794_P_NODE_14770_length_215_cov_1.030120_g10841_i0 | PRJNA554794 | 14770 | 215 | 1.03012 | 2.214758 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 121 | 5.1199999999999996e-23 | NTclustered | gi|955488450|ref|XM_014800345.1| | 84753 | g10841 | i0 | 78.534 | 17.3023255813953 | 191 | 35 | 87 | 6 | 28 | 215 | 354 | 167 | Moesziomyces antarcticus 60S ribosomal protein L3 (PAN0_011d4375), partial mRNA | blastn | 3720 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 14549962 | 14549962 | PRJNA554794_P_NODE_22472_length_168_cov_1.184874_g18543_i0 | PRJNA554794 | 22472 | 168 | 1.184874 | 1.99058832 | Epithele typhae | 378194 | Fungi | Fungi | 126 | 8.2e-25 | NTclustered | gi|2234730693|ref|XM_048014543.1| | 378194 | g18543 | i0 | 87.85 | 54.7380952380952 | 107 | 13 | 64 | 0 | 62 | 168 | 560 | 454 | Epithele typhae actin 1 (BXZ73DRAFT_100304), partial mRNA | blastn | 9196 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Epitheliaceae | Epithele | Epithele typhae | |
| 15823694 | 15823694 | PRJNA554794_P_NODE_22493_length_168_cov_0.806723_g18564_i0 | PRJNA554794 | 22493 | 168 | 0.806723 | 1.35529464 | Wallemia ichthyophaga | 245174 | Fungi | Fungi | 147 | 6.289999999999999e-31 | NTclustered | gi|685945649|ref|XM_009269144.1| | 1299270 | g18564 | i0 | 83.766 | 8.77380952380952 | 154 | 25 | 92 | 0 | 1 | 154 | 2297 | 2144 | Wallemia ichthyophaga EXF-994 Elongation factor 2 (J056_003935), partial mRNA | blastn | 1474 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia ichthyophaga | |
| 18372697 | 18372697 | PRJNA554794_P_NODE_24775_length_161_cov_0.892857_g20846_i0 | PRJNA554794 | 24775 | 161 | 0.892857 | 1.43749977 | Malassezia restricta | 76775 | Fungi | Fungi | 298 | 1.56e-76 | NTclustered | gi|1546631183|ref|XM_027627252.1| | 76775 | g20846 | i0 | 100 | 1 | 161 | 0 | 100 | 0 | 1 | 161 | 1579 | 1419 | Malassezia restricta transcription initiation factor TFIID subunit 6 (MRET_0625), partial mRNA | blastn | 161 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18974707 | 18974707 | PRJNA554794_P_NODE_12315_length_279_cov_1.426087_g8386_i0 | PRJNA554794 | 12315 | 279 | 1.426087 | 3.97878273 | Opisthokonta | 33154 | Fungi | Fungi | 514 | 2.73e-141 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g8386 | i0 | 100 | 99.5555555555556 | 278 | 0 | 99 | 0 | 1 | 278 | 251 | 528 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 27776 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20923123 | 20923123 | PRJNA554794_P_NODE_24817_length_161_cov_0.866071_g20888_i0 | PRJNA554794 | 24817 | 161 | 0.866071 | 1.39437431 | Malassezia restricta | 76775 | Fungi | Fungi | 298 | 1.56e-76 | NTclustered | gi|1546634620|ref|XM_027628970.1| | 76775 | g20888 | i0 | 100 | 1 | 161 | 0 | 100 | 0 | 1 | 161 | 3069 | 2909 | Malassezia restricta DNA polymerase epsilon subunit 1 (MRET_2343), partial mRNA | blastn | 161 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24747151 | 24747151 | PRJNA554794_P_NODE_21040_length_185_cov_2.477941_g17111_i0 | PRJNA554794 | 21040 | 185 | 2.477941 | 4.58419085 | Vanrija albida | 181172 | Fungi | Fungi | 137 | 4.24e-28 | NTclustered | gi|2837703642|ref|XM_069349283.1| | 181172 | g17111 | i0 | 80.108 | 5.11891891891892 | 186 | 35 | 100 | 2 | 1 | 185 | 186 | 2 | Vanrija albida 40S ribosomal protein eS6 (RPS6), partial mRNA | blastn | 947 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija albida |
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);;