api_results

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

9 rows where query_id = 63128

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
103448 103448 63128 63128 PubChem (compound) 1 148211 148211 1
442263 442263 63128 63128 PubChem (substance) 2 148211 148211 1
493039 493039 63128 63128 PubChem (substance) 2 301 301 4
736223 736223 63128 63128 PubChem (substance) 2 172314 172314 5
753709 753709 63128 63128 PubChem (substance) 2 184155 184155 2
753710 753710 63128 63128 PubChem (substance) 2 236988 236988 3
753711 753711 63128 63128 PubChem (substance) 2 233349 233349 6
753712 753712 63128 63128 PubChem (substance) 2 234885 234885 7
753713 753713 63128 63128 PubChem (substance) 2 250982 250982 8 
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)
);