api_results

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

13 rows where inchi_id = 20727

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
68535 68535 32991 32991 PubChem (compound) 1 20727 20727 1
68536 68536 160206 160206 PubChem (compound) 1 20727 20727 1
68537 68537 32992 32992 PubChem (compound) 1 20727 20727 1
393293 393293 32991 32991 PubChem (substance) 2 20727 20727 1
393294 393294 32992 32992 PubChem (substance) 2 20727 20727 1
393295 393295 371816 371816 PubChem (substance) 2 20727 20727 2
393296 393296 180427 180427 PubChem (substance) 2 20727 20727 2
393297 393297 105724 105724 PubChem (substance) 2 20727 20727 2
393298 393298 160206 160206 PubChem (substance) 2 20727 20727 1
393299 393299 344375 344375 PubChem (substance) 2 20727 20727 2
988774 988774 32991 32991 CAS Common Chemistry 3 20727 20727 1
988775 988775 32992 32992 CAS Common Chemistry 3 20727 20727 1
988776 988776 160206 160206 CAS Common Chemistry 3 20727 20727 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)
);