api_results

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

11 rows where query_id = 83639

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
113621 113621 83639 83639 PubChem (compound) 1 43182 43182 1
455942 455942 83639 83639 PubChem (substance) 2 43182 43182 1
478084 478084 83639 83639 PubChem (substance) 2 96906 96906 2
761931 761931 83639 83639 PubChem (substance) 2 143193 143193 3
761932 761932 83639 83639 PubChem (substance) 2 276079 276079 4
761933 761933 83639 83639 PubChem (substance) 2 234611 234611 5
761935 761935 83639 83639 PubChem (substance) 2 168585 168585 6
761936 761936 83639 83639 PubChem (substance) 2 259393 259393 7
761937 761937 83639 83639 PubChem (substance) 2 238820 238820 8
1021206 1021206 83639 83639 CAS Common Chemistry 3 43182 43182 1
1223655 1223655 83639 83639 Computational Toxicology and Exposure Data 4 43182 43182 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)
);