All database records with sequences derived from species uniquely present in ABNJ

Custom SQL query returning 133 rows (hide)

SELECT
  Applicants.Applicant_name,
  Applicants.Applicant_type,
  Applicants.Applicant_country,
  Applications.Patent_application_number,
  Applications.Year_of_application,
  Applications.Patent_system,
  Marine_Sequences.Sequence_accession_number,
  Marine_Sequences.Species_name AS Marine_Species_name,
  Marine_Sequences.GC_content,
  Marine_Sequences.Sequence_length,
  Marine_Sequences.Sequence_status,
  Marine_Sequences.Is_protein_coding_sequence,
  Marine_Sequences.Is_annotated,
  Marine_Species.Domain,
  Marine_Species.Phylum,
  Marine_Species.Taxonomic_source,
  Marine_Species.Is_deep_sea,
  Marine_Species.Deep_sea_source,
  Marine_Species.Is_ABNJ_present,
  Marine_Sequences_Protein_Annotations.f_header,
  Marine_Sequences_Protein_Annotations.sseqid,
  Marine_Sequences_Protein_Annotations.stitle,
  Marine_Sequences_Protein_Annotations.pident,
  Marine_Sequences_Protein_Annotations.evalue,
  Marine_Sequences_Protein_Annotations.qcovs,
  Marine_Sequences_Protein_Annotations.annotation_source
FROM
  Applications
INNER JOIN Applicants ON Applications.Applicant_name = Applicants.Applicant_name
INNER JOIN Applications_Sequences ON Applications.Patent_application_number = Applications_Sequences.Patent_application_number
INNER JOIN Marine_Sequences ON Applications_Sequences.Sequence_accession_number = Marine_Sequences.Sequence_accession_number
INNER JOIN Marine_Species ON Marine_Sequences.Species_name = Marine_Species.Species_name
LEFT JOIN Marine_Sequences_Protein_Annotations ON Marine_Sequences.Sequence_accession_number = Marine_Sequences_Protein_Annotations.Sequence_accession_number
WHERE
  Marine_Species.Species_name IN ('Idiomarina zobellii', 'Moritella marina', 'Moritella abyssi', 'Psychroflexus torquis', 'Shewanella violacea')
ORDER BY
  Applicants.Applicant_name;

Edit SQL