contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA816047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25603987 | 25603987 | PRJNA816047d_S_NODE_39233_length_344_cov_2.728522_g37398_i0 | PRJNA816047 | 39233 | 344 | 2.728522 | 9.38611568 | Sporanauta perivermis | 1261140 | Fungi | Fungi | 222 | 2.34e-53 | NTclustered | gi|422313306|gb|KC172651.1| | 1261140 | g37398 | i0 | 79.567 | 32.6482558139535 | 323 | 57 | 92 | 8 | 17 | 334 | 635 | 953 | Sporanauta perivermis 18S ribosomal RNA gene, partial sequence | blastn | 11231 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Sporanauta | Sporanauta perivermis | ||||
| 25876266 | 25876266 | PRJNA816047d_S_NODE_44059_length_328_cov_3.825455_g42224_i0 | PRJNA816047 | 44059 | 328 | 3.825455 | 12.5474924 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 213 | 1.34e-50 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g42224 | i0 | 84.375 | 3.63719512195122 | 224 | 27 | 89 | 8 | 105 | 325 | 2533 | 2751 | 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 | 1193 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 26010665 | 26010665 | PRJNA816047d_S_NODE_17108_length_543_cov_26616.793878_g15372_i0 | PRJNA816047 | 17108 | 543 | 26616.793878 | 144529.19075754 | uncultured Microsporidia | 546760 | Fungi | Fungi | 274 | 1.0499999999999998e-68 | NTclustered | gi|1372080716|gb|MG241392.1| | 546760 | g15372 | i0 | 86.992 | 56.1675874769797 | 246 | 29 | 45 | 2 | 175 | 417 | 416 | 171 | Uncultured Microsporidia clone OTU16 small subunit ribosomal RNA gene, partial sequence | blastn | 30499 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | uncultured Microsporidia | |||||
| 26011402 | 26011402 | PRJNA816047d_S_NODE_24284_length_437_cov_1.627604_g22456_i0 | PRJNA816047 | 24284 | 437 | 1.627604 | 7.11262948 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 717 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g22456 | i0 | 99 | 91.0389016018307 | 400 | 3 | 91 | 1 | 39 | 437 | 956 | 557 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 39784 | 717 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 26281267 | 26281267 | PRJNA816047d_S_NODE_10270_length_780_cov_4.272352_g8856_i0 | PRJNA816047 | 10270 | 780 | 4.272352 | 33.3243456 | Encephalitozoon intestinalis ATCC 5 | 58839 | Fungi | Fungi | 213 | 3.39e-50 | NTclustered | gi|1253338741|ref|XR_002670131.1| | 876142 | g8856 | i0 | 73.813 | 11.9012820512821 | 653 | 122 | 80 | 38 | 122 | 747 | 693 | 63 | Encephalitozoon intestinalis ATCC 50506 5.8S-23S ribosomal RNA (Eint_010010), rRNA | blastn | 9283 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 26316333 | 26316333 | PRJNA816047d_S_NODE_57238_length_296_cov_3.226337_g55403_i0 | PRJNA816047 | 57238 | 296 | 3.226337 | 9.54995752 | Ecytonucleospora | 3078583 | Fungi | Fungi | 327 | 4.08e-85 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g55403 | i0 | 87.241 | 74.5810810810811 | 290 | 34 | 98 | 3 | 8 | 296 | 1318 | 1031 | 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 | 22076 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 26556030 | 26556030 | PRJNA816047d_S_NODE_33312_length_370_cov_2.927445_g31478_i0 | PRJNA816047 | 33312 | 370 | 2.927445 | 10.8315465 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 379 | 1.42e-100 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g31478 | i0 | 95.041 | 18.5054054054054 | 242 | 11 | 65 | 1 | 130 | 370 | 3206 | 3447 | 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 | 6847 | 379 | 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);;