consensus_index

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

28 rows where inchi_id = 73645

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
45383 45383 13836 13836 73645 8 0.461538461538462
111399 111399 38982 38982 73645 8 0.461538461538462
151615 151615 54415 54415 73645 1 0.136363636363636
158554 158554 57118 57118 73645 8 0.461538461538462
181527 181527 64852 64852 73645 1 0.148055112586726
258882 258882 87660 87660 73645 1 0.173913043478261
296042 296042 100162 100162 73645 8 0.461538461538462
314779 314779 106175 106175 73645 1 0.136363636363636
419670 419670 150438 150438 73645 2 0.487728457387774
540890 540890 214272 214272 73645 8 0.461538461538462
688498 688498 245509 245509 73645 1 0.169642214560612
726212 726212 256522 256522 73645 8 0.461538461538462
767992 767992 268817 268817 73645 1 0.136363636363636
767996 767996 268818 268818 73645 1 0.136363636363636
773276 773276 270501 270501 73645 1 0.169642214560612
773279 773279 270502 270502 73645 1 0.151912313119004
838621 838621 290899 290899 73645 8 0.461538461538462
933073 933073 332433 332433 73645 1 0.151912313119004
942148 942148 337207 337207 73645 4 0.833333333333333
1129835 1129835 385106 385106 73645 8 0.461538461538462
1369954 1369954 434416 434416 73645 8 0.461538461538462
1369958 1369958 434417 434417 73645 8 0.461538461538462
1369962 1369962 434418 434418 73645 8 0.461538461538462
1552571 1552571 472027 472027 73645 8 0.461538461538462
1604237 1604237 484674 484674 73645 8 0.461538461538462
1652071 1652071 500360 500360 73645 8 0.461538461538462
1663309 1663309 504180 504180 73645 1 0.138888888888889
1739461 1739461 532783 532783 73645 8 0.461538461538462 
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)
);