flytable_login uses your flytable user name and email to
log into the service.
flytable_set_token will obtain and store a permanent
seatable user-level API token.
flytable_base returns a base object (equivalent to
a mysql database) which allows you to access one or more tables, logging in
to the service if necessary. The returned base object give you full access
to the Python
Base
API allowing a range of row/column manipulations.
flytable_alltables lists all tables across all flytables
bases.
flytable_columns returns the name and type of all regular
columns in a base as well as the default R type. Private columns such as
_id are not included.
Usage
flytable_login(
url = "https://flytable.mrc-lmb.cam.ac.uk/",
token = Sys.getenv("FLYTABLE_TOKEN", unset = NA_character_)
)
flytable_set_token(user, pwd, url = "https://flytable.mrc-lmb.cam.ac.uk/")
flytable_base(
table = NULL,
base_name = NULL,
workspace_id = NULL,
url = "https://flytable.mrc-lmb.cam.ac.uk/",
cached = TRUE
)
flytable_alltables(ac = NULL, cached = TRUE)
flytable_columns(table, base = NULL, cached = TRUE)Arguments
- url
Optional URL to the server
- token
normally retrieved from
FLYTABLE_TOKENenvironment variable.- user, pwd
flytable user and password used by
flytable_set_tokento obtain a token- table
Character vector specifying a table foe which you want a
baseobject.- base_name
Character vector specifying the
base- workspace_id
A numeric id specifying the workspace. Advanced use only since we can normally figure this out from
base_name.- cached
Whether to use a cached version of the response if available. Set to
FALSEif you know tables have been added or renamed during your session.- ac
Optional account object returned by flytables_login
- base
Optional character vector naming a seatable base (recommended) or a
Baseobject returned byflytable_base(expert use). The default value ofNULLwill rely on thetableso long as it is unique across the flytable server.
Value
For flytable_login, a Python
Account
object from the seatable api as wrapped by reticulate.
For flytable_base, a Python
Base
object from the seatable api as wrapped by reticulate.
A data.frame containing the base_name,
workspace_id, table name and table _id.
flytable_columns a data.frame containing columns name,
type and rtype
Details
Besides initial setup (next paragraph), you should not need to use
these lower level functions directly. Instead we recommend higher level
functions such as flytable_query.
In order to start using flytable, you must get an API token. There doesn't
seem to be a convenient way to do this from the seatable web interface but
you can get one by calling flytable_set_token with your flytable
user and password. This should be a once only step. Thereafter you should
have a FLYTABLE_TOKEN environment variable set in your .Renviron
file.
flytable_base will use your flytable API token to log into
the service.
See also
Other flytable:
flytable-queries,
flytable_list_selected(),
flytable_update_rows()
Examples
if (FALSE) { # \dontrun{
flytable_login()
} # }
if (FALSE) { # \dontrun{
flytable_set_token(user='xxx@gmail.com', pwd='yyy')
} # }
if (FALSE) { # \dontrun{
hemilineages=flytable_base(base_name='hemilineages')
# equivalent, but simpler since you only have to remember the table name
hemilineages=flytable_base('fafb_hemilineages_survey')
} # }
# \donttest{
flytable_alltables()
#> base_name workspace_id
#> 1 maleCNS 111
#> 2 Orphan proofreading 44
#> 3 Orphan proofreading 44
#> 4 Remainder proofreading 44
#> 5 Remainder proofreading 44
#> 6 Review 44
#> 7 Review Catalog 44
#> 8 Review Catalog 44
#> 9 LAL_orphan_linking 29
#> 10 NO_orphan_linking 29
#> 11 Alan_Mathews_project 5
#> 12 Alan_Mathews_project 5
#> 13 Alan_Mathews_project 5
#> 14 Alan_Mathews_project 5
#> 15 Alan_Mathews_project 5
#> 16 Alan_Mathews_project 5
#> 17 Alan_Mathews_project 5
#> 18 Alan_Mathews_project 5
#> 19 Alan_Mathews_project 5
#> 20 Alan_Mathews_project 5
#> 21 Alan_Mathews_project 5
#> 22 Alan_Mathews_project 5
#> 23 Alan_Mathews_project 5
#> 24 Alan_Mathews_project 5
#> 25 Alan_Mathews_project 5
#> 26 Alan_Mathews_project 5
#> 27 Alan_Mathews_project 5
#> 28 Alan_Mathews_project 5
#> 29 Alan_Mathews_project 5
#> 30 Alan_Mathews_project 5
#> 31 Alan_Mathews_project 5
#> 32 Alan_Mathews_project 5
#> 33 Alan_Mathews_project 5
#> 34 Alan_Mathews_project 5
#> 35 Alan_Mathews_project 5
#> 36 Alan_Mathews_project 5
#> 37 Alan_Mathews_project 5
#> 38 Alan_Mathews_project 5
#> 39 Alan_Mathews_project 5
#> 40 Alan_Mathews_project 5
#> 41 Alan_Mathews_project 5
#> 42 Alan_Mathews_project 5
#> 43 Alan_Mathews_project 5
#> 44 Alan_Mathews_project 5
#> 45 Alan_Mathews_project 5
#> 46 Alan_Mathews_project 5
#> 47 Alan_Mathews_project 5
#> 48 Alan_Mathews_project 5
#> 49 Alan_Mathews_project 5
#> 50 Alan_Mathews_project 5
#> 51 Alan_Mathews_project 5
#> 52 Alan_Mathews_project 5
#> 53 AL_library 5
#> 54 cam_proofreading 5
#> 55 cam_proofreading 5
#> 56 CATMAID_proofreading 5
#> 57 CATMAID_proofreading 5
#> 58 DO_NOT_USE_main 5
#> 59 DO_NOT_USE_main 5
#> 60 flywire_matching 5
#> 61 flywire_matching 5
#> 62 flywire_matching 5
#> 63 flywire_matching 5
#> 64 flywire_matching 5
#> 65 flywire_matching 5
#> 66 flywire_matching 5
#> 67 flywire_matching 5
#> 68 hemibrain 5
#> 69 hemibrain 5
#> 70 hemibrain_matching 5
#> 71 hemibrain_matching 5
#> 72 hemibrain_matching 5
#> 73 hemibrain_matching 5
#> 74 hemibrain_matching 5
#> 75 hemibrain_matching 5
#> 76 hemibrain_matching 5
#> 77 hemibrain_matching 5
#> 78 hemibrain_matching 5
#> 79 LH_library 5
#> 80 LH_library 5
#> 81 main 5
#> 82 main 5
#> 83 main(lineage_backup) 5
#> 84 MB_library 5
#> 85 MB_library 5
#> 86 optic_lobes 5
#> 87 test 5
#> 88 fanc_left_right 123
#> 89 fanc_left_right 123
#> 90 fanc_left_right 123
#> 91 fanc_left_right 123
#> 92 fanc_maleCNS_matching 123
#> 93 fanc_maleCNS_matching 123
#> 94 fanc_maleVNC_matching 123
#> 95 fanc_manc 123
#> 96 fanc_manc 123
#> 97 manc_fanc 123
#> 98 manc_fanc_maleCNS_byType 123
#> 99 manc_left_right 123
#> 100 manc_left_right 123
#> 101 manc_left_right 123
#> 102 manc_maleCNS 123
#> 103 manc_maleCNS 123
#> 104 manc_mcns 123
#> 105 mcns_fw_matching 123
#> 106 mcns_fw_matching 123
#> 107 mcns_fw_matching 123
#> 108 DB Comparison 1
#> 109 mcns_flywire_cell_types 4
#> name _id
#> 1 cns_info 96g5
#> 2 v1 DHtk
#> 3 Table3 0t5T
#> 4 v1 vlgx
#> 5 add_proofreading_783 9l9v
#> 6 v1 9JIF
#> 7 v1 Y9RH
#> 8 review_459 SFd8
#> 9 LAL_bodies wtpy
#> 10 NO_bodies htKk
#> 11 DL4R_downstream M4SW
#> 12 DL4L_downstream P3aV
#> 13 DL4_HB_downstream ip3N
#> 14 dl4_matches_fafb_r_hb jvT0
#> 15 dl4_matches_fafb 0qC0
#> 16 dl4_matches_fafb_l_hb 8ZOA
#> 17 VL2R_downstream Ikw9
#> 18 VL2L_downstream FCty
#> 19 VL2_HB_downstream F9Sk
#> 20 vl2_matches_fafb_r_hb yP9j
#> 21 vl2_matches_fafb dV47
#> 22 Vilpn1_downstream kcqG
#> 23 Vilpn2_downstream 4IO4
#> 24 vilpn1_HB_downstream qND2
#> 25 vilpn2_HB_downstream SvpB
#> 26 vilpn1_ds_r ZCMx
#> 27 vilpn1_ds_l IqEa
#> 28 vilpn2_ds_r sikt
#> 29 vilpn2_ds_l cxOO
#> 30 vilpn1_matches_fafb UB2m
#> 31 vilpn1r_matches_fafbr_hb TuH0
#> 32 vilpn2r_matches_fafbr_hb dZ2X
#> 33 vilpn2_matches_fafb UYUu
#> 34 vl2_matches_fafb_r_hb(copy) K7hg
#> 35 vilpn2r_matches_fafbr_hb(copy) rrwF
#> 36 vl2_matches_fafb(copy) 1iG8
#> 37 vilpn1_fafb_matches(copy) 935S
#> 38 cable_length 1Itd
#> 39 prepostcable_dl4 Z738
#> 40 prepostcable_vl2 TKM9
#> 41 prepostcable_vilpn2 6D4l
#> 42 PN_stats p4KB
#> 43 NBLAST_scores yJVR
#> 44 vilpn_matches_fafb(copy) 7sqj
#> 45 vilpn_matches_1r_2l 78cE
#> 46 vilpn_matches_2r_1l OE2j
#> 47 vilpn_total iVH6
#> 48 dl4_norm 14wl
#> 49 vilpnlr_combo dznE
#> 50 norm A451
#> 51 2022-04-20T19_03_21+00_00_0wpp J4ma
#> 52 misc s6Oi
#> 53 AL_bodies wNCm
#> 54 batches 0000
#> 55 FlyWire_neuron_list - for_flywire FbAY
#> 56 catmaid TYn5
#> 57 all_done 5mdz
#> 58 DO_NOT_USE_info BXTy
#> 59 DO_NOT_USE_hemilineages QGfh
#> 60 flywire_right Nscg
#> 61 hemibrain2flywire yN5a
#> 62 hemibrain2flywire_rematch LaYJ
#> 63 hemibrain2flywire_mirrored 2ThW
#> 64 flywire_ALr_ALl dwun
#> 65 new_singles yHJb
#> 66 new_singles_lr wd66
#> 67 all_singletons CXnQ
#> 68 hb_info X2ZG
#> 69 hb_hemilineages Sz01
#> 70 type_matches cpHc
#> 71 MWP_LH_RHS_cell_typing NG0m
#> 72 MWP_LH_LHS_cell_typing_v_hb 0Cl7
#> 73 MWP_LH_LHS_cell_typing_v_rhs_flywire Z5ea
#> 74 LH_LHS_hb_vs_RHS_conflict_table 8DAX
#> 75 MWP_mega_df 9yII
#> 76 MWP_LH_stereotypy rRZE
#> 77 MWP_PM_YY_cell_typing q477
#> 78 post_GM pfDm
#> 79 LH_bodies 2PZZ
#> 80 _old_LH_bodies dvGc
#> 81 info f0ac
#> 82 hemilineages Z4SX
#> 83 lineage_project Nu8Q
#> 84 MB_bodies K5lc
#> 85 MB_bodies_RHS VR7q
#> 86 optic Nato
#> 87 testfruit 0000
#> 88 Types 0X5w
#> 89 Assignments Jj2w
#> 90 Assignments_perturbation01 e989
#> 91 Types_perturbation01 w5K6
#> 92 fanc851_maleCNS_nblast95_60 8j37
#> 93 fanc851_maleCNS_nblast95_60_old_dontUse CPe6
#> 94 fanc851_manc_nblast95_60 rR5r
#> 95 nblast95_30_old 992a
#> 96 nblast95_30 WdlO
#> 97 nblast95_30 2c4S
#> 98 Table1 Ou8V
#> 99 Assignments teVG
#> 100 Types_perturbation fQpI
#> 101 AssignmentsMeta gfUJ
#> 102 Table1_nblast95_60 kg2f
#> 103 mcns_manc_nblast95_60 NqJ6
#> 104 nblast95_60 zi2p
#> 105 mcns_fw_nblast95_60 qtS9
#> 106 mcns_fw_typing r8mP
#> 107 mcns_fw_nblast95_60(copy) gsV1
#> 108 Table1 0000
#> 109 flywire_types Fj2H
# }
# \donttest{
flytable_columns("info")
#> name type rtype
#> 1 supervoxel_id text character
#> 2 root_id text character
#> 3 pos_x number numeric
#> 4 pos_y number numeric
#> 5 pos_z number numeric
#> 6 soma_x number numeric
#> 7 soma_y number numeric
#> 8 soma_z number numeric
#> 9 nucleus_id number numeric
#> 10 side single-select character
#> 11 top_nt text character
#> 12 top_nt_conf number numeric
#> 13 ito_lee_hemilineage single-select character
#> 14 hartenstein_hemilineage text character
#> 15 flow text character
#> 16 super_class text character
#> 17 cell_sub_class text character
#> 18 cell_class text character
#> 19 cell_type text character
#> 20 cell_type_source text character
#> 21 fbbt_id text character
#> 22 vfb_id text character
#> 23 cb_type text character
#> 24 hemibrain_match text character
#> 25 hemibrain_type text character
#> 26 hemibrain_type_source text character
#> 27 malecns_type text character
#> 28 malecns_match text character
#> 29 malecns_type_source text character
#> 30 reviewed_by text character
#> 31 status single-select character
#> 32 notes long-text character
#> 33 lrcid text character
#> 34 root_duplicated checkbox logical
#> 35 proofread checkbox logical
#> 36 root_last_modified date POSIXct
#> 37 last_user last-modifier character
#> 38 LM_match text character
#> 39 LM_match_source text character
#> 40 root_630 text character
#> 41 root_783 text character
#> 42 nerve single-select character
#> 43 release_630 checkbox logical
#> 44 release_783 checkbox logical
#> 45 morphology_group text character
#> 46 known_nt text character
#> 47 known_nt_source text character
#> 48 dimorphism single-select character
#> 49 matching_notes multiple-select character
#> data
#> 1 NULL
#> 2 NULL
#> 3 number, dot, no
#> 4 number, dot, no
#> 5 number, dot, no
#> 6 number, dot, no
#> 7 number, dot, no
#> 8 number, dot, no
#> 9 number, 0, TRUE, FALSE, dot, no
#> 10 center, #59CB74, #FFFFFF, 707150, #4EB867, left, #F4667C, #FFFFFF, 21928, #DC556A, right, #46A1FD, #FFFFFF, 666421, #3C8FE4, na, #4ECCCB, #FFFFFF, 488103
#> 11 FALSE, undefined
#> 12 number, 2, FALSE, FALSE, dot, no
#> 13 ADL25, #aaa, #000000, 819986, ADL26, #aaa, #000000, 919193, ADL27, #aaa, #000000, 109498, ADL28, #aaa, #000000, 957054, ADM09, #aaa, #000000, 130521, ADM11, #aaa, #000000, 531452, ADM12, #aaa, #000000, 168743, ALad1, #aaa, #000000, 598204, ALl1_dorsal, #aaa, #000000, 403005, ALl1_ventral, #aaa, #000000, 436910, ALlv1, #aaa, #000000, 511159, ALv1, #aaa, #000000, 840849, ALv2, #aaa, #000000, 974452, AOTUv1_medial, #aaa, #000000, 790264, AOTUv1_ventral, #aaa, #000000, 442853, AOTUv2, #aaa, #000000, 670976, AOTUv3_dorsal, #aaa, #000000, 313454, AOTUv3_ventral, #aaa, #000000, 69614, AOTUv4_dorsal, #aaa, #000000, 308944, AOTUv4_ventral, #aaa, #000000, 321043, AVL22, #aaa, #000000, 722933, AVL23, #aaa, #000000, 121546, AVL25, #aaa, #000000, 35613, AVL27, #aaa, #000000, 8745, AVM16, #aaa, #000000, 862786, AVM17, #aaa, #000000, 330386, AVM19, #aaa, #000000, 168929, AVM20, #aaa, #000000, 716823, AVM21, #aaa, #000000, 144063, CLp1, #aaa, #000000, 361572, CLp2, #aaa, #000000, 426046, CREa1_dorsal, #aaa, #000000, 431266, CREa1_ventral, #aaa, #000000, 138394, CREa2_medial, #aaa, #000000, 504873, CREa2_ventral, #aaa, #000000, 575424, DL1_dorsal, #aaa, #000000, 727120, DL1_ventral, #aaa, #000000, 690284, DL2_dorsal, #aaa, #000000, 140884, DL2_ventral, #aaa, #000000, 310772, DM1, #aaa, #000000, 681894, DM2, #aaa, #000000, 88295, DM2_dorsal, #aaa, #000000, 626036, DM3, #aaa, #000000, 39866, DM3_CX, #aaa, #000000, 586041, DM3_canonical, #aaa, #000000, 772662, DM3_lateral, #aaa, #000000, 643580, DM3_medial, #aaa, #000000, 784672, DM4_dorsal, #aaa, #000000, 617128, DM4_medial, #aaa, #000000, 679773, DM4_ventral, #aaa, #000000, 122933, DM5_dorsal, #aaa, #000000, 175466, DM5_ventral, #aaa, #000000, 963751, DM6, #aaa, #000000, 244601, DM6_dorsal, #aaa, #000000, 589874, DM6_inferior, #aaa, #000000, 442502, DM6_lateral, #aaa, #000000, 701347, DM6_medial, #aaa, #000000, 55166, DM6_ventral, #aaa, #000000, 250188, EBa1, #aaa, #000000, 656315, FLAa1, #aaa, #000000, 651426, FLAa2, #aaa, #000000, 156680, FLAa3, #aaa, #000000, 516710, LALv1, #aaa, #000000, 604466, LB0, #aaa, #000000, 345842, LB0_anterior, #aaa, #000000, 519161, LB12, #aaa, #000000, 112831, LB19, #aaa, #000000, 124622, LB23, #aaa, #000000, 150685, LB3, #aaa, #000000, 672428, LB5, #aaa, #000000, 358879, LB6, #aaa, #000000, 625446, LB7, #aaa, #000000, 643150, LB7_posterior, #aaa, #000000, 809156, LHa1, #aaa, #000000, 910788, LHa2, #aaa, #000000, 667511, LHa3, #aaa, #000000, 739277, LHd1, #aaa, #000000, 561176, LHd2, #aaa, #000000, 331974, LHl1, #aaa, #000000, 600796, LHl2_lateral, #aaa, #000000, 766960, LHl2_medial, #aaa, #000000, 886621, LHl3, #aaa, #000000, 990565, LHl4_anterior, #aaa, #000000, 430384, LHl4_posterior, #aaa, #000000, 831357, LHp1, #aaa, #000000, 202734, LHp2_lateral, #aaa, #000000, 483076, LHp2_medial, #aaa, #000000, 530919, MBp1, #aaa, #000000, 580860, MBp2, #aaa, #000000, 882629, MBp3, #aaa, #000000, 400019, MBp4, #aaa, #000000, 911444, MD0, #aaa, #000000, 778325, MD3, #aaa, #000000, 166730, MD_SA1, #aaa, #000000, 924667, MX12, #aaa, #000000, 266167, MX12_medial, #aaa, #000000, 201080, MX3, #aaa, #000000, 459574, MX7, #aaa, #000000, 315447, PBp1, #aaa, #000000, 923827, PDL25, #aaa, #000000, 741158, PDL26, #aaa, #000000, 137685, PDM26, #aaa, #000000, 546113, PDM32, #aaa, #000000, 998928, PDM33, #aaa, #000000, 513930, PDM34, #aaa, #000000, 585002, PSa1, #aaa, #000000, 119090, PSp1, #aaa, #000000, 509400, PSp2, #aaa, #000000, 245308, PSp3_dorsal, #aaa, #000000, 525301, PSp3_ventral, #aaa, #000000, 305464, PVL02, #aaa, #000000, 378736, PVL15, #aaa, #000000, 109937, PVL17, #aaa, #000000, 173088, PVM13, #aaa, #000000, 256717, PVM14, #aaa, #000000, 252725, PVM15, #aaa, #000000, 303423, SIPa1_dorsal, #aaa, #000000, 25514, SIPa1_ventral, #aaa, #000000, 950343, SIPp1, #aaa, #000000, 454037, SLPa&l1_anterior, #aaa, #000000, 692055, SLPa&l1_lateral, #aaa, #000000, 80274, SLPad1_anterior, #aaa, #000000, 797608, SLPad1_posterior, #aaa, #000000, 253192, SLPal1, #aaa, #000000, 137934, SLPal2_dorsal, #aaa, #000000, 604081, SLPal2_ventral, #aaa, #000000, 519197, SLPal3, #aaa, #000000, 919481, SLPal4, #aaa, #000000, 82841, SLPal5, #aaa, #000000, 623379, SLPav1_lateral, #aaa, #000000, 99481, SLPav1_medial, #aaa, #000000, 473276, SLPav2, #aaa, #000000, 324498, SLPav3, #aaa, #000000, 257038, SLPp&v1_posterior, #aaa, #000000, 51543, SLPp&v1_ventral, #aaa, #000000, 344955, SLPpl1, #aaa, #000000, 912263, SLPpl2, #aaa, #000000, 411606, SLPpl3, #aaa, #000000, 610066, SLPpm1, #aaa, #000000, 728496, SLPpm2, #aaa, #000000, 664395, SLPpm3, #aaa, #000000, 880997, SMPad1, #aaa, #000000, 719040, SMPad2, #aaa, #000000, 517718, SMPad3, #aaa, #000000, 20480, SMPp&v1_posterior, #aaa, #000000, 566750, SMPp&v1_ventral, #aaa, #000000, 218799, SMPpd1, #aaa, #000000, 480777, SMPpd2, #aaa, #000000, 735960, SMPpv1, #aaa, #000000, 116347, SMPpv2, #aaa, #000000, 782447, TRdl, #aaa, #000000, 67085, TRdm, #aaa, #000000, 126795, VESa1, #aaa, #000000, 694066, VESa2, #aaa, #000000, 214095, VLPa1_lateral, #aaa, #000000, 231042, VLPa1_medial, #aaa, #000000, 984989, VLPa2, #aaa, #000000, 256224, VLPd&p1_dorsal, #aaa, #000000, 718802, VLPd&p1_posterior, #aaa, #000000, 946964, VLPd1, #aaa, #000000, 659295, VLPl&d1_dorsal, #aaa, #000000, 314355, VLPl&d1_lateral, #aaa, #000000, 295490, VLPl&p1_lateral, #aaa, #000000, 757777, VLPl&p1_posterior, #aaa, #000000, 716311, VLPl&p2_lateral, #aaa, #000000, 277026, VLPl&p2_posterior, #aaa, #000000, 623102, VLPl1, #aaa, #000000, 501397, VLPl2_dorsal, #aaa, #000000, 53914, VLPl2_ventral, #aaa, #000000, 633998, VLPl4_dorsal, #aaa, #000000, 917914, VLPl4_ventral, #aaa, #000000, 217170, VLPp&l1_lateral, #aaa, #000000, 941299, VLPp&l1_posterior, #aaa, #000000, 7595, VLPp1, #aaa, #000000, 614935, VLPp2, #aaa, #000000, 816034, VPNd1, #aaa, #000000, 334196, VPNl&d1_dorsal, #aaa, #000000, 265620, VPNl&d1_lateral, #aaa, #000000, 971297, VPNp&v1_posterior, #aaa, #000000, 147127, VPNp&v1_ventral, #aaa, #000000, 677039, VPNp1_lateral, #aaa, #000000, 356514, VPNp1_medial, #aaa, #000000, 726617, WEDa1_dorsal, #aaa, #000000, 289847, WEDa1_ventral, #aaa, #000000, 578652, WEDa2, #aaa, #000000, 995569, WEDd1, #aaa, #000000, 521068, WEDd2, #aaa, #000000, 663295, new_clone_1, #aaa, #000000, 220838, new_clone_2, #aaa, #000000, 460867, new_clone_3, #aaa, #000000, 626699, new_clone_4, #aaa, #000000, 524170, 613654, SLPp&v1, #FBD44A, #FFFFFF, 500246, sensory, #46A1FD, #FFFFFF, 350369, DM1_CX1, #D7E8FF, #202428, 189612, DM1_SEZ, #DEF7C4, #202428, 481669, DM1_CX2, #DC82D2, #FFFFFF, 222402, DM1_CRE, #F4667C, #FFFFFF, needs_assigment, #F4667C, #FFFFFF, 491678, #DC556A, optic, #59CB74, #FFFFFF, 865758, 471218, DM2_ALT, #9F8CF1, #FFFFFF, 17271, DM2_CX_p, #EAA775, #FFFFFF, 324985, DM2_CX_v, #59CB74, #FFFFFF, 854446, DM3_CX_p, #DEF7C4, #202428, 306346, DM2_CX_d, #9860E5, #FFFFFF, DM1_CX_d, 536481, #46A1FD, #FFFFFF, 298311, DM1_CX_p, #D7E8FF, #202428, DM4_CX_d2, 81887, #FBD44A, #FFFFFF, DM4_CX_d3, 572727, #C2C2C2, #FFFFFF, DM3_CX_d1, 361124, #ADDF84, #FFFFFF, DM2_CX_d2, 891883, #DC82D2, #FFFFFF, DM2_CX_d1, 340460, #89D2EA, #FFFFFF, DM1_CX_d2, 594996, #F4667C, #FFFFFF, DM4_CX_d1, 967181, #9F8CF1, #FFFFFF, DM3_CX_d2, 116972, #EAA775, #FFFFFF, 402580, DM1_CX_v, #FFDDE5, #202428, 643080, DM3_CX_v, #FBD44A, #FFFFFF, 375589, DM4_CX_p, #FFDDE5, #202428, 205371, DM4_CX_v, #D7E8FF, #202428, DM£_cx_p, #9860E5, #FFFFFF, 818690, DM1_loSM, #46A1FD, #FFFFFF, 492623, 916866, LHp2, #D8FAFF, #202428, primary, #59CB74, #FFFFFF, 604797, putative_primary, #ADDF84, #FFFFFF, 23976, 445149, SLPal2, #89D2EA, #FFFFFF, 39423, LHl2, #F4667C, #FFFFFF, 793080, new_clone_5, #DDFFE6, #202428, 405583, LALv1_dorsal, #46A1FD, #FFFFFF, 370038, LALv1_ventral, #D7E8FF, #202428, 397095, LHl2_ventral, #DDFFE6, #202428, 710714, LHl2_dorsal, #B7CEF9, #202428, LB0_posterior, #C2C2C2, #FFFFFF, 32408, 534862, WEDa1, #46A1FD, #FFFFFF, seb, #DC82D2, #FFFFFF, 527295, 924833, new_clone_6, #DAD7FF, #202428, DM1_OL, #9860E5, #FFFFFF, 442700, 925417, CREa2_dorsal, #D7E8FF, #202428, 757382, VLPp&l1_intermediate, #EAA775, #FFFFFF, 12847, LB3__prim, #ADDF84, #FFFFFF, 720575940621734861, 497920, #9F8CF1, #FFFFFF, 468033, PSp3, #FFD4FF, #202428, 729648, TRdl_a, #FFD9C8, #202428, 663876, TRdl_b, #DDFFE6, #202428, 562672, MX0, #D7E8FF, #202428, VLPd1__prim, 463728, #F4667C, #FFFFFF, 458317, MX12__prim, #4ECCCB, #FFFFFF, 464745, LB7__prim, #FFFCB5, #202428, 673114, VLPp&l1__prim, #E9E9E9, #202428, 460071, MX7__prim, #FFDDE5, #202428, left, 767570, #46A1FD, #FFFFFF, AN_sensory, #9860E5, #FFFFFF, 770811, 192973, LN_sensory, #DAD7FF, #202428, 119081, aPN_sensory, #DAD7FF, #202428, 447259, ON_sensory, #B7CEF9, #202428, 739390, PN_sensory, #9F8CF1, #FFFFFF, 549916, SMPad2_prim, #D8FAFF, #202428, 975326, SMPp&v1_prim, #89D2EA, #FFFFFF, vlpl2-v, #DC82D2, #FFFFFF, 716489, vlpl7p1, #EAA775, #FFFFFF, 278892, 331845, SLPa&l1_prim, #EAA775, #FFFFFF, 909782, SLPal1_prim, #89D2EA, #FFFFFF, 329809, SLPad1_posterior_or_VLPd&p1_posterior, #FFD4FF, #202428, ptua, #C2C2C2, #FFFFFF, 85765, 431580, VLPa1_prim, #FBD44A, #FFFFFF, 36279, DM3__prim, #4ECCCB, #FFFFFF, 896397, DM4__prim, #FBD44A, #FFFFFF, 836945, DM6__prim, #FFD9C8, #202428, VLPa2__prim, #ADDF84, #FFFFFF, 521774, VLPa1__prim, #F4667C, #FFFFFF, 158068, SMPad2__prim, #46A1FD, #FFFFFF, 174816, SMPp&v1__prim, #9860E5, #FFFFFF, 167661, SLPa&l1__prim, #59CB74, #FFFFFF, 17217, SLPal1__prim, #EAA775, #FFFFFF, 43986, 172733, no_lineage, #FFD9C8, #202428, aotuv1_vn, #89D2EA, #FFFFFF, 489600, 27684, SLpav2, #9F8CF1, #FFFFFF, 598276, LHp3, #9860E5, #FFFFFF, 320500, CREl1, #FFD9C8, #202428, 768209, LALa1, #59CB74, #FFFFFF, 172236, SMPpm1, #FFDDE5, #202428, 743924, CLp1_or_SLPpm2, #59CB74, #FFFFFF, 340194, VLPl&d1_medial, #89D2EA, #FFFFFF, 395985, VLPl&d1_posterior, #ADDF84, #FFFFFF, 597064, VLPl2_posterior, #DC82D2, #FFFFFF, 375022, VLPl2_medial, #D7E8FF, #202428, 832640, SLPa&l1_medial, #DEF7C4, #202428, 685235, SLPa&l1_posterior, #DC82D2, #FFFFFF, 400165, LHl4_dorsal, #FFFCB5, #202428, 726853, VLPl4_anterior, #FFD4FF, #202428, 162052, VLPl&p2_anterior, #ADDF84, #FFFFFF, 610026, VLPl&p1_anterior, #FFD4FF, #202428, 397383, DM5_central, #FBD44A, #FFFFFF, 429742, DM6_dorso_lateral, #E9E9E9, #202428, 912751, DM6_central1, #F4667C, #FFFFFF, 610414, DM6_dorso_medial, #B7CEF9, #202428, 195122, VLPd&p1_anterior, #4ECCCB, #FFFFFF, 61607, SLPp&v1_anterior, #ADDF84, #FFFFFF, 489027, VLPp&l1_anterior, #FFD9C8, #202428, 999517, DM1_antero_dorsal, #DDFFE6, #202428, 741992, DM1_antero_ventral, #E9E9E9, #202428, 229517, DM1_dorsal, #B7CEF9, #202428, 941917, DM2_central, #DEF7C4, #202428, 898011, DM3_dorso_lateral, #FFD4FF, #202428, 397372, DM3_dorso_medial, #E9E9E9, #202428, 44197, DM3_posterior, #FFD9C8, #202428, 603980, VLPl1_or_VLPl5, #FFD4FF, #202428, 985402, DM6_posterior, #D7E8FF, #202428, 53388, LALa1_posterior, #EAA775, #FFFFFF, 38120, LALa1_anterior, #D7E8FF, #202428, SLPal3_or_SLPal4_dorsal, 965919, #C2C2C2, #FFFFFF, vlpl4_am, #F4667C, #FFFFFF, 685539, 807102, VPNl&d1_medial, #F4667C, #FFFFFF, 279229, DM6_IbSpsP, #9F8CF1, #FFFFFF, 212829, DM6_central2, #FFEAB6, #202428, SMPpv2_ventral, 791739, #4ECCCB, #FFFFFF, 472132, ALad1__prim, #EAA775, #FFFFFF, 337782, SMPpv2_dorsal, #FFDDE5, #202428, MD0__prim, 864257, #FBD44A, #FFFFFF, MX0__prim, 79006, #46A1FD, #FFFFFF, DILP__prim, 69103, #ADDF84, #FFFFFF, VLPl2_lateral, 764400, #DC82D2, #FFFFFF, DM1_posterior, 912445, #89D2EA, #FFFFFF, SLPal3_and_SLPal4_dorsal, 457802, #59CB74, #FFFFFF, VPNl&d1_medial_Lee, 711486, #F4667C, #FFFFFF, VPNd3, 285703, #9860E5, #FFFFFF, VPNd2, #C2C2C2, #FFFFFF, 861927, VPNv2, #4ECCCB, #FFFFFF, 808867, VPNp2, #9F8CF1, #FFFFFF, 165924, DM2_or_DM3_posterior, 60684, #EAA775, #FFFFFF, VPNv1, #FBD44A, #FFFFFF, 780536, VPNp3, #46A1FD, #FFFFFF, 248547, SLPpm4, 121448, #ADDF84, #FFFFFF, troll-b, #DC82D2, #FFFFFF, 744328, outa, #89D2EA, #FFFFFF, 89924, MTe49, 927894, #59CB74, #FFFFFF
#> 14 NULL
#> 15 FALSE, FALSE, , custom_format
#> 16 FALSE, FALSE, , custom_format
#> 17 FALSE, FALSE, , custom_format
#> 18 NULL
#> 19 NULL
#> 20 FALSE,
#> 21 FALSE, undefined
#> 22 FALSE, FALSE, , custom_format
#> 23 FALSE, FALSE, , custom_format
#> 24 NULL
#> 25 FALSE,
#> 26 FALSE,
#> 27 FALSE, FALSE, , custom_format
#> 28 NULL
#> 29 FALSE,
#> 30 FALSE, undefined
#> 31 adequate, #ADDF84, #FFFFFF, 615586, #9CCF72, complete, #59CB74, #FFFFFF, 399046, #4EB867, incomplete, #EAA775, #FFFFFF, 896972, #D59361, merge_error, #F4667C, #FFFFFF, 96230, #DC556A, needs_extending, #46A1FD, #FFFFFF, 654216, #3C8FE4, tiny, #E9E9E9, #202428, 11704, #DADADA, unassessed, #DAD7FF, #202428, 555449, #C3BEEF, unknown, #C2C2C2, #FFFFFF, 815844, #ADADAD, wrong_hemilineage, #FBD44A, #FFFFFF, 275663, #E5C142, wrong_side, #FFFCB5, #202428, 288083, #E8E79D, bad_nucleus, #DC82D2, #FFFFFF, #D166C5, 997771, duplicate, #4ECCCB, #FFFFFF, 230512, not_a_neuron, #9860E5, #FFFFFF, 953023, 367098, proofread, #FFD4FF, #202428, to_review, #59CB74, #FFFFFF, #4EB867, 478080, hard, #F4667C, #FFFFFF, 275338, tadpole, #FFDDE5, #202428, 295683, #EDC4C1, large_fragment, #89D2EA, #FFFFFF, 597301, 162109, NA, #DAD7FF, #202428, 463206, outlier_bio, #EAA775, #FFFFFF, 82369, outlier_seg, #B7CEF9, #202428, 78729, adequat, #FFD9C8, #202428, 527429, fragment, #9860E5, #FFFFFF, NEEDS4, #46A1FD, #FFFFFF, 835587
#> 32 FALSE
#> 33 FALSE, undefined
#> 34 NULL
#> 35 NULL
#> 36 YYYY-MM-DD HH:mm
#> 37 NULL
#> 38 FALSE, FALSE, , custom_format
#> 39 FALSE, FALSE, , custom_format
#> 40 FALSE, FALSE, , custom_format
#> 41 FALSE, FALSE, , custom_format
#> 42 NCC, #4ECCCB, #FFFFFF, #45BAB9, 197106, CV, #C2C2C2, #FFFFFF, #ADADAD, 467618, AN, #89D2EA, #FFFFFF, #7BC0D6, 329258, MxLbN, #F4667C, #FFFFFF, #DC556A, 771256, PhN, #FBD44A, #FFFFFF, #E5C142, 472174, aPhN, #DC82D2, #FFFFFF, #D166C5, 902576, 843153, ON, #FFD9C8, #202428, 129288, OCN, #FFFCB5, #202428
#> 43 FALSE, FALSE
#> 44 FALSE, FALSE
#> 45 FALSE, FALSE, , custom_format
#> 46 FALSE, FALSE, , custom_format
#> 47 FALSE, FALSE, , custom_format
#> 48 sexually_dimorphic, #59CB74, #FFFFFF, #4EB867, 295048, female_specific, #9860E5, #FFFFFF, #844BD2, 641734, potentially_sexually_dimorphic, #ADDF84, #FFFFFF, #9CCF72, 596416, potentially_female_specific, #DC82D2, #FFFFFF, #D166C5, 594303
#> 49 reconstruction state, #DC82D2, #FFFFFF, #D166C5, 924598, biological variability, #4ECCCB, #FFFFFF, #45BAB9, 3986, difference in number, #46A1FD, #FFFFFF, #3C8FE4, 754018, difference in morphology, #FBD44A, #FFFFFF, #E5C142, 859165, difference in connectivity, #EAA775, #FFFFFF, #D59361, 436561
# }