contig_metadata
13 rows where bioproject = "PRJNA529224", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 497999 | 497999 | PRJNA529224_S_NODE_1581_length_167_cov_11.833333_g1574_i0 | PRJNA529224 | 1581 | 167 | 11.833333 | 19.76166611 | uncultured Filobasidiella | 1503101 | Fungi | Fungi | 231 | 1.68e-56 | NTclustered | gi|387156411|emb|HE806144.1| | 1503101 | g1574 | i0 | 91.617 | 146.826347305389 | 167 | 14 | 100 | 0 | 1 | 167 | 1656 | 1822 | Uncultured Filobasidiella partial 26S rRNA gene, clone Ao0Yyyy6 | blastn | 24520 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | uncultured Filobasidiella | ||
| 1114437 | 1114437 | PRJNA529224_S_NODE_1561_length_168_cov_138.985612_g1554_i0 | PRJNA529224 | 1561 | 168 | 138.985612 | 233.49582816 | Malassezia | 55193 | Fungi | Fungi | 309 | 7.58e-80 | NTclustered | gi|953821272|gb|KT310070.1| | 76773 | g1554 | i0 | 100 | 99.0892857142857 | 167 | 0 | 99 | 0 | 2 | 168 | 670 | 836 | Malassezia globosa isolate 1242 large subunit ribosomal RNA gene, partial sequence | blastn | 16647 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 1114453 | 1114453 | PRJNA529224_S_NODE_341_length_317_cov_97.836806_g334_i0 | PRJNA529224 | 341 | 317 | 97.836806 | 310.14267502 | Opisthokonta | 33154 | Fungi | Fungi | 560 | 3.99e-155 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g334 | i0 | 100 | 93.5141955835962 | 303 | 0 | 96 | 0 | 15 | 317 | 242 | 544 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 29644 | 560 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 1114465 | 1114465 | PRJNA529224_S_NODE_981_length_208_cov_95.905028_g974_i0 | PRJNA529224 | 981 | 208 | 95.905028 | 199.48245824 | Tremellomycetes | 155616 | Fungi | Fungi | 346 | 7.460000000000001e-91 | NTclustered | gi|1854401|dbj|D64123.1| | 57688 | g974 | i0 | 96.651 | 100.490384615385 | 209 | 6 | 100 | 1 | 1 | 208 | 151 | 359 | Fibulobasidium inconspicuum gene for small subunit ribosomal RNA | blastn | 20902 | 346 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Sirobasidiaceae | Fibulobasidium | Fibulobasidium inconspicuum | |
| 2389996 | 2389996 | PRJNA529224_S_NODE_1942_length_150_cov_13.264463_g1935_i0 | PRJNA529224 | 1942 | 150 | 13.264463 | 19.8966945 | Ustilaginaceae | 5268 | Fungi | Fungi | 276 | 6.660000000000001e-70 | NTclustered | gi|1358186638|gb|MH047195.1| | 5270 | g1935 | i0 | 100 | 44.46 | 149 | 0 | 99 | 0 | 1 | 149 | 4566 | 4418 | Mycosarcoma maydis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 6669 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 4324924 | 4324924 | PRJNA529224_S_NODE_444_length_288_cov_111.517375_g437_i0 | PRJNA529224 | 444 | 288 | 111.517375 | 321.17004 | Malassezia restricta | 76775 | Fungi | Fungi | 307 | 5.15e-79 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g437 | i0 | 86.806 | 59.9340277777778 | 288 | 23 | 99 | 11 | 2 | 288 | 3372 | 3099 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 17261 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10702001 | 10702001 | PRJNA529224_S_NODE_1929_length_151_cov_9.049180_g1922_i0 | PRJNA529224 | 1929 | 151 | 9.04918 | 13.6642618 | Malassezia globosa | 76773 | Fungi | Fungi | 279 | 5.19e-71 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1922 | i0 | 100 | 68.4966887417219 | 151 | 0 | 100 | 0 | 1 | 151 | 2094 | 1944 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 10343 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 13251852 | 13251852 | PRJNA529224_S_NODE_1751_length_158_cov_7.434109_g1744_i0 | PRJNA529224 | 1751 | 158 | 7.434109 | 11.74589222 | Leucosporidium sp. AY30 | 662878 | Fungi | Fungi | 270 | 3.3099999999999996e-68 | NTclustered | gi|254927417|gb|GQ336996.1| | 662878 | g1744 | i0 | 97.468 | 103.012658227848 | 158 | 4 | 100 | 0 | 1 | 158 | 5166 | 5009 | Leucosporidium sp. AY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 16276 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium sp. AY30 | |
| 15142602 | 15142602 | PRJNA529224_S_NODE_892_length_215_cov_27.397849_g885_i0 | PRJNA529224 | 892 | 215 | 27.397849 | 58.90537535 | Symmetrospora | 1798808 | Fungi | Fungi | 342 | 9.999999999999999e-90 | NTclustered | gi|769115784|gb|KJ701195.1| | 5441 | g885 | i0 | 95.349 | 99.8511627906977 | 215 | 10 | 100 | 0 | 1 | 215 | 1065 | 851 | Symmetrospora oryzicola voucher MCA4496 18S ribosomal RNA gene, partial sequence | blastn | 21468 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Symmetrosporaceae | Symmetrospora | Symmetrospora oryzicola | ||
| 20240956 | 20240956 | PRJNA529224_S_NODE_1576_length_167_cov_426.166667_g1569_i0 | PRJNA529224 | 1576 | 167 | 426.166667 | 711.69833389 | Basidiomycota | 5204 | Fungi | Fungi | 265 | 1.65e-66 | NTclustered | gi|406205|dbj|D12803.1|ERHSSRD3 | 5414 | g1569 | i0 | 95.21 | 99.9640718562874 | 167 | 8 | 100 | 0 | 1 | 167 | 1409 | 1243 | Erythrobasidium hasegawianum gene for small subunit ribosomal RNA | blastn | 16694 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Erythrobasidium | Erythrobasidium hasegawianum | |
| 22791611 | 22791611 | PRJNA529224_S_NODE_338_length_319_cov_134.186207_g331_i0 | PRJNA529224 | 338 | 319 | 134.186207 | 428.05400033 | Malassezia | 55193 | Fungi | Fungi | 564 | 3.109999999999999e-156 | NTclustered | gi|915512591|gb|KP825374.1| | 76773 | g331 | i0 | 100 | 93.4326018808777 | 305 | 0 | 96 | 0 | 15 | 319 | 340 | 644 | Malassezia globosa strain ISOSEB48F 28S ribosomal RNA gene, partial sequence | blastn | 29805 | 564 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 24066410 | 24066410 | PRJNA529224_S_NODE_1899_length_152_cov_18.910569_g1892_i0 | PRJNA529224 | 1899 | 152 | 18.910569 | 28.74406488 | Basidiomycota | 5204 | Fungi | Fungi | 265 | 1.47e-66 | NTclustered | gi|2905253667|dbj|LC438620.1| | 5537 | g1892 | i0 | 98.026 | 100 | 152 | 3 | 100 | 0 | 1 | 152 | 257 | 106 | Rhodotorula mucilaginosa K6 gene for 26S ribosomalRNA, partial sequence | blastn | 15200 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 25340872 | 25340872 | PRJNA529224_S_NODE_640_length_245_cov_160.750000_g633_i0 | PRJNA529224 | 640 | 245 | 160.75 | 393.8375 | Malassezia | 55193 | Fungi | Fungi | 444 | 3.12e-120 | NTclustered | gi|1101565660|gb|KX839636.1| | 55194 | g633 | i0 | 99.588 | 99.1836734693878 | 243 | 1 | 99 | 0 | 3 | 245 | 14 | 256 | Malassezia furfur isolate GDMUZJ2015102 26S ribosomal RNA gene, partial sequence | blastn | 24300 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur |
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);;