turbomam / biosample-xmldb-sqldb Goto Github PK

-- DROP SCHEMA public;

CREATE SCHEMA public AUTHORIZATION pg_database_owner;
-- public.entailed_edge definition

-- Drop table

-- DROP TABLE public.entailed_edge;

CREATE TABLE public.entailed_edge (
	subject text NULL,
	predicate text NULL,
	"object" text NULL
);
CREATE INDEX idx_190378_entailed_edge_sp ON public.entailed_edge USING btree (subject, predicate);
CREATE INDEX idx_190378_entailed_edge_spo ON public.entailed_edge USING btree (subject, predicate, object);


-- public.gold_sequencing_project definition

-- Drop table

-- DROP TABLE public.gold_sequencing_project;

CREATE TABLE public.gold_sequencing_project (
	project_gold_id text NULL,
	project_name text NULL,
	sequencing_strategy text NULL,
	its_proposal_id float8 NULL,
	its_sequencing_project_id float8 NULL,
	its_sample_id float8 NULL,
	pmo_project_id float8 NULL,
	ncbi_bioproject_accession text NULL,
	ncbi_biosample_accession text NULL,
	sra_experiment_ids text NULL,
	project_genome_publication_pubmed_id text NULL,
	project_other_publication_pubmed_id text NULL,
	project_status text NULL,
	sequencing_status text NULL,
	sequencing_centers text NULL,
	project_funding text NULL,
	project_legacy_gold_id text NULL,
	study_gold_id text NULL,
	organism_gold_id text NULL,
	biosample_gold_id text NULL,
	project_contacts text NULL,
	project_jgi_data_utilization_status text NULL,
	project_jgi_award_dois text NULL
);
CREATE INDEX gold_sequencing_project_ncbi_biosample_accession_idx ON public.gold_sequencing_project USING btree (ncbi_biosample_accession, biosample_gold_id, project_gold_id, ncbi_bioproject_accession);


-- public.insdc_country_values definition

-- Drop table

-- DROP TABLE public.insdc_country_values;

CREATE TABLE public.insdc_country_values (
	insdc_country text NULL
);
CREATE INDEX insdc_country_values_insdc_country_idx ON public.insdc_country_values USING btree (insdc_country);


-- public.insdc_missing_data_list definition

-- Drop table

-- DROP TABLE public.insdc_missing_data_list;

CREATE TABLE public.insdc_missing_data_list (
	missing_value_term varchar NULL
);
CREATE INDEX insdc_missing_data_list_missing_value_term_idx ON public.insdc_missing_data_list USING btree (missing_value_term);


-- public.insdc_missing_data_table definition

-- Drop table

-- DROP TABLE public.insdc_missing_data_table;

CREATE TABLE public.insdc_missing_data_table (
	top_level text NULL,
	lower_level text NULL,
	lower_level_definition text NULL,
	reporting_level text NULL,
	reporting_definition text NULL
);
CREATE INDEX insdc_missing_data_table_top_level_idx ON public.insdc_missing_data_table USING btree (top_level, lower_level, reporting_level);


-- public.mixs_class_definitions definition

-- Drop table

-- DROP TABLE public.mixs_class_definitions;

CREATE TABLE public.mixs_class_definitions (
	"class" text NULL,
	aliases text NULL,
	class_uri text NULL,
	"comments" text NULL,
	description text NULL,
	from_schema text NULL,
	in_subset text NULL,
	is_a text NULL,
	mixin text NULL,
	mixins text NULL,
	title text NULL,
	tree_root text NULL
);
CREATE INDEX mixs_class_definitions_class_idx ON public.mixs_class_definitions USING btree (class, class_uri, is_a, mixins);


-- public.mixs_global_slots definition

-- Drop table

-- DROP TABLE public.mixs_global_slots;

CREATE TABLE public.mixs_global_slots (
	slot text NULL,
	"examples values" text NULL,
	structured_pattern text NULL,
	"Expected_value" text NULL,
	"Preferred_unit" text NULL,
	"comments" text NULL,
	description text NULL,
	from_schema text NULL,
	in_subset text NULL,
	keywords text NULL,
	multivalued text NULL,
	pattern text NULL,
	"range" text NULL,
	recommended text NULL,
	required text NULL,
	slot_uri text NULL,
	string_serialization text NULL,
	title text NULL
);
CREATE INDEX mixs_global_slots_slot_idx ON public.mixs_global_slots USING btree (slot, in_subset, range, recommended, required, slot_uri, title);


-- public.ncbi_attributes_all_long definition

-- Drop table

-- DROP TABLE public.ncbi_attributes_all_long;

CREATE TABLE public.ncbi_attributes_all_long (
	raw_id int8 NULL,
	attribute_name text NULL,
	harmonized_name text NULL,
	display_name text NULL,
	unit text NULL,
	value text NULL
);
CREATE INDEX names_fts ON public.ncbi_attributes_all_long USING gin (to_tsvector('english'::regconfig, ((((attribute_name || ' '::text) || harmonized_name) || ' '::text) || display_name)));
CREATE INDEX ncbi_attributes_all_long_harmonized_name_idx ON public.ncbi_attributes_all_long USING btree (harmonized_name);
CREATE INDEX ncbi_attributes_all_long_raw_id_idx ON public.ncbi_attributes_all_long USING btree (raw_id);
CREATE INDEX value_fts ON public.ncbi_attributes_all_long USING gin (to_tsvector('english'::regconfig, value));


-- public.ncbi_attributes_harmonized_wide definition

-- Drop table

-- DROP TABLE public.ncbi_attributes_harmonized_wide;

