contig_metadata
9 rows where bioproject = "PRJNA1168532" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 315186 | 315186 | PRJNA1168532_S_NODE_109681_length_307_cov_1.431818_g106738_i0 | PRJNA1168532 | 109681 | 307 | 1.431818 | 4.39568126 | Malassezia restricta | 76775 | Fungi | Fungi | 568 | 2.3e-157 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g106738 | i0 | 100 | 103.657980456026 | 307 | 0 | 100 | 0 | 1 | 307 | 1499 | 1805 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 31823 | 568 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 1589878 | 1589878 | PRJNA1168532_S_NODE_360382_length_150_cov_1.355140_g357439_i0 | PRJNA1168532 | 360382 | 150 | 1.35514 | 2.03271 | Malassezia restricta | 76775 | Fungi | Fungi | 278 | 1.85e-70 | NTclustered | gi|1546632534|ref|XM_027627927.1| | 76775 | g357439 | i0 | 100 | 1 | 150 | 0 | 100 | 0 | 1 | 150 | 614 | 763 | Malassezia restricta cysteine-rich secretory protein (MRET_1300), partial mRNA | blastn | 150 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 15617958 | 15617958 | PRJNA1168532_S_NODE_252473_length_189_cov_1.431507_g249530_i0 | PRJNA1168532 | 252473 | 189 | 1.431507 | 2.70554823 | Malassezia restricta | 76775 | Fungi | Fungi | 350 | 5.14e-92 | NTclustered | gi|1546630879|ref|XM_027627100.1| | 76775 | g249530 | i0 | 100 | 1 | 189 | 0 | 100 | 0 | 1 | 189 | 1195 | 1383 | Malassezia restricta uncharacterized protein (MRET_0473), partial mRNA | blastn | 189 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17618027 | 17618027 | PRJNA1168532_S_NODE_192634_length_224_cov_1.944751_g189691_i0 | PRJNA1168532 | 192634 | 224 | 1.944751 | 4.35624224 | Malassezia | 55193 | Fungi | Fungi | 409 | 1.03e-109 | NTclustered | gi|915512619|gb|KP825402.1| | 76775 | g189691 | i0 | 99.554 | 99.3839285714286 | 224 | 1 | 100 | 0 | 1 | 224 | 248 | 25 | Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence | blastn | 22262 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18166805 | 18166805 | PRJNA1168532_S_NODE_321195_length_161_cov_1.855932_g318252_i0 | PRJNA1168532 | 321195 | 161 | 1.855932 | 2.98805052 | Malassezia restricta | 76775 | Fungi | Fungi | 152 | 1.28e-32 | NTclustered | gi|1546632090|ref|XM_027627705.1| | 76775 | g318252 | i0 | 98.824 | 0.788819875776398 | 85 | 1 | 79 | 0 | 77 | 161 | 514 | 430 | Malassezia restricta uncharacterized protein (MRET_1078), partial mRNA | blastn | 127 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19441147 | 19441147 | PRJNA1168532_S_NODE_261156_length_185_cov_0.992958_g258213_i0 | PRJNA1168532 | 261156 | 185 | 0.992958 | 1.8369723 | Malassezia restricta | 76775 | Fungi | Fungi | 331 | 1.81e-86 | NTclustered | gi|1546638177|ref|XM_027630730.1| | 76775 | g258213 | i0 | 98.919 | 1 | 185 | 2 | 100 | 0 | 1 | 185 | 5388 | 5572 | Malassezia restricta HEAT repeat protein (MRET_4103), partial mRNA | blastn | 185 | 331 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20166594 | 20166594 | PRJNA1168532_S_NODE_44116_length_445_cov_2.495025_g41296_i0 | PRJNA1168532 | 44116 | 445 | 2.495025 | 11.10286125 | Malassezia | 55193 | Fungi | Fungi | 811 | 0 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g41296 | i0 | 100 | 89.876404494382 | 439 | 0 | 99 | 0 | 1 | 439 | 32625 | 33063 | Malassezia restricta mitochondrion, complete genome | blastn | 39995 | 811 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20716541 | 20716541 | PRJNA1168532_S_NODE_291417_length_172_cov_1.217054_g288474_i0 | PRJNA1168532 | 291417 | 172 | 1.217054 | 2.09333288 | Malassezia restricta | 76775 | Fungi | Fungi | 296 | 6.04e-76 | NTclustered | gi|1546630031|ref|XM_027626676.1| | 76775 | g288474 | i0 | 98.225 | 0.982558139534884 | 169 | 3 | 98 | 0 | 1 | 169 | 231 | 399 | Malassezia restricta ESCRT-II complex subunit VPS22 (MRET_0049), partial mRNA | blastn | 169 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21991812 | 21991812 | PRJNA1168532_S_NODE_302378_length_168_cov_1.128000_g299435_i0 | PRJNA1168532 | 302378 | 168 | 1.128 | 1.89504 | Malassezia restricta | 76775 | Fungi | Fungi | 241 | 2.81e-59 | NTclustered | gi|1546638161|ref|XM_027630722.1| | 76775 | g299435 | i0 | 100 | 1.02380952380952 | 130 | 0 | 77 | 0 | 1 | 130 | 150 | 279 | Malassezia restricta uncharacterized protein (MRET_4095), partial mRNA | blastn | 172 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;