consensus_index

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

24 rows where inchi_id = 27870

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
30574 30574 8913 8913 27870 1 0.3125
44679 44679 13654 13654 27870 3 0.508673800023661
56967 56967 17900 17900 27870 7 0.332078804893245
80528 80528 29041 29041 27870 7 0.332078804893245
193150 193150 68686 68686 27870 4 0.538254187099715
193201 193201 68716 68716 27870 7 0.332078804893245
243186 243186 82712 82712 27870 2 0.314285714285714
261521 261521 88587 88587 27870 1 0.172413793103448
293945 293945 99503 99503 27870 4 0.569813386560334
336657 336657 113485 113485 27870 6 0.331756672263886
447338 447338 160301 160301 27870 1 0.172413793103448
568351 568351 222977 222977 27870 4 0.338746531709423
668530 668530 239517 239517 27870 3 0.508673800023661
694941 694941 247857 247857 27870 7 0.332078804893245
742005 742005 261352 261352 27870 1 0.0056954396492448
786172 786172 274706 274706 27870 1 0.00581703523989647
834668 834668 289659 289659 27870 1 0.00657138414730292
907892 907892 320528 320528 27870 1 0.3
917908 917908 325356 325356 27870 1 0.168674698795181
918027 918027 325407 325407 27870 4 0.338746531709423
1627684 1627684 491652 491652 27870 1 0.3125
1636975 1636975 494987 494987 27870 1 0.172413793103448
1672627 1672627 507563 507563 27870 7 0.340026339968916
1751099 1751099 536412 536412 27870 7 0.332078804893245 
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)
);