consensus_index

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

15 rows where inchi_id = 84637

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19322 19322 5677 5677 84637 8 0.519685039370079
135064 135064 47868 47868 84637 1 0.0315639340230564
145454 145454 51860 51860 84637 8 0.519685039370079
217544 217544 75457 75457 84637 8 0.413793103448276
303004 303004 102551 102551 84637 1 0.307692307692308
427349 427349 154080 154080 84637 8 0.519685039370079
533705 533705 211731 211731 84637 8 0.413793103448276
734532 734532 259128 259128 84637 8 0.519685039370079
855631 855631 295959 295959 84637 8 0.519685039370079
855634 855634 295960 295960 84637 4 0.506024096385542
855637 855637 295961 295961 84637 4 0.506024096385542
855640 855640 295962 295962 84637 4 0.506024096385542
918874 918874 325862 325862 84637 4 0.506024096385542
1612829 1612829 486913 486913 84637 8 0.519685039370079
1656193 1656193 501856 501856 84637 1 0.307692307692308 
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)
);