CREATE TABLE public.ncbi_attributes_harmonized_wide (
	raw_id int4 NOT NULL,
	abs_air_humidity text NULL,
	additional_info text NULL,
	add_recov_method text NULL,
	address text NULL,
	adjacent_environment text NULL,
	adj_room text NULL,
	affection_status text NULL,
	age text NULL,
	agrochem_addition text NULL,
	air_pm_concen text NULL,
	air_temp text NULL,
	air_temp_regm text NULL,
	alkalinity text NULL,
	alkalinity_method text NULL,
	alkyl_diethers text NULL,
	al_sat text NULL,
	al_sat_meth text NULL,
	altitude text NULL,
	aminopept_act text NULL,
	ammonium text NULL,
	amniotic_fluid_color text NULL,
	analyte_type text NULL,
	anamorph text NULL,
	ances_data text NULL,
	animal_body_cond text NULL,
	animal_diet text NULL,
	animal_env text NULL,
	animal_intrusion text NULL,
	animal_sex text NULL,
	anim_water_method text NULL,
	annual_precpt text NULL,
	annual_season_precpt text NULL,
	annual_season_temp text NULL,
	annual_temp text NULL,
	antibiotic_regm text NULL,
	antiviral_treatment_agent text NULL,
	api text NULL,
	area_samp_size text NULL,
	association_duration text NULL,
	atmospheric_data text NULL,
	authority text NULL,
	avg_occup text NULL,
	avg_temp text NULL,
	bac_prod text NULL,
	bac_resp text NULL,
	bacteria_carb_prod text NULL,
	bacterial_density text NULL,
	barometric_press text NULL,
	basin_name text NULL,
	benzene text NULL,
	beta_lactamase_family text NULL,
	biochem_oxygen_dem text NULL,
	biocide_used text NULL,
	biol_stat text NULL,
	biomass text NULL,
	bio_material text NULL,
	biomaterial_provider text NULL,
	biospecimen_repository text NULL,
	biospecimen_repository_sample_id text NULL,
	biotic_regm text NULL,
	biotic_relationship text NULL,
	biovar text NULL,
	birth_control text NULL,
	birth_date text NULL,
	birth_location text NULL,
	bishomohopanol text NULL,
	blood_blood_disord text NULL,
	blood_press_diast text NULL,
	blood_press_syst text NULL,
	body_habitat text NULL,
	body_mass_index text NULL,
	body_product text NULL,
	breed text NULL,
	breeding_history text NULL,
	breeding_method text NULL,
	bromide text NULL,
	building_setting text NULL,
	build_occup_type text NULL,
	calcium text NULL,
	carbapenemase text NULL,
	carb_dioxide text NULL,
	carb_nitro_ratio text NULL,
	cell_line text NULL,
	cell_subtype text NULL,
	cell_type text NULL,
	chem_administration text NULL,
	chem_mutagen text NULL,
	chem_oxygen_dem text NULL,
	chem_treatment text NULL,
	child_of text NULL,
	chloride text NULL,
	chlorophyll text NULL,
	climate_environment text NULL,
	clone text NULL,
	clone_lib text NULL,
	collected_by text NULL,
	collection_date text NULL,
	collection_device text NULL,
	collection_method text NULL,
	coll_site_geo_feat text NULL,
	component_organism text NULL,
	compound text NULL,
	conduc text NULL,
	cons_food_stor_dur text NULL,
	cons_food_stor_temp text NULL,
	cons_purch_date text NULL,
	cons_qty_purchased text NULL,
	crop_rotation text NULL,
	crop_yield text NULL,
	cult_isol_date text NULL,
	cultivar text NULL,
	cult_result text NULL,
	cult_result_org text NULL,
	cult_root_med text NULL,
	cult_target text NULL,
	culture_collection text NULL,
	cur_land_use text NULL,
	cur_vegetation text NULL,
	cur_vegetation_meth text NULL,
	date_of_prior_antiviral_treat text NULL,
	date_of_prior_sars_cov_2_infection text NULL,
	date_of_sars_cov_2_vaccination text NULL,
	death_date text NULL,
	density text NULL,
	"depth" text NULL,
	derived_from text NULL,
	dermatology_disord text NULL,
	description text NULL,
	dev_stage text NULL,
	dew_point text NULL,
	diet text NULL,
	dietary_claim_use text NULL,
	diether_lipids text NULL,
	diet_last_six_month text NULL,
	disease text NULL,
	disease_stage text NULL,
	diss_carb_dioxide text NULL,
	diss_hydrogen text NULL,
	diss_inorg_carb text NULL,
	diss_inorg_nitro text NULL,
	diss_inorg_phosp text NULL,
	diss_org_carb text NULL,
	diss_org_nitro text NULL,
	diss_oxygen text NULL,
	dominant_hand text NULL,
	dose text NULL,
	douche text NULL,
	down_par text NULL,
	drainage_class text NULL,
	drug_usage text NULL,
	dry_mass text NULL,
	ecotype text NULL,
	edta_inhibitor_tested text NULL,
	efficiency_percent text NULL,
	elev text NULL,
	emulsions text NULL,
	encoded_traits text NULL,
	enrichment_protocol text NULL,
	env_broad_scale text NULL,
	env_local_scale text NULL,
	env_medium text NULL,
	env_monitoring_zone text NULL,
	env_package text NULL,
	estimated_size text NULL,
	ethnicity text NULL,
	ethylbenzene text NULL,
	experimental_factor text NULL,
	exposure_event text NULL,
	extrachrom_elements text NULL,
	extreme_event text NULL,
	extreme_salinity text NULL,
	extr_weather_event text NULL,
	facility_type text NULL,
	family_id text NULL,
	family_relationship text NULL,
	fao_class text NULL,
	farm_equip text NULL,
	farm_equip_san text NULL,
	farm_equip_shared text NULL,
	farm_water_source text NULL,
	ferm_medium text NULL,
	ferm_ph text NULL,
	ferm_temp text NULL,
	ferm_time text NULL,
	ferm_vessel text NULL,
	fertilizer_admin text NULL,
	fertilizer_regm text NULL,
	field text NULL,
	filter_type text NULL,
	fire text NULL,
	flooding text NULL,
	fluor text NULL,
	foetal_health_stat text NULL,
	food_additive text NULL,
	food_allergen_label text NULL,
	food_contact_surf text NULL,
	food_contain_wrap text NULL,
	food_cooking_proc text NULL,
	food_dis_point text NULL,
	food_dis_point_city text NULL,
	food_harvest_proc text NULL,
	food_industry_class text NULL,
	food_industry_code text NULL,
	food_ingredient text NULL,
	food_name_status text NULL,
	food_origin text NULL,
	food_pack_capacity text NULL,
	food_pack_integrity text NULL,
	food_pack_medium text NULL,
	food_preserv_proc text NULL,
	food_prior_contact text NULL,
	food_processing_method text NULL,
	food_prod text NULL,
	food_prod_char text NULL,
	food_prod_synonym text NULL,
	food_product_qual text NULL,
	food_product_type text NULL,
	food_quality_date text NULL,
	food_source text NULL,
	food_trace_list text NULL,
	food_trav_mode text NULL,
	food_trav_vehic text NULL,
	food_treat_proc text NULL,
	food_type_processed text NULL,
	forma text NULL,
	forma_specialis text NULL,
	freq_clean text NULL,
	fungicide_regm text NULL,
	gap_accession text NULL,
	gap_consent_code text NULL,
	gap_consent_short_name text NULL,
	gap_sample_id text NULL,
	gap_subject_id text NULL,
	gaseous_environment text NULL,
	gaseous_substances text NULL,
	gastrointest_disord text NULL,
	gender_restroom text NULL,
	genetic_mod text NULL,
	genotype text NULL,
	geo_loc_exposure text NULL,
	geo_loc_name text NULL,
	gestation_state text NULL,
	gisaid_accession text NULL,
	gisaid_virus_name text NULL,
	glucosidase_act text NULL,
	gravidity text NULL,
	gravity text NULL,
	growth_facil text NULL,
	growth_habit text NULL,
	growth_hormone_regm text NULL,
	growth_med text NULL,
	growth_medium text NULL,
	growth_protocol text NULL,
	gynecologic_disord text NULL,
	haccp_term text NULL,
	haplotype text NULL,
	hc_produced text NULL,
	hcr text NULL,
	hcr_temp text NULL,
	health_state text NULL,
	heat_cool_type text NULL,
	heavy_metals text NULL,
	heavy_metals_meth text NULL,
	height_or_length text NULL,
	herbicide_regm text NULL,
	histological_type text NULL,
	hiv_stat text NULL,
	horizon_meth text NULL,
	host text NULL,
	host_age text NULL,
	host_am text NULL,
	host_anatomical_material text NULL,
	host_anatomical_part text NULL,
	host_animal_breed text NULL,
	host_blood_press_diast text NULL,
	host_blood_press_syst text NULL,
	host_body_habitat text NULL,
	host_body_mass_index text NULL,
	host_body_product text NULL,
	host_body_temp text NULL,
	host_cellular_loc text NULL,
	host_color text NULL,
	host_common_name text NULL,
	host_dependence text NULL,
	host_description text NULL,
	host_diet text NULL,
	host_disease text NULL,
	host_disease_outcome text NULL,
	host_disease_stage text NULL,
	host_dry_mass text NULL,
	host_family_relationship text NULL,
	host_genotype text NULL,
	host_group_size text NULL,
	host_growth_cond text NULL,
	host_health_state text NULL,
	host_height text NULL,
	host_hiv_stat text NULL,
	host_housing text NULL,
	host_infra_specific_name text NULL,
	host_infra_specific_rank text NULL,
	host_last_meal text NULL,
	host_length text NULL,
	host_life_stage text NULL,
	host_number text NULL,
	host_occupation text NULL,
	host_of_host_sub_id text NULL,
	host_phenotype text NULL,
	host_pulse text NULL,
	host_recent_travel_loc text NULL,
	host_recent_travel_return_date text NULL,
	host_sex text NULL,
	host_shape text NULL,
	host_specificity text NULL,
	host_specimen_voucher text NULL,
	host_subject_id text NULL,
	host_subspecf_genlin text NULL,
	host_substrate text NULL,
	host_symbiont text NULL,
	host_taxid text NULL,
	host_tissue_sampled text NULL,
	host_tot_mass text NULL,
	host_variety text NULL,
	host_wet_mass text NULL,
	hrt text NULL,
	humidity text NULL,
	humidity_regm text NULL,
	hygienic_area text NULL,
	hysterectomy text NULL,
	identified_by text NULL,
	ifsac_category text NULL,
	ihmc_medication_code text NULL,
	image_file text NULL,
	indoor_space text NULL,
	indoor_surf text NULL,
	indoor_surf_subpart text NULL,
	indust_eff_percent text NULL,
	infra_specific_name text NULL,
	infra_specific_rank text NULL,
	inorg_particles text NULL,
	intended_consumer text NULL,
	investigation_type text NULL,
	isolate text NULL,
	isolate_name_alias text NULL,
	isolation_source text NULL,
	isol_growth_condt text NULL,
	is_tumor text NULL,
	iwf text NULL,
	karyotype text NULL,
	kidney_disord text NULL,
	"label" text NULL,
	label_claims text NULL,
	lab_host text NULL,
	last_meal text NULL,
	lat_lon text NULL,
	life_stage text NULL,
	light_intensity text NULL,
	light_regm text NULL,
	light_type text NULL,
	link_addit_analys text NULL,
	link_class_info text NULL,
	link_climate_info text NULL,
	lithology text NULL,
	liver_disord text NULL,
	local_class text NULL,
	local_class_meth text NULL,
	location_in_facility text NULL,
	lot_number text NULL,
	magnesium text NULL,
	material_condition text NULL,
	maternal_health_stat text NULL,
	mating_type text NULL,
	mean_frict_vel text NULL,
	mean_peak_frict_vel text NULL,
	mechanical_damage text NULL,
	medic_hist_perform text NULL,
	menarche text NULL,
	menopause text NULL,
	metagenome_source text NULL,
	methane text NULL,
	microb_cult_med text NULL,
	microbial_biomass text NULL,
	microbial_biomass_meth text NULL,
	mineral_nutr_regm text NULL,
	misc_param text NULL,
	mode_transmission text NULL,
	molecular_data_type text NULL,
	morphology text NULL,
	n_alkanes text NULL,
	narms_isolate_number text NULL,
	neg_cont_type text NULL,
	nitrate text NULL,
	nitrite text NULL,
	nitro text NULL,
	non_mineral_nutr_regm text NULL,
	nose_mouth_teeth_throat_disord text NULL,
	nose_throat_disord text NULL,
	number_pets text NULL,
	num_replicons text NULL,
	num_samp_collect text NULL,
	occupant_dens_samp text NULL,
	occupation text NULL,
	occup_samp text NULL,
	omics_observ_id text NULL,
	organism_count text NULL,
	org_carb text NULL,
	org_matter text NULL,
	orgmod_note text NULL,
	org_nitro text NULL,
	org_particles text NULL,
	original_subject_id text NULL,
	outbreak text NULL,
	oxygen text NULL,
	oxy_stat_samp text NULL,
	particle_class text NULL,
	part_org_carb text NULL,
	part_org_nitro text NULL,
	part_plant_animal text NULL,
	passage_history text NULL,
	passage_method text NULL,
	passage_number text NULL,
	pathogenicity text NULL,
	pathotype text NULL,
	pathovar text NULL,
	permeability text NULL,
	perturbation text NULL,
	pesticide_regm text NULL,
	pet_farm_animal text NULL,
	petroleum_hydrocarb text NULL,
	ph text NULL,
	phaeopigments text NULL,
	phenotype text NULL,
	ph_meth text NULL,
	phosphate text NULL,
	phosplipid_fatt_acid text NULL,
	photon_flux text NULL,
	photosynt_activ text NULL,
	photosynt_activ_meth text NULL,
	ph_regm text NULL,
	plant_body_site text NULL,
	plant_growth_med text NULL,
	plant_product text NULL,
	plant_sex text NULL,
	plant_struc text NULL,
	plant_water_method text NULL,
	ploidy text NULL,
	pollutants text NULL,
	pool_dna_extracts text NULL,
	population text NULL,
	population_description text NULL,
	porosity text NULL,
	pos_cont_type text NULL,
	potassium text NULL,
	pregnancy text NULL,
	pres_animal_insect text NULL,
	pressure text NULL,
	pre_treatment text NULL,
	previous_land_use text NULL,
	previous_land_use_meth text NULL,
	primary_prod text NULL,
	primary_treatment text NULL,
	prior_sars_cov_2_antiviral_treat text NULL,
	prior_sars_cov_2_infection text NULL,
	prior_sars_cov_2_vaccination text NULL,
	prod_label_claims text NULL,
	profile_position text NULL,
	project_name text NULL,
	propagation text NULL,
	pulmonary_disord text NULL,
	pulse text NULL,
	purpose_of_sampling text NULL,
	purpose_of_sequencing text NULL,
	purpose_of_ww_sampling text NULL,
	purpose_of_ww_sequencing text NULL,
	race text NULL,
	radiation_regm text NULL,
	rainfall_regm text NULL,
	reactor_type text NULL,
	redox_potential text NULL,
	ref_biomaterial text NULL,
	reference_material text NULL,
	rel_air_humidity text NULL,
	rel_location text NULL,
	rel_to_oxygen text NULL,
	repository text NULL,
	risk_group text NULL,
	room_type text NULL,
	root_cond text NULL,
	root_med_carbon text NULL,
	root_med_macronutr text NULL,
	root_med_micronutr text NULL,
	root_med_ph text NULL,
	root_med_regl text NULL,
	root_med_solid text NULL,
	root_med_suppl text NULL,
	route_transmission text NULL,
	salinity text NULL,
	salinity_meth text NULL,
	salt_regm text NULL,
	same_as text NULL,
	samp_capt_status text NULL,
	samp_collect_device text NULL,
	samp_collect_method text NULL,
	samp_collect_point text NULL,
	samp_dis_stage text NULL,
	sample_name text NULL,
	sample_type text NULL,
	samp_mat_process text NULL,
	samp_mat_type text NULL,
	samp_pooling text NULL,
	samp_rep_biol text NULL,
	samp_rep_tech text NULL,
	samp_salinity text NULL,
	samp_size text NULL,
	samp_sort_meth text NULL,
	samp_source_mat_cat text NULL,
	samp_stor_device text NULL,
	samp_store_dur text NULL,
	samp_store_loc text NULL,
	samp_store_sol text NULL,
	samp_store_temp text NULL,
	samp_stor_media text NULL,
	samp_subtype text NULL,
	samp_transport_temp text NULL,
	samp_vol_we_dna_ext text NULL,
	sars_cov_2_diag_gene_name_1 text NULL,
	sars_cov_2_diag_gene_name_2 text NULL,
	sars_cov_2_diag_pcr_ct_value_1 text NULL,
	sars_cov_2_diag_pcr_ct_value_2 text NULL,
	season text NULL,
	season_environment text NULL,
	season_humidity text NULL,
	season_precpt text NULL,
	season_temp text NULL,
	secondary_treatment text NULL,
	sediment_type text NULL,
	sequenced_by text NULL,
	serogroup text NULL,
	serotype text NULL,
	serovar text NULL,
	sewage_type text NULL,
	sex text NULL,
	sexual_act text NULL,
	sieving text NULL,
	silicate text NULL,
	size_frac text NULL,
	size_frac_low text NULL,
	size_frac_up text NULL,
	slope_aspect text NULL,
	slope_gradient text NULL,
	sludge_retent_time text NULL,
	smoker text NULL,
	sodium text NULL,
	soil_conductivity text NULL,
	soil_cover text NULL,
	soil_depth text NULL,
	soil_horizon text NULL,
	soil_ph text NULL,
	soil_temp text NULL,
	soil_text_measure text NULL,
	soil_texture_class text NULL,
	soil_texture_meth text NULL,
	soil_type text NULL,
	soil_type_meth text NULL,
	solar_irradiance text NULL,
	soluble_inorg_mat text NULL,
	soluble_org_mat text NULL,
	soluble_react_phosp text NULL,
	source_material_id text NULL,
	source_name text NULL,
	source_type text NULL,
	source_uvig text NULL,
	space_typ_state text NULL,
	special_diet text NULL,
	"specific" text NULL,
	specimen_voucher text NULL,
	spec_intended_cons text NULL,
	spikein_count text NULL,
	spikein_org text NULL,
	spikein_strain text NULL,
	standing_water_regm text NULL,
	store_cond text NULL,
	strain text NULL,
	stud_book_number text NULL,
	study_complt_stat text NULL,
	study_design text NULL,
	study_disease text NULL,
	study_inc_dur text NULL,
	study_inc_temp text NULL,
	study_name text NULL,
	study_tmnt text NULL,
	subclone text NULL,
	subgroup text NULL,
	subject_is_affected text NULL,
	submitted_sample_id text NULL,
	submitted_subject_id text NULL,
	submitter_handle text NULL,
	subspecf_gen_lin text NULL,
	sub_species text NULL,
	subsrc_note text NULL,
	substrain text NULL,
	substrate text NULL,
	substructure_type text NULL,
	subtype text NULL,
	sulfate text NULL,
	sulfate_fw text NULL,
	sulfide text NULL,
	super_population_code text NULL,
	super_population_description text NULL,
	surface_orientation text NULL,
	surf_air_cont text NULL,
	surf_humidity text NULL,
	surf_material text NULL,
	surf_moisture text NULL,
	surf_moisture_ph text NULL,
	surf_temp text NULL,
	suspend_part_matter text NULL,
	suspend_solids text NULL,
	sym_life_cycle_type text NULL,
	tan text NULL,
	teleomorph text NULL,
	"temp" text NULL,
	tertiary_treatment text NULL,
	tidal_stage text NULL,
	tillage text NULL,
	time_last_toothbrush text NULL,
	timepoint text NULL,
	time_since_last_wash text NULL,
	tiss_cult_growth_med text NULL,
	tissue text NULL,
	tissue_lib text NULL,
	toluene text NULL,
	tot_carb text NULL,
	tot_depth_water_col text NULL,
	tot_diss_nitro text NULL,
	tot_inorg_nitro text NULL,
	tot_iron text NULL,
	tot_mass text NULL,
	tot_nitro text NULL,
	tot_nitro_cont_meth text NULL,
	tot_n_meth text NULL,
	tot_org_carb text NULL,
	tot_org_c_meth text NULL,
	tot_part_carb text NULL,
	tot_phosp text NULL,
	tot_phosphate text NULL,
	tot_sulfur text NULL,
	train_line text NULL,
	travel_out_six_month text NULL,
	treatment text NULL,
	trophic_level text NULL,
	turbidity text NULL,
	twin_sibling text NULL,
	type_of_symbiosis text NULL,
	type_status text NULL,
	type_strain text NULL,
	typ_occupant_dens text NULL,
	upstream_intervention text NULL,
	urine_collect_meth text NULL,
	urogenit_disord text NULL,
	urogenit_tract_disor text NULL,
	vaccine_received text NULL,
	variety text NULL,
	ventilation_rate text NULL,
	ventilation_type text NULL,
	vfa text NULL,
	vfa_fw text NULL,
	virus_enrich_appr text NULL,
	virus_isolate_of_prior_infection text NULL,
	volatile_org_comp text NULL,
	wastewater_type text NULL,
	water_content text NULL,
	water_content_soil text NULL,
	water_content_soil_meth text NULL,
	water_current text NULL,
	water_cut text NULL,
	watering_regm text NULL,
	water_ph text NULL,
	water_source_shared text NULL,
	water_temp_regm text NULL,
	weekday text NULL,
	weight_loss_3_month text NULL,
	wet_mass text NULL,
	wga_amp_appr text NULL,
	wind_direction text NULL,
	window_open_freq text NULL,
	wind_speed text NULL,
	ww_endog_control_1 text NULL,
	ww_endog_control_1_conc text NULL,
	ww_endog_control_1_protocol text NULL,
	ww_endog_control_1_units text NULL,
	ww_endog_control_2 text NULL,
	ww_endog_control_2_conc text NULL,
	ww_endog_control_2_protocol text NULL,
	ww_endog_control_2_units text NULL,
	ww_flow text NULL,
	ww_industrial_effluent_percent text NULL,
	ww_ph text NULL,
	ww_population text NULL,
	ww_population_source text NULL,
	ww_pre_treatment text NULL,
	ww_primary_sludge_retention_time text NULL,
	ww_processing_protocol text NULL,
	ww_sample_duration text NULL,
	ww_sample_matrix text NULL,
	ww_sample_salinity text NULL,
	ww_sample_site text NULL,
	ww_sample_type text NULL,
	ww_surv_jurisdiction text NULL,
	ww_surv_system_sample_id text NULL,
	ww_surv_target_1 text NULL,
	ww_surv_target_1_conc text NULL,
	ww_surv_target_1_conc_unit text NULL,
	ww_surv_target_1_extract text NULL,
	ww_surv_target_1_extract_unit text NULL,
	ww_surv_target_1_gene text NULL,
	ww_surv_target_1_known_present text NULL,
	ww_surv_target_1_protocol text NULL,
	ww_surv_target_2 text NULL,
	ww_surv_target_2_conc text NULL,
	ww_surv_target_2_conc_unit text NULL,
	ww_surv_target_2_extract text NULL,
	ww_surv_target_2_extract_unit text NULL,
	ww_surv_target_2_gene text NULL,
	ww_surv_target_2_known_present text NULL,
	ww_surv_target_2_protocol text NULL,
	ww_temperature text NULL,
	ww_total_suspended_solids text NULL,
	CONSTRAINT ncbi_attributes_harmonized_wide_pkey PRIMARY KEY (raw_id)
);


