home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 105332

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102163 102163 105332 105332 PubChem (compound) 1 69417 69417 1
440314 440314 105332 105332 PubChem (substance) 2 69417 69417 1
440319 440319 105332 105332 PubChem (substance) 2 219299 219299 4
482983 482983 105332 105332 PubChem (substance) 2 47125 47125 21
653515 653515 105332 105332 PubChem (substance) 2 258113 258113 19
752076 752076 105332 105332 PubChem (substance) 2 137192 137192 2
752080 752080 105332 105332 PubChem (substance) 2 146138 146138 20
752083 752083 105332 105332 PubChem (substance) 2 189132 189132 3
752085 752085 105332 105332 PubChem (substance) 2 214415 214415 7
752088 752088 105332 105332 PubChem (substance) 2 237592 237592 18
752092 752092 105332 105332 PubChem (substance) 2 290485 290485 22
752094 752094 105332 105332 PubChem (substance) 2 197944 197944 5
752097 752097 105332 105332 PubChem (substance) 2 326601 326601 23
773114 773114 105332 105332 PubChem (substance) 2 291619 291619 6
773115 773115 105332 105332 PubChem (substance) 2 232111 232111 8
773116 773116 105332 105332 PubChem (substance) 2 197724 197724 9
773118 773118 105332 105332 PubChem (substance) 2 164857 164857 10
773119 773119 105332 105332 PubChem (substance) 2 192442 192442 11
773120 773120 105332 105332 PubChem (substance) 2 197943 197943 12
773121 773121 105332 105332 PubChem (substance) 2 206873 206873 13
773122 773122 105332 105332 PubChem (substance) 2 206874 206874 14
773123 773123 105332 105332 PubChem (substance) 2 176433 176433 15
773124 773124 105332 105332 PubChem (substance) 2 176200 176200 16
773125 773125 105332 105332 PubChem (substance) 2 140367 140367 17
1013400 1013400 105332 105332 CAS Common Chemistry 3 69417 69417 1
1215521 1215521 105332 105332 Computational Toxicology and Exposure Data 4 69417 69417 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 429.853ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website