consensus_index

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

21 rows where inchi_id = 112135

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
7647 7647 2297 2297 112135 1 0.276923076923077
8759 8759 2659 2659 112135 2 0.252393886647536
30553 30553 8906 8906 112135 1 0.378378378378378
98151 98151 34798 34798 112135 1 0.375
153365 153365 55134 55134 112135 1 0.380952380952381
219292 219292 75998 75998 112135 2 0.252393886647536
428590 428590 154466 154466 112135 2 0.252393886647536
439998 439998 157731 157731 112135 1 0.321428571428571
515847 515847 206756 206756 112135 2 0.252393886647536
549564 549564 217259 217259 112135 1 0.321428571428571
717160 717160 253652 253652 112135 3 0.249653259361997
820482 820482 284817 284817 112135 2 0.382978723404255
820485 820485 284818 284818 112135 1 0.375
880540 880540 305862 305862 112135 1 0.375
1074368 1074368 377286 377286 112135 2 0.382978723404255
1300781 1300781 425298 425298 112135 2 0.382978723404255
1509511 1509511 465872 465872 112135 2 0.382978723404255
1601909 1601909 483890 483890 112135 2 0.382978723404255
1627621 1627621 491620 491620 112135 2 0.382978723404255
1718793 1718793 526408 526408 112135 2 0.340909090909091
1726998 1726998 528832 528832 112135 1 0.378378378378378 
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)
);