api_results

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

12 rows where query_id = 376708

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
270191 270191 376708 376708 PubChem (compound) 1 278917 278917 1
270192 270192 376708 376708 PubChem (compound) 1 321388 321388 2
270193 270193 376708 376708 PubChem (compound) 1 323091 323091 3
270194 270194 376708 376708 PubChem (compound) 1 204676 204676 4
270195 270195 376708 376708 PubChem (compound) 1 295317 295317 5
442497 442497 376708 376708 PubChem (substance) 2 218038 218038 3
660045 660045 376708 376708 PubChem (substance) 2 278917 278917 1
660046 660046 376708 376708 PubChem (substance) 2 321388 321388 2
660047 660047 376708 376708 PubChem (substance) 2 323091 323091 6
660048 660048 376708 376708 PubChem (substance) 2 204676 204676 7
660049 660049 376708 376708 PubChem (substance) 2 295317 295317 4
920248 920248 376708 376708 PubChem (substance) 2 297231 297231 5 
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)
);