media_variant

22 rows where media = 44

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
1033 RMS YOUNG STARS 44 DS 1 RHZRMY7_ZT ok 8945.79
1036 RMS YOUNG STARS 44 HpT 4 RHZRMY7_ZH ok 8945.79
1037 RMS YOUNG STARS 44 Ø 5 RHZRMY7_ZD ok 1403.46
1038 RMS YOUNG STARS 44 0500-0600 6 RHZRMY7_FAGA ok 489.22
1039 RMS YOUNG STARS 44 0600-0700 7 RHZRMY7_GAHA ok 1234.67
1040 RMS YOUNG STARS 44 0700-0800 8 RHZRMY7_HAIA ok 1958.92
1041 RMS YOUNG STARS 44 0800-0900 9 RHZRMY7_IAJA ok 1641.17
1042 RMS YOUNG STARS 44 0900-1000 10 RHZRMY7_JAKA ok 1250.94
1043 RMS YOUNG STARS 44 1000-1100 11 RHZRMY7_KALA ok 1259.05
1044 RMS YOUNG STARS 44 1100-1200 12 RHZRMY7_LAMA ok 1138.78
1045 RMS YOUNG STARS 44 1200-1300 13 RHZRMY7_MANA ok 1145.16
1046 RMS YOUNG STARS 44 1300-1400 14 RHZRMY7_NAOA ok 1095.86
1047 RMS YOUNG STARS 44 1400-1500 15 RHZRMY7_OAPA ok 1134.6
1048 RMS YOUNG STARS 44 1500-1600 16 RHZRMY7_PAQA ok 1299.78
1049 RMS YOUNG STARS 44 1600-1700 17 RHZRMY7_QARA ok 1450.36
1050 RMS YOUNG STARS 44 1700-1800 18 RHZRMY7_RASA ok 1420.66
1051 RMS YOUNG STARS 44 1800-1900 19 RHZRMY7_SATA ok 1232.22
1052 RMS YOUNG STARS 44 1900-2000 20 RHZRMY7_TAUA ok 829.71
1053 RMS YOUNG STARS 44 2000-2100 21 RHZRMY7_UAVA ok 517.14
1054 RMS YOUNG STARS 44 2100-2200 22 RHZRMY7_VAWA ok 350.42
1055 RMS YOUNG STARS 44 2200-2300 23 RHZRMY7_WAXA ok 240.23
1056 RMS YOUNG STARS 44 2300-2400 24 RHZRMY7_XAYA ok 193.59

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);