consensus_index

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

10 rows where inventory_id = 198049

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
500334 500334 198049 198049 33420 1 0.222459154026516
500335 500335 198049 198049 104139 1 0.0741530513421719
500336 500336 198049 198049 106976 1 0.0444918308053031
500337 500337 198049 198049 109784 1 0.0370765256710859
500338 500338 198049 198049 110731 1 0.111229577013258
500339 500339 198049 198049 123122 1 0.0556147885066289
500340 500340 198049 198049 205569 2 0.222459154026516
500341 500341 198049 198049 215145 1 0.111229577013258
500342 500342 198049 198049 266391 1 0.0278073942533145
500343 500343 198049 198049 292770 1 0.0317798791466451 
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)
);