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 = 47895

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
105407 105407 115088 115088 PubChem (compound) 1 47895 47895 1
105408 105408 437834 437834 PubChem (compound) 1 47895 47895 1
105409 105409 87921 87921 PubChem (compound) 1 47895 47895 1
105410 105410 67516 67516 PubChem (compound) 1 47895 47895 1
105411 105411 67517 67517 PubChem (compound) 1 47895 47895 1
105412 105412 399756 399756 PubChem (compound) 1 47895 47895 1
444869 444869 115088 115088 PubChem (substance) 2 47895 47895 2
444870 444870 87920 87920 PubChem (substance) 2 47895 47895 4
444871 444871 87921 87921 PubChem (substance) 2 47895 47895 2
444872 444872 67517 67517 PubChem (substance) 2 47895 47895 1
444873 444873 437834 437834 PubChem (substance) 2 47895 47895 1
444874 444874 143061 143061 PubChem (substance) 2 47895 47895 2
444875 444875 67516 67516 PubChem (substance) 2 47895 47895 1
444876 444876 399756 399756 PubChem (substance) 2 47895 47895 1
1015585 1015585 67516 67516 CAS Common Chemistry 3 47895 47895 1
1015586 1015586 437834 437834 CAS Common Chemistry 3 47895 47895 1
1015587 1015587 67517 67517 CAS Common Chemistry 3 47895 47895 1
1217741 1217741 67516 67516 Computational Toxicology and Exposure Data 4 47895 47895 1
1217742 1217742 67517 67517 Computational Toxicology and Exposure Data 4 47895 47895 1
1217743 1217743 437834 437834 Computational Toxicology and Exposure Data 4 47895 47895 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 753.903ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website