consensus_index

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

12 rows where inchi_id = 123213

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
7672 7672 2305 2305 123213 6 0.347280282607859
154826 154826 55686 55686 123213 3 0.342877137775318
296123 296123 100182 100182 123213 6 0.347280282607859
439828 439828 157670 157670 123213 2 0.408628001184222
459697 459697 165264 165264 123213 3 0.341575820667277
472328 472328 171317 171317 123213 4 0.336675376356271
540813 540813 214254 214254 123213 6 0.347280282607859
552068 552068 218097 218097 123213 1 0.0818860206469453
713923 713923 252787 252787 123213 1 0.0821382446719118
815621 815621 283320 283320 123213 1 0.0818860206469453
951203 951203 341243 341243 123213 3 0.341575820667277
1739533 1739533 532798 532798 123213 6 0.275905160479861 
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)
);