api_results

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

18 rows where query_id = 97510

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22571 22571 97510 97510 PubChem (compound) 1 72372 72372 1
326302 326302 97510 97510 PubChem (substance) 2 27582 27582 15
328140 328140 97510 97510 PubChem (substance) 2 72372 72372 1
505611 505611 97510 97510 PubChem (substance) 2 23515 23515 2
703579 703579 97510 97510 PubChem (substance) 2 75635 75635 14
708753 708753 97510 97510 PubChem (substance) 2 168498 168498 3
767908 767908 97510 97510 PubChem (substance) 2 231239 231239 4
767911 767911 97510 97510 PubChem (substance) 2 203683 203683 5
767913 767913 97510 97510 PubChem (substance) 2 202190 202190 6
767915 767915 97510 97510 PubChem (substance) 2 149533 149533 7
767918 767918 97510 97510 PubChem (substance) 2 202892 202892 8
767920 767920 97510 97510 PubChem (substance) 2 204218 204218 9
767922 767922 97510 97510 PubChem (substance) 2 204920 204920 10
767923 767923 97510 97510 PubChem (substance) 2 204357 204357 11
767925 767925 97510 97510 PubChem (substance) 2 203255 203255 12
767927 767927 97510 97510 PubChem (substance) 2 202073 202073 13
954797 954797 97510 97510 CAS Common Chemistry 3 72372 72372 1
1154542 1154542 97510 97510 Computational Toxicology and Exposure Data 4 72372 72372 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)
);