consensus_index

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

15 rows where inchi_id = 27314

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
36859 36859 11036 11036 27314 6 0.341968911917098
139655 139655 49747 49747 27314 9 0.344262295081967
267046 267046 90521 90521 27314 5 0.340909090909091
336983 336983 113582 113582 27314 1 0.0721776722258926
568161 568161 222928 222928 27314 1 0.072011082728271
568721 568721 223095 223095 27314 5 0.340909090909091
694644 694644 247746 247746 27314 6 0.341968911917098
695161 695161 247896 247896 27314 1 0.0619369715581431
783664 783664 273923 273923 27314 5 0.340909090909091
783668 783668 273924 273924 27314 6 0.341968911917098
783672 783672 273925 273925 27314 3 0.336
860703 860703 297647 297647 27314 1 0.0715815274536642
902976 902976 318188 318188 27314 3 0.336
1639489 1639489 495937 495937 27314 6 0.341968911917098
1733158 1733158 530850 530850 27314 6 0.341968911917098 
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)
);