contig_metadata
4 rows where bioproject = "PRJNA669701", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27018372 | 27018372 | PRJNA669701_P_NODE_95562_length_264_cov_1.209424_g95167_i0 | PRJNA669701 | 95562 | 264 | 1.209424 | 3.19287936 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 55.1 | 3.93e-7 | NR | KAI9168261.1 | 1313167 | g95167 | i0 | 57.8 | 0.511363636363636 | 45 | 18 | 50 | 1 | 2 | 133 | 75 | 119 | KAI9168261.1 ergosterol biosynthesis protein [Blastocladiella emersonii ATCC 22665] | diamond | 135 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 27524012 | 27524012 | PRJNA669701_P_NODE_73003_length_290_cov_2.599078_g72608_i0 | PRJNA669701 | 73003 | 290 | 2.599078 | 7.5373262 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 84 | 2.25e-17 | NR | KAI9144088.1 | 1500003 | g72608 | i0 | 48.8 | 1.68620689655172 | 86 | 41 | 85.9 | 2 | 262 | 14 | 1 | 86 | KAI9144088.1 putative catechol O-methyltransferase [Paraphysoderma sedebokerense] | diamond | 489 | 84 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28281584 | 28281584 | PRJNA669701_P_NODE_96306_length_263_cov_1.526316_g95911_i0 | PRJNA669701 | 96306 | 263 | 1.526316 | 4.01421108 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 90.5 | 4.64e-20 | NR | KAJ1510042.1 | 945690 | g95911 | i0 | 51.2 | 4.82509505703422 | 84 | 41 | 95.8 | 0 | 254 | 3 | 3 | 86 | KAJ1510042.1 26S proteasome regulatory subunit rpn6, partial [Coelomomyces lativittatus] | diamond | 1269 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 32799560 | 32799560 | PRJNA669701_P_NODE_49300_length_342_cov_1.144981_g48905_i0 | PRJNA669701 | 49300 | 342 | 1.144981 | 3.91583502 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 45.8 | 0.0075 | NR | KAJ1500491.1 | 945690 | g48905 | i0 | 43.5 | 1.13157894736842 | 62 | 35 | 54.4 | 0 | 130 | 315 | 110 | 171 | KAJ1500491.1 MAPK protein hog1 [Coelomomyces lativittatus] | diamond | 387 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus |
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);;