consensus_index

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

12 rows where inventory_id = 151620

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
420461 420461 151620 151620 61265 1 0.0476460510564447
420462 420462 151620 151620 172189 2 0.142938153169334
420463 420463 151620 151620 172358 1 0.0238230255282223
420464 420464 151620 151620 178006 2 0.0505362686981587
420465 420465 151620 151620 179359 1 0.0317640340376298
420466 420466 151620 151620 179614 2 0.0639238854129816
420467 420467 151620 151620 191933 2 0.0521936338793152
420468 420468 151620 151620 203375 2 0.285876306338668
420469 420469 151620 151620 206201 2 0.0952921021128893
420470 420470 151620 151620 226134 1 0.0408394723340954
420471 420471 151620 151620 247588 2 0.0341687540066819
420472 420472 151620 151620 255119 2 0.03047451665025 
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)
);