api_results

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

11 rows where query_id = 68264

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
704459 704459 68264 68264 PubChem (substance) 2 137235 137235 5
755583 755583 68264 68264 PubChem (substance) 2 207593 207593 1
755584 755584 68264 68264 PubChem (substance) 2 315203 315203 2
755585 755585 68264 68264 PubChem (substance) 2 332361 332361 3
755586 755586 68264 68264 PubChem (substance) 2 308678 308678 4
755587 755587 68264 68264 PubChem (substance) 2 207593 207593 6
755588 755588 68264 68264 PubChem (substance) 2 315203 315203 7
755589 755589 68264 68264 PubChem (substance) 2 317811 317811 8
755590 755590 68264 68264 PubChem (substance) 2 331453 331453 9
755591 755591 68264 68264 PubChem (substance) 2 331630 331630 10
1015815 1015815 68264 68264 CAS Common Chemistry 3 37881 37881 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)
);