consensus_index

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

11 rows where inventory_id = 417100

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1267042 1267042 417100 417100 138366 1 0.0361019676286709
1267043 1267043 417100 417100 138370 4 0.103772683351517
1267044 1267044 417100 417100 183681 4 0.0701088329046554
1267045 1267045 417100 417100 216323 4 0.288815741029367
1267046 1267046 417100 417100 230867 3 0.0585545225480608
1267047 1267047 417100 417100 257628 2 0.117908532534293
1267048 1267048 417100 417100 258438 3 0.0929495106902874
1267049 1267049 417100 417100 267246 1 0.0412593915756238
1267050 1267050 417100 417100 271596 1 0.0288815741029367
1267051 1267051 417100 417100 294543 1 0.0320906378921519
1267052 1267052 417100 417100 329384 2 0.0355507601816056 
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)
);