-- public.ncbi_metagenomes definition

-- Drop table

-- DROP TABLE public.ncbi_metagenomes;

CREATE TABLE public.ncbi_metagenomes (
	taxon_id int4 NOT NULL,
	description text NULL,
	CONSTRAINT ncbi_metagenomes_pkey PRIMARY KEY (taxon_id)
);
CREATE INDEX ncbi_metagenomes_taxon_id_idx ON public.ncbi_metagenomes USING btree (taxon_id);


-- public.ncbi_mixs_class_mappings definition

-- Drop table

-- DROP TABLE public.ncbi_mixs_class_mappings;

CREATE TABLE public.ncbi_mixs_class_mappings (
	ncbi text NULL,
	mixs text NULL
);
CREATE INDEX ncbi_mixs_class_mappings_ncbi_idx ON public.ncbi_mixs_class_mappings USING btree (ncbi, mixs);


-- public.ncbi_package_attribute_use definition

-- Drop table

-- DROP TABLE public.ncbi_package_attribute_use;

CREATE TABLE public.ncbi_package_attribute_use (
	attribute_harmonized_name text NULL,
	package text NULL,
	use text NULL
);
CREATE INDEX ncbi_package_attribute_use_attribute_harmonized_name_idx ON public.ncbi_package_attribute_use USING btree (attribute_harmonized_name, package, use);


