home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 201427

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
217880 217880 201427 201427 PubChem (compound) 1 72790 72790 1
217888 217888 201427 201427 PubChem (compound) 1 198913 198913 2
217891 217891 201427 201427 PubChem (compound) 1 229844 229844 3
217892 217892 201427 201427 PubChem (compound) 1 240089 240089 4
593710 593710 201427 201427 PubChem (substance) 2 72790 72790 1
593714 593714 201427 201427 PubChem (substance) 2 187250 187250 2
593717 593717 201427 201427 PubChem (substance) 2 136786 136786 18
593720 593720 201427 201427 PubChem (substance) 2 139997 139997 6
593723 593723 201427 201427 PubChem (substance) 2 198913 198913 4
593727 593727 201427 201427 PubChem (substance) 2 229844 229844 3
593729 593729 201427 201427 PubChem (substance) 2 240089 240089 8
659673 659673 201427 201427 PubChem (substance) 2 230650 230650 9
659680 659680 201427 201427 PubChem (substance) 2 187258 187258 5
659685 659685 201427 201427 PubChem (substance) 2 263130 263130 14
674623 674623 201427 201427 PubChem (substance) 2 207092 207092 7
785526 785526 201427 201427 PubChem (substance) 2 183267 183267 16
832157 832157 201427 201427 PubChem (substance) 2 266556 266556 15
832159 832159 201427 201427 PubChem (substance) 2 291601 291601 10
832160 832160 201427 201427 PubChem (substance) 2 291602 291602 11
832161 832161 201427 201427 PubChem (substance) 2 297476 297476 12
832162 832162 201427 201427 PubChem (substance) 2 210543 210543 13
832163 832163 201427 201427 PubChem (substance) 2 329663 329663 17
1095894 1095894 201427 201427 CAS Common Chemistry 3 72790 72790 1
1297816 1297816 201427 201427 Computational Toxicology and Exposure Data 4 72790 72790 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 657.741ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website