contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA694770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17253349 | 17253349 | PRJNA694770_P_NODE_79254_length_251_cov_0.865169_g78960_i0 | PRJNA694770 | 79254 | 251 | 0.865169 | 2.17157419 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 87.4 | 7.86e-18 | NR | AYO41470.1 | 425264 | g78960 | i0 | 95.1 | 0.729083665338645 | 61 | 3 | 72.9 | 0 | 69 | 251 | 757 | 817 | AYO41470.1 DNA polymerase V [Malassezia restricta CBS 7877] | diamond | 183 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27208877 | 27208877 | PRJNA694770_P_NODE_99302_length_241_cov_0.916667_g99008_i0 | PRJNA694770 | 99302 | 241 | 0.916667 | 2.20916747 | Cylindrobasidium torrendii FP15 | 394432 | Fungi | Fungi | 82.4 | 3.96e-16 | NR | KIY72913.1 | 1314674 | g99008 | i0 | 63.9 | 0.896265560165975 | 72 | 18 | 89.6 | 1 | 222 | 7 | 621 | 684 | KIY72913.1 Adaptor protein complex AP-3 delta subunit [Cylindrobasidium torrendii FP15055 ss-10] | diamond | 216 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium torrendii | |
| 27335620 | 27335620 | PRJNA694770_P_NODE_57083_length_284_cov_1.189573_g56789_i0 | PRJNA694770 | 57083 | 284 | 1.189573 | 3.37838732 | Cytidiella melzeri | 1883072 | Fungi | Fungi | 69.7 | 1.99e-11 | NR | KAI0703012.1 | 1883072 | g56789 | i0 | 74.2 | 0.654929577464789 | 62 | 9 | 65.5 | 1 | 282 | 97 | 182 | 236 | KAI0703012.1 hypothetical protein BC835DRAFT_1319457 [Cytidiella melzeri] | diamond | 186 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Cytidiella | Cytidiella melzeri | |
| 27872263 | 27872263 | PRJNA694770_P_NODE_49025_length_299_cov_2.530973_g48731_i0 | PRJNA694770 | 49025 | 299 | 2.530973 | 7.56760927 | Mycena venus | 2733690 | Fungi | Fungi | 46.6 | 0.00324 | NR | KAF7330964.1 | 2733690 | g48731 | i0 | 38.6 | 0.832775919732441 | 83 | 36 | 68.2 | 3 | 95 | 298 | 454 | 536 | KAF7330964.1 hypothetical protein MVEN_02436300 [Mycena venus] | diamond | 249 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena venus | |
| 28377366 | 28377366 | PRJNA694770_P_NODE_56746_length_284_cov_1.459716_g56452_i0 | PRJNA694770 | 56746 | 284 | 1.459716 | 4.14559344 | Physisporinus lineatus | 2056292 | Fungi | Fungi | 125 | 5.19e-31 | NR | KAJ3474774.1 | 2056292 | g56452 | i0 | 67.5 | 5.07042253521127 | 80 | 26 | 84.5 | 0 | 3 | 242 | 554 | 633 | KAJ3474774.1 hypothetical protein NLI96_g12260 [Physisporinus lineatus] | diamond | 1440 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meripilaceae | Meripilus | Meripilus lineatus | |
| 28515138 | 28515138 | PRJNA694770_P_NODE_99547_length_241_cov_0.916667_g99253_i0 | PRJNA694770 | 99547 | 241 | 0.916667 | 2.20916747 | Rhodotorula | 5533 | Fungi | Fungi | 82 | 5.49e-16 | NR | GJN87433.1 | 86838 | g99253 | i0 | 63.2 | 3.38589211618257 | 68 | 3 | 84.6 | 1 | 241 | 38 | 106 | 151 | GJN87433.1 hypothetical protein Rhopal_000382-T1 [Rhodotorula paludigena] | diamond | 816 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula paludigena | |
| 28724822 | 28724822 | PRJNA694770_P_NODE_80467_length_250_cov_0.870056_g80173_i0 | PRJNA694770 | 80467 | 250 | 0.870056 | 2.17514 | Schizophyllum commune | 5334 | Fungi | Fungi | 152 | 1.07e-40 | NR | KAL1663554.1 | 5334 | g80173 | i0 | 97.3 | 0.876 | 73 | 2 | 87.6 | 0 | 250 | 32 | 544 | 616 | KAL1663554.1 hypothetical protein GGF50DRAFT_56692 [Schizophyllum commune] | diamond | 219 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 31820881 | 31820881 | PRJNA694770_P_NODE_64577_length_272_cov_2.487437_g64283_i0 | PRJNA694770 | 64577 | 272 | 2.487437 | 6.76582864 | Mycena chlorophos | 658473 | Fungi | Fungi | 44.3 | 0.0139 | NR | GAT48538.1 | 658473 | g64283 | i0 | 38.2 | 0.75 | 68 | 40 | 75 | 2 | 53 | 256 | 149 | 214 | GAT48538.1 predicted protein [Mycena chlorophos] | diamond | 204 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena chlorophos | |
| 31915897 | 31915897 | PRJNA694770_P_NODE_66157_length_270_cov_1.563452_g65863_i0 | PRJNA694770 | 66157 | 270 | 1.563452 | 4.2213204 | Phakopsora pachyrhizi | 170000 | Fungi | Fungi | 66.6 | 2.08e-10 | NR | KAI8457710.1 | 170000 | g65863 | i0 | 53.1 | 2.17777777777778 | 98 | 33 | 100 | 4 | 1 | 270 | 493 | 585 | KAI8457710.1 hypothetical protein BY996DRAFT_8421641 [Phakopsora pachyrhizi] | diamond | 588 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 32074184 | 32074184 | PRJNA694770_P_NODE_93058_length_244_cov_0.900585_g92764_i0 | PRJNA694770 | 93058 | 244 | 0.900585 | 2.1974274 | Sporobolomyces phaffii | 183961 | Fungi | Fungi | 72.4 | 1.24e-12 | NR | GAA6013035.1 | 183961 | g92764 | i0 | 78.7 | 1.11885245901639 | 47 | 7 | 54.1 | 1 | 152 | 21 | 42 | 88 | GAA6013035.1 hypothetical protein JCM11491_000947 [Sporobolomyces phaffii] | diamond | 273 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces phaffii | |
| 32780321 | 32780321 | PRJNA694770_P_NODE_76960_length_252_cov_1.720670_g76666_i0 | PRJNA694770 | 76960 | 252 | 1.72067 | 4.3360884 | Malassezia | 55193 | Fungi | Fungi | 120 | 3.81e-30 | NR | XP_060120844.1 | 223818 | g76666 | i0 | 69.9 | 2 | 83 | 25 | 98.8 | 0 | 249 | 1 | 232 | 314 | XP_060120844.1 3beta-hydroxysteroid 3-dehydrogenase [Malassezia japonica] | diamond | 504 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica |
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);;