consensus_index

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

12 rows where inchi_id = 48242

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
9393 9393 2850 2850 48242 8 0.625
125974 125974 45010 45010 48242 1 0.208695652173913
205851 205851 72964 72964 48242 8 0.625
419451 419451 150147 150147 48242 4 0.833333333333333
455483 455483 163667 163667 48242 1 0.0649066323439173
530542 530542 210495 210495 48242 1 0.116504854368932
556242 556242 219182 219182 48242 8 0.478260869565217
587381 587381 229471 229471 48242 1 0.115727002967359
677439 677439 242014 242014 48242 1 0.116704805491991
709142 709142 251683 251683 48242 12 0.483870967741935
841717 841717 291801 291801 48242 1 0.206896551724138
1755909 1755909 538200 538200 48242 8 0.625 
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)
);