contig_metadata
5 rows where bioproject = "PRJNA849646" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28223307 | 28223307 | PRJNA849646_P_NODE_33686_length_246_cov_1.780347_g33568_i0 | PRJNA849646 | 33686 | 246 | 1.780347 | 4.37965362 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 110 | 4.86e-29 | NR | KAI9018215.1 | 82268 | g33568 | i0 | 64.6 | 0.963414634146341 | 79 | 28 | 96.3 | 0 | 244 | 8 | 64 | 142 | KAI9018215.1 microsomal glutathione S-transferase [Hyaloraphidium curvatum] | diamond | 237 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 29991769 | 29991769 | PRJNA849646_P_NODE_37991_length_241_cov_2.636905_g37873_i0 | PRJNA849646 | 37991 | 241 | 2.636905 | 6.35494105 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 62.8 | 3.06e-9 | NR | KXS22035.1 | 1344416 | g37873 | i0 | 58.5 | 0.659751037344398 | 53 | 22 | 66 | 0 | 215 | 57 | 518 | 570 | KXS22035.1 hypothetical protein M427DRAFT_50400 [Gonapodya prolifera JEL478] | diamond | 159 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 30339776 | 30339776 | PRJNA849646_P_NODE_4032_length_310_cov_4.540084_g3914_i0 | PRJNA849646 | 4032 | 310 | 4.540084 | 14.0742604 | Spizellomyces sp. 'palustris' | 117820 | Fungi | Fungi | 56.2 | 5.51e-7 | NR | TPX63232.1 | 117820 | g3914 | i0 | 50 | 3.30967741935484 | 46 | 23 | 44.5 | 0 | 165 | 302 | 140 | 185 | TPX63232.1 hypothetical protein SpCBS45565_g06770 [Spizellomyces sp. 'palustris'] | diamond | 1026 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 32141370 | 32141370 | PRJNA849646_P_NODE_22258_length_264_cov_1.612565_g22140_i0 | PRJNA849646 | 22258 | 264 | 1.612565 | 4.2571716 | Chytridiales sp. JEL | 2011832 | Fungi | Fungi | 119 | 8.59e-31 | NR | KAJ3417195.1 | 2786947 | g22140 | i0 | 78.1 | 4.94318181818182 | 73 | 16 | 83 | 0 | 220 | 2 | 145 | 217 | KAJ3417195.1 60S ribosomal protein L8B [Chytridiales sp. JEL 0842] | diamond | 1305 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiales sp. JEL 0842 | |||
| 32299866 | 32299866 | PRJNA849646_P_NODE_14579_length_279_cov_1.339806_g14461_i0 | PRJNA849646 | 14579 | 279 | 1.339806 | 3.73805874 | Siphonaria sp. JEL | 2047469 | Fungi | Fungi | 66.2 | 3e-10 | NR | KAJ3031318.1 | 2723227 | g14461 | i0 | 77.8 | 0.78494623655914 | 36 | 8 | 38.7 | 0 | 279 | 172 | 282 | 317 | KAJ3031318.1 hypothetical protein HDU68_005060 [Siphonaria sp. JEL0065] | diamond | 219 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Siphonaria | Siphonaria sp. JEL0065 |
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);;