api_results

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

14 rows where inchi_id = 40954

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
113507 113507 83349 83349 PubChem (compound) 1 40954 40954 2
455763 455763 19113 19113 PubChem (substance) 2 40954 40954 7
455764 455764 19232 19232 PubChem (substance) 2 40954 40954 3
455765 455765 83349 83349 PubChem (substance) 2 40954 40954 3
969272 969272 83343 83343 CAS Common Chemistry 3 40954 40954 1
969273 969273 345217 345217 CAS Common Chemistry 3 40954 40954 1
969274 969274 19113 19113 CAS Common Chemistry 3 40954 40954 1
969275 969275 83358 83358 CAS Common Chemistry 3 40954 40954 1
969276 969276 408424 408424 CAS Common Chemistry 3 40954 40954 1
969277 969277 373206 373206 CAS Common Chemistry 3 40954 40954 1
969278 969278 119495 119495 CAS Common Chemistry 3 40954 40954 1
1011039 1011039 58705 58705 CAS Common Chemistry 3 40954 40954 1
1011040 1011040 58706 58706 CAS Common Chemistry 3 40954 40954 1
1011041 1011041 442936 442936 CAS Common Chemistry 3 40954 40954 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)
);