-- public.ncbi_package_definitions definition

-- Drop table

-- DROP TABLE public.ncbi_package_definitions;

CREATE TABLE public.ncbi_package_definitions (
	"Name" text NULL,
	"DisplayName" text NULL,
	"EnvPackage" text NULL,
	"EnvPackageDisplay" text NULL,
	"Example" text NULL,
	"NotAppropriateFor" text NULL,
	"ShortName" text NULL,
	"group" text NULL,
	"Description" text NULL,
	"attributes" text NULL
);
CREATE INDEX ncbi_package_definitions_name_idx ON public.ncbi_package_definitions USING btree ("Name", "DisplayName", "EnvPackage", "EnvPackageDisplay", "ShortName", "group");


-- public.non_attribute_metadata definition

-- Drop table

-- DROP TABLE public.non_attribute_metadata;

CREATE TABLE public.non_attribute_metadata (
	raw_id int8 NOT NULL,
	accession text NOT NULL,
	bp_id text NULL,
	contributors text NOT NULL,
	model text NOT NULL,
	owner_abbreviation text NULL,
	owner_text text NULL,
	owner_url text NULL,
	package text NOT NULL,
	package_name text NOT NULL,
	paragraph text NULL,
	prefixed_id text NOT NULL,
	primary_id text NOT NULL,
	samp_name text NULL,
	sra_id text NULL,
	status text NULL,
	status_date text NULL,
	synonym text NULL,
	table_caption text NULL,
	taxonomy_id text NULL,
	taxonomy_name text NULL,
	title text NULL
);
CREATE UNIQUE INDEX non_attribute_metadata_accession_idx ON public.non_attribute_metadata USING btree (accession);
CREATE INDEX non_attribute_metadata_bp_id_idx ON public.non_attribute_metadata USING btree (bp_id);
CREATE UNIQUE INDEX non_attribute_metadata_prefixed_id_idx ON public.non_attribute_metadata USING btree (prefixed_id);
CREATE UNIQUE INDEX non_attribute_metadata_primary_id_idx ON public.non_attribute_metadata USING btree (primary_id);
CREATE UNIQUE INDEX non_attribute_metadata_raw_id_idx ON public.non_attribute_metadata USING btree (raw_id);


