media_variant

21 rows where media = 165

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
3937 hr3 165 DS 1 RHCHES3_ZT ok 1193.12
3940 hr3 165 HpT 4 RHCHES3_ZH ok 1193.12
3941 hr3 165 Ø 5 RHCHES3_ZD ok 171.71
3942 hr3 165 0500-0600 6 RHCHES3_FAGA ok 60.32
3943 hr3 165 0600-0700 7 RHCHES3_GAHA ok 155.2
3944 hr3 165 0700-0800 8 RHCHES3_HAIA ok 246.69
3945 hr3 165 0800-0900 9 RHCHES3_IAJA ok 251.75
3946 hr3 165 0900-1000 10 RHCHES3_JAKA ok 198.72
3947 hr3 165 1000-1100 11 RHCHES3_KALA ok 149.87
3948 hr3 165 1100-1200 12 RHCHES3_LAMA ok 144.26
3949 hr3 165 1200-1300 13 RHCHES3_MANA ok 144.74
3950 hr3 165 1300-1400 14 RHCHES3_NAOA ok 137.02
3951 hr3 165 1400-1500 15 RHCHES3_OAPA ok 117.15
3952 hr3 165 1500-1600 16 RHCHES3_PAQA ok 124.71
3953 hr3 165 1600-1700 17 RHCHES3_QARA ok 141.84
3954 hr3 165 1700-1800 18 RHCHES3_RASA ok 153.07
3955 hr3 165 1800-1900 19 RHCHES3_SATA ok 132.07
3956 hr3 165 1900-2000 20 RHCHES3_TAUA ok 78.13
3957 hr3 165 2000-2100 21 RHCHES3_UAVA ok 51.08
3958 hr3 165 2100-2200 22 RHCHES3_VAWA ok 26.18
3959 hr3 165 2200-2300 23 RHCHES3_WAXA ok 19.09

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE media_variant (
	id INTEGER NOT NULL, 
	media INTEGER, 
	variant INTEGER, 
	study_code VARCHAR(100), 
	study_status VARCHAR(7), 
	raw_sample INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(media) REFERENCES media (id), 
	FOREIGN KEY(variant) REFERENCES variant (id)
);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);
CREATE INDEX ix_media_variant_media ON media_variant (media);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);