api_results

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

10 rows where query_id = 130038

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
150147 150147 130038 130038 PubChem (compound) 1 30746 30746 1
505459 505459 130038 130038 PubChem (substance) 2 30746 30746 1
506475 506475 130038 130038 PubChem (substance) 2 32505 32505 5
519913 519913 130038 130038 PubChem (substance) 2 58667 58667 2
792063 792063 130038 130038 PubChem (substance) 2 237877 237877 3
792064 792064 130038 130038 PubChem (substance) 2 267330 267330 4
792065 792065 130038 130038 PubChem (substance) 2 270951 270951 6
792066 792066 130038 130038 PubChem (substance) 2 334349 334349 7
1047827 1047827 130038 130038 CAS Common Chemistry 3 30746 30746 1
1250681 1250681 130038 130038 Computational Toxicology and Exposure Data 4 30746 30746 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)
);