api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

11 rows where query_id = 36052

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
446960 446960 36052 36052 PubChem (substance) 2 250042 250042 6
735589 735589 36052 36052 PubChem (substance) 2 227667 227667 1
735592 735592 36052 36052 PubChem (substance) 2 287672 287672 2
735595 735595 36052 36052 PubChem (substance) 2 227498 227498 3
735598 735598 36052 36052 PubChem (substance) 2 248173 248173 4
735604 735604 36052 36052 PubChem (substance) 2 227387 227387 5
735605 735605 36052 36052 PubChem (substance) 2 123455 123455 7
735609 735609 36052 36052 PubChem (substance) 2 272759 272759 8
735611 735611 36052 36052 PubChem (substance) 2 201658 201658 9
735613 735613 36052 36052 PubChem (substance) 2 256427 256427 10
735615 735615 36052 36052 PubChem (substance) 2 164559 164559 11 
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);