home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 11971

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
13275 13275 11971 11971 PubChem (compound) 1 76684 76684 1
296382 296382 11971 11971 PubChem (substance) 2 76685 76685 6
314406 314406 11971 11971 PubChem (substance) 2 76684 76684 1
353909 353909 11971 11971 PubChem (substance) 2 57731 57731 15
375239 375239 11971 11971 PubChem (substance) 2 54673 54673 14
499628 499628 11971 11971 PubChem (substance) 2 19667 19667 13
511226 511226 11971 11971 PubChem (substance) 2 116980 116980 5
656295 656295 11971 11971 PubChem (substance) 2 70923 70923 2
665694 665694 11971 11971 PubChem (substance) 2 217830 217830 8
697944 697944 11971 11971 PubChem (substance) 2 173338 173338 10
709158 709158 11971 11971 PubChem (substance) 2 169882 169882 3
709161 709161 11971 11971 PubChem (substance) 2 219956 219956 4
709162 709162 11971 11971 PubChem (substance) 2 208208 208208 7
709163 709163 11971 11971 PubChem (substance) 2 200009 200009 9
709166 709166 11971 11971 PubChem (substance) 2 180491 180491 11
709169 709169 11971 11971 PubChem (substance) 2 195174 195174 12
948001 948001 11971 11971 CAS Common Chemistry 3 76684 76684 1
1146441 1146441 11971 11971 Computational Toxicology and Exposure Data 4 76684 76684 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 468.534ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website