api_results

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

13 rows where query_id = 56362

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
95514 95514 56362 56362 PubChem (compound) 1 50834 50834 1
430586 430586 56362 56362 PubChem (substance) 2 50834 50834 1
459955 459955 56362 56362 PubChem (substance) 2 54033 54033 10
651283 651283 56362 56362 PubChem (substance) 2 114915 114915 8
652142 652142 56362 56362 PubChem (substance) 2 137216 137216 2
746705 746705 56362 56362 PubChem (substance) 2 138920 138920 3
746708 746708 56362 56362 PubChem (substance) 2 50834 50834 4
746713 746713 56362 56362 PubChem (substance) 2 137216 137216 5
746714 746714 56362 56362 PubChem (substance) 2 168739 168739 6
746717 746717 56362 56362 PubChem (substance) 2 228952 228952 7
746719 746719 56362 56362 PubChem (substance) 2 174651 174651 9
1008900 1008900 56362 56362 CAS Common Chemistry 3 50834 50834 1
1210923 1210923 56362 56362 Computational Toxicology and Exposure Data 4 50834 50834 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)
);