home / zeropm-v0-0-4

api_results

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

17 rows where query_id = 398194

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
281599 281599 398194 398194 PubChem (compound) 1 215801 215801 1
281600 281600 398194 398194 PubChem (compound) 1 215695 215695 2
281601 281601 398194 398194 PubChem (compound) 1 261452 261452 3
281602 281602 398194 398194 PubChem (compound) 1 259317 259317 4
281603 281603 398194 398194 PubChem (compound) 1 331550 331550 5
650018 650018 398194 398194 PubChem (substance) 2 25328 25328 12
674352 674352 398194 398194 PubChem (substance) 2 215801 215801 1
674353 674353 398194 398194 PubChem (substance) 2 215695 215695 4
674354 674354 398194 398194 PubChem (substance) 2 261452 261452 6
674356 674356 398194 398194 PubChem (substance) 2 259317 259317 9
674357 674357 398194 398194 PubChem (substance) 2 331550 331550 11
931434 931434 398194 398194 PubChem (substance) 2 215801 215801 2
931435 931435 398194 398194 PubChem (substance) 2 215695 215695 3
931436 931436 398194 398194 PubChem (substance) 2 259317 259317 5
931437 931437 398194 398194 PubChem (substance) 2 259511 259511 7
931438 931438 398194 398194 PubChem (substance) 2 215801 215801 8
931439 931439 398194 398194 PubChem (substance) 2 320849 320849 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)
);
Powered by Datasette · Queries took 487.822ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website