api_results

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

12 rows where inchi_id = 11417

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
35052 35052 16214 16214 PubChem (compound) 1 11417 11417 4
345700 345700 16214 16214 PubChem (substance) 2 11417 11417 8
345701 345701 389756 389756 PubChem (substance) 2 11417 11417 3
963648 963648 16214 16214 CAS Common Chemistry 3 11417 11417 1
963649 963649 110209 110209 CAS Common Chemistry 3 11417 11417 1
963650 963650 16215 16215 CAS Common Chemistry 3 11417 11417 1
963651 963651 406837 406837 CAS Common Chemistry 3 11417 11417 1
963652 963652 78166 78166 CAS Common Chemistry 3 11417 11417 1
963653 963653 316445 316445 CAS Common Chemistry 3 11417 11417 1
987095 987095 31829 31829 CAS Common Chemistry 3 11417 11417 1
987096 987096 78166 78166 CAS Common Chemistry 3 11417 11417 2
987097 987097 31830 31830 CAS Common Chemistry 3 11417 11417 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)
);