home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 4946

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
9200 9200 4946 4946 PubChem (compound) 1 180017 180017 1
9204 9204 4946 4946 PubChem (compound) 1 137447 137447 2
9206 9206 4946 4946 PubChem (compound) 1 149826 149826 3
9207 9207 4946 4946 PubChem (compound) 1 194219 194219 4
9208 9208 4946 4946 PubChem (compound) 1 207283 207283 5
9209 9209 4946 4946 PubChem (compound) 1 170067 170067 6
9210 9210 4946 4946 PubChem (compound) 1 185916 185916 7
9211 9211 4946 4946 PubChem (compound) 1 200240 200240 8
308334 308334 4946 4946 PubChem (substance) 2 180017 180017 1
308343 308343 4946 4946 PubChem (substance) 2 137447 137447 2
308349 308349 4946 4946 PubChem (substance) 2 149826 149826 3
308353 308353 4946 4946 PubChem (substance) 2 194219 194219 4
308357 308357 4946 4946 PubChem (substance) 2 207283 207283 5
308358 308358 4946 4946 PubChem (substance) 2 170067 170067 6
308359 308359 4946 4946 PubChem (substance) 2 185916 185916 11
308361 308361 4946 4946 PubChem (substance) 2 200240 200240 12
430827 430827 4946 4946 PubChem (substance) 2 195832 195832 13
697882 697882 4946 4946 PubChem (substance) 2 137594 137594 7
698866 698866 4946 4946 PubChem (substance) 2 292580 292580 8
698869 698869 4946 4946 PubChem (substance) 2 201457 201457 9
698871 698871 4946 4946 PubChem (substance) 2 138746 138746 10
698872 698872 4946 4946 PubChem (substance) 2 329402 329402 14
944990 944990 4946 4946 CAS Common Chemistry 3 46096 46096 1
1142875 1142875 4946 4946 Computational Toxicology and Exposure Data 4 46096 46096 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 444.39ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website