consensus_index

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

13 rows where inventory_id = 527993

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1724200 1724200 527993 527993 37114 3 0.13366742774015
1724201 1724201 527993 527993 77512 2 0.0583372481494549
1724202 1724202 527993 527993 133163 5 0.202601934628576
1724203 1724203 527993 527993 150458 1 0.0297038728311444
1724204 1724204 527993 527993 184959 3 0.212183815408597
1724205 1724205 527993 527993 230295 1 0.0891116184934331
1724206 1724206 527993 527993 235151 1 0.0205642196523307
1724207 1724207 527993 527993 235219 2 0.0545694988656181
1724208 1724208 527993 527993 237600 1 0.0334168569350374
1724209 1724209 527993 527993 251506 2 0.0488084435846478
1724210 1724210 527993 527993 288683 2 0.0488084435846478
1724211 1724211 527993 527993 288692 2 0.0360474245592897
1724212 1724212 527993 527993 309498 1 0.0222779046233583 
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)
);