contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA689790" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3219573 | 3219573 | PRJNA689790_S_NODE_15643_length_154_cov_2.324786_g15528_i0 | PRJNA689790 | 15643 | 154 | 2.324786 | 3.58017044 | Enterospora canceri | 1081671 | Fungi | Fungi | 230 | 5.439999999999998e-56 | NTclustered | gi|2491793422|gb|OQ847707.1| | 1081671 | g15528 | i0 | 93.506 | 98.1558441558442 | 154 | 10 | 100 | 0 | 1 | 154 | 95 | 248 | Enterospora canceri strain GB1 small subunit ribosomal RNA gene, partial sequence | blastn | 15116 | 230 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterospora | Enterospora canceri | |||
| 5772326 | 5772326 | PRJNA689790_S_NODE_3545_length_329_cov_34.767123_g3430_i0 | PRJNA689790 | 3545 | 329 | 34.767123 | 114.38383467 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 532 | 9.07e-147 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g3430 | i0 | 95.796 | 24.8784194528875 | 333 | 9 | 100 | 3 | 1 | 329 | 3663 | 3994 | 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 | 8185 | 532 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 8321852 | 8321852 | PRJNA689790_S_NODE_15207_length_156_cov_1.630252_g15092_i0 | PRJNA689790 | 15207 | 156 | 1.630252 | 2.54319312 | Vavraia culicis | 103449 | Fungi | Fungi | 115 | 1.62e-21 | NTclustered | gi|667631888|ref|XM_008075036.1| | 948595 | g15092 | i0 | 81.119 | 0.916666666666667 | 143 | 27 | 92 | 0 | 14 | 156 | 231 | 373 | Vavraia culicis subsp. floridensis actin-1 (VCUG_00207), mRNA | blastn | 143 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 9597272 | 9597272 | PRJNA689790_S_NODE_268_length_1635_cov_34.774093_g260_i0 | PRJNA689790 | 268 | 1635 | 34.774093 | 568.55642055 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 719 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g260 | i0 | 84.979 | 14.5100917431193 | 719 | 96 | 93 | 12 | 6 | 717 | 1755 | 2468 | 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 | 23724 | 719 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 22346079 | 22346079 | PRJNA689790_S_NODE_15118_length_156_cov_2.596639_g15003_i0 | PRJNA689790 | 15118 | 156 | 2.596639 | 4.05075684 | Ecytonucleospora schreckii | 2902180 | Fungi | Fungi | 211 | 2e-50 | NTclustered | gi|2162236384|gb|OL780325.1| | 2902180 | g15003 | i0 | 91.083 | 100.410256410256 | 157 | 12 | 100 | 2 | 1 | 156 | 255 | 100 | Enterocytozoon schreckii isolate CC-2721 small subunit ribosomal RNA gene, partial sequence | blastn | 15664 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora schreckii | |||
| 23621609 | 23621609 | PRJNA689790_S_NODE_4039_length_304_cov_31.782772_g3924_i0 | PRJNA689790 | 4039 | 304 | 31.782772 | 96.61962688 | Vittaforma corneae | 42399 | Fungi | Fungi | 124 | 5.919999999999999e-24 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g3924 | i0 | 81.366 | 16.5 | 161 | 22 | 52 | 6 | 1 | 158 | 2206 | 2361 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 5016 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 23621627 | 23621627 | PRJNA689790_S_NODE_639_length_873_cov_5.889952_g578_i0 | PRJNA689790 | 639 | 873 | 5.889952 | 51.41928096 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 1090 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g578 | i0 | 89.552 | 92.1030927835052 | 871 | 76 | 99 | 11 | 1 | 861 | 408 | 1273 | 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 | 80406 | 1090 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei |
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);;