-- public.prefix definition

-- Drop table

-- DROP TABLE public.prefix;

CREATE TABLE public.prefix (
	prefix text NULL,
	base text NULL
);


-- public.statements definition

-- Drop table

-- DROP TABLE public.statements;

CREATE TABLE public.statements (
	stanza text NULL,
	subject text NULL,
	predicate text NULL,
	"object" text NULL,
	value text NULL,
	"datatype" text NULL,
	"language" text NULL,
	graph text NULL
);
CREATE INDEX idx_190398_statements_p ON public.statements USING btree (predicate);
CREATE INDEX idx_190398_statements_spo ON public.statements USING btree (subject, predicate, object);
CREATE INDEX idx_190398_statements_spv ON public.statements USING btree (subject, predicate, value);


-- public.attributes_plus source

CREATE OR REPLACE VIEW public.attributes_plus
AS SELECT nam.accession,
    nam.bp_id,
    nam.contributors,
    nam.model,
    nam.owner_abbreviation,
    nam.owner_text,
    nam.owner_url,
    nam.package,
    nam.package_name,
    nam.paragraph,
    nam.prefixed_id,
    nam.primary_id,
    nam.samp_name,
    nam.sra_id,
    nam.status,
    nam.status_date,
    nam.synonym,
    nam.table_caption,
    nam.taxonomy_id,
    nam.taxonomy_name,
    nam.title,
    nahw.raw_id,
    nahw.abs_air_humidity,
    nahw.additional_info,
    nahw.add_recov_method,
    nahw.address,
    nahw.adjacent_environment,
    nahw.adj_room,
    nahw.affection_status,
    nahw.age,
    nahw.agrochem_addition,
    nahw.air_pm_concen,
    nahw.air_temp,
    nahw.air_temp_regm,
    nahw.alkalinity,
    nahw.alkalinity_method,
    nahw.alkyl_diethers,
    nahw.al_sat,
    nahw.al_sat_meth,
    nahw.altitude,
    nahw.aminopept_act,
    nahw.ammonium,
    nahw.amniotic_fluid_color,
    nahw.analyte_type,
    nahw.anamorph,
    nahw.ances_data,
    nahw.animal_body_cond,
    nahw.animal_diet,
    nahw.animal_env,
    nahw.animal_intrusion,
    nahw.animal_sex,
    nahw.anim_water_method,
    nahw.annual_precpt,
    nahw.annual_season_precpt,
    nahw.annual_season_temp,
    nahw.annual_temp,
    nahw.antibiotic_regm,
    nahw.antiviral_treatment_agent,
    nahw.api,
    nahw.area_samp_size,
    nahw.association_duration,
    nahw.atmospheric_data,
    nahw.authority,
    nahw.avg_occup,
    nahw.avg_temp,
    nahw.bac_prod,
    nahw.bac_resp,
    nahw.bacteria_carb_prod,
    nahw.bacterial_density,
    nahw.barometric_press,
    nahw.basin_name,
    nahw.benzene,
    nahw.beta_lactamase_family,
    nahw.biochem_oxygen_dem,
    nahw.biocide_used,
    nahw.biol_stat,
    nahw.biomass,
    nahw.bio_material,
    nahw.biomaterial_provider,
    nahw.biospecimen_repository,
    nahw.biospecimen_repository_sample_id,
    nahw.biotic_regm,
    nahw.biotic_relationship,
    nahw.biovar,
    nahw.birth_control,
    nahw.birth_date,
    nahw.birth_location,
    nahw.bishomohopanol,
    nahw.blood_blood_disord,
    nahw.blood_press_diast,
    nahw.blood_press_syst,
    nahw.body_habitat,
    nahw.body_mass_index,
    nahw.body_product,
    nahw.breed,
    nahw.breeding_history,
    nahw.breeding_method,
    nahw.bromide,
    nahw.building_setting,
    nahw.build_occup_type,
    nahw.calcium,
    nahw.carbapenemase,
    nahw.carb_dioxide,
    nahw.carb_nitro_ratio,
    nahw.cell_line,
    nahw.cell_subtype,
    nahw.cell_type,
    nahw.chem_administration,
    nahw.chem_mutagen,
    nahw.chem_oxygen_dem,
    nahw.chem_treatment,
    nahw.child_of,
    nahw.chloride,
    nahw.chlorophyll,
    nahw.climate_environment,
    nahw.clone,
    nahw.clone_lib,
    nahw.collected_by,
    nahw.collection_date,
    nahw.collection_device,
    nahw.collection_method,
    nahw.coll_site_geo_feat,
    nahw.component_organism,
    nahw.compound,
    nahw.conduc,
    nahw.cons_food_stor_dur,
    nahw.cons_food_stor_temp,
    nahw.cons_purch_date,
    nahw.cons_qty_purchased,
    nahw.crop_rotation,
    nahw.crop_yield,
    nahw.cult_isol_date,
    nahw.cultivar,
    nahw.cult_result,
    nahw.cult_result_org,
    nahw.cult_root_med,
    nahw.cult_target,
    nahw.culture_collection,
    nahw.cur_land_use,
    nahw.cur_vegetation,
    nahw.cur_vegetation_meth,
    nahw.date_of_prior_antiviral_treat,
    nahw.date_of_prior_sars_cov_2_infection,
    nahw.date_of_sars_cov_2_vaccination,
    nahw.death_date,
    nahw.density,
    nahw.depth,
    nahw.derived_from,
    nahw.dermatology_disord,
    nahw.description,
    nahw.dev_stage,
    nahw.dew_point,
    nahw.diet,
    nahw.dietary_claim_use,
    nahw.diether_lipids,
    nahw.diet_last_six_month,
    nahw.disease,
    nahw.disease_stage,
    nahw.diss_carb_dioxide,
    nahw.diss_hydrogen,
    nahw.diss_inorg_carb,
    nahw.diss_inorg_nitro,
    nahw.diss_inorg_phosp,
    nahw.diss_org_carb,
    nahw.diss_org_nitro,
    nahw.diss_oxygen,
    nahw.dominant_hand,
    nahw.dose,
    nahw.douche,
    nahw.down_par,
    nahw.drainage_class,
    nahw.drug_usage,
    nahw.dry_mass,
    nahw.ecotype,
    nahw.edta_inhibitor_tested,
    nahw.efficiency_percent,
    nahw.elev,
    nahw.emulsions,
    nahw.encoded_traits,
    nahw.enrichment_protocol,
    nahw.env_broad_scale,
    nahw.env_local_scale,
    nahw.env_medium,
    nahw.env_monitoring_zone,
    nahw.env_package,
    nahw.estimated_size,
    nahw.ethnicity,
    nahw.ethylbenzene,
    nahw.experimental_factor,
    nahw.exposure_event,
    nahw.extrachrom_elements,
    nahw.extreme_event,
    nahw.extreme_salinity,
    nahw.extr_weather_event,
    nahw.facility_type,
    nahw.family_id,
    nahw.family_relationship,
    nahw.fao_class,
    nahw.farm_equip,
    nahw.farm_equip_san,
    nahw.farm_equip_shared,
    nahw.farm_water_source,
    nahw.ferm_medium,
    nahw.ferm_ph,
    nahw.ferm_temp,
    nahw.ferm_time,
    nahw.ferm_vessel,
    nahw.fertilizer_admin,
    nahw.fertilizer_regm,
    nahw.field,
    nahw.filter_type,
    nahw.fire,
    nahw.flooding,
    nahw.fluor,
    nahw.foetal_health_stat,
    nahw.food_additive,
    nahw.food_allergen_label,
    nahw.food_contact_surf,
    nahw.food_contain_wrap,
    nahw.food_cooking_proc,
    nahw.food_dis_point,
    nahw.food_dis_point_city,
    nahw.food_harvest_proc,
    nahw.food_industry_class,
    nahw.food_industry_code,
    nahw.food_ingredient,
    nahw.food_name_status,
    nahw.food_origin,
    nahw.food_pack_capacity,
    nahw.food_pack_integrity,
    nahw.food_pack_medium,
    nahw.food_preserv_proc,
    nahw.food_prior_contact,
    nahw.food_processing_method,
    nahw.food_prod,
    nahw.food_prod_char,
    nahw.food_prod_synonym,
    nahw.food_product_qual,
    nahw.food_product_type,
    nahw.food_quality_date,
    nahw.food_source,
    nahw.food_trace_list,
    nahw.food_trav_mode,
    nahw.food_trav_vehic,
    nahw.food_treat_proc,
    nahw.food_type_processed,
    nahw.forma,
    nahw.forma_specialis,
    nahw.freq_clean,
    nahw.fungicide_regm,
    nahw.gap_accession,
    nahw.gap_consent_code,
    nahw.gap_consent_short_name,
    nahw.gap_sample_id,
    nahw.gap_subject_id,
    nahw.gaseous_environment,
    nahw.gaseous_substances,
    nahw.gastrointest_disord,
    nahw.gender_restroom,
    nahw.genetic_mod,
    nahw.genotype,
    nahw.geo_loc_exposure,
    nahw.geo_loc_name,
    nahw.gestation_state,
    nahw.gisaid_accession,
    nahw.gisaid_virus_name,
    nahw.glucosidase_act,
    nahw.gravidity,
    nahw.gravity,
    nahw.growth_facil,
    nahw.growth_habit,
    nahw.growth_hormone_regm,
    nahw.growth_med,
    nahw.growth_medium,
    nahw.growth_protocol,
    nahw.gynecologic_disord,
    nahw.haccp_term,
    nahw.haplotype,
    nahw.hc_produced,
    nahw.hcr,
    nahw.hcr_temp,
    nahw.health_state,
    nahw.heat_cool_type,
    nahw.heavy_metals,
    nahw.heavy_metals_meth,
    nahw.height_or_length,
    nahw.herbicide_regm,
    nahw.histological_type,
    nahw.hiv_stat,
    nahw.horizon_meth,
    nahw.host,
    nahw.host_age,
    nahw.host_am,
    nahw.host_anatomical_material,
    nahw.host_anatomical_part,
    nahw.host_animal_breed,
    nahw.host_blood_press_diast,
    nahw.host_blood_press_syst,
    nahw.host_body_habitat,
    nahw.host_body_mass_index,
    nahw.host_body_product,
    nahw.host_body_temp,
    nahw.host_cellular_loc,
    nahw.host_color,
    nahw.host_common_name,
    nahw.host_dependence,
    nahw.host_description,
    nahw.host_diet,
    nahw.host_disease,
    nahw.host_disease_outcome,
    nahw.host_disease_stage,
    nahw.host_dry_mass,
    nahw.host_family_relationship,
    nahw.host_genotype,
    nahw.host_group_size,
    nahw.host_growth_cond,
    nahw.host_health_state,
    nahw.host_height,
    nahw.host_hiv_stat,
    nahw.host_housing,
    nahw.host_infra_specific_name,
    nahw.host_infra_specific_rank,
    nahw.host_last_meal,
    nahw.host_length,
    nahw.host_life_stage,
    nahw.host_number,
    nahw.host_occupation,
    nahw.host_of_host_sub_id,
    nahw.host_phenotype,
    nahw.host_pulse,
    nahw.host_recent_travel_loc,
    nahw.host_recent_travel_return_date,
    nahw.host_sex,
    nahw.host_shape,
    nahw.host_specificity,
    nahw.host_specimen_voucher,
    nahw.host_subject_id,
    nahw.host_subspecf_genlin,
    nahw.host_substrate,
    nahw.host_symbiont,
    nahw.host_taxid,
    nahw.host_tissue_sampled,
    nahw.host_tot_mass,
    nahw.host_variety,
    nahw.host_wet_mass,
    nahw.hrt,
    nahw.humidity,
    nahw.humidity_regm,
    nahw.hygienic_area,
    nahw.hysterectomy,
    nahw.identified_by,
    nahw.ifsac_category,
    nahw.ihmc_medication_code,
    nahw.image_file,
    nahw.indoor_space,
    nahw.indoor_surf,
    nahw.indoor_surf_subpart,
    nahw.indust_eff_percent,
    nahw.infra_specific_name,
    nahw.infra_specific_rank,
    nahw.inorg_particles,
    nahw.intended_consumer,
    nahw.investigation_type,
    nahw.isolate,
    nahw.isolate_name_alias,
    nahw.isolation_source,
    nahw.isol_growth_condt,
    nahw.is_tumor,
    nahw.iwf,
    nahw.karyotype,
    nahw.kidney_disord,
    nahw.label,
    nahw.label_claims,
    nahw.lab_host,
    nahw.last_meal,
    nahw.lat_lon,
    nahw.life_stage,
    nahw.light_intensity,
    nahw.light_regm,
    nahw.light_type,
    nahw.link_addit_analys,
    nahw.link_class_info,
    nahw.link_climate_info,
    nahw.lithology,
    nahw.liver_disord,
    nahw.local_class,
    nahw.local_class_meth,
    nahw.location_in_facility,
    nahw.lot_number,
    nahw.magnesium,
    nahw.material_condition,
    nahw.maternal_health_stat,
    nahw.mating_type,
    nahw.mean_frict_vel,
    nahw.mean_peak_frict_vel,
    nahw.mechanical_damage,
    nahw.medic_hist_perform,
    nahw.menarche,
    nahw.menopause,
    nahw.metagenome_source,
    nahw.methane,
    nahw.microb_cult_med,
    nahw.microbial_biomass,
    nahw.microbial_biomass_meth,
    nahw.mineral_nutr_regm,
    nahw.misc_param,
    nahw.mode_transmission,
    nahw.molecular_data_type,
    nahw.morphology,
    nahw.n_alkanes,
    nahw.narms_isolate_number,
    nahw.neg_cont_type,
    nahw.nitrate,
    nahw.nitrite,
    nahw.nitro,
    nahw.non_mineral_nutr_regm,
    nahw.nose_mouth_teeth_throat_disord,
    nahw.nose_throat_disord,
    nahw.number_pets,
    nahw.num_replicons,
    nahw.num_samp_collect,
    nahw.occupant_dens_samp,
    nahw.occupation,
    nahw.occup_samp,
    nahw.omics_observ_id,
    nahw.organism_count,
    nahw.org_carb,
    nahw.org_matter,
    nahw.orgmod_note,
    nahw.org_nitro,
    nahw.org_particles,
    nahw.original_subject_id,
    nahw.outbreak,
    nahw.oxygen,
    nahw.oxy_stat_samp,
    nahw.particle_class,
    nahw.part_org_carb,
    nahw.part_org_nitro,
    nahw.part_plant_animal,
    nahw.passage_history,
    nahw.passage_method,
    nahw.passage_number,
    nahw.pathogenicity,
    nahw.pathotype,
    nahw.pathovar,
    nahw.permeability,
    nahw.perturbation,
    nahw.pesticide_regm,
    nahw.pet_farm_animal,
    nahw.petroleum_hydrocarb,
    nahw.ph,
    nahw.phaeopigments,
    nahw.phenotype,
    nahw.ph_meth,
    nahw.phosphate,
    nahw.phosplipid_fatt_acid,
    nahw.photon_flux,
    nahw.photosynt_activ,
    nahw.photosynt_activ_meth,
    nahw.ph_regm,
    nahw.plant_body_site,
    nahw.plant_growth_med,
    nahw.plant_product,
    nahw.plant_sex,
    nahw.plant_struc,
    nahw.plant_water_method,
    nahw.ploidy,
    nahw.pollutants,
    nahw.pool_dna_extracts,
    nahw.population,
    nahw.population_description,
    nahw.porosity,
    nahw.pos_cont_type,
    nahw.potassium,
    nahw.pregnancy,
    nahw.pres_animal_insect,
    nahw.pressure,
    nahw.pre_treatment,
    nahw.previous_land_use,
    nahw.previous_land_use_meth,
    nahw.primary_prod,
    nahw.primary_treatment,
    nahw.prior_sars_cov_2_antiviral_treat,
    nahw.prior_sars_cov_2_infection,
    nahw.prior_sars_cov_2_vaccination,
    nahw.prod_label_claims,
    nahw.profile_position,
    nahw.project_name,
    nahw.propagation,
    nahw.pulmonary_disord,
    nahw.pulse,
    nahw.purpose_of_sampling,
    nahw.purpose_of_sequencing,
    nahw.purpose_of_ww_sampling,
    nahw.purpose_of_ww_sequencing,
    nahw.race,
    nahw.radiation_regm,
    nahw.rainfall_regm,
    nahw.reactor_type,
    nahw.redox_potential,
    nahw.ref_biomaterial,
    nahw.reference_material,
    nahw.rel_air_humidity,
    nahw.rel_location,
    nahw.rel_to_oxygen,
    nahw.repository,
    nahw.risk_group,
    nahw.room_type,
    nahw.root_cond,
    nahw.root_med_carbon,
    nahw.root_med_macronutr,
    nahw.root_med_micronutr,
    nahw.root_med_ph,
    nahw.root_med_regl,
    nahw.root_med_solid,
    nahw.root_med_suppl,
    nahw.route_transmission,
    nahw.salinity,
    nahw.salinity_meth,
    nahw.salt_regm,
    nahw.same_as,
    nahw.samp_capt_status,
    nahw.samp_collect_device,
    nahw.samp_collect_method,
    nahw.samp_collect_point,
    nahw.samp_dis_stage,
    nahw.sample_name,
    nahw.sample_type,
    nahw.samp_mat_process,
    nahw.samp_mat_type,
    nahw.samp_pooling,
    nahw.samp_rep_biol,
    nahw.samp_rep_tech,
    nahw.samp_salinity,
    nahw.samp_size,
    nahw.samp_sort_meth,
    nahw.samp_source_mat_cat,
    nahw.samp_stor_device,
    nahw.samp_store_dur,
    nahw.samp_store_loc,
    nahw.samp_store_sol,
    nahw.samp_store_temp,
    nahw.samp_stor_media,
    nahw.samp_subtype,
    nahw.samp_transport_temp,
    nahw.samp_vol_we_dna_ext,
    nahw.sars_cov_2_diag_gene_name_1,
    nahw.sars_cov_2_diag_gene_name_2,
    nahw.sars_cov_2_diag_pcr_ct_value_1,
    nahw.sars_cov_2_diag_pcr_ct_value_2,
    nahw.season,
    nahw.season_environment,
    nahw.season_humidity,
    nahw.season_precpt,
    nahw.season_temp,
    nahw.secondary_treatment,
    nahw.sediment_type,
    nahw.sequenced_by,
    nahw.serogroup,
    nahw.serotype,
    nahw.serovar,
    nahw.sewage_type,
    nahw.sex,
    nahw.sexual_act,
    nahw.sieving,
    nahw.silicate,
    nahw.size_frac,
    nahw.size_frac_low,
    nahw.size_frac_up,
    nahw.slope_aspect,
    nahw.slope_gradient,
    nahw.sludge_retent_time,
    nahw.smoker,
    nahw.sodium,
    nahw.soil_conductivity,
    nahw.soil_cover,
    nahw.soil_depth,
    nahw.soil_horizon,
    nahw.soil_ph,
    nahw.soil_temp,
    nahw.soil_text_measure,
    nahw.soil_texture_class,
    nahw.soil_texture_meth,
    nahw.soil_type,
    nahw.soil_type_meth,
    nahw.solar_irradiance,
    nahw.soluble_inorg_mat,
    nahw.soluble_org_mat,
    nahw.soluble_react_phosp,
    nahw.source_material_id,
    nahw.source_name,
    nahw.source_type,
    nahw.source_uvig,
    nahw.space_typ_state,
    nahw.special_diet,
    nahw.specific,
    nahw.specimen_voucher,
    nahw.spec_intended_cons,
    nahw.spikein_count,
    nahw.spikein_org,
    nahw.spikein_strain,
    nahw.standing_water_regm,
    nahw.store_cond,
    nahw.strain,
    nahw.stud_book_number,
    nahw.study_complt_stat,
    nahw.study_design,
    nahw.study_disease,
    nahw.study_inc_dur,
    nahw.study_inc_temp,
    nahw.study_name,
    nahw.study_tmnt,
    nahw.subclone,
    nahw.subgroup,
    nahw.subject_is_affected,
    nahw.submitted_sample_id,
    nahw.submitted_subject_id,
    nahw.submitter_handle,
    nahw.subspecf_gen_lin,
    nahw.sub_species,
    nahw.subsrc_note,
    nahw.substrain,
    nahw.substrate,
    nahw.substructure_type,
    nahw.subtype,
    nahw.sulfate,
    nahw.sulfate_fw,
    nahw.sulfide,
    nahw.super_population_code,
    nahw.super_population_description,
    nahw.surface_orientation,
    nahw.surf_air_cont,
    nahw.surf_humidity,
    nahw.surf_material,
    nahw.surf_moisture,
    nahw.surf_moisture_ph,
    nahw.surf_temp,
    nahw.suspend_part_matter,
    nahw.suspend_solids,
    nahw.sym_life_cycle_type,
    nahw.tan,
    nahw.teleomorph,
    nahw.temp,
    nahw.tertiary_treatment,
    nahw.tidal_stage,
    nahw.tillage,
    nahw.time_last_toothbrush,
    nahw.timepoint,
    nahw.time_since_last_wash,
    nahw.tiss_cult_growth_med,
    nahw.tissue,
    nahw.tissue_lib,
    nahw.toluene,
    nahw.tot_carb,
    nahw.tot_depth_water_col,
    nahw.tot_diss_nitro,
    nahw.tot_inorg_nitro,
    nahw.tot_iron,
    nahw.tot_mass,
    nahw.tot_nitro,
    nahw.tot_nitro_cont_meth,
    nahw.tot_n_meth,
    nahw.tot_org_carb,
    nahw.tot_org_c_meth,
    nahw.tot_part_carb,
    nahw.tot_phosp,
    nahw.tot_phosphate,
    nahw.tot_sulfur,
    nahw.train_line,
    nahw.travel_out_six_month,
    nahw.treatment,
    nahw.trophic_level,
    nahw.turbidity,
    nahw.twin_sibling,
    nahw.type_of_symbiosis,
    nahw.type_status,
    nahw.type_strain,
    nahw.typ_occupant_dens,
    nahw.upstream_intervention,
    nahw.urine_collect_meth,
    nahw.urogenit_disord,
    nahw.urogenit_tract_disor,
    nahw.vaccine_received,
    nahw.variety,
    nahw.ventilation_rate,
    nahw.ventilation_type,
    nahw.vfa,
    nahw.vfa_fw,
    nahw.virus_enrich_appr,
    nahw.virus_isolate_of_prior_infection,
    nahw.volatile_org_comp,
    nahw.wastewater_type,
    nahw.water_content,
    nahw.water_content_soil,
    nahw.water_content_soil_meth,
    nahw.water_current,
    nahw.water_cut,
    nahw.watering_regm,
    nahw.water_ph,
    nahw.water_source_shared,
    nahw.water_temp_regm,
    nahw.weekday,
    nahw.weight_loss_3_month,
    nahw.wet_mass,
    nahw.wga_amp_appr,
    nahw.wind_direction,
    nahw.window_open_freq,
    nahw.wind_speed,
    nahw.ww_endog_control_1,
    nahw.ww_endog_control_1_conc,
    nahw.ww_endog_control_1_protocol,
    nahw.ww_endog_control_1_units,
    nahw.ww_endog_control_2,
    nahw.ww_endog_control_2_conc,
    nahw.ww_endog_control_2_protocol,
    nahw.ww_endog_control_2_units,
    nahw.ww_flow,
    nahw.ww_industrial_effluent_percent,
    nahw.ww_ph,
    nahw.ww_population,
    nahw.ww_population_source,
    nahw.ww_pre_treatment,
    nahw.ww_primary_sludge_retention_time,
    nahw.ww_processing_protocol,
    nahw.ww_sample_duration,
    nahw.ww_sample_matrix,
    nahw.ww_sample_salinity,
    nahw.ww_sample_site,
    nahw.ww_sample_type,
    nahw.ww_surv_jurisdiction,
    nahw.ww_surv_system_sample_id,
    nahw.ww_surv_target_1,
    nahw.ww_surv_target_1_conc,
    nahw.ww_surv_target_1_conc_unit,
    nahw.ww_surv_target_1_extract,
    nahw.ww_surv_target_1_extract_unit,
    nahw.ww_surv_target_1_gene,
    nahw.ww_surv_target_1_known_present,
    nahw.ww_surv_target_1_protocol,
    nahw.ww_surv_target_2,
    nahw.ww_surv_target_2_conc,
    nahw.ww_surv_target_2_conc_unit,
    nahw.ww_surv_target_2_extract,
    nahw.ww_surv_target_2_extract_unit,
    nahw.ww_surv_target_2_gene,
    nahw.ww_surv_target_2_known_present,
    nahw.ww_surv_target_2_protocol,
    nahw.ww_temperature,
    nahw.ww_total_suspended_solids
   FROM non_attribute_metadata nam
     JOIN ncbi_attributes_harmonized_wide nahw ON nam.raw_id = nahw.raw_id;


-- public.ncbi_attributes_all_long_with_accessions source

CREATE OR REPLACE VIEW public.ncbi_attributes_all_long_with_accessions
AS SELECT nam.accession,
    naal.raw_id,
    naal.attribute_name,
    naal.harmonized_name,
    naal.display_name,
    naal.unit,
    naal.value
   FROM ncbi_attributes_all_long naal
     JOIN non_attribute_metadata nam ON naal.raw_id = nam.raw_id;

create database envo;