api_results

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

12 rows where query_id = 20734

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
361154 361154 20734 20734 PubChem (substance) 2 103570 103570 2
361162 361162 20734 20734 PubChem (substance) 2 103570 103570 4
361167 361167 20734 20734 PubChem (substance) 2 53041 53041 1
361176 361176 20734 20734 PubChem (substance) 2 314160 314160 9
361181 361181 20734 20734 PubChem (substance) 2 317478 317478 11
361187 361187 20734 20734 PubChem (substance) 2 103570 103570 10
645116 645116 20734 20734 PubChem (substance) 2 313847 313847 5
720315 720315 20734 20734 PubChem (substance) 2 315061 315061 3
720324 720324 20734 20734 PubChem (substance) 2 315866 315866 8
720328 720328 20734 20734 PubChem (substance) 2 315867 315867 6
720335 720335 20734 20734 PubChem (substance) 2 316308 316308 7
720347 720347 20734 20734 PubChem (substance) 2 317664 317664 12 
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)
);