contig_metadata
9 rows where bioproject = "PRJNA749559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1199842 | 1199842 | PRJNA749559_P_NODE_5161_length_193_cov_2.340909_g5091_i0 | PRJNA749559 | 5161 | 193 | 2.340909 | 4.51795437 | Malassezia | 55193 | Fungi | Fungi | 357 | 3.1499999999999996e-94 | NTclustered | gi|1101565660|gb|KX839636.1| | 55194 | g5091 | i0 | 100 | 100 | 193 | 0 | 100 | 0 | 1 | 193 | 63 | 255 | Malassezia furfur isolate GDMUZJ2015102 26S ribosomal RNA gene, partial sequence | blastn | 19300 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 8379276 | 8379276 | PRJNA749559_P_NODE_4427_length_206_cov_2.413793_g4357_i0 | PRJNA749559 | 4427 | 206 | 2.413793 | 4.9724135800000004 | Filobasidium floriforme | 5210 | Fungi | Fungi | 126 | 1.05e-24 | NTclustered | gi|2185522900|ref|XM_046184655.1| | 5210 | g4357 | i0 | 83.212 | 8.09708737864078 | 137 | 23 | 67 | 0 | 13 | 149 | 621 | 757 | Filobasidium floriforme 60s ribosomal protein l11 (HD553DRAFT_99389), mRNA | blastn | 1668 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 9654423 | 9654423 | PRJNA749559_P_NODE_2848_length_256_cov_3.928205_g2778_i0 | PRJNA749559 | 2848 | 256 | 3.928205 | 10.0562048 | Malassezia restricta | 76775 | Fungi | Fungi | 473 | 4.189999999999999e-129 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g2778 | i0 | 100 | 101.1875 | 256 | 0 | 100 | 0 | 1 | 256 | 1738 | 1483 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 25904 | 473 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10929924 | 10929924 | PRJNA749559_P_NODE_4449_length_206_cov_0.882759_g4379_i0 | PRJNA749559 | 4449 | 206 | 0.882759 | 1.81848354 | Malassezia restricta | 76775 | Fungi | Fungi | 348 | 2.05e-91 | NTclustered | gi|1546632388|ref|XM_027627854.1| | 76775 | g4379 | i0 | 97.087 | 1.61650485436893 | 206 | 6 | 100 | 0 | 1 | 206 | 1760 | 1965 | Malassezia restricta DNA polymerase zeta (MRET_1227), partial mRNA | blastn | 333 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12205405 | 12205405 | PRJNA749559_P_NODE_4130_length_209_cov_0.864865_g4060_i0 | PRJNA749559 | 4130 | 209 | 0.864865 | 1.80756785 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 372 | 1.24e-98 | NTclustered | gi|2692937071|ref|NC_086476.1| | 1514897 | g4060 | i0 | 99.034 | 89.6315789473684 | 207 | 2 | 99 | 0 | 1 | 207 | 33459 | 33665 | Malassezia arunalokei culture CBS:13387 strain CBS13387 mitochondrion, complete genome | blastn | 18733 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 13479769 | 13479769 | PRJNA749559_P_NODE_2131_length_299_cov_1.050420_g2061_i0 | PRJNA749559 | 2131 | 299 | 1.05042 | 3.1407558 | Auricularia auricula-judae | 29892 | Fungi | Fungi | 492 | 1.3799999999999996e-134 | NTclustered | gi|363987639|gb|JN712676.1| | 29892 | g2061 | i0 | 96.321 | 104.056856187291 | 299 | 11 | 100 | 0 | 1 | 299 | 4120 | 3822 | Auricularia auricula-judae strain AU110 18S ribosomal RNA gene, partial sequence; internal transcribed spacer, 28S ribosomal RNA gene, intergenic spacer 1, and 5S ribosomal RNA gene, complete sequence; and intergenic spacer 2, partial sequence | blastn | 31113 | 492 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia auricula-judae | |
| 17304039 | 17304039 | PRJNA749559_P_NODE_2794_length_259_cov_3.015152_g2724_i0 | PRJNA749559 | 2794 | 259 | 3.015152 | 7.80924368 | Malassezia restricta | 76775 | Fungi | Fungi | 316 | 7.58e-82 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g2724 | i0 | 89.615 | 67.2625482625483 | 260 | 12 | 100 | 11 | 1 | 259 | 3041 | 3286 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 17421 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17304070 | 17304070 | PRJNA749559_P_NODE_5074_length_201_cov_0.878571_g5004_i0 | PRJNA749559 | 5074 | 201 | 0.878571 | 1.76592771 | Malassezia globosa | 76773 | Fungi | Fungi | 361 | 2.5599999999999998e-95 | NTclustered | gi|164661484|ref|XM_001731813.1| | 425265 | g5004 | i0 | 99.005 | 1 | 201 | 2 | 100 | 0 | 1 | 201 | 3210 | 3410 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_1133), partial mRNA | blastn | 201 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 23678923 | 23678923 | PRJNA749559_P_NODE_2719_length_263_cov_1.267327_g2649_i0 | PRJNA749559 | 2719 | 263 | 1.267327 | 3.33307001 | Geastrum sp. 1 GMB-2014 | 1589092 | Fungi | Fungi | 128 | 3.88e-25 | NTclustered | gi|757958342|gb|KP012757.1| | 1589092 | g2649 | i0 | 90.722 | 36.361216730038 | 97 | 8 | 37 | 1 | 1 | 97 | 533 | 628 | Geastrum sp. 1 GMB-2014 voucher MEL:2382886 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9563 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Geastrales | Geastraceae | Geastrum | Geastrum sp. 1 GMB-2014 |
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);;