home / zeropm-v0-0-4

api_results

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

18 rows where inchi_id = 5198

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
44154 44154 403702 403702 PubChem (compound) 1 5198 5198 1
44155 44155 19751 19751 PubChem (compound) 1 5198 5198 1
44156 44156 19752 19752 PubChem (compound) 1 5198 5198 1
44157 44157 122169 122169 PubChem (compound) 1 5198 5198 1
44158 44158 349471 349471 PubChem (compound) 1 5198 5198 1
358438 358438 122169 122169 PubChem (substance) 2 5198 5198 1
358439 358439 19751 19751 PubChem (substance) 2 5198 5198 1
358440 358440 19752 19752 PubChem (substance) 2 5198 5198 1
358441 358441 403702 403702 PubChem (substance) 2 5198 5198 1
358442 358442 349472 349472 PubChem (substance) 2 5198 5198 1
358443 358443 126567 126567 PubChem (substance) 2 5198 5198 2
358444 358444 122172 122172 PubChem (substance) 2 5198 5198 2
358445 358445 74000 74000 PubChem (substance) 2 5198 5198 17
358446 358446 360900 360900 PubChem (substance) 2 5198 5198 1
358447 358447 122165 122165 PubChem (substance) 2 5198 5198 3
358448 358448 349471 349471 PubChem (substance) 2 5198 5198 1
970449 970449 19751 19751 CAS Common Chemistry 3 5198 5198 1
970450 970450 19752 19752 CAS Common Chemistry 3 5198 5198 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 962.753ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website