consensus_index

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

23 rows where inchi_id = 46952

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
61837 61837 19877 19877 46952 8 0.625
94402 94402 33515 33515 46952 8 0.625
187832 187832 66863 66863 46952 4 0.6
336951 336951 113573 113573 46952 1 0.114982578397213
358972 358972 121839 121839 46952 7 0.476190476190476
507341 507341 202925 202925 46952 7 0.476190476190476
557154 557154 219440 219440 46952 7 0.476190476190476
708238 708238 251450 251450 46952 8 0.625
806314 806314 280844 280844 46952 4 0.6
806316 806316 280845 280845 46952 7 0.620689655172414
1059736 1059736 374398 374398 46952 6 0.615384615384615
1059738 1059738 374399 374399 46952 6 0.615384615384615
1059740 1059740 374400 374400 46952 6 0.615384615384615
1283740 1283740 422113 422113 46952 6 0.615384615384615
1283742 1283742 422114 422114 46952 6 0.615384615384615
1283744 1283744 422115 422115 46952 6 0.615384615384615
1499189 1499189 463821 463821 46952 6 0.615384615384615
1499191 1499191 463822 463822 46952 6 0.615384615384615
1499193 1499193 463823 463823 46952 6 0.615384615384615
1600230 1600230 483408 483408 46952 6 0.615384615384615
1681837 1681837 511170 511170 46952 6 0.615384615384615
1751200 1751200 536431 536431 46952 1 0.11184824736381
1755594 1755594 538073 538073 46952 8 0.625 
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)
);