consensus_index

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

28 rows where inchi_id = 87494

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19683 19683 5765 5765 87494 8 0.625
36213 36213 10808 10808 87494 1 0.11988867480197
101057 101057 35713 35713 87494 8 0.625
129837 129837 46280 46280 87494 1 0.120430107526882
135417 135417 47991 47991 87494 16 0.642857142857143
218167 218167 75651 75651 87494 8 0.478260869565217
427763 427763 154211 154211 87494 8 0.478260869565217
515147 515147 206565 206565 87494 8 0.478260869565217
532750 532750 211313 211313 87494 8 0.625
692951 692951 247210 247210 87494 1 0.120430107526882
735526 735526 259437 259437 87494 12 0.638297872340426
780101 780101 272793 272793 87494 1 0.11988867480197
857369 857369 296546 296546 87494 7 0.620689655172414
857371 857371 296547 296547 87494 5 0.608695652173913
857373 857373 296548 296548 87494 8 0.625
857375 857375 296549 296549 87494 8 0.625
857377 857377 296550 296550 87494 7 0.620689655172414
907671 907671 320428 320428 87494 4 0.6
1174472 1174472 394170 394170 87494 8 0.625
1174474 1174474 394171 394171 87494 8 0.625
1429837 1429837 445790 445790 87494 8 0.625
1429839 1429839 445791 445791 87494 8 0.625
1587041 1587041 479072 479072 87494 8 0.625
1587043 1587043 479073 479073 87494 8 0.625
1607111 1607111 485518 485518 87494 8 0.625
1613385 1613385 487074 487074 87494 8 0.625
1638419 1638419 495533 495533 87494 1 0.11988867480197
1718250 1718250 526234 526234 87494 6 0.615384615384615 
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)
);