contig_metadata
3 rows where bioproject = "PRJNA764222", tax_clade = "Opisthokonta" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27211044 | 27211044 | PRJNA764222_S_NODE_102_length_2545_cov_36.663731_g81_i0 | PRJNA764222 | 102 | 2545 | 36.663731 | 933.09195395 | Anncaliia algerae PRA339 | 1288291 | Fungi | Fungi | 51.6 | 0.0231 | NR | KCZ80447.1 | 1288291 | g81 | i0 | 28.6 | 0.437328094302554 | 185 | 103 | 19.7 | 6 | 1663 | 1163 | 1006 | 1179 | KCZ80447.1 hypothetical protein H312_02171 [Anncaliia algerae PRA339] | diamond | 1113 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 30021762 | 30021762 | PRJNA764222_S_NODE_22211_length_199_cov_4.059211_g22053_i0 | PRJNA764222 | 22211 | 199 | 4.059211 | 8.07782989 | Nematocida sp. AWRm77 | 2670344 | Fungi | Fungi | 42.4 | 0.011 | NR | KAI5189085.1 | 2670344 | g22053 | i0 | 43.4 | 0.798994974874372 | 53 | 26 | 79.9 | 2 | 160 | 2 | 18 | 66 | KAI5189085.1 hypothetical protein NECID01_0440 [Nematocida sp. AWRm77] | diamond | 159 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm77 | ||||
| 31918143 | 31918143 | PRJNA764222_S_NODE_13757_length_240_cov_1.601036_g13599_i0 | PRJNA764222 | 13757 | 240 | 1.601036 | 3.8424864 | Hepatospora eriocheir | 1081669 | Fungi | Fungi | 57.8 | 1.44e-8 | NR | ORD96474.1 | 1081669 | g13599 | i0 | 42.3 | 0.975 | 78 | 42 | 96.3 | 2 | 240 | 10 | 1 | 76 | ORD96474.1 hypothetical protein HERIO_1589 [Hepatospora eriocheir] | diamond | 234 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Hepatosporidae | Hepatospora | Hepatospora eriocheir |
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);;