S3SEX Database Structure
OERC logo SKADS logo

Please note that all data obtained using the S-Cubed SEX database prior to 29 November 2010 was missing Column 21 (250 micron flux density). The bug has now been fixed and the 250 micron flux densities should now appear in the output.

Organization of the database

The database is broken down into three tables, galaxies, components and clusters. A summary of the columns in each table is shown below.

Galaxies table

ColumnAttributeTypeNULLDescriptionCommentsUnits
1galaxyint8NOComponent indexUnique identifier for each row 
2clusterint4NOCluster indexIdentical in source and cluster tables 
3sftypeint2NOStar formation typeNone [0] Quiescent [1] Starburst [2] 
4agntypeint2NOAGN typeNone [0] Radio-Quiet [1] FRI [2] FRII [3] GPS [4] 
5right_ascensionfloat8NOX position [degrees]
6declinationfloat8NOY position [degrees]
7distancefloat8NODistanceComoving distance[Mpc]
8redshiftfloat8NORedshiftCosmological 
9modified_redshiftfloat8NOModified RedshiftCosmological 
10itot_151float8NOlog10I @ 151 MHzTotal flux of all components @ 151 MHz[Jy]
11itot_610float8NOlog10I @ 610 MHzTotal flux of all components @ 610 MHz[Jy]
12itot_1400float8NOlog10I @ 1400 MHzTotal flux of all components @ 1400 MHz[Jy]
13itot_4860float8NOlog10I @ 4860 MHzTotal flux of all components @ 4860 MHz[Jy]
14itot_18000float8NOlog10I @ 18000 MHzTotal flux of all components @ 18000 MHz[Jy]
15m_hifloat8YESlog10MHIApplies to star-forming galaxies[MSUN]
16cos_vafloat8NOViewing angleGiven as cosine. Applies to FRI and FRII 
17itot_24micfloat8NOlog10(S) @ 24 Microns[Jy]
18itot_70micfloat8NOlog10(S) @ 70 Microns[Jy]
19itot_100micfloat8NOlog10(S) @ 100 Microns[Jy]
20itot_160micfloat8NOlog10(S) @ 160 Microns[Jy]
21itot_250micfloat8NOlog10(S) @ 250 Microns[Jy]
22itot_350micfloat8NOlog10(S) @ 350 Microns[Jy]
23itot_450micfloat8NOlog10(S) @ 450 Microns[Jy]
24itot_500micfloat8NOlog10(S) @ 500 Microns[Jy]
25itot_850micfloat8NOlog10(S) @ 850 Microns[Jy]
26itot_1200micfloat8NOlog10(S) @ 1200 Microns[Jy]
27K_magfloat8NOK-band (Vega) magnitude[mag]
28RQQ_IR_classintNORQQ classification flag1=unobscured; 2=Compton-thin obscured; 3=Compton-thick obscured; -1=Source excluded
29SD_flagintNOSpace density filter flag-1=filtered out; 0=retained
30dlog_Lfloat8NO1.4 GHz Luminosity boostStar-forming galaxies only[dex]

Components table

ColumnAttributeTypeNULLDescriptionCommentsUnits
1componentint20NOComponent index  
2galaxyint20NOGalaxy indexIdentical for all components of the same galaxy 
3structureint2NOComponent typeCore [1] Lobe [2] Hotspot [3] Disk [4] 
4right_ascensionfloat8NOX position [degrees]
5declinationfloat8NOY position [degrees]
6position_anglefloat8NOPosition angleCounted east from north [radians]
7major_axisfloat8NOMajor axis [arcsecs]
8minor_axisfloat8NOMinor axis [arcsecs]
9i_151float8NOlog10I @ 151 MHz [Jy]
10q_151float8YESlog10Q @ 151 MHzCurrently NULL[Jy]
11u_151float8YESlog10U @ 151 MHzCurrently NULL[Jy]
12v_151float8YESlog10V @ 151 MHzCurrently NULL[Jy]
13i_610float8NOlog10I @ 610 MHz [Jy]
14q_610float8YESlog10Q @ 610 MHzCurrently NULL[Jy]
15u_610float8YESlog10U @ 610 MHzCurrently NULL[Jy]
16v_610float8YESlog10V @ 610 MHzCurrently NULL[Jy]
17i_1400float8NOlog10I @ 1400 MHz [Jy]
18q_1400float8YESlog10Q @ 1400 MHzCurrently NULL[Jy]
19u_1400float8YESlog10U @ 1400 MHzCurrently NULL[Jy]
20v_1400float8YESlog10V @ 1400 MHzCurrently NULL[Jy]
21i_4860float8NOlog10I @ 4860 MHz [Jy]
22q_4860float8YESlog10Q @ 4860 MHzCurrently NULL[Jy]
23u_4860float8YESlog10U @ 4860 MHzCurrently NULL[Jy]
24v_4860float8YESlog10V @ 4860 MHzCurrently NULL[Jy]
25i_18000float8NOlog10I @ 18000 MHz [Jy]
26q_18000float8YESlog10Q @ 18000 MHzCurrently NULL[Jy]
27u_18000float8YESlog10U @ 18000 MHzCurrently NULL[Jy]
28v_18000float8YESlog10V @ 18000 MHzCurrently NULL[Jy]

Clusters table

ColumnAttributeTypeNULLDescriptionCommentsUnits
1clusterint10NOCluster indexIdentical in source and cluster tables 
2right_ascensionfloat8NOX position [degrees]
3declinationfloat8NOY position [degrees]
4redshiftfloat8NORedshiftCosmological 
5redshiftfloat8NOModified RedshiftCosmological 
6virial_massfloat8NOMass  
7virial_radiusfloat8NOVirial Radius  
8velocity_dispersionfloat8NOVelocity Dispersion