consensus_index

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

25 rows where inchi_id = 40870

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
152719 152719 54939 54939 40870 1 0.0208635666555105
159333 159333 57359 57359 40870 1 0.0237609160683168
164672 164672 58942 58942 40870 1 0.0262537586151801
164771 164771 58960 58960 40870 1 0.0332198514315704
167796 167796 59944 59944 40870 1 0.0331977396725772
276995 276995 93905 93905 40870 7 0.888888888888889
688320 688320 245466 245466 40870 1 0.0332198514315704
753610 753610 264794 264794 40870 1 0.0251731308673292
791155 791155 276217 276217 40870 1 0.0224983736913182
794219 794219 277186 277186 40870 1 0.0237540677155249
797983 797983 278385 278385 40870 1 0.0235915469457889
799098 799098 278766 278766 40870 1 0.0218618062800495
805136 805136 280556 280556 40870 1 0.018953576359532
812140 812140 282521 282521 40870 1 0.024681755240654
822740 822740 285677 285677 40870 1 0.019676699924388
829589 829589 287777 287777 40870 1 0.0269814812389762
831308 831308 288485 288485 40870 1 0.0237540677155249
832349 832349 288908 288908 40870 1 0.0262349205906338
832394 832394 288918 288918 40870 1 0.0262450090262045
836638 836638 290255 290255 40870 1 0.0331977396725772
836796 836796 290320 290320 40870 1 0.024681755240654
837842 837842 290683 290683 40870 1 0.0231430064555019
845475 845475 292858 292858 40870 1 0.0224983736913182
859683 859683 297346 297346 40870 1 0.0205561822174991
1747890 1747890 535353 535353 40870 1 0.0332198514315704 
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)
);