home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 201426

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
217878 217878 201426 201426 PubChem (compound) 1 72790 72790 1
217881 217881 201426 201426 PubChem (compound) 1 187250 187250 2
217883 217883 201426 201426 PubChem (compound) 1 136786 136786 3
217884 217884 201426 201426 PubChem (compound) 1 189763 189763 4
217885 217885 201426 201426 PubChem (compound) 1 139997 139997 5
528083 528083 201426 201426 PubChem (substance) 2 232664 232664 12
593709 593709 201426 201426 PubChem (substance) 2 72790 72790 1
593712 593712 201426 201426 PubChem (substance) 2 187250 187250 2
593715 593715 201426 201426 PubChem (substance) 2 136786 136786 5
593718 593718 201426 201426 PubChem (substance) 2 189763 189763 3
593719 593719 201426 201426 PubChem (substance) 2 139997 139997 8
593722 593722 201426 201426 PubChem (substance) 2 198913 198913 7
593725 593725 201426 201426 PubChem (substance) 2 229844 229844 6
659672 659672 201426 201426 PubChem (substance) 2 230650 230650 11
659674 659674 201426 201426 PubChem (substance) 2 243495 243495 10
659678 659678 201426 201426 PubChem (substance) 2 187258 187258 9
659684 659684 201426 201426 PubChem (substance) 2 263130 263130 14
674626 674626 201426 201426 PubChem (substance) 2 140096 140096 13
832158 832158 201426 201426 PubChem (substance) 2 266556 266556 4
1095893 1095893 201426 201426 CAS Common Chemistry 3 72790 72790 1
1297815 1297815 201426 201426 Computational Toxicology and Exposure Data 4 72790 72790 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)
);
Powered by Datasette · Queries took 462.471ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website