home / zeropm-v0-0-4

api_results

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

17 rows where query_id = 74675

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
109286 109286 74675 74675 PubChem (compound) 1 2000 2000 1
109296 109296 74675 74675 PubChem (compound) 1 185820 185820 2
109300 109300 74675 74675 PubChem (compound) 1 14308 14308 3
109301 109301 74675 74675 PubChem (compound) 1 207853 207853 4
304006 304006 74675 74675 PubChem (substance) 2 11682 11682 8
413745 413745 74675 74675 PubChem (substance) 2 83226 83226 7
450016 450016 74675 74675 PubChem (substance) 2 2000 2000 1
450028 450028 74675 74675 PubChem (substance) 2 193067 193067 6
450035 450035 74675 74675 PubChem (substance) 2 185820 185820 2
450041 450041 74675 74675 PubChem (substance) 2 14308 14308 3
450048 450048 74675 74675 PubChem (substance) 2 207853 207853 9
758465 758465 74675 74675 PubChem (substance) 2 258418 258418 4
758467 758467 74675 74675 PubChem (substance) 2 262202 262202 5
1018219 1018219 74675 74675 CAS Common Chemistry 3 2000 2000 1
1018227 1018227 74675 74675 CAS Common Chemistry 3 14308 14308 2
1220586 1220586 74675 74675 Computational Toxicology and Exposure Data 4 2000 2000 1
1220593 1220593 74675 74675 Computational Toxicology and Exposure Data 4 14308 14308 2
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 445.226ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website