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 = 55949

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
94977 94977 55949 55949 PubChem (compound) 1 248640 248640 1
94980 94980 55949 55949 PubChem (compound) 1 248675 248675 2
94982 94982 55949 55949 PubChem (compound) 1 249004 249004 3
94985 94985 55949 55949 PubChem (compound) 1 248713 248713 4
94987 94987 55949 55949 PubChem (compound) 1 326153 326153 5
94989 94989 55949 55949 PubChem (compound) 1 334589 334589 6
429809 429809 55949 55949 PubChem (substance) 2 248640 248640 1
429818 429818 55949 55949 PubChem (substance) 2 248675 248675 2
429825 429825 55949 55949 PubChem (substance) 2 249004 249004 3
429836 429836 55949 55949 PubChem (substance) 2 248713 248713 5
429842 429842 55949 55949 PubChem (substance) 2 326153 326153 10
429844 429844 55949 55949 PubChem (substance) 2 334589 334589 11
496600 496600 55949 55949 PubChem (substance) 2 12272 12272 6
652359 652359 55949 55949 PubChem (substance) 2 248589 248589 4
746376 746376 55949 55949 PubChem (substance) 2 248640 248640 7
746378 746378 55949 55949 PubChem (substance) 2 249114 249114 8
746379 746379 55949 55949 PubChem (substance) 2 322068 322068 9
746382 746382 55949 55949 PubChem (substance) 2 248640 248640 12
1008501 1008501 55949 55949 CAS Common Chemistry 3 37647 37647 1
1210518 1210518 55949 55949 Computational Toxicology and Exposure Data 4 37647 37647 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 423.435ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website