contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA554794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5624768 | 5624768 | PRJNA554794_P_NODE_20645_length_191_cov_0.760563_g16716_i0 | PRJNA554794 | 20645 | 191 | 0.760563 | 1.45267533 | Hericium alpestre | 135208 | Fungi | Fungi | 93.6 | 1.66e-20 | NR | TFY80870.1 | 135208 | g16716 | i0 | 66.7 | 9.89528795811518 | 63 | 21 | 99 | 0 | 190 | 2 | 131 | 193 | TFY80870.1 hypothetical protein EWM64_g3137 [Hericium alpestre] | diamond | 1890 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Hericium | Hericium alpestre | |
| 8173682 | 8173682 | PRJNA554794_P_NODE_20327_length_196_cov_0.768707_g16398_i0 | PRJNA554794 | 20327 | 196 | 0.768707 | 1.50666572 | Fungi | 4751 | Fungi | Fungi | 103 | 1.16e-25 | NR | GJE85391.1 | 48140 | g16398 | i0 | 81.4 | 3.38265306122449 | 59 | 11 | 90.3 | 0 | 19 | 195 | 58 | 116 | GJE85391.1 40S ribosomal protein S13 [Phanerochaete sordida] | diamond | 663 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete sordida | |
| 10725101 | 10725101 | PRJNA554794_P_NODE_23669_length_164_cov_0.869565_g19740_i0 | PRJNA554794 | 23669 | 164 | 0.869565 | 1.4260866 | Plicaturopsis crispa FD-325 SS-3 | 944288 | Fungi | Fungi | 67 | 3.41e-11 | NR | KII93129.1 | 944288 | g19740 | i0 | 75 | 3.21951219512195 | 40 | 10 | 73.2 | 0 | 21 | 140 | 140 | 179 | KII93129.1 hypothetical protein PLICRDRAFT_49203 [Plicaturopsis crispa FD-325 SS-3] | diamond | 528 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Amylocorticiales | Amylocorticiaceae | Plicatura | Plicatura crispa | |
| 15823683 | 15823683 | PRJNA554794_P_NODE_20893_length_187_cov_1.471014_g16964_i0 | PRJNA554794 | 20893 | 187 | 1.471014 | 2.75079618 | Fungi | 4751 | Fungi | Fungi | 100 | 2.39e-23 | NR | GJN92934.1 | 86838 | g16964 | i0 | 80 | 25.9893048128342 | 60 | 12 | 96.3 | 0 | 185 | 6 | 67 | 126 | GJN92934.1 hypothetical protein Rhopal_005977-T1 [Rhodotorula paludigena] | diamond | 4860 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula paludigena | |
| 17098466 | 17098466 | PRJNA554794_P_NODE_11034_length_335_cov_0.786713_g7109_i0 | PRJNA554794 | 11034 | 335 | 0.786713 | 2.63548855 | Eukaryota | 2759 | Fungi | Fungi | 150 | 2.84e-43 | NR | GHJ85847.1 | 104408 | g7109 | i0 | 71.3 | 9.88656716417911 | 101 | 29 | 90.4 | 0 | 303 | 1 | 84 | 184 | GHJ85847.1 hypothetical protein NliqN6_2249 [Naganishia liquefaciens] | diamond | 3312 | 151 | 0.993377483443709 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 26951524 | 26951524 | PRJNA554794_P_NODE_19862_length_204_cov_0.922581_g15933_i0 | PRJNA554794 | 19862 | 204 | 0.922581 | 1.88206524 | Fomes fomentarius | 40442 | Fungi | Fungi | 89 | 6.97e-19 | NR | KAI0770186.1 | 40442 | g15933 | i0 | 62.9 | 1.79411764705882 | 62 | 23 | 91.2 | 0 | 186 | 1 | 4 | 65 | KAI0770186.1 fragmin60 [Fomes fomentarius] | diamond | 366 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Fomes | Fomes fomentarius | |
| 28671980 | 28671980 | PRJNA554794_P_NODE_20127_length_199_cov_1.573333_g16198_i0 | PRJNA554794 | 20127 | 199 | 1.573333 | 3.13093267 | Agaricomycetes | 155619 | Fungi | Fungi | 74.3 | 2.73e-14 | NR | KAL4266473.1 | 28995 | g16198 | i0 | 74.1 | 9.07537688442211 | 54 | 13 | 81.4 | 1 | 38 | 199 | 38 | 90 | KAL4266473.1 Large ribosomal subunit protein uL5 [Pleurotus pulmonarius] | diamond | 1806 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus pulmonarius | |
| 29776833 | 29776833 | PRJNA554794_P_NODE_24051_length_163_cov_0.868421_g20122_i0 | PRJNA554794 | 24051 | 163 | 0.868421 | 1.41552623 | Eukaryota | 2759 | Fungi | Fungi | 80.1 | 2.67e-17 | NR | CEQ40125.1 | 5005 | g20122 | i0 | 75.9 | 20.8711656441718 | 54 | 11 | 99.4 | 1 | 162 | 1 | 71 | 122 | CEQ40125.1 SPOSA6832_01718 [Sporobolomyces salmonicolor] | diamond | 3402 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor | |
| 30268121 | 30268121 | PRJNA554794_P_NODE_21532_length_179_cov_0.869231_g17603_i0 | PRJNA554794 | 21532 | 179 | 0.869231 | 1.55592349 | Abortiporus biennis | 137743 | Fungi | Fungi | 75.9 | 3.28e-14 | NR | KAL4243471.1 | 137743 | g17603 | i0 | 50.8 | 5.93296089385475 | 59 | 29 | 98.9 | 0 | 179 | 3 | 125 | 183 | KAL4243471.1 oxygen-dependent FAD-linked oxidoreductase family protein [Abortiporus biennis] | diamond | 1062 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Podoscyphaceae | Abortiporus | Abortiporus biennis | |
| 31040955 | 31040955 | PRJNA554794_P_NODE_23355_length_165_cov_0.862069_g19426_i0 | PRJNA554794 | 23355 | 165 | 0.862069 | 1.42241385 | Fungi | 4751 | Fungi | Fungi | 43.5 | 0.00688 | NR | ALJ82901.1 | 5319 | g19426 | i0 | 44 | 5.47272727272727 | 50 | 27 | 90.9 | 1 | 152 | 3 | 264 | 312 | ALJ82901.1 choline dehydrogenase [Irpex lacteus] | diamond | 903 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Irpex | Irpex lacteus | |
| 31942970 | 31942970 | PRJNA554794_P_NODE_13897_length_233_cov_0.668478_g9968_i0 | PRJNA554794 | 13897 | 233 | 0.668478 | 1.55755374 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 99.4 | 3.15e-24 | NR | GHJ90194.1 | 104408 | g9968 | i0 | 58.4 | 10.9055793991416 | 77 | 32 | 99.1 | 0 | 1 | 231 | 5 | 81 | GHJ90194.1 hypothetical protein NliqN6_6596 [Naganishia liquefaciens] | diamond | 2541 | 99.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 32228136 | 32228136 | PRJNA554794_P_NODE_24118_length_162_cov_1.451327_g20189_i0 | PRJNA554794 | 24118 | 162 | 1.451327 | 2.35114974 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 68.2 | 1.3e-11 | NR | CAD6583621.1 | 2778381 | g20189 | i0 | 68 | 5.61111111111111 | 50 | 16 | 92.6 | 0 | 161 | 12 | 15 | 64 | CAD6583621.1 MAG: hypothetical protein CYPHOPRED_002411 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 909 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 |
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);;