contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1002570" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12906371 | 12906371 | PRJNA1002570_P_NODE_6271_length_442_cov_1.130081_g6077_i0 | PRJNA1002570 | 6271 | 442 | 1.130081 | 4.99495802 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 1.35e-14 | NR | GJN91531.1 | 86838 | g6077 | i0 | 38.6 | 11.4162895927602 | 145 | 63 | 98.4 | 4 | 6 | 440 | 83 | 201 | GJN91531.1 hypothetical protein Rhopal_004554-T1 [Rhodotorula paludigena] | diamond | 5046 | 81.3 | 0.990159901599016 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula paludigena | |
| 26781370 | 26781370 | PRJNA1002570_P_NODE_42501_length_243_cov_0.905882_g42306_i0 | PRJNA1002570 | 42501 | 243 | 0.905882 | 2.20129326 | Malassezia restricta | 76775 | Fungi | Fungi | 48.5 | 2.03e-4 | NR | XP_027482651.1 | 76775 | g42306 | i0 | 50 | 0.790123456790123 | 64 | 28 | 74.1 | 2 | 2 | 181 | 131 | 194 | XP_027482651.1 uncharacterized protein MRET_0237 [Malassezia restricta] | diamond | 192 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27413936 | 27413936 | PRJNA1002570_P_NODE_31443_length_263_cov_2.231579_g31248_i0 | PRJNA1002570 | 31443 | 263 | 2.231579 | 5.86905277 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 56.2 | 8.45e-7 | NR | AYO42100.1 | 425264 | g31248 | i0 | 58.5 | 0.467680608365019 | 41 | 17 | 46.8 | 0 | 137 | 259 | 2 | 42 | AYO42100.1 hypothetical protein DNF11_1150 [Malassezia restricta CBS 7877] | diamond | 123 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27634807 | 27634807 | PRJNA1002570_P_NODE_26284_length_276_cov_2.862069_g26089_i0 | PRJNA1002570 | 26284 | 276 | 2.862069 | 7.89931044 | Malassezia sp. CBS 17886 | 3031751 | Fungi | Fungi | 65.9 | 4.23e-10 | NR | WFD29473.1 | 3031751 | g26089 | i0 | 53.5 | 2.35869565217391 | 71 | 29 | 77.2 | 1 | 228 | 16 | 334 | 400 | WFD29473.1 hypothetical protein MSPP1_000482 [Malassezia sp. CBS 17886] | diamond | 651 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sp. CBS 17886 | |
| 28645169 | 28645169 | PRJNA1002570_P_NODE_21747_length_287_cov_1.126168_g21552_i0 | PRJNA1002570 | 21747 | 287 | 1.126168 | 3.23210216 | Coprinopsis cinerea AmutBmut pab1-1 | 1132390 | Fungi | Fungi | 87.8 | 9.3e-18 | NR | KAG2006768.1 | 1132390 | g21552 | i0 | 66.2 | 0.742160278745645 | 71 | 24 | 74.2 | 0 | 29 | 241 | 980 | 1050 | KAG2006768.1 ankyrin repeat domain-containing protein 50 [Coprinopsis cinerea AmutBmut pab1-1] | diamond | 213 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis cinerea | |
| 28676777 | 28676777 | PRJNA1002570_P_NODE_43247_length_242_cov_0.911243_g43052_i0 | PRJNA1002570 | 43247 | 242 | 0.911243 | 2.20520806 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 45.4 | 0.00416 | NR | XP_018739868.1 | 1230383 | g43052 | i0 | 39.1 | 1.1404958677686 | 92 | 37 | 91.7 | 3 | 19 | 240 | 350 | 440 | XP_018739868.1 uncharacterized protein MSY001_1274 [Malassezia sympodialis ATCC 42132] | diamond | 276 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 29434091 | 29434091 | PRJNA1002570_P_NODE_30050_length_267_cov_1.587629_g29855_i0 | PRJNA1002570 | 30050 | 267 | 1.587629 | 4.23896943 | Leucosporidium creatinivorum | 106004 | Fungi | Fungi | 46.2 | 0.00301 | NR | ORY91623.1 | 106004 | g29855 | i0 | 77.8 | 0.303370786516854 | 27 | 6 | 30.3 | 0 | 159 | 79 | 131 | 157 | ORY91623.1 amino acid/polyamine transporter I [Leucosporidium creatinivorum] | diamond | 81 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium creatinivorum | |
| 29655035 | 29655035 | PRJNA1002570_P_NODE_42290_length_243_cov_1.529412_g42095_i0 | PRJNA1002570 | 42290 | 243 | 1.529412 | 3.71647116 | Malassezia brasiliensis | 1821822 | Fungi | Fungi | 69.3 | 1.69e-11 | NR | WFC93427.1 | 1821822 | g42095 | i0 | 48.7 | 1.93827160493827 | 78 | 24 | 96.3 | 2 | 10 | 243 | 1155 | 1216 | WFC93427.1 ABC-type xenobiotic transporter [Malassezia brasiliensis] | diamond | 471 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia brasiliensis | |
| 29781668 | 29781668 | PRJNA1002570_P_NODE_18071_length_299_cov_1.362832_g17876_i0 | PRJNA1002570 | 18071 | 299 | 1.362832 | 4.07486768 | Flagelloscypha sp. PMI_526 | 1485228 | Fungi | Fungi | 44.7 | 0.0151 | NR | KAH8824220.1 | 1485228 | g17876 | i0 | 35.4 | 0.792642140468227 | 79 | 45 | 73.2 | 2 | 291 | 73 | 61 | 139 | KAH8824220.1 hypothetical protein DL96DRAFT_1712516 [Flagelloscypha sp. PMI_526] | diamond | 237 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Tricholomataceae | Flagelloscypha | Flagelloscypha sp. PMI_526 | |
| 29781678 | 29781678 | PRJNA1002570_P_NODE_29531_length_268_cov_2.389744_g29336_i0 | PRJNA1002570 | 29531 | 268 | 2.389744 | 6.40451392 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 154 | 4.199999999999999e-41 | NR | WFD15472.1 | 1514897 | g29336 | i0 | 84.1 | 2.95522388059702 | 88 | 14 | 98.5 | 0 | 266 | 3 | 589 | 676 | WFD15472.1 hypothetical protein MARU1_001490 [Malassezia arunalokei] | diamond | 792 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 29844840 | 29844840 | PRJNA1002570_P_NODE_21111_length_288_cov_1.432558_g20916_i0 | PRJNA1002570 | 21111 | 288 | 1.432558 | 4.12576704 | Malassezia sp. CBS 17886 | 3031751 | Fungi | Fungi | 114 | 9.1e-28 | NR | WFD29419.1 | 3031751 | g20916 | i0 | 55.3 | 1.95833333333333 | 94 | 38 | 97.9 | 2 | 7 | 288 | 183 | 272 | WFD29419.1 hypothetical protein MSPP1_000428 [Malassezia sp. CBS 17886] | diamond | 564 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sp. CBS 17886 | |
| 30287586 | 30287586 | PRJNA1002570_P_NODE_39032_length_247_cov_1.666667_g38837_i0 | PRJNA1002570 | 39032 | 247 | 1.666667 | 4.11666749 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 107 | 3.66e-26 | NR | AYO42179.1 | 425264 | g38837 | i0 | 62.2 | 1.9919028340081 | 82 | 27 | 99.6 | 1 | 247 | 2 | 131 | 208 | AYO42179.1 NADH-cytochrome b5 reductase 2 [Malassezia restricta CBS 7877] | diamond | 492 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30508369 | 30508369 | PRJNA1002570_P_NODE_24333_length_281_cov_1.408654_g24138_i0 | PRJNA1002570 | 24333 | 281 | 1.408654 | 3.95831774 | Malassezia japonica | 223818 | Fungi | Fungi | 85.1 | 7.68e-17 | NR | XP_060121892.1 | 223818 | g24138 | i0 | 53.5 | 2.95729537366548 | 86 | 37 | 90.7 | 2 | 2 | 256 | 557 | 640 | XP_060121892.1 DNA topoisomerase [Malassezia japonica] | diamond | 831 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 31045805 | 31045805 | PRJNA1002570_P_NODE_41755_length_244_cov_0.900585_g41560_i0 | PRJNA1002570 | 41755 | 244 | 0.900585 | 2.1974274 | Suillus brevipes Sb2 | 1400700 | Fungi | Fungi | 52 | 2.06e-5 | NR | KAG2739293.1 | 1400700 | g41560 | i0 | 36 | 0.922131147540984 | 75 | 44 | 92.2 | 2 | 231 | 7 | 253 | 323 | KAG2739293.1 WD40 repeat-like protein [Suillus brevipes Sb2] | diamond | 225 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus brevipes | |
| 31962539 | 31962539 | PRJNA1002570_P_NODE_17738_length_299_cov_3.163717_g17543_i0 | PRJNA1002570 | 17738 | 299 | 3.163717 | 9.45951383 | Auricularia subglabra TFB-1 | 1331295 | Fungi | Fungi | 44.3 | 0.0192 | NR | EJD49120.1 | 717982 | g17543 | i0 | 32.3 | 0.622073578595318 | 62 | 42 | 62.2 | 0 | 199 | 14 | 206 | 267 | EJD49120.1 NADH:flavin oxidoreductase/NADH oxidase family protein [Auricularia subglabra TFB-10046 SS5] | diamond | 186 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia subglabra | |
| 32657926 | 32657926 | PRJNA1002570_P_NODE_40940_length_245_cov_0.895349_g40745_i0 | PRJNA1002570 | 40940 | 245 | 0.895349 | 2.19360505 | Coprinellus aureogranulatus | 752674 | Fungi | Fungi | 83.2 | 1.75e-17 | NR | KAJ3535867.1 | 752674 | g40745 | i0 | 84.8 | 0.563265306122449 | 46 | 7 | 56.3 | 0 | 107 | 244 | 1 | 46 | KAJ3535867.1 hypothetical protein NMY22_g6291 [Coprinellus aureogranulatus] | diamond | 138 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus aureogranulatus |
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);;