consensus_index

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

13 rows where inchi_id = 31497

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
53173 53173 16548 16548 31497 2 0.292380241743759
172268 172268 61540 61540 31497 28 0.303380910301718
219224 219224 75978 75978 31497 1 0.171428571428571
230466 230466 78960 78960 31497 6 0.31371379398266
320427 320427 107993 107993 31497 2 0.173228346456693
435633 435633 156353 156353 31497 6 0.31371379398266
470274 470274 170225 170225 31497 1 0.168674698795181
503377 503377 201458 201458 31497 1 0.171428571428571
531416 531416 210789 210789 31497 1 0.175438596491228
565849 565849 222194 222194 31497 5 0.305197813261293
879507 879507 305336 305336 31497 1 0.168674698795181
941708 941708 336986 336986 31497 3 0.321240733405358
1614194 1614194 487354 487354 31497 1 0.173228346456693 
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)
);