consensus_index

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

18 rows where inchi_id = 119647

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
57504 57504 18087 18087 119647 2 0.384615384615385
93301 93301 33172 33172 119647 2 0.384615384615385
193261 193261 68737 68737 119647 1 0.375
338666 338666 114201 114201 119647 1 0.380952380952381
477450 477450 174138 174138 119647 1 0.375
567385 567385 222696 222696 119647 1 0.375
695867 695867 248100 248100 119647 2 0.384615384615385
786383 786383 274712 274712 119647 1 0.375
1047077 1047077 370625 370625 119647 2 0.384615384615385
1047080 1047080 370626 370626 119647 2 0.384615384615385
1047083 1047083 370627 370627 119647 2 0.384615384615385
1268364 1268364 417520 417520 119647 2 0.384615384615385
1268367 1268367 417521 417521 119647 2 0.384615384615385
1489533 1489533 460932 460932 119647 2 0.384615384615385
1489536 1489536 460933 460933 119647 2 0.384615384615385
1597643 1597643 482511 482511 119647 2 0.384615384615385
1673635 1673635 507919 507919 119647 2 0.384615384615385
1751698 1751698 536613 536613 119647 2 0.384615384615385 
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)
);