def get_public_project_accessions():
    accessions = list()
    archive_cursor = connect_archive()
    archive_cursor.execute("select accession from project where (submission_type='PRIDE' or submission_type='COMPLETE') and is_public = 1")
    projects = archive_cursor.fetchall()
    for project in projects:
        accessions.append(project[0])
    archive_cursor.close()
    return accessions
def get_public_project_accessions():
    accessions = list()
    archive_cursor = connect_archive()
    archive_cursor.execute("select accession from project where (submission_type='PRIDE' or submission_type='COMPLETE') and is_public = 1")
    projects = archive_cursor.fetchall()
    for project in projects:
        accessions.append(project[0])
    archive_cursor.close()
    return accessions