MBP fusion is an effective and generalizable approach to enable crystallographic studies of engineered binding proteins that are otherwise difficult to crystallize #Monobody #Aggregation #MaltoseBindingProtein https://doi.org/10.1107/S2053230X26000798
๐ŸŒŸ ๐ˆ๐ง๐ญ๐ซ๐จ๐๐ฎ๐œ๐ข๐ง๐  [Google Researchโ€™s] ๐†๐ซ๐จ๐ฎ๐ง๐๐ฌ๐จ๐ฎ๐ซ๐œ๐ž - ๐€๐ง ๐จ๐ฉ๐ž๐ง ๐ฌ๐จ๐ฎ๐ซ๐œ๐ž ๐๐š๐ญ๐š๐ฌ๐ž๐ญ ๐จ๐Ÿ ๐ก๐ข๐ฌ๐ญ๐จ๐ซ๐ข๐œ ๐Ÿ๐ฅ๐จ๐จ๐ ๐ž๐ฏ๐ž๐ง๐ญ๐ฌ ๐Ÿ๐ซ๐จ๐ฆ ๐ง๐ž๐ฐ๐ฌ ๐š๐ซ๐ญ๐ข๐œ๐ฅ๐ž๐ฌ.
--
https://doi.org/10.31223/X5RR2K / https://eartharxiv.org/repository/view/12083/ <-- shared paper
--
https://zenodo.org/records/18647054 <-- shared link to associated dataset
--
https://sites.research.google/gr/floodforecasting/ <-- shared link to Google Research flood forecasting effort entry page
--
#GoogleResearch #Google #Gemini #AI #ClimateTech #MachineLearning #DataScience #FloodForecasting #Sustainability #TechForGood #aggregation #curated #newsarticles #news #media #article #harvesting #reports #reporting #global #world #historic #naturalhazards #naturaldisaster #floods #flooding #flashflood #water #hydrology #extremeweather #climatechange #GDACS #Groundsource #GIS #spatial #mapping #spatialanalysis #spatiotemporal #geographic #openaccess #openscience #opendata #floodevents #LLM #gemini #largelanguagemodel #deeplearning #AI #precision #metrics #historicresource #model #modeling #forecasting #opensource
@everton137 The fun police make #mastodon pretty much #unusable for most plp. Commenting on anything can soon become a micro #aggregation or insert (offence taken). Nothing gains mass adoption under those circumstances. #commenting become pointless. #ironic #HurtyMcFeelz

HAVING Filters After GROUP BY?!

HAVING filters GROUPS, WHERE filters ROWS! HAVING runs after aggregation, WHERE runs before. This order matters and will break your logic!

#sql #sqltricks #having #where #groupby #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

https://www.youtube.com/watch?v=OMjcmF4mw08

HAVING Filters After GROUP BY?! #codingchallenge

YouTube
"The #powerOFjournalism is not only the individual stories[the water], but in shaping the riverbed through which that water flows.
Traditional journalism binds the river through wages, hierarchy, institutional agendas. Editorial #control channels the flow in deliberate directions.
In contrast, internet-era journalism has the potential to build rivers through #cooperation, #federation, and collective #aggregation โ€“ but this requires conscious design and understanding."
https://hamishcampbell.com/journalists-generally-don-t-understand-what-journalism-is/
Journalists generally donโ€™t understand what journalism is โ€“ #OMN (Open Media Network)

#Mastodon #stats: I am curious how Mastodon evolves WRT user count etc. There seems to be no complete registry of servers. The aggregators often do not work properly.

Here is one which seems to work:
https://the-federation.info/

The issue: Very few nodes.

Add your node:
`https://the-federation.info/register/<yournode.tld>`

#statistics #socialmedia #socialnetworks #users #usercount #fediverse #aggregation #count #monthlyactiveusers

The Federation - a statistics hub

Node list and statistics for The Federation and Fediverse

Ich hatte neulich erst einen Beitrag zur objektorientierten Programmieung in Java geschrieben und mรถchte ergรคnzend dazu heute รผber Assoziationen sprechen. Denn auch diese sind ein wichtiger Teil wenn uns um Verbindungen, bzw. Beziehungen zwischen Klassen geht.

https://magicmarcy.de/assoziationen-in-java-entschuldigung-kennen-wir-uns

#Assoziationen #einfach #bidirektional #Aggregation #Komposition #hat-eine #besteht-aus #one-to-one #one-to-many #eins-zu-eins #eins-zu-viele

Assoziationen in Java - Entschuldigung, kennen wir uns? | magicmarcy.de

Ich hatte neulich erst einen Beitrag zur objektorientierten Programmieung in Java geschrieben und mรถchte ergรคnzend dazu heute รผber Assoziationen sprechen. Denn auch diese sind ein wichtiger Teil wenn uns um Verbindungen, bzw. Beziehungen zwischen Klassen geht.

magicmarcy.de

What Makes an Antibody Hard to Manufacture? Data-Driven Insights

The Features That Matter After training the developability model on 100+ therapeutic antibodies, I looked at the feature importance rankings. The model had learned to weight certain properties more heavily than others when making predictions. Some of these were obvious. Some were surprising. All of them tell us something about what actually makes antibodies difficult to manufacture. The single most predictive feature was aggregation propensity in the complementarity-determining regions [โ€ฆ]

https://kemal.yaylali.uk/what-makes-an-antibody-hard-to-manufacture-data-driven-insights/

What Makes an Antibody Hard to Manufacture? Data-Driven Insights โ€“ Kemal's

Conditional Aggregation with CASE?!

CASE inside SUM creates conditional aggregation! You can sum only certain rows based on conditions. This conditional math will transform your data!

#sql #sqltricks #case #sum #conditionalaggregation #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

https://www.youtube.com/watch?v=ncgl7_S0NvQ

Conditional Aggregation with CASE?! #sqlwtf

YouTube

GROUPING SETS / ROLLUP / CUBE?!

ROLLUP creates MULTIPLE grouping levels! It generates subtotals and grand totals automatically. This one query returns MANY result sets!

#sql #sqltricks #rollup #cube #groupingsets #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

https://www.youtube.com/watch?v=C35N6p1rooE

GROUPING SETS ROLLUP CUBE?! #codingchallenge

YouTube