contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1123436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11759130 | 11759130 | PRJNA1123436_P_NODE_84870_length_269_cov_1.178571_g83656_i0 | PRJNA1123436 | 84870 | 269 | 1.178571 | 3.17035599 | Ordospora pajunii | 3039483 | Fungi | Fungi | 161 | 3.92e-35 | NTclustered | gi|2607439339|ref|XM_060421342.1| | 3039483 | g83656 | i0 | 79.325 | 1.77323420074349 | 237 | 43 | 87 | 6 | 1 | 234 | 1149 | 1382 | Ordospora pajunii MCMP-loop domain-containing protein (HK407_09g13800), partial mRNA | blastn | 477 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora pajunii | |||
| 16856771 | 16856771 | PRJNA1123436_P_NODE_32234_length_450_cov_5.323607_g31022_i0 | PRJNA1123436 | 32234 | 450 | 5.323607 | 23.9562315 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 436 | 1.03e-117 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g31022 | i0 | 84.361 | 7.18 | 454 | 61 | 99 | 10 | 1 | 448 | 1754 | 2203 | 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 | 3231 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 19406367 | 19406367 | PRJNA1123436_P_NODE_8156_length_1031_cov_5.503132_g7188_i0 | PRJNA1123436 | 8156 | 1031 | 5.503132 | 56.73729092 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 516 | 3.09e-141 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g7188 | i0 | 86.214 | 13.3171677982541 | 486 | 56 | 87 | 10 | 215 | 695 | 2533 | 3012 | 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 | 13730 | 516 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 21431760 | 21431760 | PRJNA1123436_P_NODE_7057_length_1127_cov_4.055028_g6158_i0 | PRJNA1123436 | 7057 | 1127 | 4.055028 | 45.70016556 | Ecytonucleospora | 3078583 | Fungi | Fungi | 1410 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g6158 | i0 | 89.349 | 96.0834072759539 | 1136 | 102 | 99 | 15 | 4 | 1127 | 1142 | 14 | 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 | 108286 | 1410 | 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);;