contig_metadata
8 rows where bioproject = "PRJNA637219", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 608800 | 608800 | PRJNA637219_S_NODE_1881_length_327_cov_1.140288_g1836_i0 | PRJNA637219 | 1881 | 327 | 1.140288 | 3.72874176 | Gonapodya sp. JEL | 2107737 | Fungi | Fungi | 134 | 1.23e-34 | NR | KAJ3342729.1 | 2725673 | g1836 | i0 | 59.6 | 0.908256880733945 | 99 | 40 | 90.8 | 0 | 300 | 4 | 333 | 431 | KAJ3342729.1 protein disulfide-isomerase precursor [Gonapodya sp. JEL0774] | diamond | 297 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya sp. JEL0774 | |
| 26827971 | 26827971 | PRJNA637219_S_NODE_4901_length_221_cov_1.779070_g4856_i0 | PRJNA637219 | 4901 | 221 | 1.77907 | 3.9317447 | Gaertneriomyces semiglobifer | 109897 | Fungi | Fungi | 45.8 | 0.00225 | NR | KAI8999341.1 | 109897 | g4856 | i0 | 40.8 | 0.665158371040724 | 49 | 29 | 66.5 | 0 | 7 | 153 | 6 | 54 | KAI8999341.1 hypothetical protein BC832DRAFT_594783 [Gaertneriomyces semiglobifer] | diamond | 147 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 27049492 | 27049492 | PRJNA637219_S_NODE_11522_length_166_cov_0.871795_g11477_i0 | PRJNA637219 | 11522 | 166 | 0.871795 | 1.4471797 | Blyttiomyces sp. JEL | 2750429 | Fungi | Fungi | 68.6 | 8.9e-12 | NR | KAJ3278065.1 | 2724214 | g11477 | i0 | 50.9 | 3.93975903614458 | 53 | 25 | 95.8 | 1 | 1 | 159 | 115 | 166 | KAJ3278065.1 hypothetical protein HDU76_010039 [Blyttiomyces sp. JEL0837] | diamond | 654 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Blyttiomyces | Blyttiomyces sp. JEL0837 | |||
| 27270589 | 27270589 | PRJNA637219_S_NODE_12643_length_165_cov_0.879310_g12598_i0 | PRJNA637219 | 12643 | 165 | 0.87931 | 1.4508615 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 46.6 | 5.83e-4 | NR | KAI9328679.1 | 2211651 | g12598 | i0 | 54.1 | 2.27272727272727 | 37 | 17 | 67.3 | 0 | 4 | 114 | 448 | 484 | KAI9328679.1 WD40-repeat-containing domain protein [Zopfochytrium polystomum] | diamond | 375 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 27428904 | 27428904 | PRJNA637219_S_NODE_9043_length_177_cov_1.085938_g8998_i0 | PRJNA637219 | 9043 | 177 | 1.085938 | 1.92211026 | Phlyctochytrium planicorne | 261098 | Fungi | Fungi | 78.2 | 2.93e-16 | NR | KAJ3096340.1 | 261098 | g8998 | i0 | 70.2 | 0.966101694915254 | 57 | 17 | 96.6 | 0 | 5 | 175 | 53 | 109 | KAJ3096340.1 hypothetical protein HDU97_006013 [Phlyctochytrium planicorne] | diamond | 171 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium planicorne | |
| 27965319 | 27965319 | PRJNA637219_S_NODE_7905_length_186_cov_1.116788_g7860_i0 | PRJNA637219 | 7905 | 186 | 1.116788 | 2.07722568 | Spizellomyces sp. 'palustris' | 117820 | Fungi | Fungi | 48.5 | 1.62e-4 | NR | TPX59569.1 | 117820 | g7860 | i0 | 81.5 | 0.435483870967742 | 27 | 5 | 43.5 | 0 | 103 | 183 | 154 | 180 | TPX59569.1 hypothetical protein SpCBS45565_g07698 [Spizellomyces sp. 'palustris'] | diamond | 81 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 28217722 | 28217722 | PRJNA637219_S_NODE_8026_length_185_cov_1.125000_g7981_i0 | PRJNA637219 | 8026 | 185 | 1.125 | 2.08125 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 46.2 | 0.00102 | NR | KAI8811837.1 | 109936 | g7981 | i0 | 75 | 0.389189189189189 | 24 | 6 | 38.9 | 0 | 75 | 4 | 194 | 217 | KAI8811837.1 hypothetical protein BJ742DRAFT_795723 [Cladochytrium replicatum] | diamond | 72 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 29177808 | 29177808 | PRJNA637219_S_NODE_16269_length_162_cov_0.902655_g16224_i0 | PRJNA637219 | 16269 | 162 | 0.902655 | 1.4623011 | Chytridiomycetes | 451435 | Fungi | Fungi | 68.9 | 6.4e-13 | NR | KAH9262557.1 | 1357716 | g16224 | i0 | 66.7 | 7.44444444444444 | 51 | 17 | 94.4 | 0 | 161 | 9 | 66 | 116 | KAH9262557.1 hypothetical protein BASA82_000386 [Batrachochytrium salamandrivorans] | diamond | 1206 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans |
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);;