contig_metadata
3 rows where bioproject = "PRJNA688736", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26892635 | 26892635 | PRJNA688736_P_NODE_40221_length_253_cov_0.866667_g39936_i0 | PRJNA688736 | 40221 | 253 | 0.866667 | 2.19266751 | Encephalitozoon hellem ATCC 5 | 27973 | Fungi | Fungi | 87.8 | 5.27e-18 | NR | XP_003887081.1 | 907965 | g39936 | i0 | 54.9 | 4.86166007905138 | 82 | 37 | 97.2 | 0 | 251 | 6 | 288 | 369 | XP_003887081.1 lysyl-tRNA synthetase [Encephalitozoon hellem ATCC 50504] | diamond | 1230 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon hellem | |||
| 30156762 | 30156762 | PRJNA688736_P_NODE_46952_length_246_cov_0.901734_g46667_i0 | PRJNA688736 | 46952 | 246 | 0.901734 | 2.21826564 | Encephalitozoon | 6033 | Fungi | Fungi | 55.5 | 2.85e-7 | NR | UYI28142.1 | 6035 | g46667 | i0 | 58 | 3.0609756097561 | 50 | 20 | 59.8 | 1 | 1 | 147 | 27 | 76 | UYI28142.1 hypothetical protein J0A71_09g20400 [Encephalitozoon cuniculi] | diamond | 753 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon cuniculi | |||
| 32674239 | 32674239 | PRJNA688736_P_NODE_46860_length_246_cov_0.901734_g46575_i0 | PRJNA688736 | 46860 | 246 | 0.901734 | 2.21826564 | Encephalitozoon intestinalis ATCC 5 | 58839 | Fungi | Fungi | 90.5 | 7.320000000000001e-21 | NR | XP_003073550.2 | 876142 | g46575 | i0 | 53.1 | 2.96341463414634 | 81 | 38 | 98.8 | 0 | 245 | 3 | 2 | 82 | XP_003073550.2 uncharacterized protein Eint_090610 [Encephalitozoon intestinalis ATCC 50506] | diamond | 729 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis |
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);;