home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 40952

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
56325 56325 40952 40952 PubChem (compound) 1 54960 54960 1
56334 56334 40952 40952 PubChem (compound) 1 171178 171178 2
79957 79957 40952 40952 PubChem (compound) 1 105378 105378 3
79958 79958 40952 40952 PubChem (compound) 1 291093 291093 4
79959 79959 40952 40952 PubChem (compound) 1 308063 308063 5
79960 79960 40952 40952 PubChem (compound) 1 340492 340492 6
375364 375364 40952 40952 PubChem (substance) 2 54960 54960 1
375372 375372 40952 40952 PubChem (substance) 2 171178 171178 3
409001 409001 40952 40952 PubChem (substance) 2 105378 105378 5
409008 409008 40952 40952 PubChem (substance) 2 291093 291093 6
409009 409009 40952 40952 PubChem (substance) 2 308063 308063 12
409010 409010 40952 40952 PubChem (substance) 2 340492 340492 14
442111 442111 40952 40952 PubChem (substance) 2 12546 12546 4
442288 442288 40952 40952 PubChem (substance) 2 54700 54700 10
708167 708167 40952 40952 PubChem (substance) 2 235027 235027 13
725090 725090 40952 40952 PubChem (substance) 2 60419 60419 2
725094 725094 40952 40952 PubChem (substance) 2 287134 287134 11
738474 738474 40952 40952 PubChem (substance) 2 207033 207033 7
738476 738476 40952 40952 PubChem (substance) 2 166953 166953 8
738477 738477 40952 40952 PubChem (substance) 2 264564 264564 9
996677 996677 40952 40952 CAS Common Chemistry 3 60419 60419 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 443.813ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website