contig_metadata
7 rows where bioproject = "PRJNA495391" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10680546 | 10680546 | PRJNA495391_S_NODE_56509_length_165_cov_2.346154_g55457_i0 | PRJNA495391 | 56509 | 165 | 2.346154 | 3.8711541 | Neobodo curvifilus | 351716 | Euglenozoa | other_Eukaryota | 165 | 1.6999999999999998e-36 | NTclustered | gi|197723535|gb|EF681919.2| | 351716 | g55457 | i0 | 85.366 | 8.15757575757576 | 164 | 19 | 99 | 4 | 1 | 163 | 22 | 181 | Neobodo curvifilus strain HFCC37 28S ribosomal RNA gene, partial sequence | blastn | 1346 | 165 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo curvifilus | |||
| 15135779 | 15135779 | PRJNA495391_S_NODE_65632_length_155_cov_1.841667_g64580_i0 | PRJNA495391 | 65632 | 155 | 1.841667 | 2.85458385 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 97.8 | 2.9e-24 | NR | QLA09595.1 | 3039 | g64580 | i0 | 84 | 0.967741935483871 | 50 | 8 | 96.8 | 0 | 150 | 1 | 103 | 152 | QLA09595.1 40S small subunit ribosomal protein eS31 [Euglena gracilis] | diamond | 150 | 97.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 20878219 | 20878219 | PRJNA495391_S_NODE_37217_length_200_cov_2.175758_g36165_i0 | PRJNA495391 | 37217 | 200 | 2.175758 | 4.351516 | Peranema trichophorum | 56466 | Euglenozoa | other_Eukaryota | 370 | 4.22e-98 | NTclustered | gi|1803019516|gb|MT007902.1| | 56466 | g36165 | i0 | 100 | 31.545 | 200 | 0 | 100 | 0 | 1 | 200 | 242 | 441 | Peranema trichophorum isolate PP8 small subunit ribosomal RNA gene, partial sequence | blastn | 6309 | 370 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemidae | Peranema | Peranema trichophorum | ||
| 27139824 | 27139824 | PRJNA495391_S_NODE_56142_length_166_cov_1.480916_g55090_i0 | PRJNA495391 | 56142 | 166 | 1.480916 | 2.45832056 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 47 | 4.29e-4 | NR | CUG86219.1 | 75058 | g55090 | i0 | 51.1 | 1.68072289156627 | 47 | 23 | 84.9 | 0 | 165 | 25 | 1110 | 1156 | CUG86219.1 FtsX-like permease family protein, putative [Bodo saltans] | diamond | 279 | 47 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 29019168 | 29019168 | PRJNA495391_S_NODE_64428_length_156_cov_2.561983_g63376_i0 | PRJNA495391 | 64428 | 156 | 2.561983 | 3.99669348 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.4 | 2.11e-5 | NR | CAG4719398.1 | 5763 | g63376 | i0 | 49 | 4.69230769230769 | 49 | 25 | 94.2 | 0 | 3 | 149 | 314 | 362 | CAG4719398.1 unnamed protein product [Naegleria fowleri] | diamond | 732 | 50.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29950649 | 29950649 | PRJNA495391_S_NODE_58251_length_163_cov_1.937500_g57199_i0 | PRJNA495391 | 58251 | 163 | 1.9375 | 3.158125 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 42.7 | 0.0128 | NR | XP_044548087.1 | 51637 | g57199 | i0 | 46.5 | 2.65030674846626 | 43 | 23 | 79.1 | 0 | 34 | 162 | 23 | 65 | XP_044548087.1 uncharacterized protein C9374_005610 [Naegleria lovaniensis] | diamond | 432 | 42.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 30045236 | 30045236 | PRJNA495391_S_NODE_23511_length_248_cov_1.910798_g22459_i0 | PRJNA495391 | 23511 | 248 | 1.910798 | 4.73877904 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 45.1 | 0.00499 | NR | KAL0479510.1 | 1008807 | g22459 | i0 | 33.3 | 0.907258064516129 | 75 | 50 | 90.7 | 0 | 237 | 13 | 158 | 232 | KAL0479510.1 hypothetical protein AKO1_015016, partial [Acrasis kona] | diamond | 225 | 45.1 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona |
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);;