contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5695402 | 5695402 | PRJNA613025_S_NODE_25205_length_187_cov_1.847826_g25051_i0 | PRJNA613025 | 25205 | 187 | 1.847826 | 3.45543462 | Rhizoclosmatium hyalinum | 2724196 | Fungi | Fungi | 73.2 | 4.08e-14 | NR | KAJ3073494.1 | 2724196 | g25051 | i0 | 70 | 0.802139037433155 | 50 | 15 | 80.2 | 0 | 11 | 160 | 137 | 186 | KAJ3073494.1 60S ribosomal protein L9A [Rhizoclosmatium hyalinum] | diamond | 150 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Rhizoclosmatium | Rhizoclosmatium hyalinum | |
| 8244793 | 8244793 | PRJNA613025_S_NODE_20587_length_215_cov_1.837349_g20433_i0 | PRJNA613025 | 20587 | 215 | 1.837349 | 3.95030035 | Eukaryota | 2759 | Fungi | Fungi | 116 | 4.7399999999999994e-30 | NR | KAJ3387474.1 | 109889 | g20433 | i0 | 81.2 | 16.7302325581395 | 69 | 13 | 96.3 | 0 | 2 | 208 | 11 | 79 | KAJ3387474.1 40S ribosomal protein S4 [Lobulomyces angularis] | diamond | 3597 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Lobulomyces | Lobulomyces angularis | |
| 27206466 | 27206466 | PRJNA613025_S_NODE_32562_length_163_cov_0.894737_g32408_i0 | PRJNA613025 | 32562 | 163 | 0.894737 | 1.45842131 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 110 | 2.19e-26 | NR | KAH9257606.1 | 1357716 | g32408 | i0 | 90.7 | 0.993865030674847 | 54 | 5 | 99.4 | 0 | 162 | 1 | 275 | 328 | KAH9257606.1 hypothetical protein BASA81_004055 [Batrachochytrium salamandrivorans] | diamond | 162 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 27219500 | 27219500 | PRJNA613025_S_NODE_17162_length_248_cov_2.522613_g17008_i0 | PRJNA613025 | 17162 | 248 | 2.522613 | 6.25608024 | Chytriomyces | 109882 | Fungi | Fungi | 125 | 2.8199999999999996e-31 | NR | KAJ3237501.1 | 4814 | g17008 | i0 | 82.2 | 8.84274193548387 | 73 | 13 | 88.3 | 0 | 247 | 29 | 520 | 592 | KAJ3237501.1 Aspartate aminotransferase, cytoplasmic [Chytriomyces hyalinus] | diamond | 2193 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 27996368 | 27996368 | PRJNA613025_S_NODE_32425_length_163_cov_1.324561_g32271_i0 | PRJNA613025 | 32425 | 163 | 1.324561 | 2.15903443 | Polyrhizophydium stewartii | 2732419 | Fungi | Fungi | 72.8 | 1.41e-14 | NR | KAL2915722.1 | 2732419 | g32271 | i0 | 69.8 | 1.95092024539877 | 53 | 16 | 97.5 | 0 | 161 | 3 | 68 | 120 | KAL2915722.1 40S ribosomal protein S16 [Polyrhizophydium stewartii] | diamond | 318 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Polyrhizophydium | Polyrhizophydium stewartii | ||
| 28564632 | 28564632 | PRJNA613025_S_NODE_30327_length_167_cov_0.864407_g30173_i0 | PRJNA613025 | 30327 | 167 | 0.864407 | 1.44355969 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 107 | 2.32e-27 | NR | KAH9248333.1 | 1357716 | g30173 | i0 | 96.4 | 0.988023952095808 | 55 | 2 | 98.8 | 0 | 165 | 1 | 129 | 183 | KAH9248333.1 ribosomal protein L10.e [Batrachochytrium salamandrivorans] | diamond | 165 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29196214 | 29196214 | PRJNA613025_S_NODE_23629_length_196_cov_1.027211_g23475_i0 | PRJNA613025 | 23629 | 196 | 1.027211 | 2.01333356 | Blyttiomyces sp. JEL | 2750429 | Fungi | Fungi | 69.7 | 5.44e-12 | NR | KAJ3314914.1 | 2724214 | g23475 | i0 | 50.8 | 0.964285714285714 | 63 | 29 | 93.4 | 1 | 3 | 185 | 301 | 363 | KAJ3314914.1 hypothetical protein HDU76_002327 [Blyttiomyces sp. JEL0837] | diamond | 189 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Blyttiomyces | Blyttiomyces sp. JEL0837 | |||
| 30504120 | 30504120 | PRJNA613025_S_NODE_27233_length_178_cov_1.186047_g27079_i0 | PRJNA613025 | 27233 | 178 | 1.186047 | 2.11116366 | Opisthokonta | 33154 | Fungi | Fungi | 92.4 | 4.77e-20 | NR | KAJ3230186.1 | 4814 | g27079 | i0 | 74.1 | 61.5842696629214 | 58 | 15 | 97.8 | 0 | 3 | 176 | 439 | 496 | KAJ3230186.1 hypothetical protein HDU81_004679 [Chytriomyces hyalinus] | diamond | 10962 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 30617309 | 30617309 | PRJNA613025_S_NODE_30913_length_166_cov_0.871795_g30759_i0 | PRJNA613025 | 30913 | 166 | 0.871795 | 1.4471797 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 89.7 | 3.51e-19 | NR | KAH9257606.1 | 1357716 | g30759 | i0 | 75.9 | 0.975903614457831 | 54 | 13 | 97.6 | 0 | 3 | 164 | 393 | 446 | KAH9257606.1 hypothetical protein BASA81_004055 [Batrachochytrium salamandrivorans] | diamond | 162 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30680388 | 30680388 | PRJNA613025_S_NODE_31433_length_165_cov_0.879310_g31279_i0 | PRJNA613025 | 31433 | 165 | 0.87931 | 1.4508615 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 72.8 | 3.32e-13 | NR | KAH9248493.1 | 1357716 | g31279 | i0 | 61.8 | 1 | 55 | 21 | 100 | 0 | 1 | 165 | 229 | 283 | KAH9248493.1 hypothetical protein BASA81_013819 [Batrachochytrium salamandrivorans] | diamond | 165 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 31470943 | 31470943 | PRJNA613025_S_NODE_31216_length_165_cov_1.284483_g31062_i0 | PRJNA613025 | 31216 | 165 | 1.284483 | 2.11939695 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 41.2 | 0.0459 | NR | XP_052971629.1 | 110093 | g31062 | i0 | 51.3 | 1.41818181818182 | 39 | 19 | 70.9 | 0 | 163 | 47 | 1405 | 1443 | XP_052971629.1 uncharacterized protein BJ171DRAFT_470521 [Polychytrium aggregatum] | diamond | 234 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 31799895 | 31799895 | PRJNA613025_S_NODE_30317_length_167_cov_0.864407_g30163_i0 | PRJNA613025 | 30317 | 167 | 0.864407 | 1.44355969 | Fungi | 4751 | Fungi | Fungi | 66.2 | 6.75e-11 | NR | KAI9020469.1 | 82268 | g30163 | i0 | 57.4 | 13.4191616766467 | 54 | 23 | 97 | 0 | 166 | 5 | 200 | 253 | KAI9020469.1 pyridoxal phosphate-dependent transferase [Hyaloraphidium curvatum] | diamond | 2241 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 32148190 | 32148190 | PRJNA613025_S_NODE_33758_length_161_cov_0.910714_g33604_i0 | PRJNA613025 | 33758 | 161 | 0.910714 | 1.46624954 | Synchytriaceae | 286113 | Fungi | Fungi | 90.9 | 1.32e-19 | NR | TPX54992.1 | 286115 | g33604 | i0 | 81.1 | 9.87577639751553 | 53 | 10 | 98.8 | 0 | 2 | 160 | 469 | 521 | TPX54992.1 acetolactate synthase [Synchytrium endobioticum] | diamond | 1590 | 91.7 | 0.991275899672846 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 32685282 | 32685282 | PRJNA613025_S_NODE_19060_length_228_cov_2.458101_g18906_i0 | PRJNA613025 | 19060 | 228 | 2.458101 | 5.60447028 | Opisthokonta | 33154 | Fungi | Fungi | 76.3 | 1.12e-14 | NR | KAI8852759.1 | 64509 | g18906 | i0 | 61.4 | 11.8157894736842 | 57 | 22 | 75 | 0 | 2 | 172 | 188 | 244 | KAI8852759.1 40S ribosomal protein S4 [Chytridium lagenaria] | diamond | 2694 | 76.6 | 0.996083550913838 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria |
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);;