api_results

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

10 rows where query_id = 335818

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
644563 644563 335818 335818 PubChem (substance) 2 26246 26246 3
644565 644565 335818 335818 PubChem (substance) 2 139420 139420 1
644568 644568 335818 335818 PubChem (substance) 2 201636 201636 4
644572 644572 335818 335818 PubChem (substance) 2 168053 168053 2
644575 644575 335818 335818 PubChem (substance) 2 237606 237606 6
644577 644577 335818 335818 PubChem (substance) 2 238947 238947 7
644579 644579 335818 335818 PubChem (substance) 2 241947 241947 8
847691 847691 335818 335818 PubChem (substance) 2 243366 243366 9
847692 847692 335818 335818 PubChem (substance) 2 216842 216842 5
847697 847697 335818 335818 PubChem (substance) 2 260113 260113 10 
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)
);