home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 133572

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
153636 153636 133572 133572 PubChem (compound) 1 39072 39072 1
153639 153639 133572 133572 PubChem (compound) 1 211085 211085 2
153641 153641 133572 133572 PubChem (compound) 1 272682 272682 3
153643 153643 133572 133572 PubChem (compound) 1 326461 326461 4
153645 153645 133572 133572 PubChem (compound) 1 343745 343745 5
510011 510011 133572 133572 PubChem (substance) 2 39072 39072 1
510015 510015 133572 133572 PubChem (substance) 2 211085 211085 2
510018 510018 133572 133572 PubChem (substance) 2 272682 272682 3
510019 510019 133572 133572 PubChem (substance) 2 326461 326461 9
510022 510022 133572 133572 PubChem (substance) 2 343745 343745 11
749908 749908 133572 133572 PubChem (substance) 2 243355 243355 4
794273 794273 133572 133572 PubChem (substance) 2 261016 261016 5
794275 794275 133572 133572 PubChem (substance) 2 291118 291118 6
794276 794276 133572 133572 PubChem (substance) 2 295292 295292 7
794278 794278 133572 133572 PubChem (substance) 2 296529 296529 8
794279 794279 133572 133572 PubChem (substance) 2 238507 238507 10
794281 794281 133572 133572 PubChem (substance) 2 344167 344167 12
1050454 1050454 133572 133572 CAS Common Chemistry 3 39072 39072 1
1253218 1253218 133572 133572 Computational Toxicology and Exposure Data 4 39072 39072 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 1813.821ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website