contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA675638" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27839842 | 27839842 | PRJNA675638_S_NODE_7644_length_167_cov_0.864407_g7582_i0 | PRJNA675638 | 7644 | 167 | 0.864407 | 1.44355969 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 114 | 7.47e-32 | NR | KRH92142.1 | 146866 | g7582 | i0 | 100 | 0.988023952095808 | 55 | 0 | 98.8 | 0 | 165 | 1 | 8 | 62 | KRH92142.1 40S ribosomal protein S28 [Pseudoloma neurophilia] | diamond | 165 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27998076 | 27998076 | PRJNA675638_S_NODE_9005_length_162_cov_0.902655_g8943_i0 | PRJNA675638 | 9005 | 162 | 0.902655 | 1.4623011 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 115 | 3.9999999999999994e-28 | NR | KRH92938.1 | 146866 | g8943 | i0 | 100 | 0.981481481481482 | 53 | 0 | 98.1 | 0 | 160 | 2 | 614 | 666 | KRH92938.1 Nuclear pore complex, Nup98 component (sc Nup145/Nup100/Nup116), partial [Pseudoloma neurophilia] | diamond | 159 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28155962 | 28155962 | PRJNA675638_S_NODE_7845_length_166_cov_0.871795_g7783_i0 | PRJNA675638 | 7845 | 166 | 0.871795 | 1.4471797 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 121 | 1.41e-30 | NR | KRH92949.1 | 146866 | g7783 | i0 | 100 | 0.993975903614458 | 55 | 0 | 99.4 | 0 | 2 | 166 | 49 | 103 | KRH92949.1 hypothetical protein M153_1976000584 [Pseudoloma neurophilia] | diamond | 165 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28597946 | 28597946 | PRJNA675638_P_NODE_19687_length_165_cov_0.879310_g19490_i0 | PRJNA675638 | 19687 | 165 | 0.87931 | 1.4508615 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 115 | 6.840000000000001e-29 | NR | KRH93716.1 | 146866 | g19490 | i0 | 100 | 0.981818181818182 | 54 | 0 | 98.2 | 0 | 164 | 3 | 284 | 337 | KRH93716.1 Translation initiation factor 2, gamma subunit (eIF-2gamma, GTPase) [Pseudoloma neurophilia] | diamond | 162 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29260679 | 29260679 | PRJNA675638_P_NODE_19989_length_164_cov_0.886957_g19792_i0 | PRJNA675638 | 19989 | 164 | 0.886957 | 1.45460948 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 103 | 1.17e-25 | NR | KRH94821.1 | 146866 | g19792 | i0 | 100 | 0.98780487804878 | 54 | 0 | 98.8 | 0 | 2 | 163 | 16 | 69 | KRH94821.1 hypothetical protein M153_1310005524 [Pseudoloma neurophilia] | diamond | 162 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30966774 | 30966774 | PRJNA675638_S_NODE_8694_length_163_cov_0.894737_g8632_i0 | PRJNA675638 | 8694 | 163 | 0.894737 | 1.45842131 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 113 | 1.26e-27 | NR | KRH95228.1 | 146866 | g8632 | i0 | 100 | 0.975460122699387 | 53 | 0 | 97.5 | 0 | 161 | 3 | 23 | 75 | KRH95228.1 Transketolase [Pseudoloma neurophilia] | diamond | 159 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31440715 | 31440715 | PRJNA675638_P_NODE_18736_length_166_cov_0.871795_g18539_i0 | PRJNA675638 | 18736 | 166 | 0.871795 | 1.4471797 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 110 | 7.76e-28 | NR | KRH93782.1 | 146866 | g18539 | i0 | 100 | 0.975903614457831 | 54 | 0 | 97.6 | 0 | 164 | 3 | 98 | 151 | KRH93782.1 hypothetical protein M153_574000719 [Pseudoloma neurophilia] | diamond | 162 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;