contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1847166 | 1847166 | PRJNA599026_S_NODE_20862_length_229_cov_2.266667_g20406_i0 | PRJNA599026 | 20862 | 229 | 2.266667 | 5.19066743 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 235 | 1.89e-57 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g20406 | i0 | 86.239 | 0.951965065502183 | 218 | 28 | 95 | 2 | 13 | 229 | 3011 | 2795 | 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 | 218 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 6949721 | 6949721 | PRJNA599026_S_NODE_20366_length_231_cov_2.241758_g19910_i0 | PRJNA599026 | 20366 | 231 | 2.241758 | 5.17846098 | Pleistophora mulleri | 249366 | Fungi | Fungi | 220 | 5.35e-53 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g19910 | i0 | 96.947 | 10.5627705627706 | 131 | 4 | 57 | 0 | 98 | 228 | 2842 | 2972 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 2440 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 6950377 | 6950377 | PRJNA599026_S_NODE_7426_length_353_cov_3.236842_g6970_i0 | PRJNA599026 | 7426 | 353 | 3.236842 | 11.42605226 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 638 | 2.01e-178 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g6970 | i0 | 99.429 | 98.6458923512748 | 350 | 2 | 99 | 0 | 1 | 350 | 41 | 390 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 34822 | 638 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 7519068 | 7519068 | PRJNA599026_S_NODE_35446_length_190_cov_1.085106_g34990_i0 | PRJNA599026 | 35446 | 190 | 1.085106 | 2.0617014 | Pleistophoridae | 35232 | Fungi | Fungi | 206 | 1.1799999999999999e-48 | NTclustered | gi|27448231|gb|AF387331.1| | 184033 | g34990 | i0 | 87.64 | 19.4368421052632 | 178 | 20 | 93 | 2 | 14 | 190 | 3939 | 3763 | Heterosporis anguillarum small subunit ribosomal RNA gene, internal transcribed spacer, and large subunit ribosomal RNA gene, complete sequence | blastn | 3693 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis anguillarum | |||
| 9499939 | 9499939 | PRJNA599026_S_NODE_22928_length_221_cov_3.558140_g22472_i0 | PRJNA599026 | 22928 | 221 | 3.55814 | 7.8634894 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 405 | 1.31e-108 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g22472 | i0 | 99.548 | 99.8506787330317 | 221 | 1 | 100 | 0 | 1 | 221 | 640 | 420 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22067 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 12620434 | 12620434 | PRJNA599026_S_NODE_650_length_1094_cov_3.288995_g462_i0 | PRJNA599026 | 650 | 1094 | 3.288995 | 35.9816053 | Pleistophoridae | 35232 | Fungi | Fungi | 1110 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g462 | i0 | 87.004 | 33.9405850091408 | 1008 | 104 | 90 | 24 | 18 | 1007 | 2624 | 1626 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 37131 | 1110 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 14600258 | 14600258 | PRJNA599026_S_NODE_10992_length_296_cov_3.716599_g10536_i0 | PRJNA599026 | 10992 | 296 | 3.716599 | 11.00113304 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 547 | 2.8799999999999986e-151 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g10536 | i0 | 100 | 99.3682432432432 | 296 | 0 | 100 | 0 | 1 | 296 | 926 | 1221 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 29413 | 547 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 20974047 | 20974047 | PRJNA599026_S_NODE_46217_length_172_cov_3.341463_g45761_i0 | PRJNA599026 | 46217 | 172 | 3.341463 | 5.74731636 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 316 | 4.629999999999998e-82 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g45761 | i0 | 100 | 100.895348837209 | 171 | 0 | 99 | 0 | 1 | 171 | 1690 | 1520 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17354 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 22818311 | 22818311 | PRJNA599026_S_NODE_10058_length_308_cov_3.254826_g9602_i0 | PRJNA599026 | 10058 | 308 | 3.254826 | 10.02486408 | Heterosporis | 157917 | Fungi | Fungi | 425 | 1.47e-114 | NTclustered | gi|448278452|gb|KC137548.1| | 1289055 | g9602 | i0 | 91.613 | 35.8961038961039 | 310 | 22 | 100 | 3 | 1 | 308 | 3478 | 3171 | Heterosporis sp. NBDP-2013a isolate MN/WAE small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 11056 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a |
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);;