home / zeropm-v0-0-4

consensus_index

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

10 rows where inchi_id = 143461

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
40958 40958 12416 12416 143461 1 0.19047619047619
141502 141502 50452 50452 143461 1 0.1875
285001 285001 96594 96594 143461 1 0.19047619047619
455944 455944 163817 163817 143461 1 0.1875
553996 553996 218532 218532 143461 1 0.1875
711749 711749 252336 252336 143461 1 0.19047619047619
812094 812094 282505 282505 143461 1 0.1875
812097 812097 282506 282506 143461 1 0.19047619047619
1647469 1647469 498839 498839 143461 1 0.191489361702128
1736801 1736801 532051 532051 143461 1 0.19047619047619
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)
);
Powered by Datasette · Queries took 1505.203ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website