api_results

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

18 rows where query_id = 88992

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
34210 34210 88992 88992 PubChem (compound) 1 313978 313978 1
34215 34215 88992 88992 PubChem (compound) 1 97071 97071 2
34218 34218 88992 88992 PubChem (compound) 1 314164 314164 3
344532 344532 88992 88992 PubChem (substance) 2 313978 313978 1
344537 344537 88992 88992 PubChem (substance) 2 97071 97071 4
344543 344543 88992 88992 PubChem (substance) 2 314406 314406 12
344548 344548 88992 88992 PubChem (substance) 2 314164 314164 6
344552 344552 88992 88992 PubChem (substance) 2 313978 313978 2
618158 618158 88992 88992 PubChem (substance) 2 313979 313979 8
713934 713934 88992 88992 PubChem (substance) 2 317647 317647 3
713938 713938 88992 88992 PubChem (substance) 2 316880 316880 5
713943 713943 88992 88992 PubChem (substance) 2 150553 150553 9
713947 713947 88992 88992 PubChem (substance) 2 314164 314164 7
713952 713952 88992 88992 PubChem (substance) 2 224263 224263 10
713955 713955 88992 88992 PubChem (substance) 2 281881 281881 11
713957 713957 88992 88992 PubChem (substance) 2 318090 318090 13
963092 963092 88992 88992 CAS Common Chemistry 3 9513 9513 1
1164425 1164425 88992 88992 Computational Toxicology and Exposure Data 4 97071 97071 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)
);