home / zeropm-v0-0-4

api_results

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

15 rows where inchi_id = 36966

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99908 99908 60077 60077 PubChem (compound) 1 36966 36966 1
99909 99909 60078 60078 PubChem (compound) 1 36966 36966 1
99910 99910 111589 111589 PubChem (compound) 1 36966 36966 1
437098 437098 60078 60078 PubChem (substance) 2 36966 36966 1
437099 437099 326684 326684 PubChem (substance) 2 36966 36966 3
437100 437100 60077 60077 PubChem (substance) 2 36966 36966 1
437101 437101 111589 111589 PubChem (substance) 2 36966 36966 1
437102 437102 94850 94850 PubChem (substance) 2 36966 36966 1
437103 437103 372287 372287 PubChem (substance) 2 36966 36966 2
1011869 1011869 60077 60077 CAS Common Chemistry 3 36966 36966 1
1011870 1011870 60078 60078 CAS Common Chemistry 3 36966 36966 1
1011871 1011871 111589 111589 CAS Common Chemistry 3 36966 36966 1
1213986 1213986 111589 111589 Computational Toxicology and Exposure Data 4 36966 36966 1
1213987 1213987 60077 60077 Computational Toxicology and Exposure Data 4 36966 36966 1
1213988 1213988 60078 60078 Computational Toxicology and Exposure Data 4 36966 36966 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 684.337ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website