Revision as of 18:08, 30 May 2013

Elementary SQL Commands

Checking for names in a GFF2 table schema: select distinct fref from fdata where fref like '%Contig2';

Checking for names in a GFF3 table schema: select distinct name from name where name like '%Scaffold122';

Table name format: genus-initial_species_bioproject-id_release

Example: a_suum_PRJNA62057_WS238

Table	Data Format	Format Changed from WS237 to WS238?	Landmark Includes Bioproject ID?
a_suum_PRJNA62057_WS238	GFF3	no	no
a_suum_PRJNA80881_WS238	GFF3	no	yes (e.g., As_PRJNA80881_Scaffold122)
b_malayi_PRJNA10729_WS238	GFF2	no	?
b_xylophilus_PRJEA64437_WS238	GFF3	no	no
c_angaria_PRJNA51225_WS238	GFF3	no	no
c_brenneri_PRJNA20035_WS238	GFF2	no	?
c_briggsae_PRJNA10731_WS238	GFF2	no	?
c_elegans_PRJNA13758_WS238	GFF2	no	?
c_japonica_PRJNA12591_WS238	GFF2	no	?
c_remanei_PRJNA53967_WS238	GFF2	no	?
c_sp11_PRJNA53597_WS238	GFF3	no	no
c_sp5_PRJNA194557_WS238	GFF3	no	no
h_bacteriophora_PRJNA13977_WS238	GFF3	no	no
h_contortus_PRJEB506_WS238	GFF3	no	no
l_loa_PRJNA60051_WS238	GFF3	no	no
m_hapla_PRJNA29083_WS238	GFF3	no	no
m_incognita_PRJEA28837_WS238	GFF3	no	no
p_pacificus_PRJNA12644_WS238	GFF2	no	?
s_ratti_PRJEA62033_WS238	GFF3	no	no
t_spiralis_PRJNA12603_WS238	GFF3	no	no

@@ Line 1: / Line 1: @@
+= Elementary SQL Commands =
+Checking for names in a GFF2 table schema: '''select distinct fref from fdata where fref like '%Contig2';'''
+Checking for names in a GFF3 table schema: '''select distinct name from name where name like '%Scaffold122';'''
 = WS238 =