api_results

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

15 rows where query_id = 89799

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
116928 116928 89799 89799 PubChem (compound) 1 62066 62066 1
460738 460738 89799 89799 PubChem (substance) 2 62066 62066 1
579940 579940 89799 89799 PubChem (substance) 2 60396 60396 4
764940 764940 89799 89799 PubChem (substance) 2 170678 170678 2
764943 764943 89799 89799 PubChem (substance) 2 238128 238128 3
764944 764944 89799 89799 PubChem (substance) 2 211306 211306 5
764945 764945 89799 89799 PubChem (substance) 2 309727 309727 6
764947 764947 89799 89799 PubChem (substance) 2 233322 233322 7
764950 764950 89799 89799 PubChem (substance) 2 288182 288182 8
764951 764951 89799 89799 PubChem (substance) 2 168235 168235 9
764954 764954 89799 89799 PubChem (substance) 2 308365 308365 10
764956 764956 89799 89799 PubChem (substance) 2 271994 271994 11
764957 764957 89799 89799 PubChem (substance) 2 234233 234233 12
1023553 1023553 89799 89799 CAS Common Chemistry 3 62066 62066 1
1225896 1225896 89799 89799 Computational Toxicology and Exposure Data 4 62066 62066 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)
);