contig_metadata
11 rows where 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 | |
| 11844056 | 11844056 | PRJNA177642_P_NODE_17430_length_167_cov_1.021739_g16205_i0 | PRJNA177642 | 17430 | 167 | 1.021739 | 1.70630413 | Hypholoma sublateritium FD-334 SS-4 | 945553 | Fungi | Fungi | 91.7 | 4.94e-20 | NR | KJA21562.1 | 945553 | g16205 | i0 | 87.3 | 2.96407185628743 | 55 | 6 | 98.8 | 1 | 166 | 2 | 209 | 262 | KJA21562.1 hypothetical protein HYPSUDRAFT_202904 [Hypholoma sublateritium FD-334 SS-4] | diamond | 495 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Hypholoma | Hypholoma sublateritium | |
| 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 | |
| 30327221 | 30327221 | PRJNA177642_P_NODE_19012_length_154_cov_3.232000_g17787_i0 | PRJNA177642 | 19012 | 154 | 3.232 | 4.97728 | Macrolepiota fuliginosa MF-IS2 | 1400762 | Fungi | Fungi | 79.7 | 1.96e-17 | NR | KAF9450724.1 | 1400762 | g17787 | i0 | 75.6 | 1.81168831168831 | 45 | 11 | 87.7 | 0 | 3 | 137 | 57 | 101 | KAF9450724.1 hypothetical protein P691DRAFT_700613 [Macrolepiota fuliginosa MF-IS2] | diamond | 279 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Macrolepiota | Macrolepiota fuliginosa | |
| 30660433 | 30660433 | PRJNA177642_P_NODE_16333_length_173_cov_1.000000_g15108_i0 | PRJNA177642 | 16333 | 173 | 1 | 1.73 | Agaricomycetes | 155619 | Fungi | Fungi | 81.3 | 2.99e-16 | NR | GJE95822.1 | 48140 | g15108 | i0 | 70.7 | 2.01156069364162 | 58 | 16 | 98.8 | 1 | 1 | 171 | 304 | 361 | GJE95822.1 3-deoxy-7-phosphoheptulonate synthase [Phanerochaete sordida] | diamond | 348 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete sordida |
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);;