consensus_index

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

19 rows where inventory_id = 73325

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
207011 207011 73325 73325 46096 4 0.201303008020063
207012 207012 73325 73325 137447 3 0.100651504010031
207013 207013 73325 73325 137594 2 0.0439279177082971
207014 207014 73325 73325 138746 1 0.0201303008020063
207015 207015 73325 73325 149826 3 0.0505906292627759
207016 207016 73325 73325 170067 2 0.0335505013366771
207017 207017 73325 73325 173810 1 0.0183002734563693
207018 207018 73325 73325 180017 4 0.201303008020063
207019 207019 73325 73325 185916 2 0.0229406068370255
207020 207020 73325 73325 192429 1 0.0335505013366771
207021 207021 73325 73325 194219 3 0.0399435758369263
207022 207022 73325 73325 195832 1 0.0154848467707741
207023 207023 73325 73325 200240 3 0.0204060926182426
207024 207024 73325 73325 201457 2 0.0223670008911181
207025 207025 73325 73325 207283 2 0.0402606016040125
207026 207026 73325 73325 220948 1 0.0402606016040125
207027 207027 73325 73325 227547 1 0.0503257520050157
207028 207028 73325 73325 292580 1 0.0251628760025078
207029 207029 73325 73325 329402 1 0.0143787862871473 
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)
);