home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 4049

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
7612 7612 4049 4049 PubChem (compound) 1 10980 10980 1
306055 306055 4049 4049 PubChem (substance) 2 10980 10980 1
306112 306112 4049 4049 PubChem (substance) 2 84329 84329 10
336958 336958 4049 4049 PubChem (substance) 2 41654 41654 5
353796 353796 4049 4049 PubChem (substance) 2 48400 48400 2
459899 459899 4049 4049 PubChem (substance) 2 174913 174913 8
489111 489111 4049 4049 PubChem (substance) 2 66784 66784 9
492576 492576 4049 4049 PubChem (substance) 2 176469 176469 3
514392 514392 4049 4049 PubChem (substance) 2 174884 174884 13
617597 617597 4049 4049 PubChem (substance) 2 187569 187569 6
631423 631423 4049 4049 PubChem (substance) 2 176955 176955 11
676432 676432 4049 4049 PubChem (substance) 2 174733 174733 14
697985 697985 4049 4049 PubChem (substance) 2 176064 176064 4
697987 697987 4049 4049 PubChem (substance) 2 186957 186957 7
697991 697991 4049 4049 PubChem (substance) 2 187035 187035 12
697992 697992 4049 4049 PubChem (substance) 2 187061 187061 15
697993 697993 4049 4049 PubChem (substance) 2 223390 223390 16
697994 697994 4049 4049 PubChem (substance) 2 188036 188036 17
697995 697995 4049 4049 PubChem (substance) 2 173343 173343 18
697996 697996 4049 4049 PubChem (substance) 2 248607 248607 19
697997 697997 4049 4049 PubChem (substance) 2 188622 188622 20
943760 943760 4049 4049 CAS Common Chemistry 3 10980 10980 1
1141447 1141447 4049 4049 Computational Toxicology and Exposure Data 4 10980 10980 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 655.97ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website