contig_metadata
14 rows where bioproject = "PRJNA564810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 554093 | 554093 | PRJNA564810_S_NODE_7681_length_216_cov_1.350993_g7659_i0 | PRJNA564810 | 7681 | 216 | 1.350993 | 2.91814488 | Malassezia restricta | 76775 | Fungi | Fungi | 73.1 | 1.46e-8 | NTclustered | gi|1546633490|ref|XM_027628405.1| | 76775 | g7659 | i0 | 100 | 0.180555555555556 | 39 | 0 | 18 | 0 | 1 | 39 | 229 | 267 | Malassezia restricta uncharacterized protein (MRET_1778), partial mRNA | blastn | 39 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3684972 | 3684972 | PRJNA564810_S_NODE_5263_length_249_cov_1.478261_g5241_i0 | PRJNA564810 | 5263 | 249 | 1.478261 | 3.68086989 | Eukaryota | 2759 | Fungi | Fungi | 121 | 6.09e-23 | NTclustered | gi|2033609165|ref|XM_041390925.1| | 48586 | g5241 | i0 | 79.769 | 7.01204819277108 | 173 | 29 | 68 | 5 | 77 | 246 | 445 | 614 | Suillus subalutaceus V-type ATPase (DFJ58DRAFT_802290), mRNA | blastn | 1746 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus subalutaceus | |
| 4381631 | 4381631 | PRJNA564810_S_NODE_2264_length_325_cov_1.569231_g2242_i0 | PRJNA564810 | 2264 | 325 | 1.569231 | 5.10000075 | Pseudomicrostroma glucosiphilum | 1684307 | Fungi | Fungi | 134 | 1.06e-26 | NTclustered | gi|1418637249|ref|XM_025493162.1| | 1684307 | g2242 | i0 | 86.777 | 0.372307692307692 | 121 | 14 | 37 | 2 | 206 | 325 | 726 | 607 | Pseudomicrostroma glucosiphilum putative 40S ribosomal protein S7 (BCV69DRAFT_284757), mRNA | blastn | 121 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Pseudomicrostroma | Pseudomicrostroma glucosiphilum | ||
| 6932229 | 6932229 | PRJNA564810_S_NODE_7186_length_221_cov_1.743590_g7164_i0 | PRJNA564810 | 7186 | 221 | 1.74359 | 3.8533339 | Phellinidium ferrugineofuscum | 167367 | Fungi | Fungi | 150 | 6.749999999999999e-32 | NTclustered | gi|2452627700|ref|NC_071825.1| | 167367 | g7164 | i0 | 79.63 | 77.7918552036199 | 216 | 38 | 96 | 5 | 1 | 213 | 21715 | 21503 | Phellinidium ferrugineofuscum mitochondrion, complete genome | blastn | 17192 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Phellinidium | Phellinidium ferrugineofuscum | |
| 9482539 | 9482539 | PRJNA564810_S_NODE_1568_length_358_cov_2.290102_g1546_i0 | PRJNA564810 | 1568 | 358 | 2.290102 | 8.19856516 | Malassezia globosa | 76773 | Fungi | Fungi | 383 | 1.0599999999999996e-101 | NTclustered | gi|164662380|ref|XM_001732260.1| | 425265 | g1546 | i0 | 97.748 | 45.2905027932961 | 222 | 5 | 62 | 0 | 115 | 336 | 1377 | 1156 | Malassezia globosa CBS 7966 translation elongation factor EF-1 alpha (MGL_0087), partial mRNA | blastn | 16214 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 12033288 | 12033288 | PRJNA564810_S_NODE_1670_length_352_cov_11.916376_g1648_i0 | PRJNA564810 | 1670 | 352 | 11.916376 | 41.94564352 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 165 | 4.0999999999999995e-36 | NTclustered | gi|1022846989|ref|XM_016421541.1| | 1130832 | g1648 | i0 | 82.888 | 5.39772727272727 | 187 | 28 | 53 | 4 | 146 | 330 | 402 | 218 | Rhodotorula toruloides NP11 60S ribosomal protein l23a (RHTO_07886), partial mRNA | blastn | 1900 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 12033294 | 12033294 | PRJNA564810_S_NODE_3570_length_283_cov_1.752294_g3548_i0 | PRJNA564810 | 3570 | 283 | 1.752294 | 4.95899202 | Malassezia restricta | 76775 | Fungi | Fungi | 414 | 2.89e-111 | NTclustered | gi|1546632884|ref|XM_027628102.1| | 76775 | g3548 | i0 | 95.057 | 0.929328621908127 | 263 | 13 | 93 | 0 | 1 | 263 | 659 | 921 | Malassezia restricta mitochondrial 54S ribosomal protein YmL8 (MRET_1475), partial mRNA | blastn | 263 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14583031 | 14583031 | PRJNA564810_S_NODE_8052_length_212_cov_2.312925_g8030_i0 | PRJNA564810 | 8052 | 212 | 2.312925 | 4.903401 | Malassezia restricta | 76775 | Fungi | Fungi | 387 | 4.5e-103 | NTclustered | gi|1546633932|ref|XM_027628626.1| | 76775 | g8030 | i0 | 99.528 | 1 | 212 | 1 | 100 | 0 | 1 | 212 | 19 | 230 | Malassezia restricta ubiquinol-cytochrome-c reductase complex subunit (QCR10) (MRET_1999), partial mRNA | blastn | 212 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 22231274 | 22231274 | PRJNA564810_S_NODE_6398_length_231_cov_1.801205_g6376_i0 | PRJNA564810 | 6398 | 231 | 1.801205 | 4.16078355 | Malassezia restricta | 76775 | Fungi | Fungi | 239 | 1.48e-58 | NTclustered | gi|1546636739|ref|XM_027630012.1| | 76775 | g6376 | i0 | 99.242 | 0.571428571428571 | 132 | 1 | 57 | 0 | 1 | 132 | 1069 | 1200 | Malassezia restricta lactate 2-monooxygenase (MRET_3385), partial mRNA | blastn | 132 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24780396 | 24780396 | PRJNA564810_S_NODE_2440_length_317_cov_4.857143_g2418_i0 | PRJNA564810 | 2440 | 317 | 4.857143 | 15.39714331 | Melanopsichium pennsylvanicum | 63383 | Fungi | Fungi | 91.6 | 6.29e-14 | NTclustered | gi|673527370|emb|HG529590.1| | 1398559 | g2418 | i0 | 94.828 | 7.66561514195584 | 58 | 3 | 18 | 0 | 259 | 316 | 106879 | 106822 | Melanopsichium pennsylvanicum 4 genomic scaffold, scaffold SCAFFOLD20 | blastn | 2430 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Melanopsichium | Melanopsichium pennsylvanicum | |
| 26712977 | 26712977 | PRJNA564810_S_NODE_3641_length_281_cov_2.018519_g3619_i0 | PRJNA564810 | 3641 | 281 | 2.018519 | 5.67203839 | Fungi | 4751 | Fungi | Fungi | 112 | 2.04e-26 | NR | SAM62041.1 | 307758 | g3619 | i0 | 62.4 | 14.8932384341637 | 93 | 35 | 99.3 | 0 | 2 | 280 | 463 | 555 | SAM62041.1 probable CCT6-component of chaperonin-containing T-complex (zeta subunit) [Ustilago bromivora] | diamond | 4185 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Ustilago | Ustilago bromivora | |
| 27187682 | 27187682 | PRJNA564810_S_NODE_1402_length_369_cov_1.476974_g1380_i0 | PRJNA564810 | 1402 | 369 | 1.476974 | 5.45003406 | Fungi | 4751 | Fungi | Fungi | 56.2 | 2.72e-6 | NR | XP_043014138.1 | 181124 | g1380 | i0 | 47.4 | 2.30081300813008 | 57 | 29 | 46.3 | 1 | 2 | 172 | 408 | 463 | XP_043014138.1 uncharacterized protein E1B28_004994 [Marasmius oreades] | diamond | 849 | 56.6 | 0.992932862190813 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius oreades | |
| 27693573 | 27693573 | PRJNA564810_S_NODE_7744_length_215_cov_3.066667_g7722_i0 | PRJNA564810 | 7744 | 215 | 3.066667 | 6.59333405 | Eukaryota | 2759 | Fungi | Fungi | 54.7 | 2.45e-7 | NR | XP_001732053.1 | 425265 | g7722 | i0 | 41.8 | 2.72093023255814 | 67 | 38 | 93.5 | 1 | 206 | 6 | 11 | 76 | XP_001732053.1 uncharacterized protein MGL_0646 [Malassezia globosa CBS 7966] | diamond | 585 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 32905486 | 32905486 | PRJNA564810_S_NODE_3780_length_278_cov_2.103286_g3758_i0 | PRJNA564810 | 3780 | 278 | 2.103286 | 5.84713508 | Sporobolomyces | 5429 | Fungi | Fungi | 75.5 | 1.71e-13 | NR | GAA6020773.1 | 183961 | g3758 | i0 | 45.6 | 6.52877697841727 | 90 | 47 | 96 | 2 | 277 | 11 | 484 | 572 | GAA6020773.1 hypothetical protein JCM11491_003527 [Sporobolomyces phaffii] | diamond | 1815 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces phaffii |
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);;