home / zeropm-v0-0-4

api_results

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

13 rows where inchi_id = 75072

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
42112 42112 305568 305568 PubChem (compound) 1 75072 75072 1
42113 42113 18943 18943 PubChem (compound) 1 75072 75072 1
42114 42114 118653 118653 PubChem (compound) 1 75072 75072 1
42115 42115 18944 18944 PubChem (compound) 1 75072 75072 1
355608 355608 18944 18944 PubChem (substance) 2 75072 75072 1
355609 355609 375370 375370 PubChem (substance) 2 75072 75072 2
355610 355610 18943 18943 PubChem (substance) 2 75072 75072 1
355611 355611 118653 118653 PubChem (substance) 2 75072 75072 1
355612 355612 305568 305568 PubChem (substance) 2 75072 75072 1
968964 968964 305568 305568 CAS Common Chemistry 3 75072 75072 1
968965 968965 18943 18943 CAS Common Chemistry 3 75072 75072 1
968966 968966 118653 118653 CAS Common Chemistry 3 75072 75072 1
968967 968967 18944 18944 CAS Common Chemistry 3 75072 75072 1
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)
);
Powered by Datasette · Queries took 718.056ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website