api_results

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

18 rows where query_id = 369909

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22573 22573 369909 369909 PubChem (compound) 1 72372 72372 1
326310 326310 369909 369909 PubChem (substance) 2 27582 27582 15
328145 328145 369909 369909 PubChem (substance) 2 72372 72372 1
505605 505605 369909 369909 PubChem (substance) 2 23515 23515 2
703583 703583 369909 369909 PubChem (substance) 2 75635 75635 14
708754 708754 369909 369909 PubChem (substance) 2 168498 168498 3
767909 767909 369909 369909 PubChem (substance) 2 231239 231239 4
767912 767912 369909 369909 PubChem (substance) 2 203683 203683 5
767914 767914 369909 369909 PubChem (substance) 2 202190 202190 6
767916 767916 369909 369909 PubChem (substance) 2 149533 149533 7
767917 767917 369909 369909 PubChem (substance) 2 202892 202892 8
767919 767919 369909 369909 PubChem (substance) 2 204218 204218 9
767921 767921 369909 369909 PubChem (substance) 2 204920 204920 10
767924 767924 369909 369909 PubChem (substance) 2 204357 204357 11
767926 767926 369909 369909 PubChem (substance) 2 203255 203255 12
767928 767928 369909 369909 PubChem (substance) 2 202073 202073 13
954795 954795 369909 369909 CAS Common Chemistry 3 72372 72372 1
1154545 1154545 369909 369909 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)
);