consensus_index

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

27 rows where inchi_id = 138184

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
12445 12445 3818 3818 138184 1 0.227848101265823
30785 30785 8995 8995 138184 2 0.285704173916896
30789 30789 8996 8996 138184 1 0.227848101265823
55827 55827 17502 17502 138184 3 0.365160321615826
86974 86974 31157 31157 138184 2 0.212765957446809
134539 134539 47721 47721 138184 2 0.178948785573273
134546 134546 47722 47722 138184 2 0.212765957446809
138951 138951 49495 49495 138184 1 0.0228062880194111
243768 243768 82932 82932 138184 2 0.211020313803582
243774 243774 82933 82933 138184 2 0.178948785573273
440342 440342 157864 157864 138184 2 0.211020313803582
440348 440348 157865 157865 138184 2 0.178948785573273
522020 522020 208291 208291 138184 2 0.211020313803582
549062 549062 217028 217028 138184 2 0.178948785573273
549069 549069 217029 217029 138184 2 0.211020313803582
717709 717709 253852 253852 138184 2 0.189788723812004
717718 717718 253854 253854 138184 2 0.179536939666066
821322 821322 285171 285171 138184 2 0.189788723812004
821327 821327 285172 285172 138184 2 0.212765957446809
821332 821332 285173 285173 138184 1 0.20979020979021
821336 821336 285174 285174 138184 1 0.230769230769231
821340 821340 285175 285175 138184 1 0.229007633587786
887585 887585 309441 309441 138184 1 0.226415094339623
952083 952083 341575 341575 138184 1 0.208816705336427
1628057 1628057 491810 491810 138184 1 0.211841390548615
1628061 1628061 491811 491811 138184 2 0.231454005934718
1727135 1727135 528888 528888 138184 1 0.230769230769231 
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)
);