home / zeropm-v0-0-4

consensus_index

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

14 rows where inventory_id = 67531

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
189540 189540 67531 67531 27116 1 0.0217377562512934
189541 189541 67531 67531 41267 1 0.13042653750776
189542 189542 67531 67531 54029 2 0.0922254891184189
189543 189543 67531 67531 91293 8 0.260853075015521
189544 189544 67531 67531 169824 1 0.0326066343769401
189545 189545 67531 67531 169850 1 0.0289836750017245
189546 189546 67531 67531 173747 1 0.0237139159105019
189547 189547 67531 67531 204553 1 0.0260853075015521
189548 189548 67531 67531 205335 1 0.0372647250022172
189549 189549 67531 67531 217243 1 0.0869510250051735
189550 189550 67531 67531 232151 1 0.0434755125025868
189551 189551 67531 67531 315679 1 0.0869510250051735
189552 189552 67531 67531 315681 1 0.0652132687538801
189553 189553 67531 67531 315682 1 0.0521706150031041
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 952.815ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website