api_results

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

14 rows where inchi_id = 315701

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102711 102711 62310 62310 PubChem (compound) 1 315701 315701 7
102712 102712 150315 150315 PubChem (compound) 1 315701 315701 11
102713 102713 351532 351532 PubChem (compound) 1 315701 315701 11
441084 441084 81629 81629 PubChem (substance) 2 315701 315701 11
441085 441085 150315 150315 PubChem (substance) 2 315701 315701 13
441086 441086 317187 317187 PubChem (substance) 2 315701 315701 9
441087 441087 81623 81623 PubChem (substance) 2 315701 315701 10
441088 441088 81634 81634 PubChem (substance) 2 315701 315701 11
441089 441089 351532 351532 PubChem (substance) 2 315701 315701 13
441090 441090 62310 62310 PubChem (substance) 2 315701 315701 8
441091 441091 62311 62311 PubChem (substance) 2 315701 315701 10
441092 441092 81631 81631 PubChem (substance) 2 315701 315701 11
441093 441093 81630 81630 PubChem (substance) 2 315701 315701 20
441094 441094 81626 81626 PubChem (substance) 2 315701 315701 12 
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)
);