contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA864829" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27308168 | 27308168 | PRJNA864829_S_NODE_10663_length_194_cov_1.489655_g10577_i0 | PRJNA864829 | 10663 | 194 | 1.489655 | 2.8899307 | Schizosaccharomyces pombe | 4896 | Fungi | Fungi | 75.9 | 6.59e-16 | NR | NP_588143.1 | 4896 | g10577 | i0 | 62.5 | 1.7319587628866 | 56 | 21 | 86.6 | 0 | 179 | 12 | 48 | 103 | NP_588143.1 60S ribosomal protein L34 [Schizosaccharomyces pombe] | diamond | 336 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 27537253 | 27537253 | PRJNA864829_S_NODE_15303_length_167_cov_0.889831_g15217_i0 | PRJNA864829 | 15303 | 167 | 0.889831 | 1.48601777 | Chaetomiaceae | 35718 | Fungi | Fungi | 65.5 | 6.04e-12 | NR | KAL1835581.1 | 85995 | g15217 | i0 | 55.6 | 2.91017964071856 | 54 | 9 | 97 | 2 | 6 | 167 | 52 | 90 | KAL1835581.1 hypothetical protein VTJ49DRAFT_6440 [Mycothermus thermophilus] | diamond | 486 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Mycothermus | Mycothermus thermophilus | |
| 28926406 | 28926406 | PRJNA864829_S_NODE_14548_length_170_cov_0.876033_g14462_i0 | PRJNA864829 | 14548 | 170 | 0.876033 | 1.4892561 | Eukaryota | 2759 | Fungi | Fungi | 79.7 | 1.27e-15 | NR | EMG46868.1 | 1245528 | g14462 | i0 | 78.7 | 12.7411764705882 | 47 | 10 | 82.9 | 0 | 3 | 143 | 372 | 418 | EMG46868.1 Polyadenylate-binding protein, cytoplasmic and nuclear [Candida maltosa Xu316] | diamond | 2166 | 80.1 | 0.995006242197254 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida maltosa | |
| 28950119 | 28950119 | PRJNA864829_S_NODE_6688_length_236_cov_3.096257_g6602_i0 | PRJNA864829 | 6688 | 236 | 3.096257 | 7.30716652 | Xylaria scruposa | 743287 | Fungi | Fungi | 46.6 | 3.57e-4 | NR | KAI1733355.1 | 743287 | g6602 | i0 | 69 | 1.19491525423729 | 29 | 9 | 36.9 | 0 | 234 | 148 | 15 | 43 | KAI1733355.1 hypothetical protein F4680DRAFT_463211 [Xylaria scruposa] | diamond | 282 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria scruposa | |
| 30371510 | 30371510 | PRJNA864829_S_NODE_4092_length_284_cov_1.876596_g4006_i0 | PRJNA864829 | 4092 | 284 | 1.876596 | 5.32953264 | [Candida] subhashii | 561895 | Fungi | Fungi | 50.1 | 1.63e-4 | NR | XP_049261443.1 | 561895 | g4006 | i0 | 40 | 0.845070422535211 | 80 | 36 | 83.5 | 3 | 37 | 273 | 526 | 594 | XP_049261443.1 uncharacterized protein J8A68_005278, partial [[Candida] subhashii] | diamond | 240 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Spathaspora | [Candida] subhashii | |
| 31983231 | 31983231 | PRJNA864829_S_NODE_8978_length_209_cov_1.168750_g8892_i0 | PRJNA864829 | 8978 | 209 | 1.16875 | 2.4426875 | Tothia fuscella | 1048955 | Fungi | Fungi | 40.8 | 0.0144 | NR | KAF2413444.1 | 1048955 | g8892 | i0 | 56.8 | 0.5311004784689 | 37 | 16 | 53.1 | 0 | 99 | 209 | 13 | 49 | KAF2413444.1 hypothetical protein EJ08DRAFT_601403, partial [Tothia fuscella] | diamond | 111 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Cylindrosympodiaceae | Tothia | Tothia fuscella | |
| 32109898 | 32109898 | PRJNA864829_S_NODE_11218_length_190_cov_1.645390_g11132_i0 | PRJNA864829 | 11218 | 190 | 1.64539 | 3.126241 | Onygenales sp. PD_12 | 2135916 | Fungi | Fungi | 51.6 | 1.39e-5 | NR | KAK2789604.1 | 2135916 | g11132 | i0 | 42.9 | 4.98947368421053 | 63 | 35 | 97.9 | 1 | 187 | 2 | 222 | 284 | KAK2789604.1 heme peroxidase [Onygenales sp. PD_12] | diamond | 948 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Onygenales sp. PD_12 | |||
| 32561264 | 32561264 | PRJNA864829_S_NODE_10759_length_193_cov_2.590278_g10673_i0 | PRJNA864829 | 10759 | 193 | 2.590278 | 4.99923654 | root | 1 | Root_unresolved | Root_unresolved | 60.1 | 1.49e-8 | NR | YP_010119226.1 | 36044 | g10673 | i0 | 42.6 | 2.82901554404145 | 61 | 35 | 94.8 | 0 | 192 | 10 | 620 | 680 | YP_010119226.1 reverse transcriptase domain-containing protein, partial [Erysiphe pisi] | diamond | 546 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe pisi |
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);;