api_results

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

11 rows where query_id = 115844

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
135329 135329 115844 115844 PubChem (compound) 1 55227 55227 1
486023 486023 115844 115844 PubChem (substance) 2 55227 55227 1
782064 782064 115844 115844 PubChem (substance) 2 166580 166580 2
782067 782067 115844 115844 PubChem (substance) 2 141095 141095 3
782070 782070 115844 115844 PubChem (substance) 2 261993 261993 4
782072 782072 115844 115844 PubChem (substance) 2 277415 277415 5
782073 782073 115844 115844 PubChem (substance) 2 160100 160100 6
782074 782074 115844 115844 PubChem (substance) 2 309885 309885 7
782077 782077 115844 115844 PubChem (substance) 2 211048 211048 8
1036483 1036483 115844 115844 CAS Common Chemistry 3 55227 55227 1
1239445 1239445 115844 115844 Computational Toxicology and Exposure Data 4 55227 55227 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)
);