api_results

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

15 rows where inchi_id = 77145

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
23537 23537 12032 12032 PubChem (compound) 1 77145 77145 1
23538 23538 56449 56449 PubChem (compound) 1 77145 77145 1
23539 23539 25329 25329 PubChem (compound) 1 77145 77145 1
23540 23540 12033 12033 PubChem (compound) 1 77145 77145 1
23541 23541 105789 105789 PubChem (compound) 1 77145 77145 1
23542 23542 25330 25330 PubChem (compound) 1 77145 77145 1
23543 23543 405940 405940 PubChem (compound) 1 77145 77145 1
329425 329425 12032 12032 PubChem (substance) 2 77145 77145 1
329426 329426 12033 12033 PubChem (substance) 2 77145 77145 1
329427 329427 25329 25329 PubChem (substance) 2 77145 77145 1
329428 329428 56449 56449 PubChem (substance) 2 77145 77145 1
329429 329429 25330 25330 PubChem (substance) 2 77145 77145 1
329430 329430 105789 105789 PubChem (substance) 2 77145 77145 1
329431 329431 405940 405940 PubChem (substance) 2 77145 77145 1
955509 955509 12032 12032 CAS Common Chemistry 3 77145 77145 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)
);