home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 171501

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
190186 190186 171501 171501 PubChem (compound) 1 280172 280172 1
190187 190187 171501 171501 PubChem (compound) 1 314564 314564 2
190188 190188 171501 171501 PubChem (compound) 1 34662 34662 3
190189 190189 171501 171501 PubChem (compound) 1 280172 280172 4
558140 558140 171501 171501 PubChem (substance) 2 280172 280172 1
558141 558141 171501 171501 PubChem (substance) 2 314564 314564 3
558142 558142 171501 171501 PubChem (substance) 2 34662 34662 4
558144 558144 171501 171501 PubChem (substance) 2 280172 280172 8
558145 558145 171501 171501 PubChem (substance) 2 104753 104753 2
818527 818527 171501 171501 PubChem (substance) 2 274908 274908 5
818528 818528 171501 171501 PubChem (substance) 2 318003 318003 6
818529 818529 171501 171501 PubChem (substance) 2 274908 274908 7
818530 818530 171501 171501 PubChem (substance) 2 318116 318116 9
818531 818531 171501 171501 PubChem (substance) 2 318212 318212 10
818532 818532 171501 171501 PubChem (substance) 2 238412 238412 11
818533 818533 171501 171501 PubChem (substance) 2 104753 104753 12
818534 818534 171501 171501 PubChem (substance) 2 326434 326434 13
818535 818535 171501 171501 PubChem (substance) 2 238412 238412 14
1077170 1077170 171501 171501 CAS Common Chemistry 3 34662 34662 1
1278591 1278591 171501 171501 Computational Toxicology and Exposure Data 4 104753 104753 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 1373.746ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website