api_results

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

13 rows where inchi_id = 287

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
43388 43388 19463 19463 PubChem (compound) 1 287 287 1
43389 43389 19462 19462 PubChem (compound) 1 287 287 1
43390 43390 346454 346454 PubChem (compound) 1 287 287 1
43391 43391 120786 120786 PubChem (compound) 1 287 287 1
357329 357329 19463 19463 PubChem (substance) 2 287 287 1
357330 357330 120786 120786 PubChem (substance) 2 287 287 1
357331 357331 19462 19462 PubChem (substance) 2 287 287 1
357332 357332 346454 346454 PubChem (substance) 2 287 287 1
969914 969914 19462 19462 CAS Common Chemistry 3 287 287 1
969915 969915 19463 19463 CAS Common Chemistry 3 287 287 1
969916 969916 346454 346454 CAS Common Chemistry 3 287 287 1
1172148 1172148 19462 19462 Computational Toxicology and Exposure Data 4 287 287 1
1172149 1172149 19463 19463 Computational Toxicology and Exposure Data 4 287 287 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)
);