consensus_index

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

11 rows where inventory_id = 42415

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
122092 122092 42415 42415 245 1 0.101092443217484
122093 122093 42415 42415 51007 1 0.0433253328074934
122094 122094 42415 42415 52193 8 0.303277329652454
122095 122095 42415 42415 137481 3 0.151638664826227
122096 122096 42415 42415 137620 2 0.0758193324131134
122097 122097 42415 42415 189167 1 0.0505462216087422
122098 122098 42415 42415 206690 2 0.0783058698017473
122099 122099 42415 42415 214614 1 0.0505462216087422
122100 122100 42415 42415 231503 1 0.0379096662065567
122101 122101 42415 42415 308237 1 0.0336974810724948
122102 122102 42415 42415 314691 1 0.0606554659304907 
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)
);