contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA690124" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6282711 | 6282711 | PRJNA690124_P_NODE_52225_length_245_cov_0.906977_g51859_i0 | PRJNA690124 | 52225 | 245 | 0.906977 | 2.22209365 | Tilletiaria anomala UBC 951 | 1037660 | Fungi | Fungi | 145 | 1.7499999999999999e-40 | NR | XP_013240829.1 | 1037660 | g51859 | i0 | 88.9 | 0.991836734693878 | 81 | 9 | 99.2 | 0 | 243 | 1 | 243 | 323 | XP_013240829.1 putative porphobilinogen synthase [Tilletiaria anomala UBC 951] | diamond | 243 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Georgefischeriales | Tilletiariaceae | Tilletiaria | Tilletiaria anomala | |
| 14698672 | 14698672 | PRJNA690124_P_NODE_54912_length_243_cov_0.917647_g54546_i0 | PRJNA690124 | 54912 | 243 | 0.917647 | 2.22988221 | Cryptococcaceae | 1884633 | Fungi | Fungi | 84.3 | 1.64e-17 | NR | XP_065825039.1 | 1296121 | g54546 | i0 | 56.3 | 3.66666666666667 | 80 | 23 | 98.8 | 2 | 4 | 243 | 82 | 149 | XP_065825039.1 uncharacterized protein I303_104471 [Kwoniella dejecticola CBS 10117] | diamond | 891 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dejecticola | |
| 24895548 | 24895548 | PRJNA690124_P_NODE_37160_length_273_cov_1.340000_g36794_i0 | PRJNA690124 | 37160 | 273 | 1.34 | 3.6582 | Fungi | 4751 | Fungi | Fungi | 144 | 1.35e-37 | NR | XP_046039246.1 | 5210 | g36794 | i0 | 78.2 | 165.395604395604 | 87 | 19 | 95.6 | 0 | 3 | 263 | 434 | 520 | XP_046039246.1 putative ATP dependent DNA helicase [Filobasidium floriforme] | diamond | 45153 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 26639165 | 26639165 | PRJNA690124_P_NODE_45601_length_251_cov_0.876404_g45235_i0 | PRJNA690124 | 45601 | 251 | 0.876404 | 2.19977404 | Cutaneotrichosporon sp. HIS471 | 3040995 | Fungi | Fungi | 111 | 3.3e-26 | NR | BEJ14783.1 | 3040995 | g45235 | i0 | 68.7 | 1.94820717131474 | 83 | 25 | 98 | 1 | 251 | 6 | 494 | 576 | BEJ14783.1 hypothetical protein CspHIS471_0405500 [Cutaneotrichosporon sp. HIS471] | diamond | 489 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon sp. HIS471 | |
| 26765889 | 26765889 | PRJNA690124_P_NODE_38461_length_268_cov_1.348718_g38095_i0 | PRJNA690124 | 38461 | 268 | 1.348718 | 3.61456424 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 95.5 | 3.669999999999999e-23 | NR | XP_066825599.1 | 1397322 | g38095 | i0 | 82.8 | 1.2089552238806 | 58 | 10 | 64.9 | 0 | 266 | 93 | 60 | 117 | XP_066825599.1 U6 snRNA-associated Sm-like protein LSm2 [Cystobasidium minutum MCA 4210] | diamond | 324 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 27030566 | 27030566 | PRJNA690124_P_NODE_16742_length_395_cov_2.975155_g16376_i0 | PRJNA690124 | 16742 | 395 | 2.975155 | 11.75186225 | Serendipita | 358905 | Fungi | Fungi | 115 | 9.47e-29 | NR | PVG03633.1 | 109899 | g16376 | i0 | 55.7 | 2.67341772151899 | 106 | 42 | 77.5 | 2 | 317 | 12 | 42 | 146 | PVG03633.1 hypothetical protein CPB86DRAFT_748997 [Serendipita vermifera] | diamond | 1056 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 27682923 | 27682923 | PRJNA690124_P_NODE_1984_length_1060_cov_3.059777_g1749_i0 | PRJNA690124 | 1984 | 1060 | 3.059777 | 32.4336362 | Mixia osmundae IAM 14324 | 764103 | Fungi | Fungi | 387 | 3.83e-128 | NR | XP_014566342.1 | 764103 | g1749 | i0 | 55.7 | 15.3141509433962 | 332 | 135 | 94 | 3 | 1049 | 54 | 121 | 440 | XP_014566342.1 uncharacterized protein L969DRAFT_89758 [Mixia osmundae IAM 14324] | diamond | 16233 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Mixiomycetes | Mixiales | Mixiaceae | Mixia | Mixia osmundae | |
| 27746002 | 27746002 | PRJNA690124_P_NODE_54504_length_243_cov_0.917647_g54138_i0 | PRJNA690124 | 54504 | 243 | 0.917647 | 2.22988221 | Pseudohyphozyma bogoriensis | 106002 | Fungi | Fungi | 42.7 | 0.0386 | NR | KAI5477047.1 | 106002 | g54138 | i0 | 45.5 | 0.54320987654321 | 44 | 23 | 54.3 | 1 | 237 | 106 | 9 | 51 | KAI5477047.1 hypothetical protein MNV49_006923 [Pseudohyphozyma bogoriensis] | diamond | 132 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Chrysozymaceae | Pseudohyphozyma | Pseudohyphozyma bogoriensis | ||
| 28136261 | 28136261 | PRJNA690124_P_NODE_10445_length_497_cov_2.004717_g10080_i0 | PRJNA690124 | 10445 | 497 | 2.004717 | 9.96344349 | Fungi | 4751 | Fungi | Fungi | 158 | 7.22e-44 | NR | KAG6331729.1 | 265491 | g10080 | i0 | 52.1 | 15.7364185110664 | 163 | 77 | 98.4 | 1 | 489 | 1 | 94 | 255 | KAG6331729.1 hypothetical protein ID866_7358 [Astraeus odoratus] | diamond | 7821 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Astraeaceae | Astraeus | Astraeus odoratus | |
| 29103583 | 29103583 | PRJNA690124_P_NODE_49688_length_247_cov_1.327586_g49322_i0 | PRJNA690124 | 49688 | 247 | 1.327586 | 3.27913742 | Cylindrobasidium torrendii FP15 | 394432 | Fungi | Fungi | 64.7 | 7.34e-10 | NR | KIY74395.1 | 1314674 | g49322 | i0 | 56.5 | 0.753036437246964 | 62 | 21 | 75.3 | 1 | 232 | 47 | 1002 | 1057 | KIY74395.1 hypothetical protein CYLTODRAFT_416234 [Cylindrobasidium torrendii FP15055 ss-10] | diamond | 186 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium torrendii | |
| 29714436 | 29714436 | PRJNA690124_P_NODE_31810_length_293_cov_2.145455_g31444_i0 | PRJNA690124 | 31810 | 293 | 2.145455 | 6.28618315 | Cutaneotrichosporon | 1838142 | Fungi | Fungi | 71.6 | 4.81e-12 | NR | XP_060458265.1 | 279322 | g31444 | i0 | 63.3 | 1.62798634812287 | 90 | 32 | 91.1 | 1 | 268 | 2 | 690 | 779 | XP_060458265.1 uncharacterized protein CcaverHIS019_0506280 [Cutaneotrichosporon cavernicola] | diamond | 477 | 72 | 0.994444444444444 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon cavernicola | |
| 30725693 | 30725693 | PRJNA690124_P_NODE_33834_length_285_cov_1.910377_g33468_i0 | PRJNA690124 | 33834 | 285 | 1.910377 | 5.44457445 | Cutaneotrichosporon | 1838142 | Fungi | Fungi | 116 | 6.62e-28 | NR | BEI83727.1 | 279322 | g33468 | i0 | 71 | 2.61052631578947 | 93 | 27 | 97.9 | 0 | 281 | 3 | 903 | 995 | BEI83727.1 hypothetical protein CcaverHIS002_0403310 [Cutaneotrichosporon cavernicola] | diamond | 744 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon cavernicola | |
| 31187896 | 31187896 | PRJNA690124_P_NODE_6615_length_622_cov_3.812386_g6255_i0 | PRJNA690124 | 6615 | 622 | 3.812386 | 23.71304092 | Tricholoma matsutake 945 | 1095628 | Fungi | Fungi | 48.5 | 0.00608 | NR | KAF8234535.1 | 1095628 | g6255 | i0 | 34.8 | 0.332797427652733 | 69 | 45 | 33.3 | 0 | 330 | 536 | 94 | 162 | KAF8234535.1 hypothetical protein L208DRAFT_1376882 [Tricholoma matsutake 945] | diamond | 207 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Tricholomataceae | Tricholoma | Tricholoma matsutake |
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);;