Skip to content

Instantly share code, notes, and snippets.

@renzok

renzok/00141-tara-satge-table-and-data-import-patch.sql

Created October 23, 2015 06:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save renzok/32840a8340017f99111f to your computer and use it in GitHub Desktop.
Save renzok/32840a8340017f99111f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
00141-tara-satge-table-and-data-import-patch.sql
COPY tara_samples (sample_name, ena_read_no, pangaea_id, publication, type_of_study, seq_method, date_verb, latitude_verb, longitude_verb, depth_verb, feature_verb) FROM STDIN WITH (FORMAT csv, HEADER, DELIMITER E'\t', NULL '', FORCE_NOT_NULL(type_of_study,seq_method) );
sample_name ena_read_no pangaea_id publication type_of_study seq_method date_verb latitude_verb longitude_verb depth_verb feature_verb
TARA_004_DCM_0.22-1.6 ERR598950|ERR599095 TARA_X000000368 sunagawa
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment