api_results

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

17 rows where query_id = 80733

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28230 28230 80733 80733 PubChem (compound) 1 91456 91456 1
335873 335873 80733 80733 PubChem (substance) 2 91456 91456 1
363758 363758 80733 80733 PubChem (substance) 2 22235 22235 2
363765 363765 80733 80733 PubChem (substance) 2 22236 22236 13
380385 380385 80733 80733 PubChem (substance) 2 74958 74958 7
448941 448941 80733 80733 PubChem (substance) 2 33290 33290 14
626677 626677 80733 80733 PubChem (substance) 2 18993 18993 8
711404 711404 80733 80733 PubChem (substance) 2 124341 124341 6
760748 760748 80733 80733 PubChem (substance) 2 208285 208285 3
760750 760750 80733 80733 PubChem (substance) 2 202197 202197 4
760753 760753 80733 80733 PubChem (substance) 2 202023 202023 5
760754 760754 80733 80733 PubChem (substance) 2 204167 204167 9
760757 760757 80733 80733 PubChem (substance) 2 202304 202304 10
760760 760760 80733 80733 PubChem (substance) 2 202305 202305 11
760761 760761 80733 80733 PubChem (substance) 2 202737 202737 12
958893 958893 80733 80733 CAS Common Chemistry 3 91456 91456 1
1159305 1159305 80733 80733 Computational Toxicology and Exposure Data 4 106237 106237 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)
);