consensus_index

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

12 rows where inchi_id = 3749

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
48942 48942 15043 15043 3749 1 0.350440262760282
114308 114308 39887 39887 3749 1 0.350440262760282
166567 166567 59619 59619 3749 1 0.210135699235907
166578 166578 59620 59620 3749 1 0.350440262760282
180362 180362 64438 64438 3749 1 0.179381984500643
303568 303568 102677 102677 3749 1 0.350440262760282
463472 463472 166521 166521 3749 1 0.350440262760282
527304 527304 209665 209665 3749 1 0.210135699235907
591489 591489 230738 230738 3749 1 0.350440262760282
805536 805536 280669 280669 3749 1 0.17944377417013
959227 959227 345136 345136 3749 1 0.343849596088132
1656416 1656416 501913 501913 3749 2 0.283822040343498 
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)
);