home / zeropm-v0-0-4

api_results

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

20 rows where inchi_id = 27619

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
115569 115569 87198 87198 PubChem (compound) 1 27619 27619 1
115570 115570 87200 87200 PubChem (compound) 1 27619 27619 1
458746 458746 87198 87198 PubChem (substance) 2 27619 27619 1
458747 458747 333658 333658 PubChem (substance) 2 27619 27619 3
458748 458748 21201 21201 PubChem (substance) 2 27619 27619 4
458749 458749 21202 21202 PubChem (substance) 2 27619 27619 2
458750 458750 294581 294581 PubChem (substance) 2 27619 27619 4
458751 458751 165609 165609 PubChem (substance) 2 27619 27619 1
458752 458752 313196 313196 PubChem (substance) 2 27619 27619 1
458753 458753 87200 87200 PubChem (substance) 2 27619 27619 1
458754 458754 336063 336063 PubChem (substance) 2 27619 27619 1
458755 458755 125215 125215 PubChem (substance) 2 27619 27619 2
458756 458756 96136 96136 PubChem (substance) 2 27619 27619 3
1022602 1022602 87198 87198 CAS Common Chemistry 3 27619 27619 1
1022603 1022603 336063 336063 CAS Common Chemistry 3 27619 27619 1
1022604 1022604 417740 417740 CAS Common Chemistry 3 27619 27619 1
1022605 1022605 87200 87200 CAS Common Chemistry 3 27619 27619 2
1224985 1224985 87198 87198 Computational Toxicology and Exposure Data 4 27619 27619 1
1224986 1224986 87200 87200 Computational Toxicology and Exposure Data 4 27619 27619 1
1224987 1224987 417740 417740 Computational Toxicology and Exposure Data 4 27619 27619 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 787.62ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website