api_results

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

15 rows where inchi_id = 3797

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
842116 842116 241299 241299 PubChem (substance) 2 3797 3797 3
842117 842117 241300 241300 PubChem (substance) 2 3797 3797 1
985243 985243 403847 403847 CAS Common Chemistry 3 3797 3797 1
985244 985244 30493 30493 CAS Common Chemistry 3 3797 3797 1
985245 985245 330997 330997 CAS Common Chemistry 3 3797 3797 1
985246 985246 97004 97004 CAS Common Chemistry 3 3797 3797 2
985247 985247 330998 330998 CAS Common Chemistry 3 3797 3797 1
985248 985248 351944 351944 CAS Common Chemistry 3 3797 3797 2
985249 985249 30494 30494 CAS Common Chemistry 3 3797 3797 1
985250 985250 243885 243885 CAS Common Chemistry 3 3797 3797 1
1025992 1025992 241300 241300 CAS Common Chemistry 3 3797 3797 1
1025993 1025993 351944 351944 CAS Common Chemistry 3 3797 3797 1
1025994 1025994 241299 241299 CAS Common Chemistry 3 3797 3797 1
1025995 1025995 97006 97006 CAS Common Chemistry 3 3797 3797 1
1025996 1025996 97004 97004 CAS Common Chemistry 3 3797 3797 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)
);