consensus_index

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

11 rows where inventory_id = 517667

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1697730 1697730 517667 517667 55421 9 0.166628038655169
1697731 1697731 517667 517667 61368 1 0.0257854987253287
1697732 1697732 517667 517667 66005 2 0.283640485978616
1697733 1697733 517667 517667 145170 1 0.0945468286595385
1697734 1697734 517667 517667 223000 2 0.0501410277636317
1697735 1697735 517667 517667 238407 1 0.0315156095531795
1697736 1697736 517667 517667 241062 3 0.141820242989308
1697737 1697737 517667 517667 259474 2 0.0334273518424212
1697738 1697738 517667 517667 259475 4 0.0651167318551895
1697739 1697739 517667 517667 266076 1 0.0567280971957231
1697740 1697740 517667 517667 326586 1 0.0405200694255165 
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)
);