Unified query search for marine species names across all dataset tables

Custom SQL query returning more than 1,000 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 LIKE '%' || :text || '%' 
ORDER BY 
  Applicants.Applicant_name
LIMIT
  5000;

Query parameters

text

Edit SQL