contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA177642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365461 | 365461 | PRJNA177642_P_NODE_16801_length_170_cov_1.021277_g15576_i0 | PRJNA177642 | 16801 | 170 | 1.021277 | 1.7361709 | Malassezia restricta | 76775 | Fungi | Fungi | 315 | 1.64e-81 | NTclustered | gi|1546637747|ref|XM_027630515.1| | 76775 | g15576 | i0 | 100 | 1 | 170 | 0 | 100 | 0 | 1 | 170 | 253 | 84 | Malassezia restricta ribonuclease P/MRP protein subunit POP5 (MRET_3888), partial mRNA | blastn | 170 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 2330391 | 2330391 | PRJNA177642_P_NODE_16382_length_172_cov_2.104895_g15157_i0 | PRJNA177642 | 16382 | 172 | 2.104895 | 3.6204194 | Malassezia | 55193 | Fungi | Fungi | 318 | 1.2899999999999999e-82 | NTclustered | gi|37575174|gb|AY387222.1| | 55194 | g15157 | i0 | 100 | 99.9883720930233 | 172 | 0 | 100 | 0 | 1 | 172 | 327 | 498 | Malassezia furfur strain TPB1 large subunit ribosomal RNA gene, partial sequence | blastn | 17198 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 15668311 | 15668311 | PRJNA177642_P_NODE_16473_length_172_cov_1.006993_g15248_i0 | PRJNA177642 | 16473 | 172 | 1.006993 | 1.73202796 | Malassezia globosa | 76773 | Fungi | Fungi | 291 | 2.81e-74 | NTclustered | gi|164662458|ref|XM_001732299.1| | 425265 | g15248 | i0 | 97.093 | 1 | 172 | 5 | 100 | 0 | 1 | 172 | 714 | 543 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_0126), partial mRNA | blastn | 172 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 16942637 | 16942637 | PRJNA177642_P_NODE_10874_length_337_cov_1.340909_g9650_i0 | PRJNA177642 | 10874 | 337 | 1.340909 | 4.51886333 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 52.8 | 0.032 | NTclustered | gi|1423565254|ref|XM_025744529.1| | 58919 | g9650 | i0 | 96.875 | 0.0949554896142433 | 32 | 0 | 9 | 1 | 303 | 333 | 636 | 605 | Tilletiopsis washingtonensis hypothetical protein (FA09DRAFT_342132), partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 16942686 | 16942686 | PRJNA177642_P_NODE_13674_length_239_cov_2.195238_g12449_i0 | PRJNA177642 | 13674 | 239 | 2.195238 | 5.24661882 | Amanita gracilior | 1004500 | Fungi | Fungi | 110 | 1.26e-19 | NTclustered | gi|329131503|gb|HQ539699.1| | 1004500 | g12449 | i0 | 81.295 | 4.2092050209205 | 139 | 23 | 57 | 3 | 99 | 235 | 1078 | 1215 | Amanita gracilior voucher RET 342-2 large subunit ribosomal RNA gene, partial sequence | blastn | 1006 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita gracilior | |
| 20767038 | 20767038 | PRJNA177642_P_NODE_17977_length_164_cov_3.007407_g16752_i0 | PRJNA177642 | 17977 | 164 | 3.007407 | 4.93214748 | Malassezia restricta | 76775 | Fungi | Fungi | 283 | 4.46e-72 | NTclustered | gi|1546629949|ref|XM_027626635.1| | 76775 | g16752 | i0 | 98.148 | 0.98780487804878 | 162 | 3 | 99 | 0 | 2 | 163 | 960 | 799 | Malassezia restricta oligosaccharyltransferase complex subunit beta (MRET_0008), partial mRNA | blastn | 162 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23317581 | 23317581 | PRJNA177642_P_NODE_16499_length_172_cov_1.006993_g15274_i0 | PRJNA177642 | 16499 | 172 | 1.006993 | 1.73202796 | Cutaneotrichosporon dermatis | 129132 | Fungi | Fungi | 128 | 2.33e-25 | NTclustered | gi|921326985|dbj|AB919772.1| | 129132 | g15274 | i0 | 81.818 | 2.66279069767442 | 154 | 26 | 89 | 2 | 20 | 172 | 1500 | 1652 | Trichosporon dermatis gene for ATP-binding cassette (ABC) transporter, complete sequence, strain: JCM 11170 | blastn | 458 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon dermatis | |
| 23317597 | 23317597 | PRJNA177642_P_NODE_17379_length_167_cov_1.043478_g16154_i0 | PRJNA177642 | 17379 | 167 | 1.043478 | 1.74260826 | Filobasidium floriforme | 5210 | Fungi | Fungi | 270 | 3.5499999999999993e-68 | NTclustered | gi|2185522840|ref|XM_046179011.1| | 5210 | g16154 | i0 | 95.808 | 1 | 167 | 7 | 100 | 0 | 1 | 167 | 1540 | 1706 | Filobasidium floriforme elongation factor g 1, mitochondrial precursor (mef-g-1) (HD553DRAFT_304438), mRNA | blastn | 167 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme |
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);;