contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA600413" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2417894 | 2417894 | PRJNA600413_P_NODE_76662_length_182_cov_1.330827_g75961_i0 | PRJNA600413 | 76662 | 182 | 1.330827 | 2.42210514 | Glugea | 36736 | Fungi | Fungi | 219 | 1.44e-52 | NTclustered | gi|16605611|emb|AJ295329.1| | 144521 | g75961 | i0 | 90 | 93.9010989010989 | 170 | 15 | 93 | 2 | 9 | 177 | 1220 | 1388 | Unidentified microsporidian MYX1 partial 16S rRNA gene, ITS and partial 23S rRNA gene | blastn | 17090 | 220 | 0.995454545454545 | Eukaryota | Opisthokonta | Fungi | Microsporidia | unidentified microsporidian MYX1 | |||||
| 3123816 | 3123816 | PRJNA600413_P_NODE_10683_length_452_cov_26.444169_g9984_i0 | PRJNA600413 | 10683 | 452 | 26.444169 | 119.52764388 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 833 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g9984 | i0 | 100 | 98.8606194690265 | 451 | 0 | 99 | 0 | 2 | 452 | 1335 | 885 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 44685 | 833 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 3126211 | 3126211 | PRJNA600413_P_NODE_87723_length_175_cov_1.579365_g87022_i0 | PRJNA600413 | 87723 | 175 | 1.579365 | 2.76388875 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 150 | 5.079999999999999e-32 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g87022 | i0 | 89.744 | 0.668571428571429 | 117 | 12 | 67 | 0 | 59 | 175 | 2280 | 2396 | 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 | 117 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 4401105 | 4401105 | PRJNA600413_P_NODE_147684_length_161_cov_0.910714_g146983_i0 | PRJNA600413 | 147684 | 161 | 0.910714 | 1.46624954 | Vavraia culicis | 103449 | Fungi | Fungi | 91.6 | 2.83e-14 | NTclustered | gi|667633188|ref|XM_008075686.1| | 948595 | g146983 | i0 | 85.227 | 0.546583850931677 | 88 | 13 | 55 | 0 | 46 | 133 | 8 | 95 | Vavraia culicis subsp. floridensis small GTP-binding protein domain (VCUG_00857), partial mRNA | blastn | 88 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 5677619 | 5677619 | PRJNA600413_P_NODE_28325_length_266_cov_7.248848_g27624_i0 | PRJNA600413 | 28325 | 266 | 7.248848 | 19.28193568 | Vavraia culicis | 103449 | Fungi | Fungi | 287 | 6.130000000000001e-73 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g27624 | i0 | 87.059 | 1.92481203007519 | 255 | 32 | 96 | 1 | 1 | 255 | 2362 | 2615 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 512 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 9503770 | 9503770 | PRJNA600413_P_NODE_96348_length_170_cov_1.570248_g95647_i0 | PRJNA600413 | 96348 | 170 | 1.570248 | 2.6694216 | Ecytonucleospora schreckii | 2902180 | Fungi | Fungi | 235 | 1.3199999999999998e-57 | NTclustered | gi|2162236384|gb|OL780325.1| | 2902180 | g95647 | i0 | 91.765 | 99.8176470588235 | 170 | 12 | 99 | 2 | 1 | 169 | 100 | 268 | Enterocytozoon schreckii isolate CC-2721 small subunit ribosomal RNA gene, partial sequence | blastn | 16969 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora schreckii | |||
| 14602178 | 14602178 | PRJNA600413_P_NODE_137672_length_162_cov_1.663717_g136971_i0 | PRJNA600413 | 137672 | 162 | 1.663717 | 2.69522154 | Nematocida displodere | 1805483 | Fungi | Fungi | 71.3 | 3.72e-8 | NTclustered | gi|2797490813|ref|XM_067688610.1| | 1805483 | g136971 | i0 | 90.566 | 0.91358024691358 | 53 | 5 | 33 | 0 | 105 | 157 | 794 | 742 | Nematocida displodere serine/threonine-protein phosphatase 2A catalytic subunit (NEDG_01192), partial mRNA | blastn | 148 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida displodere | ||||
| 14603417 | 14603417 | PRJNA600413_P_NODE_532_length_1698_cov_15.531231_g358_i0 | PRJNA600413 | 532 | 1698 | 15.531231 | 263.72030238 | Pleistophora mulleri | 249366 | Fungi | Fungi | 1615 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g358 | i0 | 83.984 | 35.9393404004711 | 1742 | 210 | 100 | 58 | 1 | 1698 | 3091 | 1375 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 61025 | 1615 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 23526249 | 23526249 | PRJNA600413_P_NODE_2639_length_897_cov_25.336085_g2164_i0 | PRJNA600413 | 2639 | 897 | 25.336085 | 227.26468245 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1650 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g2164 | i0 | 99.777 | 96.8416945373467 | 897 | 2 | 100 | 0 | 1 | 897 | 914 | 18 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 86867 | 1650 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 23526384 | 23526384 | PRJNA600413_P_NODE_31999_length_252_cov_1.064039_g31298_i0 | PRJNA600413 | 31999 | 252 | 1.064039 | 2.68137828 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 130 | 1.03e-25 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g31298 | i0 | 90 | 7.34523809523809 | 100 | 10 | 40 | 0 | 153 | 252 | 2852 | 2951 | 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 | 1851 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 24801073 | 24801073 | PRJNA600413_P_NODE_68120_length_187_cov_3.159420_g67419_i0 | PRJNA600413 | 68120 | 187 | 3.15942 | 5.9081154 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 196 | 6.989999999999999e-46 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g67419 | i0 | 85.561 | 1 | 187 | 27 | 100 | 0 | 1 | 187 | 2935 | 2749 | 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 | 187 | 196 | 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);;