consensus_index

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

11 rows where inventory_id = 422957

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1286938 1286938 422957 422957 50109 5 0.155589220553896
1286939 1286939 422957 422957 97357 2 0.23582915916398
1286940 1286940 422957 422957 159142 1 0.058957289790995
1286941 1286941 422957 422957 187011 1 0.0786097197213267
1286942 1286942 422957 422957 187012 4 0.23582915916398
1286943 1286943 422957 422957 196929 2 0.0430563167305294
1286944 1286944 422957 422957 203968 2 0.0527330030967277
1286945 1286945 422957 422957 244168 1 0.0262032399071089
1286946 1286946 422957 422957 244216 1 0.0393048598606634
1286947 1286947 422957 422957 246653 1 0.0336898798805686
1286948 1286948 422957 422957 247846 1 0.0294786448954975 
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)
);