contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8278754 | 8278754 | PRJNA658591_S_NODE_927_length_413_cov_2.271978_g864_i0 | PRJNA658591 | 927 | 413 | 2.271978 | 9.38326914 | Eukaryota | 2759 | Fungi | Fungi | 212 | 4.32e-68 | NR | KAJ1676764.1 | 68401 | g864 | i0 | 73.9 | 18.6682808716707 | 138 | 33 | 98.8 | 2 | 5 | 412 | 9 | 145 | KAJ1676764.1 Peptidyl-prolyl cis-trans isomerase 7, partial [Spiromyces aspiralis] | diamond | 7710 | 213 | 0.995305164319249 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 11364853 | 11364853 | PRJNA658591_S_NODE_9649_length_165_cov_0.896552_g9586_i0 | PRJNA658591 | 9649 | 165 | 0.896552 | 1.4793108 | Mycoemilia scoparia | 417184 | Fungi | Fungi | 60.1 | 9.67e-9 | NR | KAJ1911557.1 | 417184 | g9586 | i0 | 60.8 | 4.76363636363636 | 51 | 19 | 92.7 | 1 | 2 | 154 | 426 | 475 | KAJ1911557.1 ATP-dependent RNA helicase [Mycoemilia scoparia] | diamond | 786 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Mycoemilia | Mycoemilia scoparia | |
| 23578147 | 23578147 | PRJNA658591_S_NODE_879_length_421_cov_6.771505_g816_i0 | PRJNA658591 | 879 | 421 | 6.771505 | 28.50803605 | Ascomycota | 4890 | Fungi | Fungi | 226 | 3.820000000000001e-71 | NR | KAF3932129.1 | 47266 | g816 | i0 | 75.5 | 7.92399049881235 | 139 | 34 | 99 | 0 | 421 | 5 | 114 | 252 | KAF3932129.1 Beta-TrCP [Dactylellina cionopaga] | diamond | 3336 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Dactylellina | Dactylellina cionopaga | |
| 26954635 | 26954635 | PRJNA658591_S_NODE_7002_length_183_cov_1.597015_g6939_i0 | PRJNA658591 | 7002 | 183 | 1.597015 | 2.92253745 | Gorgonomyces haynaldii | 382530 | Fungi | Fungi | 81.6 | 8.5e-18 | NR | KAI8911690.1 | 382530 | g6939 | i0 | 62.7 | 1.9672131147541 | 59 | 22 | 96.7 | 0 | 7 | 183 | 26 | 84 | KAI8911690.1 NAC domain-containing protein [Gorgonomyces haynaldii] | diamond | 360 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 27883196 | 27883196 | PRJNA658591_S_NODE_7625_length_178_cov_1.209302_g7562_i0 | PRJNA658591 | 7625 | 178 | 1.209302 | 2.15255756 | Ascomycota | 4890 | Fungi | Fungi | 74.3 | 1.14e-13 | NR | RAL64089.1 | 38457 | g7562 | i0 | 62.5 | 9.37078651685393 | 56 | 21 | 94.4 | 0 | 177 | 10 | 188 | 243 | RAL64089.1 hypothetical protein DID88_003277 [Monilinia fructigena] | diamond | 1668 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Monilinia | Monilinia fructigena | |
| 28672725 | 28672725 | PRJNA658591_S_NODE_8927_length_168_cov_2.739496_g8864_i0 | PRJNA658591 | 8927 | 168 | 2.739496 | 4.60235328 | Ascomycota | 4890 | Fungi | Fungi | 65.9 | 9.69e-11 | NR | KAK8162722.1 | 1130410 | g8864 | i0 | 51.8 | 7.69642857142857 | 56 | 27 | 100 | 0 | 168 | 1 | 756 | 811 | KAK8162722.1 glycoside hydrolase family 3 protein [Phyllosticta citrichinensis] | diamond | 1293 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Phyllostictaceae | Phyllosticta | Phyllosticta citrichinensis | |
| 28692187 | 28692187 | PRJNA658591_S_NODE_2947_length_253_cov_3.279412_g2884_i0 | PRJNA658591 | 2947 | 253 | 3.279412 | 8.29691236 | Friedmanniomyces endolithicus | 329885 | Fungi | Fungi | 172 | 4.51e-53 | NR | KAK0330773.1 | 329885 | g2884 | i0 | 97.5 | 0.936758893280632 | 79 | 2 | 93.7 | 0 | 251 | 15 | 69 | 147 | KAK0330773.1 hypothetical protein LTR94_031517, partial [Friedmanniomyces endolithicus] | diamond | 237 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus | |
| 29134219 | 29134219 | PRJNA658591_S_NODE_9049_length_168_cov_0.873950_g8986_i0 | PRJNA658591 | 9049 | 168 | 0.87395 | 1.468236 | Irineochytrium annulatum | 109884 | Fungi | Fungi | 79 | 2.28e-15 | NR | KAJ3192026.1 | 109884 | g8986 | i0 | 63 | 2.92857142857143 | 54 | 20 | 96.4 | 0 | 167 | 6 | 243 | 296 | KAJ3192026.1 Insulinase (Peptidase M16) [Irineochytrium annulatum] | diamond | 492 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Irineochytrium | Irineochytrium annulatum | |
| 29386734 | 29386734 | PRJNA658591_S_NODE_9449_length_166_cov_0.888889_g9386_i0 | PRJNA658591 | 9449 | 166 | 0.888889 | 1.47555574 | Aspergillus tanneri | 1220188 | Fungi | Fungi | 49.7 | 4.77e-5 | NR | XP_033429431.1 | 1220188 | g9386 | i0 | 48.1 | 2.87349397590361 | 54 | 26 | 97.6 | 1 | 5 | 166 | 924 | 975 | XP_033429431.1 uncharacterized protein ATNIH1004_002751 [Aspergillus tanneri] | diamond | 477 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus tanneri | |
| 30219894 | 30219894 | PRJNA658591_S_NODE_8092_length_174_cov_1.640000_g8029_i0 | PRJNA658591 | 8092 | 174 | 1.64 | 2.8536 | Boothiomyces | 451452 | Fungi | Fungi | 54.7 | 7.08e-7 | NR | KAJ3259685.1 | 261099 | g8029 | i0 | 56.8 | 2.27586206896552 | 44 | 19 | 75.9 | 0 | 169 | 38 | 94 | 137 | KAJ3259685.1 Protein tyrosine phosphatase type IVA 1 [Boothiomyces macroporosus] | diamond | 396 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces macroporosus | |
| 30966221 | 30966221 | PRJNA658591_S_NODE_9014_length_168_cov_1.025210_g8951_i0 | PRJNA658591 | 9014 | 168 | 1.02521 | 1.7223528 | Lipomyces tetrasporus | 54092 | Fungi | Fungi | 44.7 | 0.00282 | NR | XP_056041472.1 | 54092 | g8951 | i0 | 73.1 | 1.85714285714286 | 26 | 7 | 46.4 | 0 | 167 | 90 | 1011 | 1036 | XP_056041472.1 flavoprotein subunit of succinate dehydrogenase [Lipomyces tetrasporus] | diamond | 312 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces tetrasporus | |
| 31736959 | 31736959 | PRJNA658591_S_NODE_7877_length_176_cov_0.897638_g7814_i0 | PRJNA658591 | 7877 | 176 | 0.897638 | 1.57984288 | Opisthokonta | 33154 | Fungi | Fungi | 53.1 | 3.13e-6 | NR | KAJ6256734.1 | 74499 | g7814 | i0 | 72.7 | 3.34090909090909 | 33 | 9 | 56.3 | 0 | 46 | 144 | 123 | 155 | KAJ6256734.1 hypothetical protein Dda_8601 [Drechslerella dactyloides] | diamond | 588 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Drechslerella | Drechslerella dactyloides | |
| 31819673 | 31819673 | PRJNA658591_S_NODE_1957_length_300_cov_1.254980_g1894_i0 | PRJNA658591 | 1957 | 300 | 1.25498 | 3.76494 | Wickerhamomyces pijperi | 599730 | Fungi | Fungi | 44.7 | 0.0156 | NR | KAH3681638.1 | 599730 | g1894 | i0 | 37.3 | 0.59 | 59 | 33 | 59 | 1 | 54 | 230 | 694 | 748 | KAH3681638.1 hypothetical protein WICPIJ_007398 [Wickerhamomyces pijperi] | diamond | 177 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces pijperi |
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);;