home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 301852

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
296990 296990 301852 301852 PubChem (substance) 2 6831 6831 1
313189 313189 301852 301852 PubChem (substance) 2 27891 27891 2
313651 313651 301852 301852 PubChem (substance) 2 7655 7655 15
429046 429046 301852 301852 PubChem (substance) 2 9853 9853 12
474561 474561 301852 301852 PubChem (substance) 2 87546 87546 13
513687 513687 301852 301852 PubChem (substance) 2 44395 44395 7
517767 517767 301852 301852 PubChem (substance) 2 53424 53424 3
525949 525949 301852 301852 PubChem (substance) 2 210506 210506 9
675256 675256 301852 301852 PubChem (substance) 2 210507 210507 10
815155 815155 301852 301852 PubChem (substance) 2 148373 148373 5
846007 846007 301852 301852 PubChem (substance) 2 150096 150096 4
846008 846008 301852 301852 PubChem (substance) 2 141057 141057 6
846009 846009 301852 301852 PubChem (substance) 2 215601 215601 8
846010 846010 301852 301852 PubChem (substance) 2 228745 228745 11
846011 846011 301852 301852 PubChem (substance) 2 273255 273255 14
947368 947368 301852 301852 CAS Common Chemistry 3 27891 27891 1
1021524 1021524 301852 301852 CAS Common Chemistry 3 75058 75058 3
1052624 1052624 301852 301852 CAS Common Chemistry 3 44395 44395 2
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 433.192ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website