api_results

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

14 rows where query_id = 372268

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
371200 371200 372268 372268 PubChem (substance) 2 135923 135923 2
439855 439855 372268 372268 PubChem (substance) 2 141977 141977 3
568280 568280 372268 372268 PubChem (substance) 2 100386 100386 5
572548 572548 372268 372268 PubChem (substance) 2 127076 127076 9
596616 596616 372268 372268 PubChem (substance) 2 182182 182182 8
833112 833112 372268 372268 PubChem (substance) 2 223367 223367 4
833115 833115 372268 372268 PubChem (substance) 2 100386 100386 6
915740 915740 372268 372268 PubChem (substance) 2 141366 141366 1
915741 915741 372268 372268 PubChem (substance) 2 230997 230997 7
977122 977122 372268 372268 CAS Common Chemistry 3 44074 44074 2
1013158 1013158 372268 372268 CAS Common Chemistry 3 880 880 1
1082640 1082640 372268 372268 CAS Common Chemistry 3 46818 46818 3
1084948 1084948 372268 372268 CAS Common Chemistry 3 51289 51289 4
1097456 1097456 372268 372268 CAS Common Chemistry 3 77581 77581 5 
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)
);