api_results

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

16 rows where query_id = 117563

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
137182 137182 117563 117563 PubChem (compound) 1 60119 60119 1
488392 488392 117563 117563 PubChem (substance) 2 60119 60119 1
783043 783043 117563 117563 PubChem (substance) 2 138202 138202 2
783045 783045 117563 117563 PubChem (substance) 2 172577 172577 3
783047 783047 117563 117563 PubChem (substance) 2 210299 210299 5
783050 783050 117563 117563 PubChem (substance) 2 238104 238104 4
783052 783052 117563 117563 PubChem (substance) 2 320494 320494 8
783054 783054 117563 117563 PubChem (substance) 2 288694 288694 9
783056 783056 117563 117563 PubChem (substance) 2 323950 323950 10
783057 783057 117563 117563 PubChem (substance) 2 294520 294520 12
783063 783063 117563 117563 PubChem (substance) 2 324622 324622 13
783065 783065 117563 117563 PubChem (substance) 2 291641 291641 6
783067 783067 117563 117563 PubChem (substance) 2 232019 232019 7
783068 783068 117563 117563 PubChem (substance) 2 256891 256891 11
1037992 1037992 117563 117563 CAS Common Chemistry 3 60119 60119 1
1240982 1240982 117563 117563 Computational Toxicology and Exposure Data 4 60119 60119 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)
);