api_results

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

15 rows where inchi_id = 331

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
285392 285392 413136 413136 PubChem (compound) 1 331 331 1
679458 679458 27335 27335 PubChem (substance) 2 331 331 2
679459 679459 240229 240229 PubChem (substance) 2 331 331 2
679460 679460 3651 3651 PubChem (substance) 2 331 331 2
679461 679461 3648 3648 PubChem (substance) 2 331 331 2
679462 679462 305831 305831 PubChem (substance) 2 331 331 4
679463 679463 302021 302021 PubChem (substance) 2 331 331 2
679464 679464 84964 84964 PubChem (substance) 2 331 331 2
679465 679465 413136 413136 PubChem (substance) 2 331 331 1
943231 943231 31843 31843 CAS Common Chemistry 3 331 331 1
943232 943232 31844 31844 CAS Common Chemistry 3 331 331 1
943233 943233 3652 3652 CAS Common Chemistry 3 331 331 1
1114039 1114039 440880 440880 CAS Common Chemistry 3 331 331 1
1114040 1114040 319953 319953 CAS Common Chemistry 3 331 331 1
1114041 1114041 319954 319954 CAS Common Chemistry 3 331 331 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)
);