epitope_2697049_ns7b_orf7b

SELECT DISTINCT epi.iedb_epitope_id,

    epi.epitope_iri,

    epi.cell_type,

    epi.mhc_class,

    epi.mhc_allele,

    epi.response_frequency_pos,

    epi.epi_annotation_start,

    epi.epi_annotation_stop,

    epi.is_linear,

    epi.assay_type,

    epif.epi_fragment_sequence,

    epif.epi_frag_annotation_start,

    epif.epi_frag_annotation_stop,

    vir.taxon_id,

    vir.taxon_name,

    hspec.host_taxon_id,

    hspec.host_taxon_name,

    seq.sequence_id,

    ann.product,

    amin.aminoacid_variant_id,

    amin.start_aa_original,

    amin.sequence_aa_original,

    amin.sequence_aa_alternative,

    amin.variant_aa_length,

    amin.variant_aa_type

   FROM (((((((epitope epi

     JOIN epitope_fragment epif ON ((epi.epitope_id = epif.epitope_id)))

     JOIN virus vir ON ((epi.virus_id = vir.virus_id)))

     JOIN host_specie hspec ON ((epi.host_id = hspec.host_id)))

     JOIN host_sample hsamp ON ((hspec.host_id = hsamp.host_id)))

     JOIN sequence seq ON (((hsamp.host_sample_id = seq.host_sample_id) AND (vir.virus_id = seq.virus_id))))

     JOIN annotation ann ON ((seq.sequence_id = ann.sequence_id)))

     JOIN aminoacid_variant amin ON ((ann.annotation_id = amin.annotation_id)))

  WHERE (((epi.protein_name)::text = (ann.product)::text) AND (amin.start_aa_original <= epif.epi_frag_annotation_stop) AND (amin.start_aa_original >= epif.epi_frag_annotation_start) AND ((ann.product)::text = 'NS7b (ORF7b)'::text) AND ((epi.protein_name)::text = 'NS7b (ORF7b)'::text) AND (vir.taxon_id = 2697049))

  ORDER BY epi.iedb_epitope_id;