consensus_index

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

21 rows where inventory_id = 155769

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
433242 433242 155769 155769 7153 5 0.153459821182342
433243 433243 155769 155769 23302 3 0.057597616032412
433244 433244 155769 155769 63043 1 0.0252249861825862
433245 433245 155769 155769 102597 6 0.252249861825862
433246 433246 155769 155769 137095 2 0.0550454326599601
433247 433247 155769 155769 217156 1 0.0168166574550574
433248 433248 155769 155769 229073 2 0.0728182628141036
433249 433249 155769 155769 230016 1 0.0315312327282327
433250 433250 155769 155769 230820 1 0.0140138812125479
433251 433251 155769 155769 231005 3 0.0585420070965643
433252 433252 155769 155769 239432 2 0.0343268582867179
433253 433253 155769 155769 261021 1 0.0315312327282327
433254 433254 155769 155769 261868 2 0.0340133644298736
433255 433255 155769 155769 278069 1 0.0280277624250957
433256 433256 155769 155769 288038 2 0.0240510806393329
433257 433257 155769 155769 291195 1 0.0210208218188218
433258 433258 155769 155769 292828 2 0.0201961523358818
433259 433259 155769 155769 309190 2 0.0186980037706277
433260 433260 155769 155769 328726 1 0.0148382271662272
433261 433261 155769 155769 333642 2 0.0168541528359543
433262 433262 155769 155769 334344 1 0.0132763085171506 
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)
);