home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 9871

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
18716 18716 9871 9871 PubChem (compound) 1 7812 7812 1
322104 322104 9871 9871 PubChem (substance) 2 7812 7812 1
322115 322115 9871 9871 PubChem (substance) 2 7814 7814 5
322126 322126 9871 9871 PubChem (substance) 2 136466 136466 6
322174 322174 9871 9871 PubChem (substance) 2 56289 56289 9
456931 456931 9871 9871 PubChem (substance) 2 137782 137782 11
498286 498286 9871 9871 PubChem (substance) 2 16385 16385 3
677336 677336 9871 9871 PubChem (substance) 2 195790 195790 2
705234 705234 9871 9871 PubChem (substance) 2 137781 137781 4
705236 705236 9871 9871 PubChem (substance) 2 273967 273967 7
705238 705238 9871 9871 PubChem (substance) 2 276015 276015 8
705241 705241 9871 9871 PubChem (substance) 2 248990 248990 10
705242 705242 9871 9871 PubChem (substance) 2 289582 289582 12
705244 705244 9871 9871 PubChem (substance) 2 309841 309841 13
705245 705245 9871 9871 PubChem (substance) 2 137781 137781 14
705248 705248 9871 9871 PubChem (substance) 2 323193 323193 15
952146 952146 9871 9871 CAS Common Chemistry 3 7812 7812 1
1151357 1151357 9871 9871 Computational Toxicology and Exposure Data 4 7812 7812 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 469.469ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website