contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA674048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27219885 | 27219885 | PRJNA674048_P_NODE_11082_length_280_cov_0.978355_g10879_i0 | PRJNA674048 | 11082 | 280 | 0.978355 | 2.739394 | Basidiomycota | 5204 | Fungi | Fungi | 104 | 4.86e-26 | NR | CDZ97758.1 | 264483 | g10879 | i0 | 87.3 | 12.375 | 55 | 7 | 58.9 | 0 | 280 | 116 | 107 | 161 | CDZ97758.1 40s ribosomal protein s14 [Phaffia rhodozyma] | diamond | 3465 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Phaffia | Phaffia rhodozyma | |
| 27283392 | 27283392 | PRJNA674048_P_NODE_28803_length_167_cov_0.881356_g28600_i0 | PRJNA674048 | 28803 | 167 | 0.881356 | 1.47186452 | Fungi | 4751 | Fungi | Fungi | 62.4 | 1.55e-9 | NR | XP_019009096.1 | 1296096 | g28600 | i0 | 49.1 | 8.92814371257485 | 55 | 28 | 98.8 | 0 | 166 | 2 | 680 | 734 | XP_019009096.1 eukaryotic translation initiation factor 3 subunit C [Kwoniella pini CBS 10737] | diamond | 1491 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella pini | |
| 27504680 | 27504680 | PRJNA674048_P_NODE_32603_length_162_cov_0.920354_g32400_i0 | PRJNA674048 | 32603 | 162 | 0.920354 | 1.49097348 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 2.28e-5 | NR | XP_007391402.1 | 650164 | g32400 | i0 | 49 | 3.62962962962963 | 49 | 25 | 90.7 | 0 | 149 | 3 | 57 | 105 | XP_007391402.1 uncharacterized protein PHACADRAFT_85938 [Phanerochaete carnosa HHB-10118-sp] | diamond | 588 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete carnosa | |
| 28167633 | 28167633 | PRJNA674048_P_NODE_23585_length_181_cov_1.575758_g23382_i0 | PRJNA674048 | 23585 | 181 | 1.575758 | 2.85212198 | Malassezia | 55193 | Fungi | Fungi | 90.9 | 1.78e-19 | NR | XP_017991538.1 | 77020 | g23382 | i0 | 74.6 | 4.77348066298343 | 59 | 10 | 97.8 | 1 | 1 | 177 | 130 | 183 | XP_017991538.1 sugar transporter stl1 [Malassezia pachydermatis] | diamond | 864 | 91.7 | 0.991275899672846 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 28262055 | 28262055 | PRJNA674048_P_NODE_30366_length_165_cov_0.896552_g30163_i0 | PRJNA674048 | 30366 | 165 | 0.896552 | 1.4793108 | Tremellales | 5234 | Fungi | Fungi | 87.8 | 1.93e-20 | NR | ORY34778.1 | 71784 | g30163 | i0 | 77.6 | 1.78181818181818 | 49 | 11 | 89.1 | 0 | 164 | 18 | 87 | 135 | ORY34778.1 hypothetical protein BCR39DRAFT_514648 [Naematelia encephala] | diamond | 294 | 88.6 | 0.99097065462754 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 28293707 | 28293707 | PRJNA674048_P_NODE_31946_length_163_cov_0.912281_g31743_i0 | PRJNA674048 | 31946 | 163 | 0.912281 | 1.48701803 | Fungi | 4751 | Fungi | Fungi | 89 | 2.89e-20 | NR | XP_011388966.1 | 5270 | g31743 | i0 | 72.2 | 22.8588957055215 | 54 | 15 | 99.4 | 0 | 1 | 162 | 52 | 105 | XP_011388966.1 putative ran-specific GTPase-activating protein [Mycosarcoma maydis] | diamond | 3726 | 89.4 | 0.995525727069351 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 29166191 | 29166191 | PRJNA674048_P_NODE_29569_length_166_cov_0.888889_g29366_i0 | PRJNA674048 | 29569 | 166 | 0.888889 | 1.47555574 | Amanita rubescens | 71933 | Fungi | Fungi | 83.2 | 6.89e-17 | NR | KAF8351434.1 | 71933 | g29366 | i0 | 69.8 | 12.4879518072289 | 53 | 16 | 95.8 | 0 | 2 | 160 | 148 | 200 | KAF8351434.1 kinase-like domain-containing protein [Amanita rubescens] | diamond | 2073 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita rubescens | |
| 29449898 | 29449898 | PRJNA674048_P_NODE_30170_length_165_cov_0.896552_g29967_i0 | PRJNA674048 | 30170 | 165 | 0.896552 | 1.4793108 | Flagelloscypha sp. PMI_526 | 1485228 | Fungi | Fungi | 86.7 | 4.48e-18 | NR | KAH8833430.1 | 1485228 | g29967 | i0 | 74.1 | 10.7818181818182 | 54 | 14 | 98.2 | 0 | 1 | 162 | 824 | 877 | KAH8833430.1 multidrug resistance-associated ABC transporter [Flagelloscypha sp. PMI_526] | diamond | 1779 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Tricholomataceae | Flagelloscypha | Flagelloscypha sp. PMI_526 | |
| 29588035 | 29588035 | PRJNA674048_P_NODE_31730_length_163_cov_0.912281_g31527_i0 | PRJNA674048 | 31730 | 163 | 0.912281 | 1.48701803 | Ustilaginaceae | 5268 | Fungi | Fungi | 52.8 | 3.71e-6 | NR | CDI56367.1 | 1398559 | g31527 | i0 | 51.2 | 1.52760736196319 | 43 | 21 | 79.1 | 0 | 2 | 130 | 220 | 262 | CDI56367.1 related to phosphatidic acid-preferring phospholipase A1, partial [Melanopsichium pennsylvanicum 4] | diamond | 249 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Melanopsichium | Melanopsichium pennsylvanicum | |
| 29702346 | 29702346 | PRJNA674048_P_NODE_27330_length_169_cov_0.866667_g27127_i0 | PRJNA674048 | 27330 | 169 | 0.866667 | 1.46466723 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 68.6 | 1.09e-11 | NR | AYO43640.1 | 425264 | g27127 | i0 | 72.9 | 0.85207100591716 | 48 | 13 | 85.2 | 0 | 145 | 2 | 499 | 546 | AYO43640.1 hypothetical protein DNF11_2690 [Malassezia restricta CBS 7877] | diamond | 144 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 31946526 | 31946526 | PRJNA674048_P_NODE_23637_length_181_cov_1.250000_g23434_i0 | PRJNA674048 | 23637 | 181 | 1.25 | 2.2625 | Mycosarcoma maydis | 5270 | Fungi | Fungi | 98.6 | 3.39e-22 | NR | Q0H8Y2.2 | 5270 | g23434 | i0 | 81.7 | 12.9281767955801 | 60 | 11 | 99.4 | 0 | 2 | 181 | 18 | 77 | Q0H8Y2.2 RecName: Full=Probable intron-encoded endonuclease aI7; Contains: RecName: Full=Truncated non-functional cytochrome oxidase 1; Contains: RecName: Full=Intron-encoded endonuclease aI7; Flags: Precursor [Mycosarcoma maydis] | diamond | 2340 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 32073320 | 32073320 | PRJNA674048_P_NODE_22478_length_185_cov_2.830882_g22275_i0 | PRJNA674048 | 22478 | 185 | 2.830882 | 5.2371317 | Lentinula aff. detonsa | 2804958 | Fungi | Fungi | 64.7 | 2.39e-11 | NR | KAJ3798930.1 | 2804958 | g22275 | i0 | 78.4 | 7.2 | 37 | 8 | 60 | 0 | 184 | 74 | 96 | 132 | KAJ3798930.1 ribosomal L37ae protein family-domain-containing protein [Lentinula aff. detonsa] | diamond | 1332 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula aff. detonsa | |
| 32496703 | 32496703 | PRJNA674048_P_NODE_13959_length_241_cov_2.395833_g13756_i0 | PRJNA674048 | 13959 | 241 | 2.395833 | 5.77395753 | Fungi | 4751 | Fungi | Fungi | 115 | 4.239999999999999e-31 | NR | KAI3628568.1 | 55194 | g13756 | i0 | 72.5 | 14.6390041493776 | 80 | 21 | 98.3 | 1 | 239 | 3 | 53 | 132 | KAI3628568.1 COF1 [Malassezia furfur] | diamond | 3528 | 115 | 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);;