View_MarineSequences_Applicants (view)

Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT

104,515 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE VIEW View_MarineSequences_Applicants AS
SELECT 
    ms.Sequence_accession_number,
    ms.Species_name,
    ms.GC_content,
    ms.Sequence_length,
    ms.Sequence_status,
    ms.Is_protein_coding_sequence,
    ms.Is_annotated,
    a.Applicant_name,
    a.Applicant_type,
    a.Applicant_country,
    ap.Patent_application_number,
    ap.Year_of_application,
    ap.Patent_system
FROM 
    Marine_Sequences ms
JOIN 
    Applications_Sequences aps ON ms.Sequence_accession_number = aps.Sequence_accession_number
JOIN 
    Applications ap ON aps.Patent_application_number = ap.Patent_application_number
JOIN 
    Applicants a ON ap.Applicant_name = a.Applicant_name;