home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 87597

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
115770 115770 87597 87597 PubChem (compound) 1 152161 152161 1
115773 115773 87597 87597 PubChem (compound) 1 35024 35024 2
115774 115774 87597 87597 PubChem (compound) 1 177285 177285 3
115775 115775 87597 87597 PubChem (compound) 1 152161 152161 4
115776 115776 87597 87597 PubChem (compound) 1 152161 152161 5
459038 459038 87597 87597 PubChem (substance) 2 152161 152161 1
459040 459040 87597 87597 PubChem (substance) 2 35024 35024 4
459041 459041 87597 87597 PubChem (substance) 2 177285 177285 6
459045 459045 87597 87597 PubChem (substance) 2 152161 152161 9
459046 459046 87597 87597 PubChem (substance) 2 152161 152161 8
763284 763284 87597 87597 PubChem (substance) 2 190143 190143 2
764011 764011 87597 87597 PubChem (substance) 2 238421 238421 3
764013 764013 87597 87597 PubChem (substance) 2 215096 215096 5
764014 764014 87597 87597 PubChem (substance) 2 138614 138614 7
764018 764018 87597 87597 PubChem (substance) 2 248299 248299 10
764019 764019 87597 87597 PubChem (substance) 2 292540 292540 11
764020 764020 87597 87597 PubChem (substance) 2 308324 308324 12
764021 764021 87597 87597 PubChem (substance) 2 333582 333582 13
764022 764022 87597 87597 PubChem (substance) 2 263482 263482 14
1022748 1022748 87597 87597 CAS Common Chemistry 3 35024 35024 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 461.63ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website