contig_metadata
4 rows where bioproject = "PRJNA939370", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7634277 | 7634277 | PRJNA939370_S_NODE_1326_length_240_cov_2.141361_g1274_i0 | PRJNA939370 | 1326 | 240 | 2.141361 | 5.1392664 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 239 | 1.54e-58 | NTclustered | gi|440222381|gb|JX030049.1| | 5659 | g1274 | i0 | 95.364 | 75.4916666666667 | 151 | 6 | 63 | 1 | 1 | 150 | 672 | 822 | Leishmania amazonensis isolate LaPH8.rRNA.25 28S ribosomal RNA (LSU-beta), partial sequence | blastn | 18118 | 239 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania amazonensis | ||
| 9842689 | 9842689 | PRJNA939370_S_NODE_848_length_316_cov_2.966292_g796_i0 | PRJNA939370 | 848 | 316 | 2.966292 | 9.37348272 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 396 | 1.1899999999999997e-105 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g796 | i0 | 89.198 | 135.835443037975 | 324 | 26 | 100 | 7 | 1 | 316 | 4480 | 4802 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 42924 | 396 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 13668273 | 13668273 | PRJNA939370_S_NODE_1251_length_248_cov_1.216080_g1199_i0 | PRJNA939370 | 1251 | 248 | 1.21608 | 3.0158784 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 396 | 9e-106 | NTclustered | gi|197723537|gb|EF681922.2| | 312471 | g1199 | i0 | 95.565 | 157.016129032258 | 248 | 9 | 100 | 2 | 1 | 248 | 955 | 1200 | Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence | blastn | 38940 | 396 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 20382484 | 20382484 | PRJNA939370_S_NODE_556_length_389_cov_1.688235_g504_i0 | PRJNA939370 | 556 | 389 | 1.688235 | 6.56723415 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 285 | 3.3699999999999995e-72 | NTclustered | gi|2414483|emb|Y00055.1| | 5656 | g504 | i0 | 86.029 | 76.73264781491 | 272 | 31 | 69 | 6 | 80 | 347 | 7326 | 7058 | Crithidia fasciculata ribosomal DNA repeat (complete) | blastn | 29849 | 287 | 0.993031358885017 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia fasciculata |
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);;