api_results

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

12 rows where inchi_id = 20607

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
68490 68490 32963 32963 PubChem (compound) 1 20607 20607 1
68491 68491 32964 32964 PubChem (compound) 1 20607 20607 1
68492 68492 160102 160102 PubChem (compound) 1 20607 20607 1
393235 393235 32964 32964 PubChem (substance) 2 20607 20607 1
393236 393236 137107 137107 PubChem (substance) 2 20607 20607 1
393237 393237 126187 126187 PubChem (substance) 2 20607 20607 2
393238 393238 160102 160102 PubChem (substance) 2 20607 20607 1
393239 393239 32963 32963 PubChem (substance) 2 20607 20607 1
393240 393240 137108 137108 PubChem (substance) 2 20607 20607 1
988741 988741 32964 32964 CAS Common Chemistry 3 20607 20607 1
988742 988742 32963 32963 CAS Common Chemistry 3 20607 20607 1
988743 988743 137107 137107 CAS Common Chemistry 3 20607 20607 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)
);