contig_metadata
8 rows where bioproject = "PRJNA854078", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4670165 | 4670165 | PRJNA854078_P_NODE_3264_length_526_cov_6.187638_g3052_i0 | PRJNA854078 | 3264 | 526 | 6.187638 | 32.54697588 | Eukaryota | 2759 | Fungi | Fungi | 72 | 1.44e-11 | NR | XP_016607783.1 | 645134 | g3052 | i0 | 32.5 | 3.93536121673004 | 120 | 77 | 66.2 | 2 | 6 | 353 | 67 | 186 | XP_016607783.1 Hsp90 cochaperone SBA1 [Spizellomyces punctatus DAOM BR117] | diamond | 2070 | 72.4 | 0.994475138121547 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 6338766 | 6338766 | PRJNA854078_P_NODE_2485_length_605_cov_2.212406_g2282_i0 | PRJNA854078 | 2485 | 605 | 2.212406 | 13.3850563 | Opisthokonta | 33154 | Fungi | Fungi | 283 | 3.82e-93 | NR | KAJ3134370.1 | 109957 | g2282 | i0 | 68.4 | 42.2380165289256 | 196 | 62 | 97.2 | 0 | 1 | 588 | 87 | 282 | KAJ3134370.1 Proteasome subunit beta type-8 [Physocladia obscura] | diamond | 25554 | 284 | 0.996478873239437 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 18693059 | 18693059 | PRJNA854078_P_NODE_655_length_1178_cov_5.414480_g527_i0 | PRJNA854078 | 655 | 1178 | 5.41448 | 63.7825744 | Opisthokonta | 33154 | Fungi | Fungi | 266 | 2.45e-84 | NR | KAI9021102.1 | 82268 | g527 | i0 | 67.8 | 44.2792869269949 | 208 | 61 | 51.4 | 2 | 1178 | 573 | 6 | 213 | KAI9021102.1 small GTPase [Hyaloraphidium curvatum] | diamond | 52161 | 266 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 18693095 | 18693095 | PRJNA854078_P_NODE_9415_length_307_cov_1.008547_g9203_i0 | PRJNA854078 | 9415 | 307 | 1.008547 | 3.09623929 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 178 | 6.91e-51 | NR | KAH6567106.1 | 1357716 | g9203 | i0 | 81.2 | 5.90228013029316 | 101 | 19 | 98.7 | 0 | 4 | 306 | 102 | 202 | KAH6567106.1 hypothetical protein BASA62_006341 [Batrachochytrium salamandrivorans] | diamond | 1812 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 27466008 | 27466008 | PRJNA854078_P_NODE_1803_length_711_cov_1.490596_g1605_i0 | PRJNA854078 | 1803 | 711 | 1.490596 | 10.59813756 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 54.7 | 1.23e-4 | NR | KAH9260861.1 | 1357716 | g1605 | i0 | 39.2 | 0.430379746835443 | 102 | 53 | 41.8 | 4 | 415 | 711 | 117 | 212 | KAH9260861.1 hypothetical protein BASA81_001328 [Batrachochytrium salamandrivorans] | diamond | 306 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28223464 | 28223464 | PRJNA854078_P_NODE_6326_length_375_cov_1.274834_g6114_i0 | PRJNA854078 | 6326 | 375 | 1.274834 | 4.7806275 | Spizellomyces sp. 'palustris' | 117820 | Fungi | Fungi | 74.7 | 1.08e-12 | NR | TPX63104.1 | 117820 | g6114 | i0 | 35.2 | 1.92 | 125 | 81 | 100 | 0 | 375 | 1 | 111 | 235 | TPX63104.1 hypothetical protein SpCBS45565_g06834 [Spizellomyces sp. 'palustris'] | diamond | 720 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 32173314 | 32173314 | PRJNA854078_P_NODE_13578_length_255_cov_1.269231_g13366_i0 | PRJNA854078 | 13578 | 255 | 1.269231 | 3.23653905 | Chytridiales sp. JEL | 2011832 | Fungi | Fungi | 77.8 | 1.67e-15 | NR | KAJ3411797.1 | 2786947 | g13366 | i0 | 45.9 | 0.870588235294118 | 74 | 40 | 87.1 | 0 | 242 | 21 | 13 | 86 | KAJ3411797.1 ER membrane protein complex subunit 8 [Chytridiales sp. JEL 0842] | diamond | 222 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiales sp. JEL 0842 | |||
| 32402842 | 32402842 | PRJNA854078_P_NODE_13139_length_259_cov_1.655914_g12927_i0 | PRJNA854078 | 13139 | 259 | 1.655914 | 4.28881726 | Chytridiomycota | 4761 | Fungi | Fungi | 115 | 4.86e-29 | NR | KAI9026238.1 | 82268 | g12927 | i0 | 75.6 | 5.42084942084942 | 78 | 17 | 90.3 | 1 | 234 | 1 | 3 | 78 | KAI9026238.1 putative mitochondrial ADP/ATP translocase [Hyaloraphidium curvatum] | diamond | 1404 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum |
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);;