api_results

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

10 rows where query_id = 1080

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
298539 298539 1080 1080 PubChem (substance) 2 119536 119536 3
494362 494362 1080 1080 PubChem (substance) 2 4340 4340 2
501286 501286 1080 1080 PubChem (substance) 2 22681 22681 8
648261 648261 1080 1080 PubChem (substance) 2 119536 119536 1
693951 693951 1080 1080 PubChem (substance) 2 241496 241496 4
693953 693953 1080 1080 PubChem (substance) 2 224102 224102 5
693954 693954 1080 1080 PubChem (substance) 2 48113 48113 6
693957 693957 1080 1080 PubChem (substance) 2 4340 4340 7
939621 939621 1080 1080 CAS Common Chemistry 3 4340 4340 1
1136599 1136599 1080 1080 Computational Toxicology and Exposure Data 4 119536 119536 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)
);