contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA641991" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168600 | 3168600 | PRJNA641991_P_NODE_3983_length_162_cov_1.353982_g3942_i0 | PRJNA641991 | 3983 | 162 | 1.353982 | 2.19345084 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 165 | 1.66e-36 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g3942 | i0 | 85.093 | 0.993827160493827 | 161 | 24 | 99 | 0 | 1 | 161 | 2937 | 2777 | 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 | 161 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 8271014 | 8271014 | PRJNA641991_P_NODE_3327_length_167_cov_0.864407_g3286_i0 | PRJNA641991 | 3327 | 167 | 0.864407 | 1.44355969 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 159 | 8.02e-35 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g3286 | i0 | 85.443 | 0.946107784431138 | 158 | 17 | 93 | 6 | 13 | 167 | 2611 | 2765 | 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 | 158 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 8271057 | 8271057 | PRJNA641991_S_NODE_4307_length_257_cov_1.913462_g4188_i0 | PRJNA641991 | 4307 | 257 | 1.913462 | 4.91759734 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 195 | 3.67e-45 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g4188 | i0 | 80.534 | 7.58365758754864 | 262 | 43 | 100 | 8 | 1 | 257 | 2055 | 1797 | 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 | 1949 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 8271069 | 8271069 | PRJNA641991_S_NODE_7607_length_201_cov_1.585526_g7488_i0 | PRJNA641991 | 7607 | 201 | 1.585526 | 3.18690726 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 211 | 2.73e-50 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g7488 | i0 | 90.123 | 3.11940298507463 | 162 | 16 | 81 | 0 | 40 | 201 | 2280 | 2441 | 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 | 627 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 15920626 | 15920626 | PRJNA641991_S_NODE_3293_length_290_cov_3.522822_g3174_i0 | PRJNA641991 | 3293 | 290 | 3.522822 | 10.2161838 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 178 | 4.25e-40 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g3174 | i0 | 94.783 | 0.396551724137931 | 115 | 5 | 39 | 1 | 177 | 290 | 3206 | 3320 | 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 | 115 | 178 | 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);;