home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 105322

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22517 22517 105322 105322 PubChem (compound) 1 28012 28012 1
302343 302343 105322 105322 PubChem (substance) 2 45294 45294 14
322860 322860 105322 105322 PubChem (substance) 2 30575 30575 13
328060 328060 105322 105322 PubChem (substance) 2 28012 28012 1
371657 371657 105322 105322 PubChem (substance) 2 45272 45272 2
479459 479459 105322 105322 PubChem (substance) 2 36135 36135 4
708703 708703 105322 105322 PubChem (substance) 2 28012 28012 5
743714 743714 105322 105322 PubChem (substance) 2 149798 149798 10
773094 773094 105322 105322 PubChem (substance) 2 186023 186023 3
773097 773097 105322 105322 PubChem (substance) 2 186001 186001 6
773098 773098 105322 105322 PubChem (substance) 2 184624 184624 7
773101 773101 105322 105322 PubChem (substance) 2 241211 241211 8
773103 773103 105322 105322 PubChem (substance) 2 169504 169504 9
773105 773105 105322 105322 PubChem (substance) 2 241509 241509 11
773106 773106 105322 105322 PubChem (substance) 2 186023 186023 12
773108 773108 105322 105322 PubChem (substance) 2 151452 151452 15
954751 954751 105322 105322 CAS Common Chemistry 3 28012 28012 2
977400 977400 105322 105322 CAS Common Chemistry 3 45272 45272 1
1154474 1154474 105322 105322 Computational Toxicology and Exposure Data 4 28012 28012 2
1180239 1180239 105322 105322 Computational Toxicology and Exposure Data 4 95219 95219 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 460.416ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website