contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4135290 | 4135290 | PRJNA1159911_P_NODE_76404_length_270_cov_1.172589_g75862_i0 | PRJNA1159911 | 76404 | 270 | 1.172589 | 3.1659903 | Leishmania sp. Ghana 2012 LV757 | 2803181 | Euglenozoa | other_Eukaryota | 272 | 1.74e-68 | NTclustered | gi|2795012999|ref|XM_067840170.1| | 2803181 | g75862 | i0 | 85.338 | 32.3185185185185 | 266 | 36 | 98 | 3 | 1 | 264 | 1497 | 1761 | Leishmania sp. Ghana 2012 LV757 uncharacterized protein (GH5_00021), partial mRNA | blastn | 8726 | 272 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania sp. Ghana 2012 LV757 | ||
| 4135746 | 4135746 | PRJNA1159911_P_NODE_99764_length_242_cov_0.911243_g99222_i0 | PRJNA1159911 | 99764 | 242 | 0.911243 | 2.20520806 | Euglena agilis | 96764 | Euglenozoa | other_Eukaryota | 86.1 | 2.15e-12 | NTclustered | gi|1002637589|gb|KU041763.1| | 96764 | g99222 | i0 | 86.076 | 1.69834710743802 | 79 | 11 | 33 | 0 | 164 | 242 | 4653 | 4575 | Euglena agilis strain UW PO heat shock protein 90 (hsp90) gene, partial cds | blastn | 411 | 86.1 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena agilis | ||
| 6686801 | 6686801 | PRJNA1159911_P_NODE_97886_length_243_cov_0.905882_g97344_i0 | PRJNA1159911 | 97886 | 243 | 0.905882 | 2.20129326 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 399 | 6.789999999999999e-107 | NTclustered | gi|225216795|gb|FJ176710.1| | 312471 | g97344 | i0 | 96.296 | 157.020576131687 | 243 | 9 | 100 | 0 | 1 | 243 | 1120 | 878 | Neobodo designis HFCC95 28S ribosomal RNA gene, partial sequence | blastn | 38156 | 399 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 7961105 | 7961105 | PRJNA1159911_P_NODE_49427_length_350_cov_1.097473_g48885_i0 | PRJNA1159911 | 49427 | 350 | 1.097473 | 3.8411555 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 329 | 1.36e-85 | NTclustered | gi|1002461111|ref|XM_015796608.1| | 157538 | g48885 | i0 | 85.852 | 77.8971428571429 | 311 | 42 | 89 | 2 | 14 | 323 | 387 | 78 | Leptomonas pyrrhocoris putative 60S ribosomal protein L12 mRNA | blastn | 27264 | 329 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 14337298 | 14337298 | PRJNA1159911_P_NODE_72312_length_278_cov_1.824390_g71770_i0 | PRJNA1159911 | 72312 | 278 | 1.82439 | 5.0718042 | Leishmania martiniquensis | 1580590 | Euglenozoa | other_Eukaryota | 207 | 5.16e-49 | NTclustered | gi|2787686310|ref|XM_067319732.1| | 1580590 | g71770 | i0 | 80.989 | 0.946043165467626 | 263 | 48 | 94 | 2 | 2 | 263 | 300 | 39 | Leishmania martiniquensis uncharacterized protein (LSCM1_02145), partial mRNA | blastn | 263 | 207 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania martiniquensis | ||
| 16884822 | 16884822 | PRJNA1159911_P_NODE_41214_length_394_cov_1.728972_g40672_i0 | PRJNA1159911 | 41214 | 394 | 1.728972 | 6.81214968 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 560 | 5.07e-155 | NTclustered | gi|116222222|gb|DQ980497.1| | 312471 | g40672 | i0 | 92.366 | 104.484771573604 | 393 | 30 | 99 | 0 | 2 | 394 | 651 | 259 | Neobodo designis clone ndtua1 alpha tubulin gene, partial cds | blastn | 41167 | 560 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 18159384 | 18159384 | PRJNA1159911_P_NODE_37715_length_420_cov_0.870317_g37173_i0 | PRJNA1159911 | 37715 | 420 | 0.870317 | 3.6553314 | Leishmania martiniquensis | 1580590 | Euglenozoa | other_Eukaryota | 235 | 3.74e-57 | NTclustered | gi|2787683904|ref|XM_067321488.1| | 1580590 | g37173 | i0 | 78.125 | 11.5619047619048 | 384 | 74 | 90 | 10 | 10 | 388 | 171 | 549 | Leishmania martiniquensis uncharacterized protein (LSCM1_03960), partial mRNA | blastn | 4856 | 235 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania martiniquensis | ||
| 18889523 | 18889523 | PRJNA1159911_P_NODE_67335_length_290_cov_1.414747_g66793_i0 | PRJNA1159911 | 67335 | 290 | 1.414747 | 4.1027663 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 130 | 1.21e-25 | NTclustered | gi|2593249679|emb|OY748418.1| | 5660 | g66793 | i0 | 85.496 | 4.80689655172414 | 131 | 12 | 44 | 4 | 152 | 278 | 777062 | 777189 | Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 24 | blastn | 1394 | 130 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 21985230 | 21985230 | PRJNA1159911_P_NODE_76758_length_269_cov_1.530612_g76216_i0 | PRJNA1159911 | 76758 | 269 | 1.530612 | 4.11734628 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 222 | 1.77e-53 | NTclustered | gi|1002453727|ref|XM_015799466.1| | 157538 | g76216 | i0 | 84.416 | 35.7137546468402 | 231 | 31 | 84 | 4 | 5 | 231 | 535 | 306 | Leptomonas pyrrhocoris putative mitochondrial putative ADP/ATP translocase 1 mRNA | blastn | 9607 | 222 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris |
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);;