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 = 104696

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124632 124632 104696 104696 PubChem (compound) 1 48071 48071 1
440307 440307 104696 104696 PubChem (substance) 2 45278 45278 4
471209 471209 104696 104696 PubChem (substance) 2 45289 45289 13
471520 471520 104696 104696 PubChem (substance) 2 48069 48069 16
471525 471525 104696 104696 PubChem (substance) 2 48071 48071 1
771425 771425 104696 104696 PubChem (substance) 2 171126 171126 2
771428 771428 104696 104696 PubChem (substance) 2 195627 195627 3
771430 771430 104696 104696 PubChem (substance) 2 173871 173871 14
771432 771432 104696 104696 PubChem (substance) 2 277347 277347 5
771433 771433 104696 104696 PubChem (substance) 2 290474 290474 17
771435 771435 104696 104696 PubChem (substance) 2 326517 326517 18
771437 771437 104696 104696 PubChem (substance) 2 180084 180084 6
771438 771438 104696 104696 PubChem (substance) 2 206727 206727 7
771439 771439 104696 104696 PubChem (substance) 2 206728 206728 8
771440 771440 104696 104696 PubChem (substance) 2 206729 206729 9
771441 771441 104696 104696 PubChem (substance) 2 195284 195284 10
771442 771442 104696 104696 PubChem (substance) 2 176260 176260 11
771443 771443 104696 104696 PubChem (substance) 2 188242 188242 12
771444 771444 104696 104696 PubChem (substance) 2 137605 137605 15
771445 771445 104696 104696 PubChem (substance) 2 233268 233268 19
1028471 1028471 104696 104696 CAS Common Chemistry 3 48071 48071 1
1231276 1231276 104696 104696 Computational Toxicology and Exposure Data 4 48071 48071 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 1147.347ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website