contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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);;