api_results

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

17 rows where inchi_id = 12

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28414 28414 13802 13802 PubChem (compound) 1 12 12 1
28415 28415 13803 13803 PubChem (compound) 1 12 12 1
28416 28416 107485 107485 PubChem (compound) 1 12 12 1
28417 28417 69792 69792 PubChem (compound) 1 12 12 1
336114 336114 308542 308542 PubChem (substance) 2 12 12 2
336115 336115 13803 13803 PubChem (substance) 2 12 12 1
336116 336116 13802 13802 PubChem (substance) 2 12 12 1
336117 336117 107485 107485 PubChem (substance) 2 12 12 1
336118 336118 69792 69792 PubChem (substance) 2 12 12 1
336119 336119 107454 107454 PubChem (substance) 2 12 12 2
959031 959031 13802 13802 CAS Common Chemistry 3 12 12 1
959032 959032 107485 107485 CAS Common Chemistry 3 12 12 1
959033 959033 13803 13803 CAS Common Chemistry 3 12 12 1
959034 959034 69792 69792 CAS Common Chemistry 3 12 12 1
1159487 1159487 13802 13802 Computational Toxicology and Exposure Data 4 12 12 1
1159488 1159488 13803 13803 Computational Toxicology and Exposure Data 4 12 12 1
1159489 1159489 107485 107485 Computational Toxicology and Exposure Data 4 12 12 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)
);