Pin data of medulla for left optic lobe

[Xin Zhong]

Dear all, I have a question: in the Reiserlab GitHub repository (see the attached link), they offer the pin data for the medulla of right optic lobe. Does anyone know where I can find the pin data of the left optic lobe medulla?
  https://github.com/reiserlab/male-drosophila-visual-system-connectome-code/blob/main/results/eyemap/ME_pindata.csv

[Berg, Stuart]

Hi Xin,

I’ve attached a copy of the complete table, including left and right sides.

This was obtained via the neuprint API, using the code shown below.

Best,
Stuart

import pandas as pd
from neuprint import Client

def fetch_column_pin_table(client):
    q = """\
        MATCH (pin:ColumnPin)
        RETURN
            pin.`ME(L)` as `ME(L)`,
            pin.`LO(L)` as `LO(L)`,
            pin.`LOP(L)` as `LOP(L)`,

            pin.`ME(R)` as `ME(R)`,
            pin.`LO(R)` as `LO(R)`,
            pin.`LOP(R)` as `LOP(R)`,

            pin.olHex1 as hex1,
            pin.olHex2 as hex2,
            pin.olLayer as layer,

            pin.depth as depth,

            pin.location.x as x,
            pin.location.y as y,
            pin.location.z as z
    """
    df = client.fetch_custom(q)

    roi_names = ['ME(L)', 'LO(L)', 'LOP(L)', 'ME(R)', 'LO(R)', 'LOP(R)']
    df['roi'] = df[roi_names].idxmax(axis=1)
    df = df.drop(columns=roi_names)

    assert df.columns.tolist() == ['hex1', 'hex2', 'layer', 'depth', 'x', 'y', 'z', 'roi']
    return df

c = Client('neuprint-cns.janelia.org', 'male-cns:v0.9')
df = fetch_column_pin_table(c)
df.to_csv('/tmp/malecns-v0.9-optic-column-pins.csv’)

[Berg, Stuart]

BTW, you can visualize the pins in neuroglancer via this link:

https://neuroglancer-demo.appspot.com/#!gs://flyem-user-links/short/2025-12-08.233806.715783.json

On Dec 8, 2025, at 6:44 PM, Berg, Stuart <be...@janelia.hhmi.org> wrote:

Hi Xin,

I’ve attached a copy of the complete table, including left and right sides.

This was obtained via the neuprint API, using the code shown below.

Best,
Stuart

<malecns-v0.9-optic-column-pins.csv.zip>

[Xin Zhong]

❤️

Xin Zhong reacted via Gmail

[Xin Zhong]

❤️

Xin Zhong reacted via Gmail