contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA720429" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2468904 | 2468904 | PRJNA720429_P_NODE_402_length_635_cov_2.389680_g348_i0 | PRJNA720429 | 402 | 635 | 2.38968 | 15.174468 | Sus scrofa | 9823 | Chordata | Chordata | 377 | 8.42e-127 | NR | XP_020938199.1 | 9823 | g348 | i0 | 100 | 1.75748031496063 | 186 | 0 | 87.9 | 0 | 76 | 633 | 65 | 250 | XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] | diamond | 1116 | 377 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 3261295 | 3261295 | PRJNA720429_P_NODE_4083_length_247_cov_0.885057_g4026_i0 | PRJNA720429 | 4083 | 247 | 0.885057 | 2.18609079 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 110 | 2.07e-27 | NR | CAF0892122.1 | 104777 | g4026 | i0 | 71.6 | 3.93522267206478 | 81 | 23 | 98.4 | 0 | 3 | 245 | 3 | 83 | CAF0892122.1 unnamed protein product [Brachionus calyciflorus] | diamond | 972 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 8363310 | 8363310 | PRJNA720429_P_NODE_3487_length_250_cov_0.870056_g3430_i0 | PRJNA720429 | 3487 | 250 | 0.870056 | 2.17514 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 142 | 5.419999999999999e-38 | NR | XP_069231962.1 | 1052096 | g3430 | i0 | 91.5 | 1.968 | 82 | 7 | 98.4 | 0 | 3 | 248 | 428 | 509 | XP_069231962.1 uncharacterized protein WHR41_02628 [Cladosporium halotolerans] | diamond | 492 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 13463773 | 13463773 | PRJNA720429_P_NODE_4271_length_246_cov_0.890173_g4214_i0 | PRJNA720429 | 4271 | 246 | 0.890173 | 2.18982558 | Verruconis gallopava | 253628 | Fungi | Fungi | 164 | 2.3599999999999998e-48 | NR | XP_016213952.1 | 253628 | g4214 | i0 | 91.4 | 0.98780487804878 | 81 | 7 | 98.8 | 0 | 2 | 244 | 202 | 282 | XP_016213952.1 phosphoadenosine phosphosulfate reductase [Verruconis gallopava] | diamond | 243 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Sympoventuriaceae | Verruconis | Verruconis gallopava | |
| 18561839 | 18561839 | PRJNA720429_P_NODE_4535_length_244_cov_0.900585_g4478_i0 | PRJNA720429 | 4535 | 244 | 0.900585 | 2.1974274 | Stachybotrys chartarum IBT 7711 | 1280523 | Fungi | Fungi | 163 | 1.62e-47 | NR | KEY68132.1 | 1280523 | g4478 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 1 | 243 | 153 | 233 | KEY68132.1 hypothetical protein S7711_05541 [Stachybotrys chartarum IBT 7711] | diamond | 243 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Stachybotryaceae | Stachybotrys | Stachybotrys chartarum | |
| 23663044 | 23663044 | PRJNA720429_P_NODE_3719_length_248_cov_1.405714_g3662_i0 | PRJNA720429 | 3719 | 248 | 1.405714 | 3.48617072 | Eukaryota | 2759 | Fungi | Fungi | 138 | 4.12e-39 | NR | TPX69010.1 | 246404 | g3662 | i0 | 81.7 | 3.96774193548387 | 82 | 15 | 99.2 | 0 | 3 | 248 | 61 | 142 | TPX69010.1 hypothetical protein CcCBS67573_g06961 [Chytriomyces confervae] | diamond | 984 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces confervae | |
| 26735091 | 26735091 | PRJNA720429_P_NODE_2321_length_284_cov_0.890995_g2264_i0 | PRJNA720429 | 2321 | 284 | 0.890995 | 2.5304258 | Kockiozyma suomiensis | 1337062 | Fungi | Fungi | 58.5 | 3.05e-8 | NR | XP_066765151.1 | 1337062 | g2264 | i0 | 31.5 | 1.84859154929577 | 89 | 61 | 94 | 0 | 276 | 10 | 39 | 127 | XP_066765151.1 ubiquitin-related domain-containing protein [Kockiozyma suomiensis] | diamond | 525 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Kockiozyma | Kockiozyma suomiensis | |
| 27020419 | 27020419 | PRJNA720429_P_NODE_4842_length_242_cov_0.911243_g4785_i0 | PRJNA720429 | 4842 | 242 | 0.911243 | 2.20520806 | Icmadophila ericetorum | 90408 | Fungi | Fungi | 43.9 | 0.0148 | NR | MCJ1351926.1 | 90408 | g4785 | i0 | 43.1 | 0.71900826446281 | 58 | 33 | 71.9 | 0 | 218 | 45 | 9 | 66 | MCJ1351926.1 hypothetical protein [Icmadophila ericetorum] | diamond | 174 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Pertusariales | Icmadophilaceae | Icmadophila | Icmadophila ericetorum | |
| 27399858 | 27399858 | PRJNA720429_P_NODE_3603_length_249_cov_0.875000_g3546_i0 | PRJNA720429 | 3603 | 249 | 0.875 | 2.17875 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 70.9 | 2.75e-13 | NR | KAJ1510890.1 | 945690 | g3546 | i0 | 53.5 | 9.55421686746988 | 71 | 31 | 83.1 | 1 | 209 | 3 | 3 | 73 | KAJ1510890.1 ribosomal protein S15 [Coelomomyces lativittatus] | diamond | 2379 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 27462998 | 27462998 | PRJNA720429_P_NODE_2203_length_288_cov_1.144186_g2146_i0 | PRJNA720429 | 2203 | 288 | 1.144186 | 3.29525568 | Trichoderma virens Gv29-8 | 413071 | Fungi | Fungi | 89 | 3.0600000000000003e-21 | NR | XP_013953124.1 | 413071 | g2146 | i0 | 87.8 | 1.02083333333333 | 49 | 6 | 51 | 0 | 2 | 148 | 2 | 50 | XP_013953124.1 uncharacterized protein TRIVIDRAFT_225473 [Trichoderma virens Gv29-8] | diamond | 294 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma virens | |
| 28315440 | 28315440 | PRJNA720429_P_NODE_3886_length_248_cov_0.880000_g3829_i0 | PRJNA720429 | 3886 | 248 | 0.88 | 2.1824 | Botrytis byssoidea | 139641 | Fungi | Fungi | 48.9 | 3.36e-5 | NR | XP_038736525.1 | 139641 | g3829 | i0 | 69.4 | 0.435483870967742 | 36 | 11 | 43.5 | 0 | 18 | 125 | 56 | 91 | XP_038736525.1 uncharacterized protein EAE97_002807 [Botrytis byssoidea] | diamond | 108 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis byssoidea | |
| 28631325 | 28631325 | PRJNA720429_P_NODE_4687_length_243_cov_0.905882_g4630_i0 | PRJNA720429 | 4687 | 243 | 0.905882 | 2.20129326 | Oleoguttula sp. CCFEE 5521 | 2901242 | Fungi | Fungi | 90.9 | 4.18e-19 | NR | KAK6441762.1 | 2901242 | g4630 | i0 | 62 | 3.91358024691358 | 79 | 29 | 97.5 | 1 | 241 | 5 | 424 | 501 | KAK6441762.1 hypothetical protein LTR95_002016 [Oleoguttula sp. CCFEE 5521] | diamond | 951 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Oleoguttula | Oleoguttula sp. CCFEE 5521 | |
| 28851925 | 28851925 | PRJNA720429_P_NODE_2408_length_280_cov_1.487923_g2351_i0 | PRJNA720429 | 2408 | 280 | 1.487923 | 4.1661844 | Medioppia subpectinata | 1979941 | Arthropoda | Arthropoda | 131 | 4.34e-36 | NR | CAD7627118.1 | 1979941 | g2351 | i0 | 75.6 | 11.3464285714286 | 86 | 21 | 92.1 | 0 | 278 | 21 | 24 | 109 | CAD7627118.1 unnamed protein product [Medioppia subpectinata] | diamond | 3177 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Medioppia | Medioppia subpectinata | |
| 29325617 | 29325617 | PRJNA720429_P_NODE_4909_length_242_cov_0.911243_g4852_i0 | PRJNA720429 | 4909 | 242 | 0.911243 | 2.20520806 | Microbotryomycetes sp. JL221 | 2987685 | Fungi | Fungi | 136 | 4.69e-35 | NR | KAK4049731.1 | 2987685 | g4852 | i0 | 86.8 | 1.79752066115702 | 76 | 10 | 94.2 | 0 | 13 | 240 | 450 | 525 | KAK4049731.1 Vacuolar import and degradation protein 27 [Microbotryomycetes sp. JL221] | diamond | 435 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Microbotryomycetes sp. JL221 | ||||
| 29357361 | 29357361 | PRJNA720429_P_NODE_4349_length_245_cov_0.895349_g4292_i0 | PRJNA720429 | 4349 | 245 | 0.895349 | 2.19360505 | Steinernema hermaphroditum | 289476 | Nematoda | Nematoda | 73.2 | 7.23e-13 | NR | KAK0424339.1 | 289476 | g4292 | i0 | 64.7 | 3.24489795918367 | 51 | 18 | 62.4 | 0 | 154 | 2 | 276 | 326 | KAK0424339.1 hypothetical protein QR680_008618 [Steinernema hermaphroditum] | diamond | 795 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema hermaphroditum | |
| 29672716 | 29672716 | PRJNA720429_P_NODE_5070_length_241_cov_0.916667_g5013_i0 | PRJNA720429 | 5070 | 241 | 0.916667 | 2.20916747 | Gomphillus americanus | 1940652 | Fungi | Fungi | 67 | 4.57e-11 | NR | CAF9926776.1 | 1940652 | g5013 | i0 | 43.2 | 1.00829875518672 | 81 | 43 | 97.1 | 1 | 238 | 5 | 100 | 180 | CAF9926776.1 MAG: hypothetical protein GOMPHAMPRED_004218 [Gomphillus americanus] | diamond | 243 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Gomphillus | Gomphillus americanus | |
| 30747210 | 30747210 | PRJNA720429_P_NODE_2314_length_284_cov_1.303318_g2257_i0 | PRJNA720429 | 2314 | 284 | 1.303318 | 3.70142312 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 152 | 3.24e-41 | NR | XP_069226042.1 | 1052096 | g2257 | i0 | 85.1 | 0.992957746478873 | 94 | 13 | 99.3 | 1 | 3 | 284 | 372 | 464 | XP_069226042.1 uncharacterized protein WHR41_08188 [Cladosporium halotolerans] | diamond | 282 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 30999997 | 30999997 | PRJNA720429_P_NODE_4014_length_247_cov_0.885057_g3957_i0 | PRJNA720429 | 4014 | 247 | 0.885057 | 2.18609079 | Mya arenaria | 6604 | Mollusca | Mollusca | 52.8 | 6.86e-6 | NR | XP_052770210.1 | 6604 | g3957 | i0 | 40 | 1.55465587044534 | 65 | 39 | 78.9 | 0 | 21 | 215 | 138 | 202 | XP_052770210.1 vesicle transport through interaction with t-SNAREs homolog 1B-like [Mya arenaria] | diamond | 384 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31073651 | 31073651 | PRJNA720429_P_NODE_4775_length_243_cov_0.905882_g4718_i0 | PRJNA720429 | 4775 | 243 | 0.905882 | 2.20129326 | Xylaria | 37991 | Fungi | Fungi | 50.8 | 5.09e-5 | NR | KAI0545556.1 | 42375 | g4718 | i0 | 35.6 | 2.32098765432099 | 73 | 42 | 84 | 1 | 40 | 243 | 172 | 244 | KAI0545556.1 heterokaryon incompatibility protein-domain-containing protein [Xylaria curta] | diamond | 564 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria curta | |
| 31980171 | 31980171 | PRJNA720429_P_NODE_3878_length_248_cov_0.880000_g3821_i0 | PRJNA720429 | 3878 | 248 | 0.88 | 2.1824 | Penicillium chermesinum | 63820 | Fungi | Fungi | 53.1 | 8.48e-6 | NR | XP_058326521.1 | 63820 | g3821 | i0 | 36.3 | 0.967741935483871 | 80 | 50 | 95.6 | 1 | 241 | 5 | 376 | 455 | XP_058326521.1 uncharacterized protein N7468_008895 [Penicillium chermesinum] | diamond | 240 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chermesinum | |
| 32339025 | 32339025 | PRJNA720429_P_NODE_3399_length_250_cov_0.870056_g3342_i0 | PRJNA720429 | 3399 | 250 | 0.870056 | 2.17514 | Basidiomycota | 5204 | Fungi | Fungi | 87 | 1.04e-17 | NR | KAK1927683.1 | 5418 | g3342 | i0 | 49.4 | 9.48 | 81 | 38 | 97.2 | 1 | 243 | 1 | 350 | 427 | KAK1927683.1 phosphate transporter [Papiliotrema laurentii] | diamond | 2370 | 87.4 | 0.995423340961098 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii |
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);;