api_results

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

18 rows where inchi_id = 170845

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
693214 693214 631 631 PubChem (substance) 2 170845 170845 3
693215 693215 330821 330821 PubChem (substance) 2 170845 170845 4
693216 693216 351478 351478 PubChem (substance) 2 170845 170845 4
693217 693217 97194 97194 PubChem (substance) 2 170845 170845 2
693218 693218 637 637 PubChem (substance) 2 170845 170845 2
693219 693219 632 632 PubChem (substance) 2 170845 170845 3
693220 693220 633 633 PubChem (substance) 2 170845 170845 1
693221 693221 103942 103942 PubChem (substance) 2 170845 170845 1
693222 693222 638 638 PubChem (substance) 2 170845 170845 3
693223 693223 351479 351479 PubChem (substance) 2 170845 170845 3
693224 693224 103946 103946 PubChem (substance) 2 170845 170845 2
693225 693225 351481 351481 PubChem (substance) 2 170845 170845 2
693226 693226 91817 91817 PubChem (substance) 2 170845 170845 3
693227 693227 351011 351011 PubChem (substance) 2 170845 170845 2
693228 693228 634 634 PubChem (substance) 2 170845 170845 3
693229 693229 351482 351482 PubChem (substance) 2 170845 170845 1
693230 693230 103943 103943 PubChem (substance) 2 170845 170845 3
693231 693231 91815 91815 PubChem (substance) 2 170845 170845 2 
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)
);