contig_metadata
10 rows where analysis = "blastn", 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 |
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);;