api_results

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

10 rows where query_id = 340274

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124895 124895 340274 340274 PubChem (compound) 1 248548 248548 1
264979 264979 340274 340274 PubChem (compound) 1 249079 249079 2
264980 264980 340274 340274 PubChem (compound) 1 248567 248567 3
471942 471942 340274 340274 PubChem (substance) 2 248548 248548 1
492837 492837 340274 340274 PubChem (substance) 2 248910 248910 5
652363 652363 340274 340274 PubChem (substance) 2 249079 249079 2
652371 652371 340274 340274 PubChem (substance) 2 248567 248567 4
771947 771947 340274 340274 PubChem (substance) 2 238970 238970 3
771950 771950 340274 340274 PubChem (substance) 2 251029 251029 6
771953 771953 340274 340274 PubChem (substance) 2 233467 233467 7 
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)
);