GFF Release Data and Changes
From WormBaseWiki
Revision as of 18:08, 30 May 2013 by Joachim.baran (talk | contribs) (Added SQL commands that explain how I retrieve names from GFF2/GFF3 tables.)
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
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 |