api_results

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

13 rows where inchi_id = 315716

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
169586 169586 150315 150315 PubChem (compound) 1 315716 315716 12
169587 169587 351532 351532 PubChem (compound) 1 315716 315716 12
531184 531184 62310 62310 PubChem (substance) 2 315716 315716 17
531185 531185 317187 317187 PubChem (substance) 2 315716 315716 7
531186 531186 81630 81630 PubChem (substance) 2 315716 315716 18
531187 531187 351532 351532 PubChem (substance) 2 315716 315716 15
531188 531188 62311 62311 PubChem (substance) 2 315716 315716 8
531189 531189 150315 150315 PubChem (substance) 2 315716 315716 15
531190 531190 81626 81626 PubChem (substance) 2 315716 315716 10
531191 531191 81623 81623 PubChem (substance) 2 315716 315716 8
531192 531192 81629 81629 PubChem (substance) 2 315716 315716 9
531193 531193 81631 81631 PubChem (substance) 2 315716 315716 9
531194 531194 81634 81634 PubChem (substance) 2 315716 315716 9 
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)
);