contig_metadata
5 rows where bioproject = "PRJNA293022", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1648112 | 1648112 | PRJNA293022_P_NODE_58482_length_182_cov_1.172932_g57745_i0 | PRJNA293022 | 58482 | 182 | 1.172932 | 2.13473624 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 283 | 5.04e-72 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g57745 | i0 | 95 | 42.543956043956 | 180 | 9 | 99 | 0 | 1 | 180 | 3460 | 3281 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 7743 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 4200298 | 4200298 | PRJNA293022_P_NODE_10024_length_452_cov_3.464020_g9291_i0 | PRJNA293022 | 10024 | 452 | 3.46402 | 15.6573704 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 444 | 6.18e-120 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g9291 | i0 | 84.615 | 7.15265486725664 | 455 | 60 | 99 | 10 | 2 | 450 | 2203 | 1753 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3233 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 5476646 | 5476646 | PRJNA293022_P_NODE_16725_length_349_cov_1.216667_g15988_i0 | PRJNA293022 | 16725 | 349 | 1.216667 | 4.24616783 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 102 | 3.23e-17 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g15988 | i0 | 83.636 | 0.315186246418338 | 110 | 16 | 32 | 1 | 191 | 300 | 2962 | 2855 | Heterosporis sp. NBDP-2013a isolate MN/CISCO small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 110 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 14402133 | 14402133 | PRJNA293022_P_NODE_21472_length_307_cov_1.589147_g20735_i0 | PRJNA293022 | 21472 | 307 | 1.589147 | 4.87868129 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 272 | 2.02e-68 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g20735 | i0 | 86.585 | 0.801302931596091 | 246 | 33 | 80 | 0 | 3 | 248 | 2767 | 3012 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 246 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 28084833 | 28084833 | PRJNA293022_P_NODE_67645_length_169_cov_0.866667_g66908_i0 | PRJNA293022 | 67645 | 169 | 0.866667 | 1.46466723 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 44.3 | 0.00175 | NR | KRH92703.1 | 146866 | g66908 | i0 | 40.4 | 2.0414201183432 | 52 | 25 | 92.3 | 1 | 164 | 9 | 54 | 99 | KRH92703.1 putative transposable element [Pseudoloma neurophilia] | diamond | 345 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;