contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA399133" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26632248 | 26632248 | PRJNA399133_P_NODE_5261_length_229_cov_1.752577_g5173_i0 | PRJNA399133 | 5261 | 229 | 1.752577 | 4.01340133 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 41.6 | 0.0201 | NR | KAH0207543.1 | 46634 | g5173 | i0 | 100 | 0.209606986899563 | 16 | 0 | 21 | 0 | 21 | 68 | 45 | 60 | KAH0207543.1 hypothetical protein KCU99_g36, partial [Aureobasidium melanogenum] | diamond | 48 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 26870991 | 26870991 | PRJNA399133_P_NODE_5001_length_229_cov_2.072165_g4913_i0 | PRJNA399133 | 5001 | 229 | 2.072165 | 4.74525785 | Chordata | 7711 | Chordata | Chordata | 51.2 | 3.25e-5 | NR | XP_007885991.2 | 7868 | g4913 | i0 | 100 | 197.449781659389 | 24 | 0 | 31.4 | 0 | 2 | 73 | 697 | 720 | XP_007885991.2 liprin-beta-2 isoform X2 [Callorhinchus milii] | diamond | 45216 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 27644292 | 27644292 | PRJNA399133_P_NODE_4964_length_229_cov_2.206186_g4876_i0 | PRJNA399133 | 4964 | 229 | 2.206186 | 5.05216594 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 50.1 | 7.8e-5 | NR | KAH0409634.1 | 46634 | g4876 | i0 | 100 | 1.57205240174672 | 24 | 0 | 31.4 | 0 | 156 | 227 | 424 | 447 | KAH0409634.1 glycoside hydrolase, partial [Aureobasidium melanogenum] | diamond | 360 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 27739152 | 27739152 | PRJNA399133_P_NODE_5024_length_229_cov_2.020619_g4936_i0 | PRJNA399133 | 5024 | 229 | 2.020619 | 4.62721751 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 52.4 | 1.62e-6 | NR | KAG9888057.1 | 46634 | g4936 | i0 | 100 | 1.96506550218341 | 25 | 0 | 32.8 | 0 | 75 | 1 | 39 | 63 | KAG9888057.1 hypothetical protein KCV05_g18927, partial [Aureobasidium melanogenum] | diamond | 450 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 29096587 | 29096587 | PRJNA399133_P_NODE_9608_length_170_cov_1.185185_g9520_i0 | PRJNA399133 | 9608 | 170 | 1.185185 | 2.0148145 | Leptotrombidium deliense | 299467 | Arthropoda | Arthropoda | 69.7 | 1.31e-12 | NR | RWS23085.1 | 299467 | g9520 | i0 | 60.4 | 0.847058823529412 | 48 | 18 | 84.7 | 1 | 150 | 7 | 22 | 68 | RWS23085.1 hypothetical protein B4U80_13961 [Leptotrombidium deliense] | diamond | 144 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense | |
| 29365854 | 29365854 | PRJNA399133_P_NODE_5069_length_229_cov_1.953608_g4981_i0 | PRJNA399133 | 5069 | 229 | 1.953608 | 4.47376232 | Malassezia | 55193 | Fungi | Fungi | 47.4 | 7.32e-4 | NR | WFD04011.1 | 76774 | g4981 | i0 | 38.7 | 1.95196506550218 | 75 | 37 | 98.3 | 1 | 228 | 4 | 402 | 467 | WFD04011.1 hypothetical protein MOBT1_002708 [Malassezia obtusa] | diamond | 447 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia obtusa | |
| 29886016 | 29886016 | PRJNA399133_P_NODE_12031_length_152_cov_3.418803_g11943_i0 | PRJNA399133 | 12031 | 152 | 3.418803 | 5.19658056 | Hortaea werneckii | 91943 | Fungi | Fungi | 46.6 | 4.27e-4 | NR | KAI7165328.1 | 91943 | g11943 | i0 | 75.9 | 0.572368421052632 | 29 | 7 | 57.2 | 0 | 87 | 1 | 127 | 155 | KAI7165328.1 hypothetical protein KC349_g25 [Hortaea werneckii] | diamond | 87 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 30123563 | 30123563 | PRJNA399133_P_NODE_8432_length_180_cov_3.124138_g8344_i0 | PRJNA399133 | 8432 | 180 | 3.124138 | 5.6234484 | Malassezia | 55193 | Fungi | Fungi | 42.4 | 0.00638 | NR | XP_027484461.1 | 76775 | g8344 | i0 | 95.8 | 0.8 | 24 | 1 | 40 | 0 | 179 | 108 | 7 | 30 | XP_027484461.1 uncharacterized protein MRET_1845 [Malassezia restricta] | diamond | 144 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30233379 | 30233379 | PRJNA399133_P_NODE_6592_length_204_cov_2.639053_g6504_i0 | PRJNA399133 | 6592 | 204 | 2.639053 | 5.38366812 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 81.6 | 2.85e-17 | NR | KAH0046435.1 | 46634 | g6504 | i0 | 91.1 | 0.661764705882353 | 45 | 4 | 66.2 | 0 | 190 | 56 | 150 | 194 | KAH0046435.1 hypothetical protein KCU78_g57, partial [Aureobasidium melanogenum] | diamond | 135 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 30233381 | 30233381 | PRJNA399133_P_NODE_8712_length_178_cov_1.118881_g8624_i0 | PRJNA399133 | 8712 | 178 | 1.118881 | 1.99160818 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 55.5 | 5.16e-7 | NR | KNE56084.1 | 578462 | g8624 | i0 | 58.3 | 0.808988764044944 | 48 | 18 | 80.9 | 1 | 34 | 177 | 342 | 387 | KNE56084.1 hypothetical protein AMAG_01927 [Allomyces macrogynus ATCC 38327] | diamond | 144 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 30297060 | 30297060 | PRJNA399133_P_NODE_5292_length_229_cov_1.711340_g5204_i0 | PRJNA399133 | 5292 | 229 | 1.71134 | 3.9189686 | Malassezia cuniculi | 948313 | Fungi | Fungi | 49.7 | 1.1e-4 | NR | WFD34210.1 | 948313 | g5204 | i0 | 91.7 | 0.314410480349345 | 24 | 2 | 31.4 | 0 | 157 | 228 | 371 | 394 | WFD34210.1 dihydrolipoyllysine-residue succinyltransferase [Malassezia cuniculi] | diamond | 72 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi | |
| 30802035 | 30802035 | PRJNA399133_P_NODE_8514_length_180_cov_1.103448_g8426_i0 | PRJNA399133 | 8514 | 180 | 1.103448 | 1.9862064 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 62.4 | 1.83e-9 | NR | GHJ89788.1 | 104408 | g8426 | i0 | 100 | 0.55 | 33 | 0 | 55 | 0 | 178 | 80 | 583 | 615 | GHJ89788.1 hypothetical protein NliqN6_6190 [Naganishia liquefaciens] | diamond | 99 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 31371201 | 31371201 | PRJNA399133_P_NODE_4136_length_248_cov_4.009390_g4048_i0 | PRJNA399133 | 4136 | 248 | 4.00939 | 9.9432872 | Hortaea werneckii | 91943 | Fungi | Fungi | 41.2 | 0.0371 | NR | RMZ14196.1 | 91943 | g4048 | i0 | 51 | 0.592741935483871 | 49 | 16 | 59.3 | 1 | 78 | 224 | 53 | 93 | RMZ14196.1 hypothetical protein D0864_00250 [Hortaea werneckii] | diamond | 147 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 31434168 | 31434168 | PRJNA399133_P_NODE_8696_length_178_cov_1.398601_g8608_i0 | PRJNA399133 | 8696 | 178 | 1.398601 | 2.48950978 | Araneus ventricosus | 182803 | Arthropoda | Arthropoda | 51.2 | 1.62e-5 | NR | GBN61280.1 | 182803 | g8608 | i0 | 56.8 | 5.6123595505618 | 44 | 19 | 74.2 | 0 | 2 | 133 | 1145 | 1188 | GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] | diamond | 999 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 31623976 | 31623976 | PRJNA399133_P_NODE_2336_length_325_cov_1.365517_g2248_i0 | PRJNA399133 | 2336 | 325 | 1.365517 | 4.43793025 | Powellomyces hirtus | 109895 | Fungi | Fungi | 157 | 3.75e-47 | NR | KAI8920797.1 | 109895 | g2248 | i0 | 76 | 6.38769230769231 | 100 | 24 | 92.3 | 0 | 2 | 301 | 25 | 124 | KAI8920797.1 ribosomal protein S27a, partial [Powellomyces hirtus] | diamond | 2076 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 31655466 | 31655466 | PRJNA399133_P_NODE_4837_length_230_cov_8.497436_g4749_i0 | PRJNA399133 | 4837 | 230 | 8.497436 | 19.5441028 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 148 | 1.21e-41 | NR | KAG9680159.1 | 46634 | g4749 | i0 | 94.5 | 1.90434782608696 | 73 | 4 | 95.2 | 0 | 229 | 11 | 57 | 129 | KAG9680159.1 hypothetical protein KCU87_g307, partial [Aureobasidium melanogenum] | diamond | 438 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 32257125 | 32257125 | PRJNA399133_P_NODE_9958_length_167_cov_1.212121_g9870_i0 | PRJNA399133 | 9958 | 167 | 1.212121 | 2.02424207 | [Torrubiella] hemipterigena | 1531966 | Fungi | Fungi | 58.5 | 3.53e-8 | NR | CEJ88720.1 | 1531966 | g9870 | i0 | 47.3 | 0.988023952095808 | 55 | 29 | 98.8 | 0 | 1 | 165 | 145 | 199 | CEJ88720.1 hypothetical protein VHEMI04801 [[Torrubiella] hemipterigena] | diamond | 165 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | [Torrubiella] hemipterigena | ||
| 32573403 | 32573403 | PRJNA399133_P_NODE_5159_length_229_cov_1.850515_g5071_i0 | PRJNA399133 | 5159 | 229 | 1.850515 | 4.23767935 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 51.6 | 2.31e-5 | NR | AYO44189.1 | 425264 | g5071 | i0 | 88 | 0.327510917030568 | 25 | 3 | 32.8 | 0 | 228 | 154 | 313 | 337 | AYO44189.1 25S rRNA (adenine(645)-N(1))-methyltransferase [Malassezia restricta CBS 7877] | diamond | 75 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;