consensus_index

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

12 rows where inventory_id = 41453

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
118981 118981 41453 41453 48079 7 0.316872618627186
118982 118982 41453 41453 156988 1 0.0396090773283983
118983 118983 41453 41453 172788 1 0.158436309313593
118984 118984 41453 41453 218231 1 0.105624206209062
118985 118985 41453 41453 219361 1 0.052812103104531
118986 118986 41453 41453 227307 1 0.0792181546567965
118987 118987 41453 41453 239165 1 0.0633745237254372
118988 118988 41453 41453 241349 1 0.0452675169467409
118989 118989 41453 41453 247640 1 0.0288066016933806
118990 118990 41453 41453 288696 1 0.035208068736354
118991 118991 41453 41453 291116 1 0.0316872618627186
118992 118992 41453 41453 326520 1 0.0264060515522655 
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)
);