consensus_index

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

20 rows where inchi_id = 199481

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
33051 33051 9757 9757 199481 1 0.0532997998451746
33992 33992 10056 10056 199481 1 0.0275684903906456
86317 86317 30964 30964 199481 1 0.0597524541186513
104262 104262 36755 36755 199481 1 0.0275684903906456
189570 189570 67534 67534 199481 1 0.0272030420743136
189586 189586 67535 67535 199481 1 0.0606426666911029
254667 254667 86526 86526 199481 2 0.0425111522674256
256521 256521 87005 87005 199481 1 0.0275684903906456
444377 444377 159316 159316 199481 2 0.0425111522674256
580455 580455 227121 227121 199481 1 0.0275684903906456
585813 585813 228759 228759 199481 2 0.0425111522674256
678650 678650 242657 242657 199481 2 0.0415926790269204
682996 682996 243909 243909 199481 1 0.0275684903906456
755760 755760 265548 265548 199481 1 0.0594985125371866
755771 755771 265549 265549 199481 2 0.0425111522674256
764276 764276 267914 267914 199481 1 0.0275684903906456
946405 946405 339114 339114 199481 1 0.0594985125371866
1633454 1633454 493786 493786 199481 1 0.0532997998451746
1729536 1729536 529681 529681 199481 1 0.052921583846062
1730713 1730713 530027 530027 199481 1 0.0275684903906456 
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)
);