api_results

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

13 rows where inchi_id = 46393

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
197807 197807 179436 179436 PubChem (compound) 1 46393 46393 1
197808 197808 179437 179437 PubChem (compound) 1 46393 46393 1
197809 197809 420539 420539 PubChem (compound) 1 46393 46393 1
567835 567835 420539 420539 PubChem (substance) 2 46393 46393 1
567836 567836 16700 16700 PubChem (substance) 2 46393 46393 4
567837 567837 2393 2393 PubChem (substance) 2 46393 46393 4
567838 567838 179436 179436 PubChem (substance) 2 46393 46393 1
567839 567839 179437 179437 PubChem (substance) 2 46393 46393 1
1082414 1082414 420539 420539 CAS Common Chemistry 3 46393 46393 1
1082415 1082415 179436 179436 CAS Common Chemistry 3 46393 46393 1
1283995 1283995 179437 179437 Computational Toxicology and Exposure Data 4 46393 46393 1
1283996 1283996 179436 179436 Computational Toxicology and Exposure Data 4 46393 46393 1
1283997 1283997 420539 420539 Computational Toxicology and Exposure Data 4 46393 46393 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)
);