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 berg2025 111 mcns_nblast_review
#> 2 maleCNS 111 cns_info
#> 3 Orphan proofreading 44 v1
#> 4 Orphan proofreading 44 Table3
#> 5 Remainder proofreading 44 v1
#> 6 Remainder proofreading 44 add_proofreading_783
#> 7 Review 44 v1
#> 8 Review Catalog 44 v1
#> 9 Review Catalog 44 review_459
#> 10 LAL_orphan_linking 29 LAL_bodies
#> 11 NO_orphan_linking 29 NO_bodies
#> 12 Alan_Mathews_project 5 DL4R_downstream
#> 13 Alan_Mathews_project 5 DL4L_downstream
#> 14 Alan_Mathews_project 5 DL4_HB_downstream
#> 15 Alan_Mathews_project 5 dl4_matches_fafb_r_hb
#> 16 Alan_Mathews_project 5 dl4_matches_fafb
#> 17 Alan_Mathews_project 5 dl4_matches_fafb_l_hb
#> 18 Alan_Mathews_project 5 VL2R_downstream
#> 19 Alan_Mathews_project 5 VL2L_downstream
#> 20 Alan_Mathews_project 5 VL2_HB_downstream
#> 21 Alan_Mathews_project 5 vl2_matches_fafb_r_hb
#> 22 Alan_Mathews_project 5 vl2_matches_fafb
#> 23 Alan_Mathews_project 5 Vilpn1_downstream
#> 24 Alan_Mathews_project 5 Vilpn2_downstream
#> 25 Alan_Mathews_project 5 vilpn1_HB_downstream
#> 26 Alan_Mathews_project 5 vilpn2_HB_downstream
#> 27 Alan_Mathews_project 5 vilpn1_ds_r
#> 28 Alan_Mathews_project 5 vilpn1_ds_l
#> 29 Alan_Mathews_project 5 vilpn2_ds_r
#> 30 Alan_Mathews_project 5 vilpn2_ds_l
#> 31 Alan_Mathews_project 5 vilpn1_matches_fafb
#> 32 Alan_Mathews_project 5 vilpn1r_matches_fafbr_hb
#> 33 Alan_Mathews_project 5 vilpn2r_matches_fafbr_hb
#> 34 Alan_Mathews_project 5 vilpn2_matches_fafb
#> 35 Alan_Mathews_project 5 vl2_matches_fafb_r_hb(copy)
#> 36 Alan_Mathews_project 5 vilpn2r_matches_fafbr_hb(copy)
#> 37 Alan_Mathews_project 5 vl2_matches_fafb(copy)
#> 38 Alan_Mathews_project 5 vilpn1_fafb_matches(copy)
#> 39 Alan_Mathews_project 5 cable_length
#> 40 Alan_Mathews_project 5 prepostcable_dl4
#> 41 Alan_Mathews_project 5 prepostcable_vl2
#> 42 Alan_Mathews_project 5 prepostcable_vilpn2
#> 43 Alan_Mathews_project 5 PN_stats
#> 44 Alan_Mathews_project 5 NBLAST_scores
#> 45 Alan_Mathews_project 5 vilpn_matches_fafb(copy)
#> 46 Alan_Mathews_project 5 vilpn_matches_1r_2l
#> 47 Alan_Mathews_project 5 vilpn_matches_2r_1l
#> 48 Alan_Mathews_project 5 vilpn_total
#> 49 Alan_Mathews_project 5 dl4_norm
#> 50 Alan_Mathews_project 5 vilpnlr_combo
#> 51 Alan_Mathews_project 5 norm
#> 52 Alan_Mathews_project 5 2022-04-20T19_03_21+00_00_0wpp
#> 53 Alan_Mathews_project 5 misc
#> 54 AL_library 5 AL_bodies
#> 55 cam_proofreading 5 batches
#> 56 cam_proofreading 5 FlyWire_neuron_list - for_flywire
#> 57 CATMAID_proofreading 5 catmaid
#> 58 CATMAID_proofreading 5 all_done
#> 59 DO_NOT_USE_main 5 DO_NOT_USE_info
#> 60 DO_NOT_USE_main 5 DO_NOT_USE_hemilineages
#> 61 flywire_matching 5 flywire_right
#> 62 flywire_matching 5 hemibrain2flywire
#> 63 flywire_matching 5 hemibrain2flywire_rematch
#> 64 flywire_matching 5 hemibrain2flywire_mirrored
#> 65 flywire_matching 5 flywire_ALr_ALl
#> 66 flywire_matching 5 new_singles
#> 67 flywire_matching 5 new_singles_lr
#> 68 flywire_matching 5 all_singletons
#> 69 hemibrain 5 hb_info
#> 70 hemibrain 5 hb_hemilineages
#> 71 hemibrain_matching 5 type_matches
#> 72 hemibrain_matching 5 MWP_LH_RHS_cell_typing
#> 73 hemibrain_matching 5 MWP_LH_LHS_cell_typing_v_hb
#> 74 hemibrain_matching 5 MWP_LH_LHS_cell_typing_v_rhs_flywire
#> 75 hemibrain_matching 5 LH_LHS_hb_vs_RHS_conflict_table
#> 76 hemibrain_matching 5 MWP_mega_df
#> 77 hemibrain_matching 5 MWP_LH_stereotypy
#> 78 hemibrain_matching 5 MWP_PM_YY_cell_typing
#> 79 hemibrain_matching 5 post_GM
#> 80 LH_library 5 LH_bodies
#> 81 LH_library 5 _old_LH_bodies
#> 82 main 5 info
#> 83 main 5 hemilineages
#> 84 main(lineage_backup) 5 lineage_project
#> 85 MB_library 5 MB_bodies
#> 86 MB_library 5 MB_bodies_RHS
#> 87 optic_lobes 5 optic
#> 88 test 5 testfruit
#> 89 fanc 123 fanc_main
#> 90 fanc_left_right 123 Types
#> 91 fanc_left_right 123 Assignments
#> 92 fanc_maleCNS_matching 123 fanc851_maleCNS_nblast95_60
#> 93 fanc_maleCNS_matching 123 fanc851_maleCNS_nblast95_60(copy)
#> 94 fanc_maleVNC_matching 123 fanc851_manc_nblast95_60
#> 95 fanc_manc 123 nblast95_65
#> 96 fanc_manc 123 nblast95_65_old
#> 97 fanc_manc_old 123 nblast95_30
#> 98 manc_fanc 123 nblast95_65old
#> 99 manc_fanc 123 nblast95_65
#> 100 manc_fanc_maleCNS_byType 123 Table1
#> 101 manc_fanc_old 123 nblast95_30
#> 102 manc_maleCNS 123 Table1_nblast95_60
#> 103 manc_mcns 123 nblast95_60
#> 104 mcns_fw_matching 123 mcns_fw_nblast95_60
#> 105 zheng_ca3 145 annotations
#> 106 aedes 148 aedes_main
#> 107 DB Comparison 1 Original Comparison
#> 108 DB Comparison 1 Review 2025-03
#> 109 mcns_flywire_cell_types 4 flywire_types
#> 110 Yakuba_manc 113 fullAssignment
#> _id
#> 1 UPz7
#> 2 96g5
#> 3 DHtk
#> 4 0t5T
#> 5 vlgx
#> 6 9l9v
#> 7 9JIF
#> 8 Y9RH
#> 9 SFd8
#> 10 wtpy
#> 11 htKk
#> 12 M4SW
#> 13 P3aV
#> 14 ip3N
#> 15 jvT0
#> 16 0qC0
#> 17 8ZOA
#> 18 Ikw9
#> 19 FCty
#> 20 F9Sk
#> 21 yP9j
#> 22 dV47
#> 23 kcqG
#> 24 4IO4
#> 25 qND2
#> 26 SvpB
#> 27 ZCMx
#> 28 IqEa
#> 29 sikt
#> 30 cxOO
#> 31 UB2m
#> 32 TuH0
#> 33 dZ2X
#> 34 UYUu
#> 35 K7hg
#> 36 rrwF
#> 37 1iG8
#> 38 935S
#> 39 1Itd
#> 40 Z738
#> 41 TKM9
#> 42 6D4l
#> 43 p4KB
#> 44 yJVR
#> 45 7sqj
#> 46 78cE
#> 47 OE2j
#> 48 iVH6
#> 49 14wl
#> 50 dznE
#> 51 A451
#> 52 J4ma
#> 53 s6Oi
#> 54 wNCm
#> 55 0000
#> 56 FbAY
#> 57 TYn5
#> 58 5mdz
#> 59 BXTy
#> 60 QGfh
#> 61 Nscg
#> 62 yN5a
#> 63 LaYJ
#> 64 2ThW
#> 65 dwun
#> 66 yHJb
#> 67 wd66
#> 68 CXnQ
#> 69 X2ZG
#> 70 Sz01
#> 71 cpHc
#> 72 NG0m
#> 73 0Cl7
#> 74 Z5ea
#> 75 8DAX
#> 76 9yII
#> 77 rRZE
#> 78 q477
#> 79 pfDm
#> 80 2PZZ
#> 81 dvGc
#> 82 f0ac
#> 83 Z4SX
#> 84 Nu8Q
#> 85 K5lc
#> 86 VR7q
#> 87 Nato
#> 88 0000
#> 89 E56C
#> 90 0X5w
#> 91 Jj2w
#> 92 CPe6
#> 93 8j37
#> 94 rR5r
#> 95 k4ux
#> 96 jebJ
#> 97 992a
#> 98 GVNI
#> 99 r51n
#> 100 Ou8V
#> 101 2c4S
#> 102 kg2f
#> 103 zi2p
#> 104 qtS9
#> 105 8tvi
#> 106 0000
#> 107 0000
#> 108 Ieb4
#> 109 Fj2H
#> 110 QcrY
# }
# \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_match text character
#> 30 malecns_type_source 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
#> 51 synonyms text character
#> 52 fru_dsx single-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, 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, 384816, VLPp2__prim, #4ECCCB, #FFFFFF
#> 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 NULL
#> 30 FALSE,
#> 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, 24316, dimorphic, #EAA775, #FFFFFF, Small morphological difference between mcns neurons and fw, but not with hb, so not considered dimorphic., #C2C2C2, #FFFFFF, 908897
#> 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, DNge005 was merged into DNge172, #59CB74, #FFFFFF, 612500, best match in male is P1_17a and P1_17b, #89D2EA, #FFFFFF, 93999, uncertain match to LM, #F4667C, #FFFFFF, 278525, The male has a small extra dorsal branch that makes a lot a male-specific connections, #9860E5, #FFFFFF, 990062, additional dorsal branch mcns, #C2C2C2, #FFFFFF, 814592, 438473, numerical, #FFDDE5, #202428, 912105, dimorphism:, #9F8CF1, #FFFFFF, 739927, more, #4ECCCB, #FFFFFF, 197456, neurons, #EAA775, #FFFFFF, 567682, in, #FFEAB6, #202428, 621094, male, #9F8CF1, #FFFFFF, numerical dimorphism: more neurons in male, #DC82D2, #FFFFFF, 254144, likely a biological outlier of SMP032 or SMP004, #46A1FD, #FFFFFF, 508562, extra medial dendrite in male, #59CB74, #FFFFFF, 475757, The axonal difference isn’t symmetrical, 977283, #89D2EA, #FFFFFF, but the dendrites appear smaller in FW, 713671, #F4667C, #FFFFFF, although this could just be biological variability., 575983, #F4667C, #FFFFFF, There is a shift in dendritic innervation of the LO between FW and MCNs, but without a clear difference in inputs, so not labeled as dimorphic for now., #ADDF84, #FFFFFF, 563466, fw has one bigger axonic branch, 473092, #C2C2C2, #FFFFFF, A few fw neurons send a branch more dorsally compared to mcns; however, 791875, #9860E5, #FFFFFF, most fw neurons do not, 412084, #4ECCCB, #FFFFFF, so they are not currently considered dimorphic., 721097, #FBD44A, #FFFFFF, Some mcns neurons are bilateral, 859072, #9F8CF1, #FFFFFF, unlike fw neurons; however, 424186, #9F8CF1, #FFFFFF, this is occasionally observed between fw and hb neurons as well, 689435, #9F8CF1, #FFFFFF, so not considered a dimorphism., 157393, #EAA775, #FFFFFF, An extra dorsal branch is present in some fw neurons, 403825, #DC82D2, #FFFFFF, but only seen in a few, 190299, #46A1FD, #FFFFFF, Small morphological difference between mcns neurons and fw, but not with hb, so not considered dimorphic., 977832, #89D2EA, #FFFFFF, more extensive dendrites in male, #F4667C, #FFFFFF, 329980, LoVP94 in male has more extensive dendrites in the LO but it's not quite clear if this neuron is the right match, or rather PLP184/185, #ADDF84, #FFFFFF, 41553, LoVP94 in male has more extensive dendrites in the LO but it's not quite clear if this neuron is the right match, or rather PLP185/186, #C2C2C2, #FFFFFF, 357227, LoVP94 in male has more extensive dendrites in the LO but it's not quite clear if this neuron is the right match, 365994, #9860E5, #FFFFFF, or rather PLP185/186, 319683, #9860E5, #FFFFFF, more extensive branches in MCNS, #FBD44A, #FFFFFF, 462231, extra dendrite in DL2d glomerulus in female, #59CB74, #FFFFFF, 512513, extra dendrite in male, #9F8CF1, #FFFFFF, 951828, denser, 159655, #4ECCCB, #FFFFFF, more extensive neurites in male, 870956, #4ECCCB, #FFFFFF, denser, more extensive neurites in male, #46A1FD, #FFFFFF, 397342, extra branches in male, #EAA775, #FFFFFF, 85572
#> 50 FALSE, FALSE, , custom_format
#> 51 FALSE, FALSE, , custom_format
#> 52 fru, #9860E5, #FFFFFF, #844BD2, 715076, dsx, #ADDF84, #FFFFFF, #9CCF72, 777623, coexpress, #EAA775, #FFFFFF, #D59361, 462522, 639105, fru_backfilled, #9F8CF1, #FFFFFF
# }