consensus_index

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

20 rows where inventory_id = 525342

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1714375 1714375 525342 525342 44431 1 0.0417848240748443
1714376 1714376 525342 525342 132637 6 0.250708944449066
1714377 1714377 525342 525342 136619 4 0.125354472224533
1714378 1714378 525342 525342 183515 2 0.0377957954692548
1714379 1714379 525342 525342 195535 1 0.0278565493832295
1714380 1714380 525342 525342 195708 2 0.028387198005431
1714381 1714381 525342 525342 199839 1 0.0250708944449066
1714382 1714382 525342 525342 224591 4 0.0242949810559241
1714383 1714383 525342 525342 225111 1 0.0179077817463618
1714384 1714384 525342 525342 237277 4 0.0723734382829575
1714385 1714385 525342 525342 238095 1 0.0250708944449066
1714386 1714386 525342 525342 259285 4 0.0321999718882485
1714387 1714387 525342 525342 260131 2 0.0218214126884103
1714388 1714388 525342 525342 267550 4 0.0590926649080186
1714389 1714389 525342 525342 288417 2 0.0200727802085255
1714390 1714390 525342 525342 290999 2 0.0253254278177223
1714391 1714391 525342 525342 297614 4 0.0378742918327846
1714392 1714392 525342 525342 308814 2 0.0501417888898131
1714393 1714393 525342 525342 320843 2 0.022159749340507
1714394 1714394 525342 525342 333102 2 0.0202686168480511 
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)
);