home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 92984

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
100614 100614 92984 92984 PubChem (compound) 1 21585 21585 1
308049 308049 92984 92984 PubChem (substance) 2 358 358 3
438105 438105 92984 92984 PubChem (substance) 2 21585 21585 1
488045 488045 92984 92984 PubChem (substance) 2 58854 58854 14
558834 558834 92984 92984 PubChem (substance) 2 35348 35348 12
703472 703472 92984 92984 PubChem (substance) 2 170223 170223 7
750856 750856 92984 92984 PubChem (substance) 2 168284 168284 2
750859 750859 92984 92984 PubChem (substance) 2 168424 168424 4
750860 750860 92984 92984 PubChem (substance) 2 168425 168425 5
750863 750863 92984 92984 PubChem (substance) 2 168426 168426 6
750864 750864 92984 92984 PubChem (substance) 2 168925 168925 8
750866 750866 92984 92984 PubChem (substance) 2 180750 180750 9
750869 750869 92984 92984 PubChem (substance) 2 186523 186523 10
750870 750870 92984 92984 PubChem (substance) 2 270531 270531 11
750873 750873 92984 92984 PubChem (substance) 2 173816 173816 13
750874 750874 92984 92984 PubChem (substance) 2 214916 214916 15
750876 750876 92984 92984 PubChem (substance) 2 145093 145093 16
750878 750878 92984 92984 PubChem (substance) 2 178969 178969 17
1012369 1012369 92984 92984 CAS Common Chemistry 3 21585 21585 1
1214508 1214508 92984 92984 Computational Toxicology and Exposure Data 4 21585 21585 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 467.509ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website