contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1074408" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9118616 | 9118616 | PRJNA1074408_S_NODE_348_length_677_cov_31.075710_g252_i0 | PRJNA1074408 | 348 | 677 | 31.07571 | 210.3825567 | Enterocytozoon sp. ex Acetes sibogae australis | 2881109 | Fungi | Fungi | 861 | 0 | NTclustered | gi|2108103202|gb|OK413268.1| | 2881109 | g252 | i0 | 89.808 | 86.9453471196455 | 677 | 62 | 99 | 6 | 3 | 677 | 1020 | 349 | Enterocytozoon sp. ex Acetes sibogae australis isolate RA19015_21 small subunit ribosomal RNA gene, partial sequence | blastn | 58862 | 861 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon sp. ex Acetes sibogae australis | |||
| 16767933 | 16767933 | PRJNA1074408_S_NODE_34_length_1663_cov_17.196914_g12_i0 | PRJNA1074408 | 34 | 1663 | 17.196914 | 285.98467982 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 741 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g12 | i0 | 85.226 | 13.3066746843055 | 731 | 96 | 92 | 12 | 913 | 1636 | 2468 | 1743 | 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 | 22129 | 741 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 18042714 | 18042714 | PRJNA1074408_S_NODE_10015_length_150_cov_4.532710_g9885_i0 | PRJNA1074408 | 10015 | 150 | 4.53271 | 6.799065 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 265 | 1.44e-66 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g9885 | i0 | 98.667 | 13.2333333333333 | 150 | 1 | 100 | 1 | 1 | 150 | 3814 | 3666 | 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 | 1985 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 23143228 | 23143228 | PRJNA1074408_S_NODE_1039_length_436_cov_11.155216_g909_i0 | PRJNA1074408 | 1039 | 436 | 11.155216 | 48.63674176 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 562 | 1.5699999999999997e-155 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g909 | i0 | 91.443 | 85.8256880733945 | 409 | 35 | 94 | 0 | 1 | 409 | 412 | 4 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 37420 | 562 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila | |||
| 24416907 | 24416907 | PRJNA1074408_S_NODE_2920_length_268_cov_10.551111_g2790_i0 | PRJNA1074408 | 2920 | 268 | 10.551111 | 28.27697748 | Vittaforma corneae | 42399 | Fungi | Fungi | 121 | 6.63e-23 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g2790 | i0 | 81.132 | 17.9701492537313 | 159 | 22 | 58 | 6 | 1 | 156 | 2208 | 2361 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 4816 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae |
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);;