api_results

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

13 rows where query_id = 61965

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102214 102214 61965 61965 PubChem (compound) 1 26761 26761 1
440388 440388 61965 61965 PubChem (substance) 2 26761 26761 1
650126 650126 61965 61965 PubChem (substance) 2 189210 189210 7
752256 752256 61965 61965 PubChem (substance) 2 136821 136821 2
752258 752258 61965 61965 PubChem (substance) 2 192011 192011 3
752260 752260 61965 61965 PubChem (substance) 2 233891 233891 4
752262 752262 61965 61965 PubChem (substance) 2 234060 234060 5
752264 752264 61965 61965 PubChem (substance) 2 264404 264404 6
752266 752266 61965 61965 PubChem (substance) 2 199445 199445 8
752267 752267 61965 61965 PubChem (substance) 2 199780 199780 9
752269 752269 61965 61965 PubChem (substance) 2 308565 308565 10
1013422 1013422 61965 61965 CAS Common Chemistry 3 26761 26761 1
1215556 1215556 61965 61965 Computational Toxicology and Exposure Data 4 26761 26761 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)
);