consensus_index

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

12 rows where inventory_id = 42416

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
122103 122103 42416 42416 35702 1 0.0418011651101048
122104 122104 42416 42416 36775 8 0.229991024499793
122105 122105 42416 42416 98828 1 0.250806990660629
122106 122106 42416 42416 135599 2 0.056082148034932
122107 122107 42416 42416 137918 2 0.102391525173588
122108 122108 42416 42416 157515 2 0.102391525173588
122109 122109 42416 42416 196744 1 0.0278674434067365
122110 122110 42416 42416 207013 1 0.0250806990660629
122111 122111 42416 42416 219149 1 0.0627017476651571
122112 122112 42416 42416 242180 1 0.0313508738325786
122113 122113 42416 42416 258935 1 0.0358295700943755
122114 122114 42416 42416 320878 1 0.0228006355146026 
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)
);