api_results

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

8 rows where query_id = 156508

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
175703 175703 156508 156508 PubChem (compound) 1 16337 16337 1
298923 298923 156508 156508 PubChem (substance) 2 16512 16512 5
539325 539325 156508 156508 PubChem (substance) 2 16337 16337 1
539327 539327 156508 156508 PubChem (substance) 2 226939 226939 2
669572 669572 156508 156508 PubChem (substance) 2 125197 125197 3
809724 809724 156508 156508 PubChem (substance) 2 196568 196568 4
1067255 1067255 156508 156508 CAS Common Chemistry 3 16337 16337 1
1268867 1268867 156508 156508 Computational Toxicology and Exposure Data 4 16337 16337 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)
);