api_results

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

9 rows where query_id = 163760

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99472 99472 163760 163760 PubChem (compound) 1 142782 142782 1
436359 436359 163760 163760 PubChem (substance) 2 142782 142782 1
814102 814102 163760 163760 PubChem (substance) 2 263807 263807 2
814103 814103 163760 163760 PubChem (substance) 2 289589 289589 3
814104 814104 163760 163760 PubChem (substance) 2 210802 210802 4
814105 814105 163760 163760 PubChem (substance) 2 314337 314337 5
814106 814106 163760 163760 PubChem (substance) 2 25159 25159 6
1072491 1072491 163760 163760 CAS Common Chemistry 3 25159 25159 1
1273839 1273839 163760 163760 Computational Toxicology and Exposure Data 4 126815 126815 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)
);