home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 339551

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102207 102207 339551 339551 PubChem (compound) 1 48079 48079 1
440356 440356 339551 339551 PubChem (substance) 2 45291 45291 7
440377 440377 339551 339551 PubChem (substance) 2 48079 48079 1
473359 473359 339551 339551 PubChem (substance) 2 78291 78291 20
651944 651944 339551 339551 PubChem (substance) 2 172788 172788 2
691140 691140 339551 339551 PubChem (substance) 2 24588 24588 8
752184 752184 339551 339551 PubChem (substance) 2 218231 218231 5
752186 752186 339551 339551 PubChem (substance) 2 227307 227307 4
752188 752188 339551 339551 PubChem (substance) 2 239165 239165 6
752191 752191 339551 339551 PubChem (substance) 2 219361 219361 9
752195 752195 339551 339551 PubChem (substance) 2 241349 241349 3
752200 752200 339551 339551 PubChem (substance) 2 288696 288696 18
752203 752203 339551 339551 PubChem (substance) 2 291116 291116 19
752206 752206 339551 339551 PubChem (substance) 2 247640 247640 21
752208 752208 339551 339551 PubChem (substance) 2 326520 326520 22
912403 912403 339551 339551 PubChem (substance) 2 232149 232149 10
912405 912405 339551 339551 PubChem (substance) 2 161571 161571 11
912406 912406 339551 339551 PubChem (substance) 2 206852 206852 12
912407 912407 339551 339551 PubChem (substance) 2 206853 206853 13
912408 912408 339551 339551 PubChem (substance) 2 206854 206854 14
912409 912409 339551 339551 PubChem (substance) 2 176254 176254 15
912410 912410 339551 339551 PubChem (substance) 2 210945 210945 16
912411 912411 339551 339551 PubChem (substance) 2 287460 287460 17
1013416 1013416 339551 339551 CAS Common Chemistry 3 48079 48079 1
1215549 1215549 339551 339551 Computational Toxicology and Exposure Data 4 48079 48079 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 430.792ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website