home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 120641

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
140532 140532 120641 120641 PubChem (compound) 1 91393 91393 1
140536 140536 120641 120641 PubChem (compound) 1 7281 7281 2
140539 140539 120641 120641 PubChem (compound) 1 91393 91393 3
140541 140541 120641 120641 PubChem (compound) 1 233046 233046 4
140544 140544 120641 120641 PubChem (compound) 1 91393 91393 5
442251 442251 120641 120641 PubChem (substance) 2 162943 162943 10
492804 492804 120641 120641 PubChem (substance) 2 91393 91393 1
492808 492808 120641 120641 PubChem (substance) 2 7281 7281 3
492811 492811 120641 120641 PubChem (substance) 2 91393 91393 4
492813 492813 120641 120641 PubChem (substance) 2 233046 233046 6
492816 492816 120641 120641 PubChem (substance) 2 91393 91393 8
785364 785364 120641 120641 PubChem (substance) 2 210635 210635 2
785367 785367 120641 120641 PubChem (substance) 2 220929 220929 5
785371 785371 120641 120641 PubChem (substance) 2 217326 217326 7
785372 785372 120641 120641 PubChem (substance) 2 227309 227309 9
785374 785374 120641 120641 PubChem (substance) 2 310680 310680 11
785375 785375 120641 120641 PubChem (substance) 2 297903 297903 12
785377 785377 120641 120641 PubChem (substance) 2 308344 308344 13
785378 785378 120641 120641 PubChem (substance) 2 285852 285852 14
785380 785380 120641 120641 PubChem (substance) 2 183190 183190 15
1040564 1040564 120641 120641 CAS Common Chemistry 3 91393 91393 1
1243548 1243548 120641 120641 Computational Toxicology and Exposure Data 4 91393 91393 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 491.164ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website