consensus_index

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

11 rows where inventory_id = 283745

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
817110 817110 283745 283745 54009 4 0.34390992870478
817111 817111 283745 283745 101864 1 0.0859774821761949
817112 817112 283745 283745 176673 1 0.0382122143005311
817113 817113 283745 283745 232270 2 0.0750472990731676
817114 817114 283745 283745 261595 1 0.0573183214507966
817115 817115 283745 283745 262660 1 0.0429887410880975
817116 817116 283745 283745 314248 1 0.17195496435239
817117 817117 283745 283745 315467 1 0.068781985740956
817118 817118 283745 283745 317246 1 0.034390992870478
817119 817119 283745 283745 317270 1 0.0312645389731618
817120 817120 283745 283745 320650 1 0.0286591607253983 
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)
);