home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 104694

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124627 124627 104694 104694 PubChem (compound) 1 48069 48069 1
315556 315556 104694 104694 PubChem (substance) 2 73697 73697 16
440350 440350 104694 104694 PubChem (substance) 2 45291 45291 6
471518 471518 104694 104694 PubChem (substance) 2 48069 48069 1
651840 651840 104694 104694 PubChem (substance) 2 137375 137375 13
771398 771398 104694 104694 PubChem (substance) 2 189152 189152 3
771400 771400 104694 104694 PubChem (substance) 2 137378 137378 2
771404 771404 104694 104694 PubChem (substance) 2 173330 173330 5
771408 771408 104694 104694 PubChem (substance) 2 234161 234161 15
771409 771409 104694 104694 PubChem (substance) 2 190414 190414 17
771411 771411 104694 104694 PubChem (substance) 2 180085 180085 4
771416 771416 104694 104694 PubChem (substance) 2 186041 186041 7
771417 771417 104694 104694 PubChem (substance) 2 219161 219161 8
771418 771418 104694 104694 PubChem (substance) 2 176506 176506 9
771419 771419 104694 104694 PubChem (substance) 2 207031 207031 10
771420 771420 104694 104694 PubChem (substance) 2 195362 195362 11
771421 771421 104694 104694 PubChem (substance) 2 176203 176203 12
771422 771422 104694 104694 PubChem (substance) 2 284043 284043 14
771423 771423 104694 104694 PubChem (substance) 2 291621 291621 18
1028467 1028467 104694 104694 CAS Common Chemistry 3 48069 48069 1
1231275 1231275 104694 104694 Computational Toxicology and Exposure Data 4 48069 48069 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)
);
Powered by Datasette · Queries took 478.406ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website