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 name
#> 1 maleCNS 111 cns_info
#> 2 Orphan proofreading 44 v1
#> 3 Orphan proofreading 44 Table3
#> 4 Remainder proofreading 44 v1
#> 5 Remainder proofreading 44 add_proofreading_783
#> 6 Review 44 v1
#> 7 Review Catalog 44 v1
#> 8 Review Catalog 44 review_459
#> 9 LAL_orphan_linking 29 LAL_bodies
#> 10 NO_orphan_linking 29 NO_bodies
#> 11 Alan_Mathews_project 5 DL4R_downstream
#> 12 Alan_Mathews_project 5 DL4L_downstream
#> 13 Alan_Mathews_project 5 DL4_HB_downstream
#> 14 Alan_Mathews_project 5 dl4_matches_fafb_r_hb
#> 15 Alan_Mathews_project 5 dl4_matches_fafb
#> 16 Alan_Mathews_project 5 dl4_matches_fafb_l_hb
#> 17 Alan_Mathews_project 5 VL2R_downstream
#> 18 Alan_Mathews_project 5 VL2L_downstream
#> 19 Alan_Mathews_project 5 VL2_HB_downstream
#> 20 Alan_Mathews_project 5 vl2_matches_fafb_r_hb
#> 21 Alan_Mathews_project 5 vl2_matches_fafb
#> 22 Alan_Mathews_project 5 Vilpn1_downstream
#> 23 Alan_Mathews_project 5 Vilpn2_downstream
#> 24 Alan_Mathews_project 5 vilpn1_HB_downstream
#> 25 Alan_Mathews_project 5 vilpn2_HB_downstream
#> 26 Alan_Mathews_project 5 vilpn1_ds_r
#> 27 Alan_Mathews_project 5 vilpn1_ds_l
#> 28 Alan_Mathews_project 5 vilpn2_ds_r
#> 29 Alan_Mathews_project 5 vilpn2_ds_l
#> 30 Alan_Mathews_project 5 vilpn1_matches_fafb
#> 31 Alan_Mathews_project 5 vilpn1r_matches_fafbr_hb
#> 32 Alan_Mathews_project 5 vilpn2r_matches_fafbr_hb
#> 33 Alan_Mathews_project 5 vilpn2_matches_fafb
#> 34 Alan_Mathews_project 5 vl2_matches_fafb_r_hb(copy)
#> 35 Alan_Mathews_project 5 vilpn2r_matches_fafbr_hb(copy)
#> 36 Alan_Mathews_project 5 vl2_matches_fafb(copy)
#> 37 Alan_Mathews_project 5 vilpn1_fafb_matches(copy)
#> 38 Alan_Mathews_project 5 cable_length
#> 39 Alan_Mathews_project 5 prepostcable_dl4
#> 40 Alan_Mathews_project 5 prepostcable_vl2
#> 41 Alan_Mathews_project 5 prepostcable_vilpn2
#> 42 Alan_Mathews_project 5 PN_stats
#> 43 Alan_Mathews_project 5 NBLAST_scores
#> 44 Alan_Mathews_project 5 vilpn_matches_fafb(copy)
#> 45 Alan_Mathews_project 5 vilpn_matches_1r_2l
#> 46 Alan_Mathews_project 5 vilpn_matches_2r_1l
#> 47 Alan_Mathews_project 5 vilpn_total
#> 48 Alan_Mathews_project 5 dl4_norm
#> 49 Alan_Mathews_project 5 vilpnlr_combo
#> 50 Alan_Mathews_project 5 norm
#> 51 Alan_Mathews_project 5 2022-04-20T19_03_21+00_00_0wpp
#> 52 Alan_Mathews_project 5 misc
#> 53 AL_library 5 AL_bodies
#> 54 cam_proofreading 5 batches
#> 55 cam_proofreading 5 FlyWire_neuron_list - for_flywire
#> 56 CATMAID_proofreading 5 catmaid
#> 57 CATMAID_proofreading 5 all_done
#> 58 DO_NOT_USE_main 5 DO_NOT_USE_info
#> 59 DO_NOT_USE_main 5 DO_NOT_USE_hemilineages
#> 60 flywire_matching 5 flywire_right
#> 61 flywire_matching 5 hemibrain2flywire
#> 62 flywire_matching 5 hemibrain2flywire_rematch
#> 63 flywire_matching 5 hemibrain2flywire_mirrored
#> 64 flywire_matching 5 flywire_ALr_ALl
#> 65 flywire_matching 5 new_singles
#> 66 flywire_matching 5 new_singles_lr
#> 67 flywire_matching 5 all_singletons
#> 68 hemibrain 5 hb_info
#> 69 hemibrain 5 hb_hemilineages
#> 70 hemibrain_matching 5 type_matches
#> 71 hemibrain_matching 5 MWP_LH_RHS_cell_typing
#> 72 hemibrain_matching 5 MWP_LH_LHS_cell_typing_v_hb
#> 73 hemibrain_matching 5 MWP_LH_LHS_cell_typing_v_rhs_flywire
#> 74 hemibrain_matching 5 LH_LHS_hb_vs_RHS_conflict_table
#> 75 hemibrain_matching 5 MWP_mega_df
#> 76 hemibrain_matching 5 MWP_LH_stereotypy
#> 77 hemibrain_matching 5 MWP_PM_YY_cell_typing
#> 78 hemibrain_matching 5 post_GM
#> 79 LH_library 5 LH_bodies
#> 80 LH_library 5 _old_LH_bodies
#> 81 main 5 info
#> 82 main 5 hemilineages
#> 83 main(lineage_backup) 5 lineage_project
#> 84 MB_library 5 MB_bodies
#> 85 MB_library 5 MB_bodies_RHS
#> 86 optic_lobes 5 optic
#> 87 test 5 testfruit
#> 88 fanc_left_right 123 Types
#> 89 fanc_left_right 123 Assignments
#> 90 fanc_maleCNS_matching 123 fanc851_maleCNS_nblast95_60
#> 91 fanc_maleCNS_matching 123 fanc851_maleCNS_nblast95_60(copy)
#> 92 fanc_maleVNC_matching 123 fanc851_manc_nblast95_60
#> 93 fanc_manc 123 nblast95_65
#> 94 fanc_manc_old 123 nblast95_30
#> 95 manc_fanc 123 nblast95_65
#> 96 manc_fanc_maleCNS_byType 123 Table1
#> 97 manc_fanc_old 123 nblast95_30
#> 98 manc_left_right 123 Assignments
#> 99 manc_maleCNS 123 Table1_nblast95_60
#> 100 manc_mcns 123 nblast95_60
#> 101 mcns_fw_matching 123 mcns_fw_nblast95_60
#> 102 zheng_ca3 145 annotations
#> 103 aedes 148 aedes_main
#> 104 DB Comparison 1 Original Comparison
#> 105 DB Comparison 1 Review 2025-03
#> 106 mcns_flywire_cell_types 4 flywire_types
#> _id
#> 1 96g5
#> 2 DHtk
#> 3 0t5T
#> 4 vlgx
#> 5 9l9v
#> 6 9JIF
#> 7 Y9RH
#> 8 SFd8
#> 9 wtpy
#> 10 htKk
#> 11 M4SW
#> 12 P3aV
#> 13 ip3N
#> 14 jvT0
#> 15 0qC0
#> 16 8ZOA
#> 17 Ikw9
#> 18 FCty
#> 19 F9Sk
#> 20 yP9j
#> 21 dV47
#> 22 kcqG
#> 23 4IO4
#> 24 qND2
#> 25 SvpB
#> 26 ZCMx
#> 27 IqEa
#> 28 sikt
#> 29 cxOO
#> 30 UB2m
#> 31 TuH0
#> 32 dZ2X
#> 33 UYUu
#> 34 K7hg
#> 35 rrwF
#> 36 1iG8
#> 37 935S
#> 38 1Itd
#> 39 Z738
#> 40 TKM9
#> 41 6D4l
#> 42 p4KB
#> 43 yJVR
#> 44 7sqj
#> 45 78cE
#> 46 OE2j
#> 47 iVH6
#> 48 14wl
#> 49 dznE
#> 50 A451
#> 51 J4ma
#> 52 s6Oi
#> 53 wNCm
#> 54 0000
#> 55 FbAY
#> 56 TYn5
#> 57 5mdz
#> 58 BXTy
#> 59 QGfh
#> 60 Nscg
#> 61 yN5a
#> 62 LaYJ
#> 63 2ThW
#> 64 dwun
#> 65 yHJb
#> 66 wd66
#> 67 CXnQ
#> 68 X2ZG
#> 69 Sz01
#> 70 cpHc
#> 71 NG0m
#> 72 0Cl7
#> 73 Z5ea
#> 74 8DAX
#> 75 9yII
#> 76 rRZE
#> 77 q477
#> 78 pfDm
#> 79 2PZZ
#> 80 dvGc
#> 81 f0ac
#> 82 Z4SX
#> 83 Nu8Q
#> 84 K5lc
#> 85 VR7q
#> 86 Nato
#> 87 0000
#> 88 0X5w
#> 89 Jj2w
#> 90 CPe6
#> 91 8j37
#> 92 rR5r
#> 93 jebJ
#> 94 992a
#> 95 H1IE
#> 96 Ou8V
#> 97 2c4S
#> 98 teVG
#> 99 kg2f
#> 100 zi2p
#> 101 qtS9
#> 102 8tvi
#> 103 0000
#> 104 0000
#> 105 Ieb4
#> 106 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 nerve single-select character
#> 16 flow text character
#> 17 super_class text character
#> 18 cell_sub_class text character
#> 19 cell_class text character
#> 20 cell_type text character
#> 21 cell_type_source text character
#> 22 fbbt_id text character
#> 23 vfb_id text character
#> 24 cb_type text character
#> 25 hemibrain_match text character
#> 26 hemibrain_type text character
#> 27 hemibrain_type_source text character
#> 28 malecns_type text character
#> 29 malecns_type_source text character
#> 30 malecns_match text character
#> 31 reviewed_by text character
#> 32 status single-select character
#> 33 notes long-text character
#> 34 lrcid text character
#> 35 root_duplicated checkbox logical
#> 36 root_last_modified date POSIXct
#> 37 proofread checkbox logical
#> 38 last_user last-modifier character
#> 39 LM_match text character
#> 40 LM_match_source text character
#> 41 root_630 text character
#> 42 root_783 text 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
#> 50 supertype text 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, MX5, #F4667C, #FFFFFF, 384813, LB11, #9860E5, #FFFFFF, 205436, MD_SA1__prim, #C2C2C2, #FFFFFF, 361818, LB6__prim, #4ECCCB, #FFFFFF, 294867, LB12__prim, #9F8CF1, #FFFFFF, 86937, TRdl_b__prim, #EAA775, #FFFFFF, 954857, TRdl_a__prim, #FBD44A, #FFFFFF, 561597, LB5__prim, #46A1FD, #FFFFFF, 49068, LB11__prim, #ADDF84, #FFFFFF, 579261, LB19__prim, #DC82D2, #FFFFFF, 905958, LB23__prim, #89D2EA, #FFFFFF, 241198, DM6_central1__prim, #59CB74, #FFFFFF, 657462, LHl1__prim, #F4667C, #FFFFFF, 420519
#> 14 NULL
#> 15 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
#> 16 FALSE, FALSE, , custom_format
#> 17 FALSE, FALSE, , custom_format
#> 18 FALSE, FALSE, , custom_format
#> 19 NULL
#> 20 NULL
#> 21 FALSE,
#> 22 FALSE, undefined
#> 23 FALSE, FALSE, , custom_format
#> 24 FALSE, FALSE, , custom_format
#> 25 NULL
#> 26 FALSE,
#> 27 FALSE,
#> 28 FALSE, FALSE, , custom_format
#> 29 FALSE,
#> 30 NULL
#> 31 FALSE, undefined
#> 32 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
#> 33 FALSE
#> 34 FALSE, undefined
#> 35 NULL
#> 36 YYYY-MM-DD HH:mm
#> 37 NULL
#> 38 NULL
#> 39 FALSE, FALSE, , custom_format
#> 40 FALSE, FALSE, , custom_format
#> 41 FALSE, FALSE, , custom_format
#> 42 FALSE, FALSE, , custom_format
#> 43 FALSE, FALSE
#> 44 FALSE, FALSE
#> 45 FALSE, FALSE, , custom_format
#> 46 FALSE, FALSE, , custom_format
#> 47 FALSE, FALSE, , custom_format
#> 48 393447, female-specific, #9860E5, #FFFFFF, #844BD2, 105996, sexually dimorphic, #9860E5, #FFFFFF, 635462, potentially sexually dimorphic, #FFDDE5, #202428, 147214, potentially female-specific, #B7CEF9, #202428
#> 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, this is likely a DNpe004 that did not descend, hence not labeled female-specific (PS), #9F8CF1, #FFFFFF, 353067
#> 50 FALSE, FALSE, , custom_format
# }