consensus_index

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

20 rows where inchi_id = 31404

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
58470 58470 18450 18450 31404 8 0.628571428571429
63867 63867 20690 20690 31404 1 0.170984455958549
112100 112100 39218 39218 31404 1 0.170984455958549
115894 115894 40435 40435 31404 8 0.628571428571429
187268 187268 66699 66699 31404 8 0.628571428571429
187313 187313 66713 66713 31404 4 0.171083383665705
342162 342162 115484 115484 31404 8 0.521739130434783
368020 368020 125161 125161 31404 1 0.170984455958549
479049 479049 175050 175050 31404 8 0.521739130434783
488376 488376 182127 182127 31404 1 0.168
551330 551330 217864 217864 31404 1 0.170454545454545
565912 565912 222216 222216 31404 4 0.6
697302 697302 248594 248594 31404 8 0.628571428571429
714706 714706 252971 252971 31404 1 0.170984455958549
789683 789683 275787 275787 31404 4 0.6
789685 789685 275788 275788 31404 8 0.628571428571429
816804 816804 283648 283648 31404 1 0.170984455958549
1675205 1675205 508506 508506 31404 8 0.628571428571429
1685770 1685770 512670 512670 31404 1 0.170984455958549
1757035 1757035 538623 538623 31404 1 0.170984455958549 
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)
);