api_results

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

10 rows where inchi_id = 38112

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
153245 153245 133186 133186 PubChem (compound) 1 38112 38112 1
153246 153246 133185 133185 PubChem (compound) 1 38112 38112 1
153247 153247 133443 133443 PubChem (compound) 1 38112 38112 1
153248 153248 133444 133444 PubChem (compound) 1 38112 38112 1
509507 509507 133444 133444 PubChem (substance) 2 38112 38112 1
509508 509508 310273 310273 PubChem (substance) 2 38112 38112 3
509509 509509 133185 133185 PubChem (substance) 2 38112 38112 1
509510 509510 133443 133443 PubChem (substance) 2 38112 38112 1
509511 509511 133186 133186 PubChem (substance) 2 38112 38112 1
1050172 1050172 133185 133185 CAS Common Chemistry 3 38112 38112 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)
);