contig_metadata
5 rows where bioproject = "PRJNA382357", tax_clade = "Discoba" and tax_phylum = "Euglenozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10002838 | 10002838 | PRJNA382357_P_NODE_151428_length_204_cov_0.909091_g150689_i0 | PRJNA382357 | 151428 | 204 | 0.909091 | 1.85454564 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1751371445|tpg|BK010876.1| | 5670 | g150689 | i0 | 100 | 1.26470588235294 | 29 | 0 | 14 | 0 | 39 | 67 | 5131 | 5159 | TPA_asm: Leishmania guyanensis strain MCAN kinetoplast, complete sequence | blastn | 258 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania guyanensis | ||
| 11882528 | 11882528 | PRJNA382357_P_NODE_44510_length_346_cov_1.291228_g43771_i0 | PRJNA382357 | 44510 | 346 | 1.291228 | 4.46764888 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|1031970226|gb|CP015660.1| | 85057 | g43771 | i0 | 100 | 0.0838150289017341 | 29 | 0 | 8 | 0 | 185 | 213 | 966345 | 966373 | Trypanosoma cruzi cruzi strain Sylvio X10/cl1 chromosome TcI10, partial sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 16979708 | 16979708 | PRJNA382357_P_NODE_105254_length_236_cov_23.531429_g104515_i0 | PRJNA382357 | 105254 | 236 | 23.531429 | 55.53417244 | Procryptobia sorokini | 351715 | Euglenozoa | other_Eukaryota | 246 | 9.05e-61 | NTclustered | gi|197723538|gb|EF681923.2| | 351715 | g104515 | i0 | 96.026 | 149.970338983051 | 151 | 6 | 100 | 0 | 86 | 236 | 424 | 274 | Procryptobia sorokini strain HFCC98 28S ribosomal RNA gene, partial sequence | blastn | 35393 | 246 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sorokini | |||
| 27612255 | 27612255 | PRJNA382357_P_NODE_119244_length_224_cov_1.036810_g118505_i0 | PRJNA382357 | 119244 | 224 | 1.03681 | 2.3224544 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 46.6 | 0.00127 | NR | CUG86635.1 | 75058 | g118505 | i0 | 37.1 | 0.9375 | 70 | 36 | 93.8 | 1 | 216 | 7 | 399 | 460 | CUG86635.1 heat shock protein 70, putative [Bodo saltans] | diamond | 210 | 46.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30233004 | 30233004 | PRJNA382357_P_NODE_130012_length_214_cov_2.483660_g129273_i0 | PRJNA382357 | 130012 | 214 | 2.48366 | 5.3150324 | Leishmania tarentolae | 5689 | Euglenozoa | other_Eukaryota | 42 | 0.0493 | NR | GET92619.1 | 5689 | g129273 | i0 | 32.7 | 0.728971962616822 | 52 | 33 | 70.1 | 1 | 62 | 211 | 50 | 101 | GET92619.1 oligosaccharyl transferase-like protein [Leishmania tarentolae] | diamond | 156 | 42 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania tarentolae |
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);;