consensus_index

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

27 rows where inchi_id = 53042

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2425 2425 666 666 53042 8 0.303653345107807
15521 15521 4764 4764 53042 8 0.519685039370079
41016 41016 12436 12436 53042 1 0.310344827586207
83038 83038 29905 29905 53042 8 0.519685039370079
159091 159091 57282 57282 53042 15 0.419117647058824
206210 206210 73080 73080 53042 8 0.303653345107807
210531 210531 73954 73954 53042 8 0.303653345107807
422911 422911 153146 153146 53042 6 0.514285714285714
511645 511645 205936 205936 53042 8 0.303653345107807
552456 552456 218162 218162 53042 8 0.303653345107807
713760 713760 252739 252739 53042 12 0.304203180305976
815298 815298 283222 283222 53042 8 0.519685039370079
815301 815301 283223 283223 53042 8 0.519685039370079
815305 815305 283224 283224 53042 8 0.303653345107807
815318 815318 283225 283225 53042 7 0.517241379310345
815321 815321 283226 283226 53042 5 0.51063829787234
875953 875953 303053 303053 53042 4 0.833333333333333
925604 925604 329055 329055 53042 1 0.3
1071912 1071912 376491 376491 53042 8 0.519685039370079
1071915 1071915 376492 376492 53042 8 0.519685039370079
1298188 1298188 424433 424433 53042 8 0.519685039370079
1298191 1298191 424434 424434 53042 8 0.519685039370079
1507729 1507729 465270 465270 53042 8 0.519685039370079
1507732 1507732 465271 465271 53042 8 0.519685039370079
1601348 1601348 483706 483706 53042 8 0.519685039370079
1608672 1608672 485852 485852 53042 8 0.519685039370079
1715300 1715300 525478 525478 53042 7 0.517241379310345 
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)
);