contig_metadata
6 rows where bioproject = "PRJNA432257", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1088909 | 1088909 | PRJNA432257_S_NODE_93001_length_181_cov_2198.201389_g92620_i0 | PRJNA432257 | 93001 | 181 | 2198.201389 | 3978.74451409 | Eukaryota | 2759 | Fungi | Fungi | 65.8 | 1.97e-6 | NTclustered | gi|348112|gb|L16866.1|EZORGSSA | 31283 | g92620 | i0 | 100 | 3.2817679558011 | 35 | 0 | 19 | 0 | 107 | 141 | 163 | 197 | Encephalitozoon sp. small subunit ribosomal RNA gene, partial sequence | blastn | 594 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon sp. | |||
| 4916733 | 4916733 | PRJNA432257_S_NODE_124904_length_152_cov_8334.521739_g124523_i0 | PRJNA432257 | 124904 | 152 | 8334.521739 | 12668.47304328 | Eukaryota | 2759 | Fungi | Fungi | 276 | 6.770000000000001e-70 | NTclustered | gi|348113|gb|L16867.1|EZORGSSB | 31283 | g124523 | i0 | 99.342 | 44.0592105263158 | 152 | 1 | 100 | 0 | 1 | 152 | 33 | 184 | Encephalitozoon sp. small subunit ribosomal RNA gene, complete sequence | blastn | 6697 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon sp. | |||
| 13842407 | 13842407 | PRJNA432257_S_NODE_89771_length_184_cov_13.612245_g89390_i0 | PRJNA432257 | 89771 | 184 | 13.612245 | 25.0465308 | Nosematidae | 27974 | Fungi | Fungi | 137 | 4.21e-28 | NTclustered | gi|58532246|gb|AY741111.1| | 40135 | g89390 | i0 | 83.444 | 77.2771739130435 | 151 | 21 | 81 | 3 | 36 | 184 | 562 | 710 | Nosema bombi small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 14219 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha bombi | |||
| 14458393 | 14458393 | PRJNA432257_S_NODE_33432_length_268_cov_221.878788_g33051_i0 | PRJNA432257 | 33432 | 268 | 221.878788 | 594.63515184 | Vittaforma corneae | 42399 | Fungi | Fungi | 263 | 1.04e-65 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g33051 | i0 | 87.342 | 23.6716417910448 | 237 | 20 | 85 | 7 | 1 | 229 | 388 | 154 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 6344 | 263 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 16391141 | 16391141 | PRJNA432257_S_NODE_126113_length_151_cov_8305.701754_g125732_i0 | PRJNA432257 | 126113 | 151 | 8305.701754 | 12541.60964854 | Eukaryota | 2759 | Fungi | Fungi | 274 | 2.42e-69 | NTclustered | gi|348113|gb|L16867.1|EZORGSSB | 31283 | g125732 | i0 | 99.342 | 44.3509933774834 | 152 | 0 | 100 | 1 | 1 | 151 | 33 | 184 | Encephalitozoon sp. small subunit ribosomal RNA gene, complete sequence | blastn | 6697 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon sp. | |||
| 18940407 | 18940407 | PRJNA432257_S_NODE_94335_length_180_cov_960.272727_g93954_i0 | PRJNA432257 | 94335 | 180 | 960.272727 | 1728.4909086 | Eukaryota | 2759 | Fungi | Fungi | 115 | 1.92e-21 | NTclustered | gi|348112|gb|L16866.1|EZORGSSA | 31283 | g93954 | i0 | 98.462 | 29.9333333333333 | 65 | 1 | 36 | 0 | 107 | 171 | 163 | 227 | Encephalitozoon sp. small subunit ribosomal RNA gene, partial sequence | blastn | 5388 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon sp. |
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);;