consensus_index

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

26 rows where inchi_id = 8726

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22969 22969 6736 6736 8726 1 0.0662251655629139
82896 82896 29849 29849 8726 8 0.625
168791 168791 60214 60214 8726 1 0.0582945311518689
222202 222202 76820 76820 8726 1 0.0661000944287063
227092 227092 78116 78116 8726 8 0.478260869565217
430775 430775 155072 155072 8726 1 0.0661000944287063
433955 433955 155942 155942 8726 8 0.625
491289 491289 184810 184810 8726 1 0.243864228693887
519871 519871 207718 207718 8726 8 0.413793103448276
535082 535082 212310 212310 8726 1 0.125786163522013
583551 583551 228058 228058 8726 8 0.375903614457831
592508 592508 231019 231019 8726 1 0.0662251655629139
673387 673387 240821 240821 8726 1 0.0662251655629139
681139 681139 243308 243308 8726 9 0.437822647742289
746270 746270 262506 262506 8726 1 0.0657894736842105
746276 746276 262507 262507 8726 1 0.0659563673262303
746282 746282 262508 262508 8726 1 0.0662251655629139
746288 746288 262509 262509 8726 1 0.0657894736842105
760645 760645 266912 266912 8726 8 0.625
760647 760647 266913 266913 8726 5 0.608695652173913
827991 827991 287307 287307 8726 1 0.143647208381732
899854 899854 316492 316492 8726 1 0.065359477124183
958432 958432 344772 344772 8726 1 0.243864228693887
1617468 1617468 488387 488387 8726 1 0.0662251655629139
1620241 1620241 489266 489266 8726 8 0.625
1722581 1722581 527556 527556 8726 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)
);