consensus_index

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

12 rows where inchi_id = 42729

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
223610 223610 77182 77182 42729 1 0.0932253344542783
278403 278403 94409 94409 42729 1 0.156802940439021
453522 453522 162860 162860 42729 1 0.156802940439021
505187 505187 202078 202078 42729 8 0.519685039370079
560038 560038 220290 220290 42729 2 0.150596931982873
560044 560044 220291 220291 42729 8 0.519685039370079
590570 590570 230466 230466 42729 1 0.0932253344542783
667987 667987 239381 239381 42729 1 0.153728920380334
800626 800626 279293 279293 42729 1 0.169894155485198
800630 800630 279294 279294 42729 1 0.17297741382261
910983 910983 321771 321771 42729 1 0.094882577065968
1644770 1644770 497884 497884 42729 1 0.169894155485198 
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)
);